Event Timeline
Comment Actions
So I tried working it in this way
select cr.contribution_status_id, COUNT(DISTINCT e2.email),e2.email, cancel_date,end_date from contribution_recur_copy crc inner join civicrm_email e on e.contact_id = crc.contact_id left join civicrm_email e2 on e2.email = e.email inner join civicrm_contribution_recur cr ON ( cr.contact_id = e.contact_id OR cr.contact_id = e2.contact_id ) WHERE cr.cancel_date IS NULL GROUP BY contribution_status_id, cancel_date; `` & found 2 rows - but 0 once I added your extra criteria