select song_id,sum(points_100) as points,avg(avg_100) as rank,sum(played_100) as stations from rankings_aggregated as rankings use index (ra_created_genre_song_id) where created>=20100902 and created<=20100902 and (genre ='Holiday') group by song_id order by points desc limit 20

Array
(
    [CAKEPHP] => 1ivomnva3qp6gqlng24jprpag5
)
Queries: 5