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` <> 6058 AND `Item`.`id` IN (6427, 6426, 6429, 6428, 6430, 11860, 11862, 11863, 11864, 11865, 11866, 11868, 11869, 11870, 11871, 11873, 11874, 11876, 11877, 11878, 11879, 11881, 11886, 11887, 11889, 11890, 11891, 11892, 11894, 11895, 11897, 11898, 5809, 5808, 5675, 5673, 5672, 5674, 5676, 4917, 11875, 11867, 11896, 11888, 11880, 11872, 11861, 11893, 4912, 6434, 5810, 11882, 11883, 11884, 11885, 6424, 6425, 18307, 18308, 18309, 18310, 18311, 18312, 18313, 18314, 18315, 18316, 18317, 18318, 18319, 18320, 18321, 18322, 18323, 18324, 18325, 18326, 18327, 18328, 18329, 18330, 18331, 18332, 18333, 18334, 18335, 18336, 18337, 18338, 18339, 18340, 18341, 18342, 18343, 18344, 18345, 18346, 18347, 18348, 18349, 18350, 18351, 13745, 17430, 17417, 17286, 10794, 17429, 4916, 5805, 5803, 5806, 34181, 34182, 34183, 34184, 34185, 34186, 34189, 34203, 34204, 34205, 34206, 34207, 34208, 34209, 34210, 34211, 34212, 34214, 34215, 34216, 34217, 34218, 34219, 34220, 34221, 34222, 34223, 34224, 34225, 34226, 34227, 34228, 34229, 34230, 34231, 34232, 34233, 34234, 34235, 32615, 32687, 32614, 32613, 32612, 32611, 32621, 32610, 32620, 32609, 32619, 32608, 32618, 32607, 32617, 32606, 32616, 32567, 32566, 32565, 32564, 32563, 32562, 32561, 32560, 32559, 32558, 32569, 32568, 32629, 32663, 32642, 32641, 6198, 34195, 34196, 34194, 34198, 34197, 34199, 34213, 6102, 4915, 5679, 5825, 34180, 33140, 4909, 4910, 6201, 6200, 6199, 32689, 32691, 32597, 32598, 32599, 32688, 35414, 35443, 6103, 35687, 42819, 42820, 42821, 42822, 42823, 42824, 42825, 42826, 42827, 42828, 42829, 42830, 42831, 42832, 42833, 42834, 42836, 42837, 42838, 42839, 42840, 42841, 42842, 42843, 42844, 42845, 42846, 42847, 42848, 42849, 42850, 42851, 42852, 42853, 42854, 42855, 42856, 42858, 42859, 42861, 42862, 42864, 42865, 42866, 42867, 42868, 42869, 42870, 42871, 42872, 42873, 42874, 42875, 42876, 42877, 42880, 42885, 42886, 42887, 42966, 42925, 42973, 42972, 42971, 42970, 42969, 42968, 42927, 42926, 42796, 42795, 44565, 44566, 43111, 42793, 42794, 35680, 42860, 42863, 42618, 42835, 42857, 35679, 42878, 42879, 52827, 52829, 52831, 52832, 52834, 52835, 52837, 52838, 52839, 52840, 52841, 52844, 52845, 52847, 52850, 52854, 52855, 52856, 52858, 52860, 52861, 52862, 52865, 52869, 52870, 52873, 52875, 52876, 52828, 52830, 52833, 52836, 52842, 52843, 52846, 52848, 52849, 52851, 52852, 52853, 52857, 52859, 52863, 52871, 52872, 52874, 52866, 6203, 6202, 52868, 51330, 52867, 52864, 35678, 4914, 5678, 5677, 4913, 35677, 25901, 25902, 59398, 59399, 59400, 59401, 59402, 59403, 59404, 59405, 59406, 59407, 59408, 59409, 59410, 59411, 59412, 59413, 59414, 59415, 59416, 59417, 59418, 59419, 59420, 59421, 59422, 59423, 59424, 59425, 59426, 59427, 59428, 59429, 59430, 59431, 59432, 59433, 59434, 59435, 59436, 59437, 59440, 59441, 58808, 58941, 58942, 58943, 59438, 59439, 58809, 5818, 35685, 35688, 4911, 58944, 68430, 68431, 68443, 68444, 68452, 68453, 68455, 68457, 68459, 68461, 68462, 67897, 68121, 35686, 65133, 94361, 6058, 94386, 94385, 94382, 94381, 92257, 92256, 92255, 92254, 92253, 92251, 92279, 92250, 92278, 92249, 92248, 84610, 92265, 92264, 92235, 92263, 92259, 92230, 92258, 91499, 91498, 91497, 91496, 91495, 87321, 91061, 84450, 88644, 88268, 94384, 94383, 94279, 92277, 92252, 92268, 92267, 92266, 92260, 90452, 88651, 88653, 88654, 88716, 88717, 87327, 87741, 87330, 91860, 91858, 91857, 88652, 84451, 84446, 94375, 92247, 92234, 92261, 87328, 6059, 91057, 88645, 88646, 87360, 84609, 87743, 87742, 87740, 87731, 87730, 87729, 87728, 87727, 87726, 87329, 87359, 86074, 87322, 87320, 87319, 86078, 86075, 86072, 84447, 84611, 84608, 85389, 83927, 65809, 79961, 79963, 79965, 94380, 94379, 94378, 94377, 94376, 84452, 87357, 87358, 84449, 87364, 92262, 88650, 87948, 87946, 87947, 87950, 87949, 85636, 85638, 85637, 87746, 87745, 87744, 87747, 87725, 87724, 87331, 84448, 87362, 87797, 84917, 86040, 86038, 87264, 91741, 91740, 86099, 91754, 91742, 87449, 87801, 87800, 87799, 87798, 94839, 94840, 94841, 94842, 94843, 94844, 94845, 94846, 94847, 94848, 94849, 95063, 95062, 95061, 95060, 95059, 95058, 95057, 95056, 95054, 95053, 95052, 95055, 87752, 87753, 87754, 87755, 87756, 87757, 95082, 95081, 87440, 88267, 94834, 94833, 85725, 87341, 87337, 87338, 87339, 87340, 95166, 95167, 95168, 95169, 95170, 95171, 95172, 95173, 95176, 95175, 95174, 95177, 95178, 95179, 95180, 87361, 87363, 85399, 86033, 86034, 86035, 86036, 86037, 86028, 86029, 86030, 86031, 86032, 91056, 95348, 95347, 87438, 94835, 94832, 65834, 95675, 95674, 95673, 95672, 85727, 85729, 85728, 95768, 91059, 86025, 95975, 95976, 95977, 95978, 95979, 95980, 95981, 95982, 95983, 95984, 95985, 95986, 95987, 95988, 95989, 95990, 95991, 95992, 95993, 95994, 96410, 96411, 96412, 96413, 96414, 96415, 96416, 96417, 96418, 85262, 85260, 85261, 85259, 94296, 94297, 94298, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94308, 94309, 94310, 94311, 94261, 94262, 87262, 85632, 85634, 85635, 85633, 95074, 95075, 95076, 95077, 95078, 95079, 95350, 95352, 91060, 90453, 87811, 86073, 97934, 97933, 97928, 97927, 97946, 97926, 97945, 97925, 97944, 97924, 97943, 97923, 97942, 97922, 97941, 97921, 97940, 97920, 97939, 97919, 97938, 97918, 97937, 97936, 97935, 64646, 64648, 35562, 35564, 64647, 64656, 64657, 64658, 64659, 64660, 85075, 85072, 85073, 85076, 85074, 87346, 87342, 87345, 87344, 88157, 88158, 88159, 91058, 98415, 98435, 98433, 98412, 94838, 94837, 94836, 84931, 95080, 84161, 84162, 84177, 84178, 84179, 87326, 87324, 87323, 87325, 87942, 87943, 87944, 87945, 95351, 99427, 99428, 99429, 99430, 99431, 99432, 99433, 99434, 99435, 99436, 99437, 99438, 99439, 99440, 99441, 99442) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 4 | maybe slow |