spGetContentTypes

            CREATE procedure [dbo].[spGetContentTypes]
            (
                @ClientSitesID int
            ) as
                set nocount on;
                select 
                    ContentTypes.ID, ContentTypes.Name,
                    convert(bit, case when ClientContentTypes.ID > 0 then 0 else 1 end) HiddenForClientSite
                from 
                    dbo.ContentTypes
                    left outer join dbo.ClientContentTypes on ClientContentTypes.ContentTypesID = ContentTypes.ID and ClientContentTypes.ClientsID = @ClientSitesID
                where
                    ContentTypes.Hidden = 0 AND ContentTypes.Deprecated = 0
                order by 
                    ContentTypes.Name;