SELECT pbn_reviews.*,
AVG(pbn_reviewvotes.vote) AS avgvote FROM pbn_reviews
LEFT JOIN pbn_reviewvotes ON(pbn_reviews.reviewid=pbn_reviewvotes.reviewid)
WHERE pbn_reviews.productid=1 GROUP BY pbn_reviews.reviewid ORDER BY avgvote DESC;