USP_DATALIST_BBNCPAGESWITHEMAILPREFSPART
Returns a list of all page IDs with a part on them that satisfies the requirement for an email to have an opt out link
Definition
Copy
CREATE procedure dbo.USP_DATALIST_BBNCPAGESWITHEMAILPREFSPART
as
BEGIN
select distinct PageID
FROM vwPageContent
WHERE IsTemplatePage = 0 and ContentTypesID = 50
UNION
select distinct sp.ID AS PageID
from SitePages sp
inner join PageContent pc on pc.SitePagesID = sp.ID
inner join SiteContent sc on pc.SiteContentID = sc.ID and sc.ContentTypesID = 121
inner join APEXFORMCONTENT afc on afc.ID = sc.Guid
inner join APEXFORM af on af.ID = afc.FORMID and af.FORMTYPEID = '89D3C4CC-4D01-4E8B-B82E-04AD966EEE09'
END