Ejegg has uploaded a new change for review. https://gerrit.wikimedia.org/r/175479
Change subject: Do not export email addresses for deleted contacts ...................................................................... Do not export email addresses for deleted contacts Change-Id: I9008d74410be67fb6819486b0846ab95c00c7d6a --- M silverpop_export/update_table.sql 1 file changed, 1 insertion(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools refs/changes/79/175479/1 diff --git a/silverpop_export/update_table.sql b/silverpop_export/update_table.sql index 5d868d2..6145f89 100755 --- a/silverpop_export/update_table.sql +++ b/silverpop_export/update_table.sql @@ -69,6 +69,7 @@ LEFT JOIN civicrm.wmf_donor d ON d.entity_id = c.id WHERE e.email IS NOT NULL AND e.email != ''; + AND c.is_deleted = 0; -- Populate data from contribution tracking; because that's fairly -- reliable. Do this before deduplication so we can attempt to make -- To view, visit https://gerrit.wikimedia.org/r/175479 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9008d74410be67fb6819486b0846ab95c00c7d6a 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