spGetCCPStats

  CREATE PROCEDURE spGetCCPStats
  (
  @CCPID int
  )
  AS
  SELECT
  sc.Title AS DisplayedContentTitle,
  sc.ID AS DisplayedContentID,
  ccs.Clickthroughs AS Clickthroughs,
  Cast(ccs.Clickthroughs AS Decimal) * 100 / cc.NumDisplays AS ClickthroughRate,
  cc.NumDisplays as NumDisplays,
  CASE ccs.PageID
  WHEN ccp.TargetPID THEN 1
  ELSE 0
  END AS IsTargeted,
  sp.Pagename AS Pagename,
  sp.ID AS PageID,
  cc.ID AS CCPRelID
  FROM
  [dbo].ContentComparisonStats ccs
  INNER JOIN [dbo].ContentComparisons cc on cc.id=ccs.ccprelid
  INNER JOIN [dbo].ContentComparisonPart ccp on ccp.id=cc.ccpid
  INNER JOIN [dbo].SitePages sp on sp.ID=ccs.PageID
  INNER JOIN [dbo].SiteContent sc on sc.ID=cc.CID
  WHERE
  ccp.ID = @CCPID
  ORDER BY
  cc.ID,
  ccs.Clickthroughs DESC