CampaignImpressions is out of sync
Signed-off-by: Christopher Guindon <chris.guindon@eclipse-foundation.org>
diff --git a/eclipse.org-common/classes/ads/adReports.class.php b/eclipse.org-common/classes/ads/adReports.class.php
index feb773c..5e75798 100644
--- a/eclipse.org-common/classes/ads/adReports.class.php
+++ b/eclipse.org-common/classes/ads/adReports.class.php
@@ -86,7 +86,7 @@
* This function creates a new temporary impressions table
* */
private function _fetchImpressions() {
- $sql = "SELECT
+ $sql = "SELECT /* USE MASTER */
campaignKey,
count(*) as impressions,
str_to_date(concat(yearweek(TimeImpressed), ' Sunday'), '%X%V %W') as date
@@ -109,7 +109,7 @@
* This function creates a new temporary Clicks table
* */
private function _fetchClicks() {
- $sql = "SELECT
+ $sql = "SELECT /* USE MASTER */
campaignKey,
count(*) as clicks,
str_to_date(concat(yearweek(TimeClicked), ' Sunday'), '%X%V %W') as date