USP_DATALIST_FAFSitePageDisplayNameTab

CREATE procedure dbo.USP_DATALIST_FAFSitePageDisplayNameTab(
  @CLIENTSITESID     int, 
    @PAGEID            integer = 0,
    @TABID            integer = 0
)
as
begin

if @TABID < 0
    BEGIN
        SELECT [DisplayName]as [Name] FROM SitePages WHERE [ID] = @PAGEID
    END
ELSE
    BEGIN
        select [Name], [TabID], [DisplayName], [Tab]
        from 
        (    select distinct sp.DisplayName + COALESCE(' - ' + ctt.text,'') as [Name], 
            convert(varchar(20),sp.id)+';'+COALESCE(convert(varchar(20),ctt.tab),'0') as [TabID],
            sp.DisplayName,COALESCE(ctt.tab, 0) as [Tab],
            case @PAGEID when 0 then 0 else sp.id end as MyPageId,
          ctt.tab as MyTabId
            from SiteContent sc
            join PageContent pg on sc.id = pg.SiteContentID
            left join ContentTabs ctt on sc.contentTypesID = ctt.ContentTypesID 
            right join SitePages sp on sp.id=pg.SitePagesID
            where sp.ClientSitesID = @CLIENTSITESID and sp.IsTemplatePage = 0 
            and sp.deleted = 0 and sc.deleted = 0
        ) v
        where v.MyPageId = @pageId and v.MyTabId = @tabId
        order by [Name],[Tab]
    END


end