$this->getSelect()
	->join(
		array('_table_views' => $this->getTable('reports/event')),
		"e.entity_id = _table_views.object_id AND e.entity_type_id = {$this->getProductEntityTypeId()}",
		array('views' => 'COUNT(_table_views.event_id)')
	      )
	 ->group('e.entity_id');
	 ->where('_table_views.event_type_id = ?', $productViewEvent)
         ->group('e.entity_id')
	 ->order('COUNT(_table_views.event_id) desc');