Debug [+/-]
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>=20100310 and created<=20100310 and (genre ='Pop') group by song_id order by points desc limit 20
Array
(
    [CAKEPHP] => e68c666d25b1b3a68e61af8fb6eaf3b0
)
Queries: 5
Username: 
Password:   
No Account yet? Sign-up
Signup
Right
Home

Video

  • Biography
  • Lyrics
  • On Air
  • Discography

Charts for Pop

0

Based on Top-100 from all stations and 1 style(s) (Pop)
Period from 2010-03-10 to 2010-03-10
01
Tick Tock - Kesha
Tick Tock
Kesha » Today's Charts
Pop, played on 3 stations, avg. position 3
Buy Buy
02
Bad Romance - Lady Gaga
Bad Romance
Lady Gaga » Today's Charts
Pop, played on 3 stations, avg. position 4
Buy Buy
03
Telephone (w/ Beyonce) - Lady Gaga
Telephone (w/ Beyonce)
Lady Gaga » Today's Charts
Pop, played on 3 stations, avg. position 7
Buy Buy
04
According To You - Orianthi
According To You
Orianthi » Today's Charts
Pop, played on 3 stations, avg. position 8
Buy Buy
05
Live Like We're Dying - Kris Allen
Live Like We're Dying
Kris Allen » Today's Charts
Pop, played on 3 stations, avg. position 10
Buy Buy
06
Hey, Soul Sister - Train
Hey, Soul Sister
Train » Today's Charts
Pop, played on 3 stations, avg. position 11
Buy Buy
07
Rude Boy - Rihanna
Rude Boy
Rihanna » Today's Charts
Pop, played on 3 stations, avg. position 12
Buy Buy
08
Already Gone - Kelly Clarkson
Already Gone
Kelly Clarkson » Today's Charts
Pop, played on 3 stations, avg. position 26
Buy Buy
09
Blah Blah Blah (w/ 3OH!3) - Ke$ha
Blah Blah Blah (w/ 3OH!3)
Ke$ha » Today's Charts
Pop, played on 3 stations, avg. position 30
Buy Buy
10
Baby (w/ Ludacris) - Justin Bieber
Baby (w/ Ludacris)
Justin Bieber » Today's Charts
Pop, played on 3 stations, avg. position 33
Buy Buy
11
Haven't Met You Yet - Michael Buble
Haven't Met You Yet
Michael Buble » Today's Charts
Pop, played on 3 stations, avg. position 36
Buy Buy
12
All The Right Moves - OneRepublic
All The Right Moves
OneRepublic » Today's Charts
Pop, played on 3 stations, avg. position 40
Buy Buy
13
Whataya Want From Me - Adam Lambert
Whataya Want From Me
Adam Lambert » Today's Charts
Pop, played on 3 stations, avg. position 41
Buy Buy
14
Fallin' For You - Colbie Caillat
Fallin' For You
Colbie Caillat » Today's Charts
Pop, played on 3 stations, avg. position 53
Buy Buy
15
Smile - Uncle Kracker
Smile
Uncle Kracker » Today's Charts
Pop, played on 3 stations, avg. position 56
Buy Buy
16
Two Is Better Than One (w/ ... - Boys Like Girls
Two Is Better Than One (w/ ...
Boys Like Girls » Today's Charts
Pop, played on 3 stations, avg. position 57
Buy Buy
17
Please Don't Leave Me - Pink
Please Don't Leave Me
Pink » Today's Charts
Pop, played on 3 stations, avg. position 65
Buy Buy
18
What Faith Can Do - Kutless
What Faith Can Do
Kutless » Today's Charts
Pop, played on 3 stations, avg. position 83
Buy Buy
19
Hot N Cold - Katy Perry
Hot N Cold
Katy Perry » Today's Charts
Pop, played on 3 stations, avg. position 84
Buy Buy
20
You Found Me - The Fray
You Found Me
The Fray » Today's Charts
Pop, played on 3 stations, avg. position 84
Buy Buy
Progress
Please wait...
Embed-Code: Bookmark and Share
Instructions: copy & paste this code-snippet to include charts on your own web-page!

Remix & Filter

Stations:

 Please wait...
Select All | None

Period:

From:    
YYYY MM DD
To:    
YYYY MM DD

Based on:

No. of Results:

Artist:

Feedback