jenkins-bot has submitted this change and it was merged.
Change subject: Zap stray semicolon
......................................................................
Zap stray semicolon
from patch suppressing deleted contact export
Change-Id: If5810fc0c5ac5a8c4a2327dad8279bb930f945c2
---
M silverpop_export/update_table.sql
1 file changed, 1 insertion(+), 1 deletion(-)
Approvals:
Awight: Looks good to me, approved
jenkins-bot: Verified
diff --git a/silverpop_export/update_table.sql
b/silverpop_export/update_table.sql
index cceb70e..2665945 100755
--- a/silverpop_export/update_table.sql
+++ b/silverpop_export/update_table.sql
@@ -69,7 +69,7 @@
LEFT JOIN civicrm.civicrm_contact c ON e.contact_id = c.id
LEFT JOIN civicrm.wmf_donor d ON d.entity_id = c.id
WHERE
- e.email IS NOT NULL AND e.email != '';
+ e.email IS NOT NULL AND e.email != ''
AND c.is_deleted = 0;
-- Populate data from contribution tracking; because that's fairly
--
To view, visit https://gerrit.wikimedia.org/r/177132
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: If5810fc0c5ac5a8c4a2327dad8279bb930f945c2
Gerrit-PatchSet: 2
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Ejegg <[email protected]>
Gerrit-Reviewer: Awight <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
