Двойная выборка из базы - как сделать "Лучшее по рейтингу"

$_query = 'SELECT mid, COUNT(mid) AS middd FROM videoplus GROUP by mid ORDER by middd DESC ';
$_result = mysql_query ($_query) or die ('Query failed : ' . mysql_error ());
$NUM1 = mysql_num_rows ($_result);
 
while ($_line = mysql_fetch_array ($_result, MYSQL_ASSOC))
{
 
 $query = 'SELECT mid, AVG(rating) AS rating FROM videoplus WHERE mid='$_line[mid]' GROUP by mid HAVING rating > 4.75 ORDER BY rating DESC LIMIT 10';
 $result = mysql_query ($query) or die ('Query failed : ' . mysql_error ());
 
  while ($line = mysql_fetch_array ($result, MYSQL_ASSOC))
  {
 
   $toprating .= '<tr><td bgcolor='$tbl_cntr_bg_col'><a href='/index.php?id=$_line[mid]' class='sl'>$line[mid]</a></td>
   <td width='30' class='small' align='right' bgcolor='$tbl_btm_bg_col'>$line[rating]</td></tr>';
  }
 }

$query = 'SELECT mid, middd, ratinggg FROM (SELECT mid, COUNT(mid) AS middd, AVG(rating) AS ratinggg FROM videoplus GROUP BY mid HAVING ratinggg > 4.75 ORDER BY middd DESC LIMIT 15) AS temp_table ';

$query = 'select mid, avg(rating) as rating from videoplus group by mid having avg(rating) > 2.5 order by 2 desc limit 10';
 $result = mysql_query ($query) or die ('Query failed : ' . mysql_error ());
 while ($line = mysql_fetch_array ($result, MYSQL_ASSOC)) {
  $C++;
  $toprating .= '<tr><td bgcolor='$tbl_cntr_bg_col'><a href='/index.php?id=$line[mid]' class='sl'>$C</a></td>  <td width='30' class='small' align='right' bgcolor='$tbl_btm_bg_col'>$line[rating]</td></tr>
';
 }
echo '<table>
$toprating</table>';

$query = 'select mid, COUNT(mid) as middd,
avg(rating) as ratinggg from videoplus
group by mid having ratinggg > 4.5
order by middd desc limit 10';