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(340,630,647,686,690,691,697,703,704,708,710,1085,1115,1118,1119,1189,1293,1379,1380,1706,1860,1888,2054,2083,2136,2482,2501,2539,2540,2541,2596,2617,3391) GROUP BY produits.id ORDER BY champ_opt.val_c DESC LIMIT 0, 12
Got error 28 from storage engine