protected function getAggregateEventSelect($eventType, $fieldName) { $select = parent::getAggregateEventSelect($eventType, $fieldName); $select->joinTable(array('useragent_id' => 'event.useragent_id'), 'useragent', 'ua'); $select->where("`ua`.`{$this->_column}` IS NOT NULL"); return $select; }
protected function getAggregateEventSelect($eventType, $fieldName) { $select = parent::getAggregateEventSelect($eventType, $fieldName); $select->where('`event`.`country_id` IS NOT NULL'); return $select; }