Adamw has uploaded a new change for review.
https://gerrit.wikimedia.org/r/133182
Change subject: possibly more efficient to use the integer index
......................................................................
possibly more efficient to use the integer index
Change-Id: I19e55d0edacb1438a91dd4a75dde1e0d292b7e59
---
M silverpop_export/update_table.sql
1 file changed, 2 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools
refs/changes/82/133182/1
diff --git a/silverpop_export/update_table.sql
b/silverpop_export/update_table.sql
index 2d22fa4..df2444d 100755
--- a/silverpop_export/update_table.sql
+++ b/silverpop_export/update_table.sql
@@ -212,8 +212,8 @@
SUM(IF('2011-07-1' <= ct.receive_date AND ct.receive_date < '2012-07-01',
1, 0)),
SUM(IF('2012-07-1' <= ct.receive_date AND ct.receive_date <
'2013-07-01', 1, 0)),
SUM(IF('2013-07-1' <= ct.receive_date AND ct.receive_date < '2014-07-01',
1, 0))
- FROM civicrm.civicrm_email e FORCE INDEX(UI_email)
- JOIN silverpop_export ex ON e.email=ex.email
+ FROM civicrm.civicrm_email e
+ JOIN silverpop_export ex ON e.id=ex.id
JOIN civicrm.civicrm_contribution ct ON e.contact_id=ct.contact_id
GROUP BY e.email;
--
To view, visit https://gerrit.wikimedia.org/r/133182
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I19e55d0edacb1438a91dd4a75dde1e0d292b7e59
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Adamw <awi...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
