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;