Page MenuHomePhabricator
Authored By
AndyRussG
Jan 24 2020, 5:20 PM
Size
309 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
8292638
Default Alt Text
raw.txt (309 B)

Event Timeline