USP_DATALIST_FormTitlesForClientSite

CREATE procedure dbo.USP_DATALIST_FormTitlesForClientSite(@CLIENTSITESID int)
as
    set nocount on;

    select a.ID,
           a.GUID,
           a.TITLE,
           b.CLIENTSITESID
    from dbo.CUSTOMFORMELEMENT a
  inner join dbo.CUSTOMFORMSETTINGS b on a.GUID = b.FORMGUID
    where b.CLIENTSITESID = @CLIENTSITESID
  order by a.TITLE