Nos récits par langue, tranche d'âge et thème

SELECT r.*, r.image_p, t.name AS theme_name, t.id AS theme_id, a.label AS age_label, lr.langue AS langue_name, lr.code_langue FROM recits r JOIN themes t ON r.theme_id = t.id JOIN age_groups a ON t.age_group_id = a.id and t.type='recit' LEFT JOIN langue_recit lr ON r.langue_id = lr.id WHERE 1=1