spSitePagesByContentTypes

  CREATE PROCEDURE [dbo].[spSitePagesByContentTypes]
  (
  @ClientSitesID int,
  @ContentTypesIDs nvarchar(max)
  )
  AS
  DECLARE @XmlData xml;
  SET @ContentTypesIDs = REPLACE(@ContentTypesIDs, 'encoding="utf-16"',    '')
  SET @ContentTypesIDs = REPLACE(@ContentTypesIDs, 'encoding="utf-8"',    '')
  SET @XmlData = CAST(@ContentTypesIDs AS XML)

  SELECT
  DISTINCT PageName, PageID
  FROM
  [dbo].vwPageContent v
  INNER JOIN
  (
  SELECT CTIDs.cs.value('(.)[1]', 'int') as ID
  FROM @XmlData.nodes('/ArrayOfInt/int') CTIDs(cs)
  ) AS R ON R.ID = v.ContentTypesID

  WHERE
  ClientSitesID =  @ClientSitesID
  and IsTemplatePage = 0
  Order by PageName