On a utilise le fichier cache. Derniere modif 20/11/2009 22:11:38 cache=20/11/2009 courant=20/11/2009 23:11:50
List of actors, actresses, cinema and theatre personnalities
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='ci') GROUP BY star.id ORDER BY star.nom
CRITERIA=ci