Got error 28 from storage engine
SELECT * FROM SC_products p WHERE ( (p.productID IN (1229,2145,2658,2659,2694,3521,3523,3524,3525,3552,3655,3723,3726,3727,3728,4302,4571,4573,4576,4585,4728,4729,4730,4906,4908,4909)) OR (categoryID IN (686,687,688,689,690,691,692,693,694,695,696,793,797,803,805,817,818,685,661,650,709,710,711,712,713,714,715,716,717,718,719,720,721,726,624,706,838,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,610,611,612,613,614,615,616,617,618,619,620,621,622,1064,1062,1063,981,1034,1117,1139,590,656,672,1067,1068,1069,1070,1073,1066,1071,1072,1074,1075,1076,1077,1093,1065,1084,1095,1099,1104,1106,1110,1078,790,845,847,849,850,853,855,856,858,860,862,865,867,868,875,876,882,881,883,884,885,886,887,844,1058,1057,1060,1059,869,890,897,900,903,904,905,906,907,920,933,889,892,893,895,901,914,916,917,922,923,924,925,928,930,932,935,939,891,944,947,949,950,952,956,957,961,963,943,1024,1098,1100,1107,1097,1115,1120,1119,1118,1126,1127,1128,1133,1134,1135,1136,1137,1125,558)) ) AND (brendID>0) GROUP BY `brendID`