On a utilise le fichier cache. Derniere modif 24/07/2008 09:07:20 cache=24/07/2008 courant=24/07/2008 09:07:48
List of famous athletes and gymnasts
SELECT count( starportrait.idstar ) AS count, nom, star.id, photo
FROM star, starportrait, portrait WHERE type LIKE '%sp%' AND star.id = starportrait.idstar
AND portrait.id = starportrait.idportrait AND portrait.status = 0
GROUP BY starportrait.idstar ORDER BY count DESC LIMIT 14
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 like '%sp%') GROUP BY star.id ORDER BY star.nom
CRITERIA=sp
