1 2 3 4 5 6 7 8 9
|
"SELECT membre.id_membre, article.id_article, photo_membre, pseudo_membre, titre_article, contenu_article, categorie_article,
occasion_article, tranche_age_article, sexe_article, licence_article, parution_article, vision_article, COUNT(id_note) AS NombreNote, id_juge
FROM article, membre, note_article
WHERE article.id_article = ".$IdArticle."
AND article.id_article = note_article.id_article
AND membre.id_membre = article.id_membre
GROUP BY membre.id_membre, article.id_article, photo_membre, pseudo_membre, titre_article, contenu_article, categorie_article,
occasion_article, tranche_age_article, sexe_article, licence_article, parution_article, vision_article, id_juge"; |
Partager