[eluser]tnathos[/eluser]
HI.. how i can make this query whit Active record.. and i need put tha pagination..
Code:
select a.titulo, b.marca, sum(c.puntos) as puntos
from
table1 a,
table2 b,
table3 c
where
a.marca=b.id and
a.id_proceso=c.id_proceso and
a.estado =1
group by
a.titulo, b.marca
order by puntos DESC
LIMIT 10, 5