| Index: trunk/extensions/MetricsReporting/metrics/ComScoreUniqueVisitorMetric.php |
| — | — | @@ -13,7 +13,7 @@ |
| 14 | 14 | return array( |
| 15 | 15 | 'table' => array( 'comscore', 'comscore_regions' ), |
| 16 | 16 | 'conds' => array(), |
| 17 | | - 'options' => array( 'GROUP BY' => 'date', 'ORDER BY' => 'date, project_code, region_code' ), |
| | 17 | + 'options' => array( 'GROUP BY' => 'comscore.region_code, date', 'ORDER BY' => 'comscore.region_code, date' ), |
| 18 | 18 | 'join_conds' => array( 'comscore_regions' => array( 'LEFT JOIN', 'comscore.region_code = comscore_regions.region_code' ) |
| 19 | 19 | ), |
| 20 | 20 | ); |