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
AND t.id = ? AND a.label = ?
Tous les récits “Découverte du monde et des animaux”
pour 1-3 ans
