Erreur SQL ! SELECT B.id AS idfilm, B.title, B.annee, B.cat,
CAT.cat AS nomsouscat, PARENT.cat AS nomcat,
(SELECT AVG(note) FROM cinefamilia_critique WHERE idarticle=B.id AND type='film') AS notemoy
FROM cinefamilia_casting A
JOIN cinefamilia_fiche B ON A.idfilm = B.id
LEFT JOIN cinefamilia_categorie CAT ON B.cat = CAT.id
LEFT JOIN cinefamilia_categorie PARENT ON CAT.sous_cat = PARENT.id
WHERE A.idartiste='1453' AND A.typecasting='film'
ORDER BY rand() LIMIT 0,5 User 'cinefamilia' has exceeded the 'max_questions' resource (current value: 40000)