On a utilise le fichier cache. Derniere modif 28/08/2008 23:08:31 cache=29/08/2008 courant=29/08/2008 07:08:07
Liste des personnages fictifs, personnages de légende, et animaux célèbres
SELECT count( starportrait.idstar ) AS count, nom, star.id, photo
FROM star, starportrait, portrait WHERE type LIKE '%pe%' 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 '%pe%') GROUP BY star.id ORDER BY star.nom
CRITERIA=pe