JOIN whit active record, 3 tables + pagination..

[eluser]flaky[/eluser]
Read the user guide

Code:

$this->db->select('a.titulo, b.marca, SUM(c.puntos)');
$this->db->from('table1 AS a');
$this->db->join('table2 AS b', 'a.marca = b.id');
$this->db->join('table AS c', 'a.id_proceso = c.id_proceso');
$this->db->where('a.estado', '1');
$this->db->group_by('a.titulo, b.marca');
$this->db->order_by('puntos');
$this->db->limit(10, 5);