spGetContentComparisonCIDFromGuid

  CREATE PROCEDURE [dbo].[spGetContentComparisonCIDFromGuid]
  (
  @guid uniqueidentifier,
  @ContentComparisonPartID int
  )
  AS
  SELECT
  cc.CID
  FROM
  [dbo].contentcomparisons cc INNER JOIN
  [dbo].ContentComparisonPart cp on cp.ID = cc.CCPID INNER JOIN
  [dbo].ContentComparisonCookiedUsers cccu ON cc.id = cccu.ccprelid  
  WHERE
  VisitorGuid=@guid and cp.SiteContentID = @ContentComparisonPartID