On a utilise le fichier cache. Derniere modif 22/11/2009 02:11:58 cache=22/11/2009 courant=22/11/2009 03:11:34
List of other famous characters : writers, painters, poets, businessmen, scientists, religious people and other...
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 (type='au' OR type='ec' OR type='ar' OR type='' OR type='sc' OR type='hi' OR type='re' OR type='bu') GROUP BY star.id ORDER BY star.nom
CRITERIA=au