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` <> 93735 AND `Item`.`id` IN (76708, 70047, 70048, 79643, 79644, 76707, 79645, 76992, 79646, 76993, 76994, 76995, 79647, 76996, 76997, 70028, 79658, 79627, 76745, 70040, 76723, 70000, 70041, 76746, 79639, 70042, 76747, 79642, 70052, 76991, 70213, 79648, 70064, 70018, 70049, 70020, 70074, 70072, 79650, 70071, 70021, 70066, 70065, 70063, 79653, 70026, 79624, 70012, 70029, 76712, 79625, 70031, 72616, 70205, 70073, 70001, 70062, 79657, 79666, 79635, 79660, 79629, 79667, 79636, 79630, 79668, 79637, 76742, 79662, 70037, 76744, 69999, 79663, 79632, 79633, 76697, 70043, 79665, 76729, 79634, 79640, 70044, 79641, 70046, 76702, 79649, 79651, 70067, 70030, 76713, 79626, 79659, 76740, 79661, 76741, 70038, 79638, 70039, 79664, 70045, 70069, 79631, 76724, 70075, 70077, 70078, 70076, 77092, 77093, 77098, 77099, 73627, 73628, 73637, 73639, 73632, 73624, 77089, 77088, 77100, 77090, 77095, 77091, 77087, 73625, 73626, 73629, 73635, 73621, 73631, 73633, 73623, 73634, 73636, 73638, 73630, 73622, 73620, 64527, 77104, 64524, 76714, 77094, 80543, 80544, 80545, 80546, 80547, 80548, 80549, 80560, 80561, 80562, 80563, 80564, 77103, 77105, 64490, 82119, 82121, 82122, 82123, 82124, 82126, 82128, 82129, 82130, 82132, 82133, 82136, 82138, 82139, 82140, 82141, 82142, 82143, 82144, 82145, 82146, 82147, 82148, 82149, 82150, 82151, 82152, 82153, 82154, 82155, 82158, 82159, 76738, 76739, 80542, 77079, 77080, 77082, 82118, 82120, 82125, 79628, 82127, 82131, 82156, 76722, 82157, 82134, 82135, 82137, 79652, 80550, 73614, 70126, 70070, 80555, 80570, 80578, 80569, 73617, 80567, 80566, 80565, 80559, 80558, 80557, 80556, 80554, 80581, 80580, 80579, 80577, 80576, 80575, 80574, 80573, 80571, 80568, 73618, 73616, 73619, 73615, 77096, 77081, 73613, 64522, 64523, 80582, 80572, 85458, 85459, 85460, 85461, 85462, 85463, 80553, 85464, 85491, 80552, 80551, 86133, 86132, 86131, 86130, 86129, 86128, 86127, 86126, 86125, 86124, 86123, 86122, 86121, 86112, 86111, 86120, 86119, 86118, 86117, 86116, 86115, 86114, 86113, 86134, 86135, 86136, 86137, 86138, 86139, 86140, 86141, 86142, 86143, 86144, 86145, 86146, 86147, 86148, 86149, 86150, 86151, 86152, 86153, 86154, 86155, 86156, 86157, 86158, 86159, 86160, 86161, 86162, 86163, 86164, 86165, 86166, 86167, 86168, 86169, 86170, 86171, 86172, 86173, 86174, 86175, 86176, 86177, 86178, 80541, 85784, 85490, 85489, 85481, 85779, 89214, 89222, 89224, 89225, 89230, 89231, 89232, 89233, 89235, 89239, 89243, 89244, 89245, 89246, 89247, 89248, 89251, 89253, 89254, 89255, 89256, 89257, 89258, 89259, 89260, 89261, 89262, 89263, 89264, 89265, 89266, 89209, 89210, 89211, 89212, 89213, 89240, 89206, 89215, 89241, 89216, 89217, 89207, 89218, 89219, 89220, 89221, 89242, 89252, 89223, 89208, 89226, 89227, 89228, 89229, 89249, 89250, 89236, 89237, 89238, 84111, 91117, 87822, 87821, 87820, 77097, 87416, 87417, 87418, 87419, 87420, 87421, 87422, 87423, 85475, 85476, 85477, 85478, 85479, 85480, 85486, 85485, 85482, 85484, 85483, 85496, 85497, 85498, 85499, 85487, 85488, 85492, 85493, 85494, 85495, 85465, 85466, 85467, 85468, 85469, 85470, 85471, 85472, 85473, 85474, 85504, 85503, 85502, 85501, 85500, 85505, 91549, 91548, 91547, 91661, 91660, 91666, 91662, 91664, 91663, 93609, 93610, 93611, 93612, 93613, 93614, 93615, 93616, 93617, 93618, 93619, 93620, 93621, 93622, 93623, 93624, 93625, 93626, 93627, 93628, 93629, 93630, 93631, 93632, 93633, 93634, 93635, 93636, 93637, 93638, 93639, 93640, 93641, 93642, 93643, 93644, 93645, 93646, 93647, 93648, 93649, 93650, 93651, 93652, 93653, 93654, 93655, 93656, 93657, 93658, 93659, 93660, 93661, 93662, 93663, 93664, 93665, 93667, 93668, 93669, 93670, 93671, 93672, 93673, 93674, 93675, 93676, 93677, 93678, 93679, 93680, 93681, 93682, 93683, 93684, 93685, 93686, 93687, 93688, 93689, 93690, 93691, 93692, 93693, 93694, 93695, 93696, 93697, 93698, 93699, 93700, 93701, 93702, 93703, 93704, 93705, 93706, 93707, 93708, 93709, 93710, 93711, 93712, 93713, 93714, 93715, 93716, 93717, 93718, 93719, 93720, 93721, 93722, 93723, 93724, 93725, 93726, 93727, 93728, 93729, 93730, 93731, 93732, 93733, 93734, 93735, 93736, 93737, 93738, 93739, 93740, 93741, 93742, 93743, 93744, 93745, 93746, 93747, 89234, 93955, 91665, 85766, 93666, 90458, 91579, 91580, 76743, 85767, 93993, 93996, 93998, 95185, 85764, 95787, 96500, 96501, 96502, 96503, 96504, 96505, 96506, 96507, 96508, 96509, 96510, 96511, 96512, 96513, 96514, 97376, 91481, 91483, 97798, 97797, 88264, 85765, 98115, 98114, 98113, 98112, 98111, 98110, 98109, 98108, 93954, 93953, 91482, 98826, 98827, 98828, 98829, 98830, 98831, 98832, 98833, 98834, 98835, 98836, 98837, 98838, 98839, 98840, 98841, 98842, 98843, 98844, 98845, 98846, 98847, 98848, 99476, 99477, 99478, 99479, 99480, 99481, 99482, 99483, 99484, 99485, 99486, 99487, 99488, 99489, 99490, 99491, 99492) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 3 | maybe slow |