
<br/>DB:- line:0;;<pre>
					SELECT 
						s.id as song_id, ( sr.total_value/ sr.total_votes ) as rank2, sr.rank_on
					FROM 
						`wp_wprs_songs` s 
							LEFT JOIN `wp_wprs_songrating` sr ON s.id=sr.song_id
					WHERE 
						s.id IN( 1,3,2 ) AND sr.`rank_on` = 29 
					ORDER BY 
						rank2 DESC, FIELD( s.id, 1,3,2 )
					LIMIT 
						50;<br/></pre>Array
(
)

<br/>DB:- line:0;;<pre>SELECT ( sr.total_value/ sr.total_votes ) as rank FROM `wp_wprs_songrating` sr 
							WHERE song_id=1 AND chart_id=1 AND rank_on <29 
							LIMIT 1;<br/></pre>;;5.0000
<br/>DB:- line:0;;<pre>SELECT ( sr.total_value/ sr.total_votes ) as rank FROM `wp_wprs_songrating` sr 
							WHERE song_id=3 AND chart_id=1 AND rank_on <29 
							LIMIT 1;<br/></pre>;;2.6667
<br/>DB:- line:0;;<pre>SELECT ( sr.total_value/ sr.total_votes ) as rank FROM `wp_wprs_songrating` sr 
							WHERE song_id=2 AND chart_id=1 AND rank_on <29 
							LIMIT 1;<br/></pre>;;4.2000Array
(
    [1] => Array
        (
            [song_id] => 1
            [id] => 1
            [album_id] => 1
            [title] => Its My Life5
            [song_mp3_url] => singles-its-my-life5.mp3
            [song_added] => 0000-00-00 00:00:00
            [genre] => Rock
            [current_chart] => ;1;2;
            [meta_var] => a:3:{s:6:"itunes";s:54:"http://itunes.apple.com/some-url-somewhere/2332434324/";s:6:"amazon";s:50:"http://www.amazon.com/itm/2323423-its-my-life-jovi";s:7:"youtube";s:43:"https://www.youtube.com/watch?v=NZs43m3_oZs";}
            [status] => 1
            [album_name] => Singles
            [album_image] => 
            [artist_name] => Manafest
            [artist_url] => http://manafest.com
            [rank] => 1
            [rank_on] => 26
            [prev_week] => 1
            [rank2] => 0
            [prev_week_votes] => 5.0000
        )

    [3] => Array
        (
            [song_id] => 3
            [id] => 1
            [album_id] => 1
            [title] => Its My Life51
            [song_mp3_url] => singles-its-my-life5.mp3
            [song_added] => 0000-00-00 00:00:00
            [genre] => Rock
            [current_chart] => ;1;
            [meta_var] => a:3:{s:6:"itunes";s:54:"http://itunes.apple.com/some-url-somewhere/2332434324/";s:6:"amazon";s:50:"http://www.amazon.com/itm/2323423-its-my-life-jovi";s:7:"youtube";s:43:"https://www.youtube.com/watch?v=NZs43m3_oZs";}
            [status] => 1
            [album_name] => Singles
            [album_image] => 
            [artist_name] => Manafest
            [artist_url] => http://manafest.com
            [rank] => 2
            [rank_on] => 26
            [prev_week] => 2
            [rank2] => 0
            [prev_week_votes] => 2.6667
        )

    [2] => Array
        (
            [song_id] => 2
            [id] => 1
            [album_id] => 1
            [title] => The Chase
            [song_mp3_url] => singles-the-chase.mp3
            [song_added] => 0000-00-00 00:00:00
            [genre] => Rock
            [current_chart] => ;1;2;
            [meta_var] => a:3:{s:6:"itunes";s:54:"http://itunes.apple.com/some-url-somewhere/2332434324/";s:6:"amazon";s:50:"http://www.amazon.com/itm/2323423-its-my-life-jovi";s:7:"youtube";s:43:"https://www.youtube.com/watch?v=NZs43m3_oZs";}
            [status] => 1
            [album_name] => Singles
            [album_image] => 
            [artist_name] => Manafest
            [artist_url] => http://manafest.com
            [rank] => 3
            [rank_on] => 26
            [prev_week] => 3
            [rank2] => 0
            [prev_week_votes] => 4.2000
        )

)
