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(57,174,303,1065,1394,1421,1422,1423,1449,1471,1483,1563,1564,1565,1599,1663,1665,1666,1667,1668,1688,1689,1690,1691,1693,1694,1695,1696,1697,1698,1777,1820,1966,2057,2106,2319,2390,2391,2631,2655,3252,3309,3411) GROUP BY produits.id ORDER BY champ_opt.val_c DESC LIMIT 0, 12
Got error 28 from storage engine