http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90628
Revision: 90628
Author: rfaulk
Date: 2011-06-22 23:06:25 +0000 (Wed, 22 Jun 2011)
Log Message:
-----------
used in 'campaigns' django view to display a list of campaigns with donation,
timestamp, and report info
Modified Paths:
--------------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_totals.sql
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_totals.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_totals.sql
2011-06-22 23:05:37 UTC (rev 90627)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_totals.sql
2011-06-22 23:06:25 UTC (rev 90628)
@@ -6,15 +6,15 @@
faulkner.test.test_name,
drupal.contribution_tracking.utm_campaign,
sum(not isnull(contribution_tracking.contribution_id)) as donations,
-min(receive_date) as earliest_timestamp,
-if(not isnull(faulkner.test.test_name),1,0) as report_exists
+min(ts) as earliest_timestamp,
+if(not isnull(faulkner.test.test_name),1,NULL) as report_exists
from
drupal.contribution_tracking left join civicrm.civicrm_contribution ON
(drupal.contribution_tracking.contribution_id = civicrm.civicrm_contribution.id)
left join faulkner.test on faulkner.test.utm_campaign =
drupal.contribution_tracking.utm_campaign
-where receive_date >= %s and receive_date < %s
+where ts >= '%s' and ts < '%s'
group by 2
-order by 3 desc;
+order by 4 desc;
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
