Примерно так
$query="SELECT gallery.pid, gallery.path, gallery.comment, gallery.date_added, users.login, votes.sum, votes.total_voted
FROM gallery, users, votes
WHERE (gallery.uid = users.uid)
AND (gallery.pid = votes.pid) GROUP BY gallery.pid LIMIT $start , $finish"...