Aide Mémoire

SELECT *
FROM `demo_cde_det` AS t1
LEFT JOIN `demo_art` AS t2 ON t1.`id_art` = t2.`cle_art`
LEFT JOIN `demo_cde` AS t3 ON t3.`cle_cde` = t1.`id_cde`
WHERE t3.`id_entr` =26
AND t2.`desi` LIKE '%BLABLABLA%'