SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_color`, `Item`.`file1_name`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_rank`, `Campaign`.`id`, `Campaign`.`campaign_price` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` <> 92065 AND `Item`.`id` IN (75433, 70832, 70827, 75431, 70841, 75473, 70774, 75434, 70753, 75432, 70834, 70760, 70767, 70769, 70768, 70766, 70765, 70844, 70843, 70797, 70754, 70752, 70828, 70825, 70824, 70783, 70823, 70822, 70821, 70820, 70772, 71931, 71813, 76814, 76808, 76807, 76806, 71796, 71815, 75749, 70684, 70676, 73259, 73243, 73220, 73240, 71928, 71828, 71827, 71826, 71963, 73251, 73234, 75762, 70669, 70683, 70670, 75765, 70686, 78297, 78298, 78299, 78300, 78301, 78302, 78303, 78304, 78305, 78306, 78307, 78308, 78309, 78310, 78311, 78312, 78313, 78314, 78315, 78316, 78317, 78318, 78319, 78320, 78321, 78322, 78323, 78324, 78325, 78327, 78328, 78329, 78330, 78331, 78332, 78333, 78334, 78335, 78336, 78338, 78339, 78344, 78347, 78348, 78356, 78357, 78358, 78359, 78360, 78361, 78362, 78363, 78364, 78365, 78366, 78367, 78369, 78372, 78373, 78368, 78354, 78353, 78351, 78350, 78349, 78355, 73138, 73139, 78754, 78753, 78789, 78752, 78751, 78750, 78743, 78763, 78744, 71814, 70817, 65741, 83055, 83057, 83059, 83061, 83062, 83063, 83064, 83065, 83066, 83067, 83068, 83069, 83070, 83071, 83090, 83091, 83092, 83093, 83094, 83095, 83096, 83097, 83098, 83099, 83100, 83104, 83105, 83106, 83107, 83111, 83112, 83113, 73193, 83089, 83074, 83088, 83073, 83087, 83072, 83086, 83085, 83076, 83075, 83080, 83079, 83078, 83077, 83084, 83083, 83082, 83081, 83109, 79068, 70674, 75438, 84239, 84238, 70671, 70682, 78370, 78371, 78342, 78340, 73260, 83058, 83110, 83103, 83102, 83101, 83054, 83053, 83056, 83060, 76863, 76815, 78345, 78346, 78341, 76811, 76812, 76813, 73209, 73211, 71802, 78352, 71803, 71804, 71801, 78343, 70826, 78326, 70810, 70816, 86595, 86596, 86597, 86598, 86599, 86600, 86601, 86602, 86603, 86604, 86605, 86606, 86607, 86608, 86609, 86610, 86611, 86612, 86613, 86614, 86616, 86617, 86618, 86619, 86620, 86621, 86622, 86623, 86624, 86625, 86626, 86627, 86628, 86629, 86630, 86631, 86632, 86633, 86634, 86636, 86637, 86638, 86639, 86640, 86641, 86642, 86937, 86938, 86939, 86940, 86941, 86942, 86943, 86944, 86945, 86282, 86615, 87295, 87414, 87413, 78337, 75764, 87816, 87817, 87818, 83108, 88507, 88508, 88509, 88510, 88511, 88512, 88513, 88514, 88515, 88516, 88517, 88518, 88519, 88520, 88521, 88522, 88523, 88524, 88525, 88526, 88527, 88528, 88529, 88530, 88531, 88532, 88533, 88534, 88535, 88536, 88537, 89461, 89458, 84985, 84986, 90316, 90317, 90318, 88169, 91333, 87713, 87712, 87711, 87710, 87709, 87708, 87714, 92044, 92045, 92046, 92047, 92048, 92049, 92050, 92051, 92052, 92053, 92054, 92055, 92056, 92057, 92058, 92059, 92060, 92061, 92062, 92063, 92064, 92065, 92066, 92067, 92068, 92069, 92070, 92071, 92072, 92073, 92074, 92075, 92076, 92077, 92078, 92079, 92080, 92081, 92082, 92083, 92084, 92085, 92086, 87843, 85785, 90320, 91343, 91344, 73257, 78093, 87707, 91342, 94767, 91035, 90314, 95163, 90315, 86635, 96039, 96040, 96041, 96042, 96043, 96044, 96045, 96046, 96047, 96048, 96049, 96050, 96051, 96052, 96053, 96054, 96055, 96056, 96057, 96058, 96059, 96060, 96061, 96062, 96063, 96064, 96684, 96685, 96686, 96687, 96688, 96689, 96690, 96691, 96692, 96693, 96694, 96695, 96696, 96697, 96698, 96699, 96700, 96701, 96702, 96703, 96704, 96705, 96706, 96707, 96708, 96709, 96710, 96711, 96712, 91334, 97789, 94768, 98213, 98155, 98193, 81567, 81568, 98671, 98672, 98673, 98674, 98675, 98676, 98677, 98678, 99319, 99320, 99321, 99322, 99323, 99324, 99325, 99326) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 5 | maybe slow |