diff options
author | Thomas Steur <tsteur@users.noreply.github.com> | 2018-05-19 04:19:00 +0300 |
---|---|---|
committer | diosmosis <diosmosis@users.noreply.github.com> | 2018-05-19 04:19:00 +0300 |
commit | 7f3e0c7d7e0cdb73c8ae2e3862c147aac1e63c39 (patch) | |
tree | 29ff84732f53f1eb193b6cb4859c349a00528202 /plugins | |
parent | 7751aeb30ee64807c7de347767adfd616a224b60 (diff) |
Better group by in actions archiver (#12929)
Diffstat (limited to 'plugins')
-rw-r--r-- | plugins/Actions/Archiver.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/plugins/Actions/Archiver.php b/plugins/Actions/Archiver.php index 7610e973ef..c7209a1c10 100644 --- a/plugins/Actions/Archiver.php +++ b/plugins/Actions/Archiver.php @@ -290,7 +290,7 @@ class Archiver extends \Piwik\Plugin\Archiver AND log_visit.idsite = ? AND log_visit.%s > 0"; - $groupBy = "log_visit.%s, idaction"; + $groupBy = "log_visit.%s"; $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "visit_entry_idaction_url", $rankingQuery); @@ -335,7 +335,7 @@ class Archiver extends \Piwik\Plugin\Archiver AND log_visit.idsite = ? AND log_visit.%s > 0"; - $groupBy = "log_visit.%s, idaction"; + $groupBy = "log_visit.%s"; $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "visit_exit_idaction_url", $rankingQuery); @@ -381,7 +381,7 @@ class Archiver extends \Piwik\Plugin\Archiver AND log_link_visit_action.%s > 0" . $this->getWhereClauseActionIsNotEvent(); - $groupBy = "log_link_visit_action.%s, idaction"; + $groupBy = "log_link_visit_action.%s"; $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "idaction_url_ref", $rankingQuery); |