fnPagePartsList

CREATE function dbo.fnPagePartsList(@PageID int) 
RETURNS TABLE AS

    RETURN (

    SELECT     
        scnt.ID, 
        dbo.fnGetPageLayoutID(spgs.id) as LayoutID,
        spgs.TemplateID, 
        spgs.IsTemplatePage,
        scnt.Title, 
        scnt.ContentTypesID, 
        atyp.Name AS TypeName, 
        pgct.ContentOrder, 
        pgct.PaneName, 
        pgct.ID AS PageContentID, 
        spgs.ID AS PageID

        from         
        dbo.SitePages spgs 
        inner join dbo.PageContent pgct ON spgs.ID=pgct.SitePagesID 
        inner join dbo.SiteContent scnt ON pgct.SiteContentID=scnt.ID
        inner join dbo.ContentTypes atyp ON scnt.ContentTypesID=atyp.ID

        where     
        spgs.ID IN(@PageID) AND
        (scnt.Deleted = 0) AND (spgs.Deleted = 0)

    )