SELECT itemid, AVG( ratinglist.rating ) FROM itemlist LEFT JOIN ratinglist USING (itemid) WHERE ratinglist.catagory = ?
ORDER BY AVG( ratinglist.rating )