USP_DATALIST_ADVOCACYFORMPAGES

create procedure dbo.USP_DATALIST_ADVOCACYFORMPAGES

as
    set nocount on;

      Select SP.ID As PageID, SP.PageName,  AFT.FormType 
      from SitePages (nolock) SP
        INNER JOIN dbo.PageContent (nolock) PC on SP.ID = PC.SitePagesID
        INNER JOIN dbo.SiteContent (nolock) SC On SC.ID = PC.SiteContentID
        INNER JOIN dbo.APEXFORMCONTENT (nolock) AC on AC.ID = SC.Guid
        INNER JOIN dbo.APEXFORM (nolock) AF on AC.FORMID = AF.ID
        INNER JOIN APEXFORMTYPE (nolock) AFT on AFT.ID = AF.FormTypeID
     where  AFT.FORMTYPE in('Advocacy Petition Form', 'Advocacy Registration Form', 'Advocacy Action Form')