USP_DATALIST_ADVOCACYPAGECONTENT

CREATE procedure dbo.USP_DATALIST_ADVOCACYPAGECONTENT(@FORMTYPE varchar(200))
as
        set nocount on;

        Declare @formid varchar(50)

        SELECT top 1 @formid = AF.ID 
        From dbo.APEXFORM AF
         Inner Join APEXFORMTYPE AFT
         on AF.FormTypeId = AFT.ID
        WHERE AFT.FORMTYPE = @FORMTYPE 
        ORDER BY AF.DATECHANGED DESC

        set @formid = '%' + @formid + '%'

        select P.SitePagesID 
        from dbo.PageContent P
        INNER JOIN dbo.SiteContent S
        ON P.SiteContentID = S.ID
        WHERE XMLData like @FormID 
    Order by CreateDate desc