$result = dbquery("SELECT cp.page_id, cp.page_title, AVG(r.rating_vote) AS ratings FROM ".DB_PREFIX."custom_pages cp

LEFT JOIN ".DB_PREFIX."ratings r ON r.rating_item_id = cp.page_id AND r.rating_type='C'

GROUP BY cp.page_id

ORDER BY ratings DESC LIMIT 0,10");

opentable("top10");

echo "<table width='100%' cellspacing='0' cellpadding='0' border='0'>";

while($data = dbarray($result)) {



echo "<tr><td align='left'><a href='".BASEDIR."viewpage.php?page_id=".$data['page_id']."'>".trimlink($data['page_title'], 30)."</a></td><td align='right'>".ceil($data['ratings'])."</td></tr>";

}

echo "</table>";

closetable();