Page MenuHomePhabricator
Paste P10290

T243356 Check no one will get double-charged 2020-01
ActivePublic

Authored by AndyRussG on Jan 29 2020, 10:17 PM.
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;