On a utilise le fichier cache. Derniere modif 02/12/2008 21:12:03 cache=03/12/2008 courant=03/12/2008 05:12:00
List of top-models and fashion celebrities
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='ma') GROUP BY star.id ORDER BY star.nom
CRITERIA=ma