SELECT
  CP.ClientID,
  CP.ProductID,
  CC.ClientProductID,
  CC.EntryType,
  CC.StartDate,
  CC.NextIncreaseDate,
  CC.CoverValue,
  CC.FreeHours,
  CC.FreeVisits,
  CC.ValueResetMonths,
  CC.HoursResetMonths,
  CC.VisitsResetMonths,
  (SELECT COUNT(*) FROM taClientProductCover WHERE (ClientProductID = @nClientProductID) AND (StartDate > @aStartDate)) AS RecordsAfterCount
FROM
  taClientProductCover AS CC
    INNER JOIN taClientProducts AS CP USING (ClientProductID)
WHERE
  (CC.ClientProductID = @nClientProductID) AND
  (CC.StartDate = @aStartDate)
