http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90629
Revision: 90629
Author: rfaulk
Date: 2011-06-22 23:12:05 +0000 (Wed, 22 Jun 2011)
Log Message:
-----------
Used by CampaignIntervalReportingLoader to return views and donations for
camapaigns broken up by time
Modified Paths:
--------------
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely.sql
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely_total.sql
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely.sql
2011-06-22 23:06:25 UTC (rev 90628)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely.sql
2011-06-22 23:12:05 UTC (rev 90629)
@@ -9,17 +9,19 @@
from
+
+
(select
DATE_FORMAT(request_time,'%sY%sm%sd%sH') as dt_hr,
FLOOR(MINUTE(request_time) / %s) * %s as dt_min,
utm_source as banner,
landing_page,
count(*) as views
-from landing_page
+from landing_page_requests
where request_time >= '%s' and request_time < '%s' and utm_campaign REGEXP
'%s'
group by 1,2,3,4) as lp
-join
+left join
(select
Modified:
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely_total.sql
===================================================================
---
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely_total.sql
2011-06-22 23:06:25 UTC (rev 90628)
+++
trunk/fundraiser-statistics/fundraiser-scripts/sql/report_campaign_metrics_minutely_total.sql
2011-06-22 23:12:05 UTC (rev 90629)
@@ -13,11 +13,11 @@
DATE_FORMAT(request_time,'%sY%sm%sd%sH') as dt_hr,
FLOOR(MINUTE(request_time) / %s) * %s as dt_min,
count(*) as views
-from landing_page
+from landing_page_requests
where request_time >= '%s' and request_time < '%s' and utm_campaign REGEXP
'%s'
group by 1,2) as lp_tot
-join
+left join
(select
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
