SELECT `produit`.`id`, `produit`.`id_support`, if(`produit`.`new`=1,if(datediff(Now(),`produit`.`stamp_update`)<190,1,0),0) `new`, `produit`.`uri`, `produit`.`produit`, `produit`.`pitch`, `support`.`photo1`, `support`.`alt1`, `support`.`indisponible` as indispo FROM `produit` LEFT JOIN `support` ON `support`.`id`=`produit`.`id_support` WHERE id_support in (1738,1753,2026,2031,2051,2052,1766,613,2059,2058,2056,336,2198,2349,2048,2032,1764,1765,1151,2575,458,2239,135,2559,2441,2030,2157,1672,1767,1267,38,1793,2473,156,1070,2033,1576,2457,820,69,1358,339,1067,2332,2013,2012,538,294,1491,1889,1878,2437,1605,1606,304,566,1145,1083,1144,1143,480,729,2202,1607,728,1602,2375,2256,1255,1254,1120,1717,1277,2192,1089,1090,309,120,730,732,945,410,1150,790,1631,1674,1069,1501,1502,1675,1068,1066,910,913,1093,1680,1154,548,1063,1374,539,1061,70,1064,1359,1360,1284,1137,1670,1800,1763,2050,60,2037,2055,1769,1592,2178,678,1985,967,2094,662,1986,1342,776,2130,1840,2121,2112,1234,2035,2090,1806,1809,1924,1906,2005,1655,1233,1635,2109,880,879,968,884,970,885,876,875,877,872,882,878,1330,874,883,971,873,881,2248,145,1858,2124,1935,1206,1207,1204,1208,1205,1654,1927,115,977,1951,896,143,2448,1735,2413,1932,1934,1846,1433,2442,1532,573,1477,1441,1537,1987,1989,479,2201,2200,731,2339,1549,1550,1088,1085,1086,2340,1448,890,61,1921,1919,1432,1437,1468,1837,113,114,1424,1426,1542,1051,1422,1270,1268,638,1225,1238,1240,1239,1237,1241,1242,1236,1637,1055,1227,1226,1271,1269,1423,1164,355,640,1992,1165,1155,1263,748,524,337,1928,1146,1547,854,1456,1917,643,1905,642,1916,1807,1264,1202,1203,1201,1198,1200,1199,1936,1397,2125,1931,2137,2116,2110,144,1664,1665,1280,1273,1272,1274,1440,1445,1261,1425,1147,1331,1457,1633,1640,1642,2114,2105,1649,1832,2123,1634,1641,1645,1650,1666,1667,2135,2113,2104,1395,1402,734,123) and id_partner=1 AND `produit`.`actif` = 1 AND `support`.`archive`=0 order by indisponible
1030
Got error 28 from storage engine