ORDER BY average_score

[Haggen]

Hi, i want to display the "Low averaged" items on my website, i have done already to display the less reviewed, but these items are not "Lowes averaged", they're just dont have reviews..

I think i must select:

ORDER BY average_score ASC

BUT! i need to query only the items who have been reviewed. Tha would be if "number_reviews" is +1

Any idea?

heres the code:

$query = "SELECT mnl_items.item_id, 
               mnl_items.item, 
               mnl_items.cat_id,
               mnl_items.sub_cat_id,
               IF(Avg( mnl_reviews.review_score ),Avg( mnl_reviews.review_score ),0) AS average_score,
               SUM( mnl_reviews.review_score ) AS total_scores
               FROM mnl_items 
               LEFT JOIN mnl_reviews ON mnl_items.item_id = mnl_reviews.item_id AND mnl_reviews.active='yes'
               GROUP BY mnl_items.item
               ORDER BY average_score ASC
               LIMIT 10";
   $result = mysql_query( $query, $link );  

   echo "<table border=\"0\" width=\"124\" cellspacing=\"1\" cellpadding=\"2\" bgcolor=\"#061376\">\n"; 
   echo "<tr>\n";
   echo "<td align=\"center\" colspan=\"2\" class=\"txtwhite\"  color=\"0E1C8D\">Los más<br>comentados</td>"; 
   echo "</tr>\n";
   echo "<tr>\n"; 
   echo "<td bgcolor=\"#DAA811\" colspan=\"2\"><img src=\"web_images/spacer.gif\" width=\"1\" height=\"1\"></td>\n";
   echo "</tr>\n";
   for ($count = 1; $row = mysql_fetch_row ( $result ); ++$count) 
       {
       print_row ( $count, "<a href=\"review_list.php?item_id=" . $row[0] . "&cat_id=" . $row[2] . "&sub_cat_id=" . $row[3] . "\"><font size=\"1\">" . ucwords ( $row[1] ) );
       }    echo "</table>\n";
	   echo "</form>\n";

Any ideas?