SELECT *, (SELECT nom FROM galerie_cat WHERE galerie_post.cat=galerie_cat.id) AS categorie, (SELECT count(*) FROM galerie_comments WHERE galerie_post.id=galerie_comments.post ) AS nb_com FROM galerie_post WHERE actif='1' ORDER BY alaune DESC, aladeux DESC, pos ASC, id ASC