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(170,356,526,625,642,733,741,749,1073,1192,1205,1583,1811,1843,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1951,1952,1953,1997,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2164,2165,2166,2167,2168,2169,2170,2171,2172,2173,2174,2175,2176,2177,2178,2179,2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2215,2507,2672,3323) GROUP BY produits.id ORDER BY champ_opt.val_c DESC LIMIT 0, 12
Got error 28 from storage engine