Change Details

SELECT r.next_sched_contribution_date, c.receive_date FROM civicrm_contribution as c LEFT JOIN civicrm_contribution_recur as r ON r.id = c.contribution_recur_id WHERE r.next_sched_contribution_date < '2020-02-01' AND c.receive_date > '2020-01-01' AND r.cancel_date IS NULL

SELECT r.next_sched_contribution_date, c.receive_date FROM civicrm_contribution as c LEFT JOIN civicrm_contribution_recur as r ON r.id = c.contribution_recur_id WHERE r.next_sched_contribution_date < '2020-02-01' AND c.receive_date > '2020-01-01' AND r.cancel_date IS NULL;

SELECT r.next_sched_contribution_date, c.receive_date FROM civicrm_contribution as c LEFT JOIN civicrm_contribution_recur as r ON r.id = c.contribution_recur_id WHERE r.next_sched_contribution_date < '2020-02-01' AND c.receive_date > '2020-01-01' AND r.cancel_date IS NULL;