| 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` <> 91387 AND `Item`.`id` IN (6366, 6368, 6369, 6370, 6371, 6374, 6375, 6376, 6377, 6399, 6402, 6403, 6405, 6406, 6354, 6357, 6352, 6355, 6353, 6384, 6383, 6382, 6380, 6379, 6378, 6356, 5280, 6385, 6381, 6350, 6351, 6388, 5886, 5888, 11586, 11587, 11588, 11589, 11590, 11591, 11593, 11594, 11595, 11596, 11597, 11598, 11599, 11601, 11602, 11603, 11604, 11605, 11606, 11607, 11608, 11609, 11610, 11611, 11612, 11613, 11614, 11615, 11616, 11617, 11618, 11619, 11621, 11622, 11624, 11625, 11626, 11627, 11628, 11629, 11630, 11631, 11633, 11634, 11635, 11636, 11637, 11638, 11639, 11640, 11641, 11642, 11643, 11644, 11645, 11646, 11647, 11648, 11649, 11650, 11651, 11652, 11653, 11654, 11655, 11656, 11657, 11658, 11659, 11660, 11661, 11662, 11663, 11665, 11666, 11667, 11668, 11669, 11670, 11671, 11673, 11674, 11675, 11676, 11677, 11678, 11679, 11681, 11682, 11684, 11685, 11686, 11687, 11688, 11689, 11690, 11691, 11692, 11693, 11694, 11695, 11696, 11697, 11698, 11699, 11700, 11701, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 11713, 11714, 11715, 11716, 11717, 11718, 11719, 11720, 11721, 11722, 11723, 11724, 11725, 11726, 11727, 11728, 11729, 11730, 11732, 11733, 5613, 5614, 5282, 5588, 5279, 5587, 5267, 5277, 5540, 5585, 5598, 5537, 5538, 5596, 5539, 5534, 5533, 5586, 5535, 5589, 5536, 5583, 5602, 5615, 5603, 5604, 5584, 5597, 5276, 5278, 5288, 5287, 5289, 5297, 5268, 5221, 5220, 5219, 5218, 5217, 5216, 11672, 11680, 11712, 11632, 11664, 11592, 11600, 11731, 11620, 11623, 6404, 6367, 11683, 12486, 12485, 12487, 12488, 12489, 5252, 5250, 6090, 6091, 6043, 6044, 6372, 6373, 6417, 6395, 17966, 17967, 17968, 17969, 17970, 17971, 17972, 17973, 17974, 17975, 17976, 17977, 17978, 17979, 17980, 17981, 17982, 17983, 17984, 17985, 17986, 17987, 17988, 17989, 17990, 17991, 17992, 17993, 17994, 17995, 17996, 17997, 17998, 17999, 18000, 18001, 18002, 18003, 18004, 18005, 18006, 18007, 18008, 18009, 18010, 18011, 18012, 18013, 18014, 18015, 18016, 18017, 18018, 18019, 18020, 18021, 18022, 18023, 18024, 18025, 18026, 18027, 18028, 18029, 18030, 18031, 18032, 18033, 18034, 18035, 18036, 18037, 18038, 18039, 18040, 18041, 18042, 18043, 18044, 18045, 18046, 18047, 18048, 18049, 18050, 18051, 18052, 18053, 18055, 18056, 18057, 18058, 18059, 18060, 18061, 18062, 18063, 18064, 18065, 18066, 18067, 18068, 18071, 18072, 18073, 18074, 18075, 18076, 18077, 18078, 18079, 18080, 18081, 18082, 18083, 18084, 18085, 18086, 18087, 18088, 18089, 18090, 18092, 18093, 18094, 18095, 18096, 18097, 18098, 18099, 18100, 18101, 18102, 18103, 18104, 18105, 18106, 18107, 18108, 18109, 18110, 18111, 18112, 18113, 18114, 18115, 18116, 18117, 18118, 18119, 18120, 18121, 18122, 18123, 18124, 18125, 18126, 18127, 18128, 18129, 18140, 18141, 18142, 18143, 18144, 18145, 6088, 15217, 18137, 18054, 6089, 12964, 18069, 18070, 5302, 5303, 5304, 5255, 5253, 5254, 5591, 5592, 5590, 5231, 5514, 5511, 5513, 5512, 5889, 5251, 5300, 5301, 5305, 5306, 5307, 18091, 33771, 33772, 33773, 33774, 33775, 33776, 33777, 33778, 33779, 33780, 33781, 33785, 33788, 33789, 33790, 33791, 33792, 33793, 33794, 33795, 33796, 33797, 33798, 33799, 33800, 33801, 33802, 33803, 33804, 33805, 33806, 33807, 33808, 33809, 33810, 33812, 33813, 33816, 33817, 33818, 33819, 33820, 33821, 33822, 33823, 33824, 33825, 33826, 33827, 33828, 33829, 33830, 33831, 33832, 33833, 33834, 33835, 33836, 33837, 33838, 33839, 33840, 33841, 33842, 33843, 33844, 33845, 33846, 33847, 33848, 33849, 33850, 33851, 33852, 33853, 33860, 33861, 33863, 33868, 33869, 33870, 33871, 33872, 33873, 33874, 33875, 33876, 33877, 33878, 33879, 33880, 33881, 33882, 33883, 33884, 33885, 33886, 33887, 33888, 33889, 33898, 33899, 33900, 33901, 33902, 33903, 33904, 33905, 33906, 33916, 33917, 33918, 33919, 33920, 33921, 33922, 33923, 33924, 33925, 33926, 33927, 33928, 33929, 33930, 33931, 33932, 33933, 33934, 33935, 33936, 33937, 33938, 33939, 33940, 33941, 33944, 33945, 33946, 33947, 33948, 33951, 33952, 33953, 33954, 33955, 33956, 33957, 33958, 33959, 33960, 33961, 33962, 33963, 33964, 33965, 33966, 33967, 33968, 33969, 33970, 33971, 33972, 33979, 33980, 33983, 33984, 33987, 33990, 33991, 33992, 33994, 33995, 33996, 33997, 33998, 33999, 34000, 34001, 33942, 33786, 33787, 33811, 33949, 33985, 33986, 6049, 6050, 33993, 33988, 33989, 33943, 33982, 33981, 32209, 35565, 33974, 33973, 39027, 39028, 39029, 39030, 39031, 39032, 39033, 39034, 39035, 39036, 39037, 39038, 39039, 39040, 39041, 39042, 39043, 39044, 39045, 39046, 39047, 39048, 39049, 39050, 39051, 39052, 39053, 39054, 39055, 39056, 39057, 39058, 39059, 39060, 39061, 39064, 39066, 39067, 39068, 39069, 39070, 39071, 39072, 39073, 39074, 39075, 39076, 39077, 39078, 39079, 39080, 39081, 39082, 39083, 39084, 39085, 39086, 39087, 39088, 39089, 39090, 39091, 39092, 39093, 39094, 39095, 39096, 39097, 39098, 39099, 39100, 39101, 39102, 39103, 39104, 39105, 39108, 39109, 39110, 39111, 39112, 39113, 39026, 39022, 39018, 39012, 34004, 34003, 34002, 39006, 39005, 39001, 39000, 38999, 38998, 38988, 38987, 38983, 38982, 38981, 38980, 38979, 38978, 38977, 38976, 38975, 38972, 38973, 38974, 38969, 38970, 38971, 38966, 38967, 38968, 38963, 38964, 38965, 39107, 39106, 34005, 38985, 38984, 44024, 35586, 35585, 35612, 35613, 35597, 35599, 35051, 35052, 36318, 44294, 44295, 44296, 44297, 44298, 44299, 44300, 44301, 44302, 44303, 44306, 44307, 44308, 44309, 44310, 44311, 44312, 44313, 44314, 44315, 44316, 44317, 44318, 44319, 44320, 44321, 44322, 44324, 44325, 44326, 44327, 44328, 44329, 44330, 44331, 44332, 44333, 44334, 44335, 44336, 44337, 44323, 35584, 35570, 35566, 35567, 38989, 39063, 39065, 38986, 6087, 35588, 35591, 35592, 35580, 35601, 35602, 6086, 35571, 39062, 44305, 44304, 52521, 52522, 52523, 52524, 52525, 52526, 52527, 52528, 52529, 52530, 52531, 52532, 52533, 52534, 52535, 52536, 52537, 52538, 52539, 52541, 52542, 52543, 52544, 52545, 52546, 52547, 52548, 52549, 52550, 52551, 52552, 52553, 52554, 52555, 52556, 52557, 52558, 52559, 52560, 52562, 52563, 52564, 52566, 52568, 52569, 52570, 52571, 52572, 52574, 52576, 52577, 52578, 52580, 52581, 52582, 52583, 52585, 52586, 52591, 52592, 52593, 52594, 52595, 52596, 52597, 52598, 52599, 52600, 52601, 52602, 52603, 52604, 52605, 52606, 52608, 52609, 52610, 52611, 52612, 52613, 52614, 52615, 52616, 52617, 52618, 52619, 52620, 52621, 52622, 52623, 52624, 52625, 52626, 52627, 52628, 52630, 52631, 52632, 52633, 52634, 52635, 52636, 52639, 52640, 52641, 52642, 50962, 50961, 50900, 50901, 50902, 50903, 50904, 50905, 50906, 50907, 50908, 50909, 50886, 50887, 50888, 50889, 50890, 50930, 50914, 50202, 50191, 50192, 50193, 50185, 50186, 50187, 50188, 53690, 52643, 52638, 52637, 52590, 52589, 52607, 52588, 52629, 52587, 12979, 12980, 6046, 6045, 6048, 35278, 35281, 35282, 35598, 35610, 52573, 35587, 6040, 52584, 35581, 52561, 52565, 5296, 35589, 38458, 35611, 35283, 35280, 35277, 35607, 35600, 5299, 52540, 44792, 52567, 52575, 52579, 6041, 35582, 62149, 62150, 62153, 62154, 62155, 62156, 62157, 62158, 62159, 62163, 62164, 62165, 62167, 62168, 62169, 62170, 62174, 62175, 62176, 62177, 62179, 62181, 62182, 62183, 62184, 62186, 62188, 62189, 62191, 62195, 62196, 62197, 62200, 62201, 62203, 62205, 62207, 62208, 62209, 62210, 62211, 62214, 62215, 62216, 62217, 62218, 62219, 62220, 62221, 62222, 62223, 62224, 62225, 62226, 62227, 62228, 62230, 62231, 62233, 62234, 62235, 62236, 62237, 62241, 62243, 62244, 62245, 62246, 62247, 62248, 62249, 62250, 62065, 62066, 62067, 62068, 62069, 62070, 62133, 62061, 62062, 62063, 62064, 62213, 6071, 6073, 6042, 62198, 62185, 62202, 62229, 62187, 35609, 62199, 38462, 5298, 62161, 62162, 6072, 36306, 62151, 62172, 62242, 62204, 6070, 62206, 35583, 62212, 62190, 62178, 62180, 62171, 62152, 62160, 65071, 65118, 65064, 35606, 35608, 57751, 57750, 35563, 62166, 62239, 62240, 65060, 65062, 65063, 62173, 64469, 65061, 62238, 71207, 71208, 71209, 71210, 71212, 71214, 71223, 71226, 71227, 71228, 71229, 71236, 71256, 71260, 71262, 71263, 71264, 71230, 71231, 71232, 71233, 71235, 71060, 71061, 71062, 71063, 65077, 71234, 5608, 71087, 71246, 65016, 65076, 35590, 71222, 69738, 69737, 69736, 69734, 71250, 71249, 71248, 71247, 71219, 71221, 71220, 71327, 71156, 71157, 71151, 71152, 71153, 71065, 71203, 71202, 71204, 71205, 71165, 71166, 71167, 71168, 71201, 71343, 71344, 71345, 71346, 73035, 73038, 73037, 73036, 71218, 69733, 74357, 74359, 74360, 74361, 74363, 74364, 74373, 74375, 74376, 74377, 74383, 74384, 74392, 74396, 74397, 74402, 36305, 13006, 13005, 73513, 65689, 65687, 65688, 71217, 75404, 75405, 75406, 75407, 75408, 75411, 75412, 75415, 75416, 75419, 75420, 75421, 75422, 75423, 75424, 75425, 75426, 75427, 75428, 75429, 75430, 35561, 65066, 38457, 6083, 6082, 71225, 71224, 65690, 65691, 65692, 65067, 65069, 38475, 75409, 71215, 71216, 75418, 75414, 65068, 71155, 75417, 65811, 75413, 77110, 57749, 73603, 73602, 73604, 73597, 73599, 73598, 73600, 73601, 65125, 73511, 73512, 79209, 79210, 79219, 79220, 79223, 79224, 79225, 69730, 69732, 69731, 79207, 73040, 73039, 45520, 36297, 36294, 36295, 35594, 75410, 44789, 35603, 48166, 81229, 77560, 77111, 77119, 65807, 77112, 64653, 77559, 77562, 36300, 81222, 81226, 81227, 81231, 65074, 36304, 75402, 75403, 82247, 82249, 71244, 71245, 71241, 81223, 65808, 77114, 78152, 80641, 81089, 36301, 65190, 81230, 71240, 71237, 71239, 71238, 71271, 71272, 71273, 71274, 79217, 79215, 79216, 79218, 71268, 71269, 71267, 71266, 71206, 82254, 79214, 79211, 79213, 79212, 69739, 71211, 71213, 74797, 80774, 81225, 81224, 77561, 77558, 77563, 77552, 80639, 65075, 81228, 81091, 36293, 64650, 84639, 84636, 84638, 84635, 81095, 84215, 69735, 36298, 36299, 36302, 64466, 65073, 44790, 77123, 84968, 84969, 84970, 81221, 85545, 85546, 85547, 85548, 71255, 82250, 82251, 6055, 83884, 83762, 36296, 35605, 35604, 81641, 64468, 85401, 71178, 71179, 71177, 85641, 85640, 85639, 85361, 85402, 85348, 84011, 83950, 83911, 35595, 82248, 74378, 74380, 74381, 74379, 74395, 74389, 74390, 74391, 74394, 79964, 79962, 74365, 74367, 74366, 74356, 74354, 74355, 74358, 71243, 71242, 79222, 79221, 74374, 74371, 74370, 71258, 82252, 71257, 71261, 71259, 74398, 74400, 74399, 74401, 82253, 74388, 74387, 74386, 71176, 81642, 81638, 81640, 81639, 81637, 85347, 86044, 77314, 77313, 81644, 83882, 77158, 83760, 81643, 6052, 74452, 6053, 86026, 86043, 85403, 84954, 88248, 88247, 88640, 88641, 88643, 88648, 88649, 88655, 88656, 88657, 88658, 88665, 88666, 88667, 88668, 88669, 83883, 90247, 90248, 90249, 90250, 90251, 88722, 88738, 88739, 88718, 88719, 88720, 88721, 88963, 69740, 88964, 88638, 88639, 83761, 84304, 87736, 84308, 44791, 83951, 88153, 86100, 85362, 84955, 80814, 85726, 86039, 86042, 86046, 73644, 84302, 84303, 84301, 84300, 84299, 84298, 84297, 85724, 81645, 91387, 91133, 91134, 77186, 85020, 85019, 85021, 85023, 85022, 85024, 77183, 77191, 77188, 84602, 84600, 73863, 73862, 73860, 73861, 73859, 73858, 73856, 73857, 73855, 73854, 73852, 73853, 85662, 87424, 88160, 86045, 90328, 84019, 84305, 84306, 84307, 83765, 88663, 88659, 88660, 88661, 88662, 88664, 92233, 92236, 92239, 92245, 92246, 92272, 92273, 92274, 84018, 85263, 85264, 85265, 85266, 91733, 91734, 91735, 87732, 87739, 87738, 87737, 87735, 92244, 92243, 92242, 92241, 87734, 88647, 88642, 86041, 87638, 87733, 94341, 94342, 94395, 94394, 94393, 94392, 94391, 94390, 94389, 94388, 94387, 93969, 74369, 74362, 92271, 92270, 92269, 92240, 91861, 91123, 74382, 74385, 91736, 87747, 83764, 94458, 94456, 94455, 94457, 57723, 77190, 77185, 77184, 84599, 84603, 83757, 83758, 80800, 80803, 85684, 85685, 6054, 80802, 85686, 77182, 77189, 87441, 85754, 65065, 94756, 94755, 94819, 85400, 92231, 91132, 84933, 85744, 85773, 87863, 77658, 77660, 91690, 91695, 91696, 91697, 91698, 91699, 91700, 91701, 77166, 77167, 87886, 87887, 87888, 87889, 77661, 85794, 87263, 87921, 95349, 95359, 95354, 95353, 80801, 85664, 85665, 83899, 84596, 84597, 84598, 84601, 83759, 91616, 91617, 91618, 91619, 91620, 91621, 80790, 95601, 95600, 95599, 95598, 95487, 95486, 95493, 95491, 95488, 80815, 77118, 85747, 85746, 95677, 95676, 95671, 95670, 95669, 95683, 95668, 95682, 95681, 95680, 95679, 95678, 80784, 95767, 95766, 95765, 95764, 95779, 95763, 95778, 91500, 91501, 91502, 91503, 91504, 36303, 95863, 95864, 95865, 95866, 95867, 95868, 95869, 95870, 95871, 95872, 95873, 95874, 96379, 96380, 96381, 96382, 96383, 96384, 96385, 91737, 91738, 91491, 97692, 97691, 97690, 97689, 97688, 97703, 97702, 97701, 97700, 77659, 84607, 84605, 84604, 84606, 87353, 91492, 90466, 87356, 87355, 87352, 87354, 93976, 97808, 95126, 85028, 88240, 95125, 85030, 88242, 95123, 88244, 95208, 95207, 95209, 90377, 90772, 90695, 90771, 90773, 90780, 90696, 90779, 90782, 90781, 87439, 83925, 65072, 65070, 77117, 90788, 90787, 90790, 90789, 91711, 91712, 91713, 91714, 91715, 91716, 97932, 97931, 97930, 97929, 97928, 97927, 97946, 97926, 97945, 97925, 97944, 97924, 97943, 97923, 97763, 97764, 97765, 97766, 97767, 97768, 97769, 97770, 97771, 97772, 97773, 97774, 97775, 97776, 85668, 85669, 85666, 85667, 83885, 83886, 83887, 83889, 83888, 83890, 83892, 83891, 83895, 83894, 83896, 83901, 83900, 83902, 95464, 95467, 95466, 95465, 95469, 95468, 84614, 84612, 84613, 84615, 84618, 84616, 84617, 84619, 84622, 84620, 84621, 84623, 77162, 77163, 77164, 77165, 35593, 64661, 64662, 64663, 64664, 64665, 64666, 35568, 35569, 35572, 35573, 35574, 83879, 83880, 83881, 98169, 98167, 87343, 73850, 73851, 80798, 80799, 77202, 77203, 91612, 91613, 91614, 91615, 91608, 91609, 91610, 91611, 91629, 91628, 91630, 91623, 91622, 91624, 91627, 91625, 91626, 85676, 85677, 85675, 85679, 85680, 85678, 85682, 85683, 85681, 35596, 64649, 64651, 64652, 64654, 44786, 44787, 44788, 73849, 44785, 80782, 80783, 80779, 80780, 80781, 80788, 80789, 80785, 80786, 80787, 80791, 80792, 80793, 80794, 80795, 80796, 80797, 90329, 98434, 77121, 85745, 57721, 73645, 87812, 84173, 84157, 84158, 84159, 84160, 84163, 84164, 84165, 84166, 84167, 84168, 84169, 84170, 84171, 84172, 84176, 84175, 84180, 84181, 84182, 84121, 84122, 84123, 84124, 84174, 95746, 98638, 98639, 98640, 98641, 99398, 99399, 99400, 99401, 99402, 99403, 99404, 99405, 99406, 99407, 99408, 99409, 99410, 99411) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 16 | maybe slow |
