Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F31543129
raw.txt
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
jgleeson
Feb 1 2020, 1:37 AM
2020-02-01 01:37:16 (UTC+0)
Size
1 KB
Referenced Files
None
Subscribers
None
raw.txt
View Options
SELECT
SUBSTRING_INDEX(c_outer.invoice_id, '|', 1) AS order_id,
x.gateway_txn_id AS payment_id,
cpt.token AS subscription_id,
x.original_currency AS currency,
x.original_amount AS amount
FROM
(SELECT
e.email,
DAY(receive_date),
MIN(c.id) AS first_c_id,
COUNT(*) AS num_donations
FROM
civicrm_contribution c
INNER JOIN civicrm_contact cnt ON cnt.id = c.contact_id
INNER JOIN civicrm_email e ON cnt.id = e.contact_id
AND e.is_primary = 1
WHERE
receive_date BETWEEN '2020-01-26' AND '2020-01-28'
AND contribution_status_id = 1
AND cnt.contact_type = 'Individual'
GROUP BY e.email , DAY(receive_date)
HAVING COUNT(*) > 1) AS grp
INNER JOIN
civicrm_email e_outer ON e_outer.email = grp.email
INNER JOIN
civicrm_contact cnt_outer ON cnt_outer.id = e_outer.contact_id
INNER JOIN
civicrm_contribution c_outer ON c_outer.contact_id = e_outer.contact_id
INNER JOIN
wmf_contribution_extra x ON x.entity_id = c_outer.id
INNER JOIN
civicrm_address addr ON addr.contact_id = c_outer.contact_id
INNER JOIN
civicrm_country country_t ON country_t.id = addr.country_id
INNER JOIN
civicrm_contribution_recur cr ON cr.id = c_outer.contribution_recur_id
INNER JOIN
civicrm_payment_token cpt ON cpt.id = cr.payment_token_id
WHERE
c_outer.receive_date BETWEEN '2020-01-26' AND '2020-01-28'
AND c_outer.id > grp.first_c_id
AND c_outer.contribution_status_id = 1
AND e_outer.is_primary = 1
AND x.gateway LIKE '%paypal%'
ORDER BY grp.email;
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8298419
Default Alt Text
raw.txt (1 KB)
Attached To
Mode
P10296 (An Untitled Masterwork)
Attached
Detach File
Event Timeline
Log In to Comment