spGetContentComparisonSummaryStats

  CREATE PROCEDURE spGetContentComparisonSummaryStats
  (
  @CCPID int
  )
  AS

  SELECT
  ccs.Clickthroughs,
  cc.Conversions,
  cc.NumDisplays,
  cc.ID
  FROM
  [dbo].ContentComparisonStats ccs
  INNER JOIN [dbo].ContentComparisonPart ccp on ccp.TargetPID = ccs.PageID
  INNER JOIN [dbo].ContentComparisons cc on ccs.CCPRelID = cc.ID
  AND ccp.ID = cc.ccpid
  WHERE
  ccp.ID=@CCPID