Erreur sql!!! SELECT F.id, F.title, F.annee, F.cat,
CAT.cat AS nomsouscat, PARENT.cat AS nomcat,
(SELECT AVG(note) FROM cinefamilia_critique WHERE idarticle=F.id AND type='film') AS notemoy
FROM (
SELECT idfilm, MAX(date) AS dernieredate
FROM cinefamilia_gueule
GROUP BY idfilm
ORDER BY dernieredate DESC
LIMIT 0,6
) AS C
JOIN cinefamilia_fiche F ON F.id = C.idfilm
LEFT JOIN cinefamilia_categorie CAT ON F.cat = CAT.id
LEFT JOIN cinefamilia_categorie PARENT ON CAT.sous_cat = PARENT.id
ORDER BY C.dernieredate DESC User 'cinefamilia' has exceeded the 'max_questions' resource (current value: 40000)