On a utilise le fichier cache. Derniere modif 07/11/2009 18:11:40 cache=07/11/2009 courant=07/11/2009 19:11:00
List of singers, bands and famous musicians.
SQL=SELECT star.nom, star.id, star.photo, COUNT(starportrait.idportrait) AS count
FROM star, starportrait, portrait
WHERE star.id = starportrait.idstar AND portrait.id = starportrait.idportrait AND portrait.status = 0 AND star.type='mu' GROUP BY star.id ORDER BY star.nom
CRITERIA=mu