Page MenuHomePhabricator
Authored By
AndyRussG
Jan 24 2020, 5:20 PM
Size
310 B
Referenced Files
None
Subscribers
None
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;

File Metadata

Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8292639
Default Alt Text
raw.txt (310 B)

Event Timeline