SELECT produits.id as id ,produits.nom as nom,produits.arbo as arbo FROM produits INNER JOIN champ_opt ON produits.id = champ_opt.id_l AND champ_opt.id_cgen=7 AND champ_opt.id_l IN(151,206,208,211,212,213,226,359,370,605,678,1772,2095,2099,2100,2101,2259,2619,2620) GROUP BY produits.id ORDER BY champ_opt.val_c DESC LIMIT 0, 12
Got error 28 from storage engine