select song_id,sum(points_100) as points,avg(avg_100) as rank,sum(played_100) as stations from rankings_aggregated as rankings where created>=20100310 and created<=20100310 and (station_ids like '%,2413,%') group by song_id order by points desc limit 20

Array
(
    [CAKEPHP] => b88f374badba71761e5a54d37f179bd0
)
Queries: 14