Ejegg has uploaded a new change for review.
https://gerrit.wikimedia.org/r/177132
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(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools
refs/changes/32/177132/1
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: newchange
Gerrit-Change-Id: If5810fc0c5ac5a8c4a2327dad8279bb930f945c2
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Ejegg <eeggles...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
