Remove USE MASTER - avoid locking tables on www
Signed-off-by: Denis Roy <denis.roy@eclipse-foundation.org>
diff --git a/eclipse.org-common/classes/ads/adReports.class.php b/eclipse.org-common/classes/ads/adReports.class.php
index 5e75798..dc7de26 100644
--- a/eclipse.org-common/classes/ads/adReports.class.php
+++ b/eclipse.org-common/classes/ads/adReports.class.php
@@ -1,6 +1,6 @@
<?php
/*******************************************************************************
- * Copyright(c) 2015 Eclipse Foundation and others.
+ * Copyright(c) 2015-2020 Eclipse Foundation and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
@@ -86,7 +86,7 @@
* This function creates a new temporary impressions table
* */
private function _fetchImpressions() {
- $sql = "SELECT /* USE MASTER */
+ $sql = "SELECT /* adReports.class.php:89 */
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 /* USE MASTER */
+ $sql = "SELECT /* adReports.class.php:112 */
campaignKey,
count(*) as clicks,
str_to_date(concat(yearweek(TimeClicked), ' Sunday'), '%X%V %W') as date
