SELECT DISTINCT
  CC.ClientProductID
FROM
  taClientProductCover AS CC
    INNER JOIN taClientProducts AS CP ON (CP.ClientProductID = CC.ClientProductID)
    INNER JOIN taClients AS CS ON (CS.ClientID = CP.ClientID)
    INNER JOIN taProducts AS PR ON (PR.ProductID = CP.ProductID)
WHERE
  (CS.ClientStatus = 1) AND
  (CC.CoverValue IS NOT NULL) AND
  (CC.CoverValue > 0) AND
  (CC.NextIncreaseDate IS NOT NULL) AND
  (CC.NextIncreaseDate <> '0000-00-00') AND
  (CC.NextIncreaseDate <= @aEffectiveDate) AND
  (PR.ServiceCoverIncreasePercentage > 0.0)
ORDER BY
  CC.ClientProductID