SELECT docURL.DocPath FROM tbl_CRO_CampaignProducts p INNER JOIN tbl_CRO_Campaigns c ON p.campaignid = c.campaignid AND c.OwnerID = AND c.OwnerType = AND c.startDate < #CreateODBCDate(Now())# AND c.endDate > #CreateODBCDate(Now())# INNER JOIN tbl_CRO_Repository r ON c.OwnerID = r.OwnerID AND c.OwnerType = r.OwnerType AND c.campaignID = r.ContainerID AND r.ContainerType = 'CR1' AND getdate() <= r.UnpublishDate AND getdate() >= r.PublishDate INNER JOIN qryDocFullPathLookup docURL ON r.ContentID = docURL.ContentID WHERE p.ProductLevel = 'SKU' AND p.ProductCode =