| 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` <> 90690 AND `Item`.`id` IN (6035, 6387, 6407, 6408, 6409, 6410, 6411, 5178, 4924, 5312, 5318, 5328, 5360, 5323, 5402, 5335, 5324, 5355, 5330, 5403, 5381, 5334, 5405, 5397, 5389, 5413, 5373, 5347, 5400, 5392, 5384, 5376, 5408, 5352, 5364, 5356, 5340, 5401, 5393, 5385, 5377, 5409, 5329, 5361, 5353, 5369, 5407, 5333, 5365, 5325, 5394, 5386, 5378, 5410, 5370, 5362, 5354, 5346, 5399, 5383, 5375, 5398, 5390, 5382, 5374, 5406, 5366, 5395, 5387, 5379, 5371, 5331, 5363, 5332, 5412, 5380, 5388, 5396, 5404, 5343, 5627, 5176, 5351, 5350, 6765, 6731, 5601, 5642, 5639, 5635, 6758, 8679, 8680, 8681, 8682, 8683, 8684, 8685, 8686, 8687, 8688, 8689, 8690, 8691, 8692, 8693, 8694, 8695, 8696, 8697, 8698, 8699, 8700, 8701, 8702, 8703, 8704, 8705, 8706, 8707, 8708, 8709, 8710, 8711, 8712, 8713, 8714, 8715, 8716, 8717, 8718, 8719, 8720, 8721, 8722, 8723, 8724, 8725, 8726, 8727, 8728, 8729, 8730, 8731, 8732, 8733, 8734, 8735, 8736, 8737, 8738, 8739, 8740, 8741, 8742, 8743, 8744, 8745, 8746, 8747, 8748, 8749, 8750, 8751, 8752, 8753, 8754, 8755, 8756, 8757, 8758, 8759, 8760, 8761, 8762, 8763, 8764, 8765, 8766, 8767, 8768, 8769, 8770, 8771, 8772, 8773, 8774, 8775, 8776, 8777, 8778, 8779, 8780, 8781, 8782, 8783, 8784, 8785, 8786, 8787, 8788, 8789, 8790, 8791, 8792, 8793, 8794, 8795, 8796, 8797, 8798, 8799, 8800, 8801, 8802, 8803, 8804, 8805, 8806, 8807, 8808, 8809, 8810, 8811, 8812, 8813, 8814, 8815, 8816, 8817, 8818, 8819, 8820, 8821, 8822, 8823, 8824, 8825, 8826, 8827, 8828, 8829, 8830, 8831, 8832, 8833, 8834, 8835, 8836, 8837, 8838, 8839, 8840, 11744, 11745, 11746, 11747, 11748, 11749, 11750, 11751, 11752, 11753, 11754, 11755, 11756, 11757, 11758, 11759, 11760, 11761, 11762, 11763, 11764, 11765, 11766, 11767, 11768, 11769, 11770, 11771, 11772, 11773, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11781, 11782, 11783, 11784, 11785, 11786, 11787, 11788, 11789, 11790, 11791, 11792, 11793, 11794, 11795, 11796, 11797, 11798, 11799, 11800, 11801, 11802, 11803, 11804, 11805, 11806, 11807, 11808, 11809, 11810, 11811, 11812, 11813, 11814, 11815, 11816, 11817, 11818, 11819, 11820, 11821, 11822, 11823, 11824, 11825, 11826, 11827, 11828, 11829, 11830, 11831, 11832, 11833, 11834, 11835, 11836, 11841, 11842, 11845, 11846, 11849, 11851, 11853, 11855, 11856, 11857, 11858, 11859, 5636, 5641, 5646, 5644, 5637, 5632, 5628, 5645, 5633, 5629, 5631, 5005, 5630, 5634, 5640, 5643, 5004, 6412, 6413, 6414, 6415, 6416, 5326, 5327, 12397, 12400, 12398, 12401, 12393, 12399, 12402, 5188, 5187, 5183, 5174, 6490, 6491, 11838, 11837, 11844, 11843, 11840, 11848, 11847, 11839, 6790, 11852, 6489, 6093, 11854, 11850, 6084, 6085, 6756, 6761, 6762, 6766, 6767, 5191, 5190, 5189, 5182, 5181, 6039, 5177, 6051, 5981, 5982, 5983, 6418, 15032, 15033, 15034, 15035, 15036, 15037, 15038, 15039, 15040, 15041, 15042, 15043, 15044, 15045, 15046, 15047, 15048, 15049, 15050, 15051, 15052, 15053, 15054, 15055, 15056, 15057, 15058, 15059, 15060, 15061, 15062, 15063, 15064, 15065, 15066, 15067, 15068, 15069, 15070, 15071, 15072, 15073, 15074, 15075, 15076, 15077, 15078, 15079, 15080, 15081, 15082, 15083, 15084, 15085, 15086, 15087, 15088, 15089, 15090, 15091, 15092, 15093, 15094, 15095, 15096, 15097, 15098, 15099, 15100, 15101, 15102, 15103, 15104, 15105, 15106, 15107, 15108, 15109, 15110, 15111, 15112, 15113, 15114, 15115, 15116, 15117, 15118, 15119, 15120, 15121, 15122, 15123, 15124, 15125, 15126, 15127, 15128, 15129, 15130, 15131, 15132, 15133, 15134, 15135, 15136, 15137, 15138, 15139, 15140, 15141, 15142, 15143, 15144, 15145, 15146, 15147, 15148, 15149, 15150, 15151, 15152, 15153, 15154, 15155, 15156, 15157, 15158, 15159, 15160, 15161, 15162, 15163, 15164, 15165, 15166, 15167, 15168, 15169, 15170, 15171, 15172, 15173, 15174, 15175, 15176, 15177, 15178, 15179, 15180, 15181, 15182, 15183, 15184, 15185, 15186, 15187, 15188, 15189, 15190, 15191, 15192, 15193, 15194, 15195, 15196, 15197, 15198, 15199, 15200, 15201, 15202, 15203, 15204, 15205, 15206, 15207, 15208, 15209, 15210, 15211, 15212, 15213, 15214, 15215, 15216, 18146, 18147, 18148, 18149, 18150, 18151, 18152, 18153, 18154, 18155, 18156, 18157, 18158, 18159, 18160, 18161, 18162, 18163, 18164, 18165, 18166, 18167, 18176, 18177, 18178, 18179, 18180, 18181, 18182, 18183, 18192, 18193, 18194, 18195, 18221, 18222, 18223, 18224, 18225, 18226, 18227, 18228, 18229, 18230, 18231, 18232, 18233, 18234, 18235, 18236, 18237, 18238, 18239, 18240, 18241, 18242, 18243, 18248, 18249, 18250, 18251, 18252, 18253, 18254, 18255, 18256, 18257, 18258, 18259, 18260, 18261, 18262, 18263, 18264, 18265, 18266, 18267, 18268, 18269, 18270, 18271, 18274, 18276, 18279, 18288, 18291, 18292, 18293, 18294, 18295, 18296, 18297, 18298, 18299, 18300, 18301, 18302, 18303, 18305, 18289, 18290, 18287, 18286, 18285, 18284, 18283, 18282, 18281, 18280, 18278, 18275, 18272, 13050, 15582, 13470, 13603, 14577, 14346, 14344, 14345, 13475, 13476, 13474, 13473, 13590, 13591, 13472, 15217, 12983, 12982, 12981, 12990, 12984, 5179, 5180, 5367, 5368, 12988, 5626, 18244, 18247, 18246, 18245, 6392, 6393, 5638, 5185, 5186, 5172, 5357, 5359, 5358, 5979, 5980, 5978, 18273, 18277, 18304, 18306, 14636, 5173, 30989, 30990, 30991, 30992, 30997, 30998, 30999, 31000, 31001, 31002, 31003, 31004, 31005, 31006, 31007, 31008, 31009, 31012, 31013, 31019, 31020, 31021, 31022, 31023, 31024, 31025, 31026, 31027, 31028, 31029, 31030, 31031, 31032, 31033, 31034, 31035, 31036, 31037, 31038, 31040, 31041, 31042, 31043, 31044, 31045, 31046, 31047, 31048, 31049, 31050, 31051, 31052, 31053, 31054, 31055, 31056, 31057, 31058, 31059, 31061, 31062, 31063, 31064, 31065, 31067, 31068, 31069, 31070, 31071, 31072, 31073, 31074, 31075, 31076, 31077, 31078, 31079, 31080, 31087, 31088, 31089, 31092, 31095, 31096, 31099, 31100, 31101, 31102, 31103, 31104, 31105, 31106, 31107, 31108, 31109, 31110, 31111, 31112, 31113, 31114, 31115, 31116, 31117, 31118, 31119, 31120, 31121, 31122, 31123, 31124, 31125, 31126, 31127, 31128, 31129, 31130, 31131, 31132, 31133, 31134, 31135, 31136, 31137, 31138, 31166, 31167, 31168, 31169, 31170, 31171, 31172, 31174, 31178, 31180, 31181, 34006, 34007, 34008, 34009, 34010, 34011, 34012, 34013, 34014, 34015, 34016, 34017, 34018, 34019, 34020, 34021, 34022, 34023, 34024, 34025, 34026, 34027, 34028, 34029, 34030, 34031, 34033, 34034, 34035, 34036, 34037, 34038, 34039, 34043, 34044, 34045, 34046, 34049, 34050, 34051, 34052, 34053, 34054, 34055, 34056, 34057, 34058, 34059, 34060, 34061, 34062, 34063, 34064, 34065, 34066, 34067, 34069, 34070, 34072, 34073, 34074, 34075, 34076, 34077, 34078, 34079, 34080, 34081, 34082, 34083, 34084, 34085, 34087, 34090, 34091, 34092, 34093, 34094, 34097, 34098, 34099, 34100, 34101, 34102, 34103, 34104, 34105, 34106, 34107, 34108, 34109, 34110, 34111, 34112, 34114, 34115, 34116, 34117, 34118, 34119, 34120, 34121, 34122, 34123, 34124, 34125, 34126, 34127, 34130, 34131, 34132, 34133, 34134, 34135, 34136, 34137, 34139, 34140, 34141, 34142, 34143, 34144, 34150, 34158, 34159, 34160, 34161, 34162, 34163, 34164, 34165, 34166, 34172, 34173, 34174, 34175, 34176, 34177, 34178, 34179, 31139, 31140, 31141, 31142, 31143, 31144, 31145, 31146, 31147, 31148, 30435, 30433, 30434, 30432, 33814, 33815, 31097, 31094, 31098, 31066, 5235, 5283, 34032, 34138, 5184, 30994, 30995, 30996, 30993, 31173, 31010, 31011, 34152, 34155, 34154, 34147, 34153, 34146, 34157, 34095, 34096, 34156, 34151, 6534, 31176, 29202, 29201, 34149, 5372, 5338, 5339, 31182, 34041, 34042, 34040, 34048, 34047, 31082, 31081, 31084, 31085, 31083, 34086, 34071, 34129, 34128, 6496, 6495, 6497, 5887, 34168, 34169, 34170, 34171, 34167, 35637, 6037, 6038, 6036, 34145, 34068, 29184, 34148, 31086, 31090, 31091, 31093, 13001, 13002, 12977, 12978, 29183, 29186, 29185, 6533, 31183, 31014, 31185, 31184, 31018, 31017, 31015, 31016, 4931, 4932, 35034, 31039, 31060, 31179, 31175, 31177, 35636, 35046, 35047, 35032, 34089, 34088, 35066, 38530, 38531, 38532, 38533, 38534, 38535, 38536, 38537, 38538, 38539, 38540, 38541, 38542, 38543, 38544, 38545, 38546, 38547, 38548, 38549, 38550, 38551, 38552, 38553, 38554, 38555, 38556, 38557, 38558, 38559, 38560, 38561, 38562, 38563, 38564, 38565, 38566, 38567, 38568, 38569, 38570, 38571, 38572, 38573, 38574, 38575, 38576, 38577, 38578, 38579, 38580, 38581, 38582, 38583, 38584, 38585, 38586, 38587, 38588, 38589, 38590, 38591, 38592, 38593, 38594, 38595, 38596, 38597, 38598, 38599, 38600, 38601, 38602, 38603, 38604, 38605, 38606, 38607, 38608, 38609, 38610, 38611, 38612, 38613, 38614, 38615, 38617, 38618, 38619, 38621, 38622, 38623, 38624, 38625, 38626, 38627, 38628, 38629, 38630, 38631, 38632, 38633, 38634, 38635, 38636, 38637, 38638, 38639, 38640, 38641, 38642, 38643, 38644, 38645, 38646, 38647, 38648, 38649, 38650, 38651, 38652, 38653, 38654, 38655, 38656, 38657, 38658, 38659, 38660, 38661, 38662, 38663, 38664, 38665, 38666, 38667, 38668, 38669, 38670, 38671, 38672, 38673, 38674, 38675, 38676, 38677, 38678, 38679, 38680, 38683, 38684, 38685, 38686, 38687, 38688, 38689, 38690, 38691, 38692, 38693, 38694, 38695, 38696, 38697, 38698, 38699, 38700, 38702, 38703, 38704, 38794, 38795, 38796, 38797, 38798, 38799, 38800, 38801, 38802, 38803, 38804, 38805, 38806, 38808, 38809, 38810, 38812, 38813, 38814, 38815, 38816, 38817, 38818, 38819, 38820, 38821, 38822, 38823, 38824, 38825, 38826, 38827, 38828, 38829, 38830, 38831, 38832, 38833, 38834, 38835, 38836, 38837, 38838, 38839, 38840, 38842, 38843, 38844, 38845, 38846, 38847, 38848, 38849, 38850, 38851, 38852, 38853, 38854, 38855, 38856, 38857, 38858, 38859, 38860, 38861, 38862, 38863, 38864, 38865, 38866, 38867, 38868, 38869, 38870, 38873, 38874, 38875, 38876, 38877, 38878, 38879, 38880, 38881, 38882, 38883, 38884, 38885, 38886, 38887, 38888, 38889, 38890, 38891, 38892, 38893, 38894, 38895, 38896, 38897, 38898, 38899, 38900, 38901, 38902, 38903, 38904, 38905, 38906, 38907, 38908, 38909, 38910, 38911, 38912, 38913, 38914, 38915, 38916, 38920, 38921, 38922, 38923, 38924, 38925, 38926, 38927, 38928, 38929, 38930, 38931, 38932, 38933, 38934, 38935, 38936, 38937, 38938, 38939, 43064, 43114, 43113, 43086, 38709, 38708, 38707, 38706, 38705, 38701, 38682, 38681, 41735, 41734, 41733, 41732, 41731, 41730, 41110, 41111, 41103, 41104, 35031, 35033, 35644, 35645, 35646, 35615, 36318, 44285, 44286, 44287, 44288, 44289, 44290, 44291, 44292, 44293, 44453, 44454, 44455, 44456, 44458, 44459, 35023, 35048, 35045, 35641, 35465, 35666, 35667, 35668, 35618, 38919, 38918, 38917, 35039, 35055, 38807, 38811, 44457, 35022, 35020, 35627, 44220, 44219, 38871, 38872, 35056, 35043, 35466, 35044, 35630, 35631, 35632, 25880, 25881, 6097, 6098, 12993, 12994, 35633, 35021, 38841, 6092, 50134, 50135, 50136, 50137, 50138, 50139, 50140, 50141, 50142, 50143, 50144, 50145, 50146, 50147, 50148, 50149, 50150, 50151, 50152, 50153, 50154, 50155, 50156, 50157, 50158, 50159, 50160, 50161, 50162, 50163, 50164, 50165, 50166, 50167, 50168, 50170, 50171, 50172, 50173, 50174, 50175, 50176, 50177, 50178, 50179, 50180, 50181, 50182, 50183, 50184, 50189, 50190, 50194, 50195, 50196, 50197, 50198, 50199, 50200, 50201, 50203, 50204, 50205, 50206, 50207, 50208, 50209, 50210, 50211, 50212, 50213, 50214, 50216, 50217, 50218, 50219, 50220, 50221, 50222, 50223, 50224, 50225, 50226, 50227, 50228, 50229, 50230, 50231, 50232, 50233, 50234, 50235, 50236, 50237, 50239, 50240, 50241, 50242, 50243, 50244, 52646, 52649, 52651, 52652, 52654, 52656, 52660, 52661, 52662, 52664, 52665, 52670, 52671, 52672, 52674, 52676, 52677, 52678, 52679, 52680, 52682, 52683, 52684, 52689, 52690, 52692, 52693, 52696, 52698, 52700, 52702, 52703, 52713, 52714, 52715, 52716, 52717, 52722, 52723, 52724, 52725, 52726, 52727, 52728, 52729, 52730, 52732, 52734, 52735, 52737, 52738, 52739, 52749, 52750, 52751, 52752, 52753, 52755, 52756, 52757, 52759, 52760, 52761, 52763, 52764, 52766, 52768, 52771, 52772, 52776, 52779, 52784, 52785, 52792, 52793, 52794, 52803, 52807, 52808, 52809, 52811, 52812, 52813, 52814, 52815, 52816, 52817, 52819, 52820, 52821, 52822, 52824, 53786, 50548, 35038, 52825, 52823, 52818, 50238, 52647, 52800, 52650, 52653, 52655, 52657, 52658, 52659, 52663, 52666, 52667, 52668, 52669, 52673, 52675, 52681, 52782, 52769, 52795, 52767, 52790, 52770, 52765, 52773, 52774, 52775, 52777, 52778, 52780, 52796, 52645, 52686, 52648, 52688, 52783, 52786, 52708, 52691, 52694, 52697, 52699, 52704, 52705, 52706, 52718, 52731, 52733, 52736, 52740, 52754, 52758, 52762, 52787, 52788, 52789, 6107, 6108, 6109, 36809, 36804, 6110, 52791, 35035, 35036, 52701, 13007, 13008, 6077, 35042, 52798, 35064, 52747, 52805, 52804, 35401, 35619, 36314, 35429, 35481, 36345, 35614, 35030, 35049, 35392, 35463, 35464, 35620, 35058, 35053, 5391, 52644, 52799, 35617, 52685, 5345, 35621, 35653, 35634, 35654, 35655, 36320, 25886, 35648, 52797, 52707, 36315, 35037, 35649, 35672, 35391, 35406, 36317, 5341, 35054, 5411, 35028, 45143, 35069, 35040, 35622, 35067, 35068, 35060, 52712, 52711, 52710, 52709, 35407, 35393, 52802, 36780, 36763, 36773, 36782, 6080, 52801, 52695, 52781, 36312, 35072, 52744, 52741, 52748, 52721, 52746, 52745, 52743, 52719, 52742, 52720, 35428, 50215, 38455, 35070, 35623, 35642, 35050, 35071, 60690, 60691, 60692, 60693, 60694, 60695, 60696, 60697, 60698, 60700, 60701, 60702, 60703, 60704, 60705, 60706, 60707, 60708, 60709, 60713, 60714, 60715, 60716, 60717, 60718, 60719, 60720, 60721, 60722, 60723, 60724, 60725, 60726, 60727, 60728, 60729, 60730, 60731, 60735, 60736, 60737, 60738, 60739, 60741, 60742, 60743, 60744, 60745, 60746, 60748, 60749, 60750, 60751, 60752, 60753, 60754, 60757, 60761, 60763, 60764, 60769, 60770, 60771, 60772, 60773, 60774, 60775, 60776, 60777, 60778, 60779, 60780, 60781, 60782, 60783, 60784, 60785, 60787, 60788, 60789, 60790, 60791, 60792, 60793, 60794, 60804, 60805, 60806, 60807, 60808, 60809, 60810, 60811, 60812, 60813, 60814, 60816, 60817, 60818, 60820, 60822, 60823, 60828, 62251, 62252, 62253, 62254, 62265, 62266, 62267, 62268, 62269, 62270, 62271, 62272, 62273, 62274, 62275, 62276, 62277, 62281, 62282, 62283, 62284, 62285, 62286, 62287, 62288, 62289, 62290, 62291, 62292, 62293, 62294, 62295, 62299, 62300, 62301, 62302, 62303, 62304, 62305, 62306, 62307, 62318, 62333, 62334, 62335, 62336, 62337, 62338, 62339, 62340, 62342, 62343, 62346, 62348, 62357, 60755, 60740, 36316, 36806, 25894, 25895, 25896, 25897, 6095, 6094, 6076, 6078, 38527, 38525, 25884, 60765, 60766, 60767, 60768, 62349, 62350, 62351, 62352, 62353, 62255, 62256, 62257, 62258, 62259, 62260, 62261, 62262, 62263, 62264, 62278, 62279, 62280, 62308, 62309, 62310, 62311, 62312, 62313, 62314, 62315, 62316, 62317, 62319, 62320, 62321, 62322, 62323, 62324, 62325, 62326, 62327, 62328, 62329, 62330, 62331, 62332, 62296, 62297, 62298, 62355, 60495, 60825, 60826, 60827, 62344, 62345, 62358, 60732, 60733, 60734, 60756, 35029, 59594, 35628, 35041, 62347, 35660, 35656, 60803, 62354, 36311, 60819, 60663, 60662, 60661, 60465, 35019, 60567, 62341, 35669, 35671, 35670, 65057, 65052, 65046, 65045, 65044, 65118, 65047, 65155, 60710, 60711, 60712, 44205, 45496, 45497, 45523, 45504, 45505, 57753, 60747, 36346, 62356, 38526, 36765, 36798, 44221, 44222, 36313, 60786, 60299, 60298, 60297, 60296, 60386, 60295, 60503, 5342, 5344, 60760, 65058, 54027, 54025, 54026, 65039, 65049, 65051, 65037, 65139, 60758, 60759, 60699, 62359, 35062, 35508, 66875, 66876, 66877, 66878, 66879, 66880, 66881, 66882, 66883, 66884, 66885, 66886, 66887, 66888, 66889, 66890, 66891, 66892, 66893, 66894, 66895, 66896, 66897, 66898, 66899, 66900, 66901, 66902, 66903, 66904, 66905, 66906, 66907, 66908, 66910, 66911, 66912, 66913, 66914, 66915, 66916, 66917, 66918, 66919, 66920, 66921, 66922, 66923, 66924, 66925, 66926, 66927, 66928, 66929, 66930, 66932, 66933, 66934, 66935, 66936, 66937, 66938, 66939, 66940, 66941, 69550, 69552, 69553, 69554, 69555, 69556, 69557, 69558, 69559, 69560, 69561, 69562, 69563, 69564, 69565, 69566, 69567, 69568, 69569, 69570, 69571, 69572, 69573, 69574, 69575, 69576, 69577, 69578, 69579, 69580, 69581, 69582, 69583, 69584, 69585, 69586, 69587, 69588, 69590, 69591, 69592, 69593, 69594, 69595, 69596, 69597, 69598, 69599, 69600, 69601, 69602, 69603, 69604, 69605, 69606, 69607, 69608, 69609, 69610, 69611, 69612, 69617, 69618, 69619, 69620, 69621, 69622, 69623, 69624, 69625, 69626, 69627, 69628, 69629, 69635, 69636, 69637, 69638, 69639, 69640, 69641, 69642, 69643, 69644, 69645, 69650, 69651, 69652, 69653, 69654, 69655, 69656, 69657, 69658, 69659, 69660, 69661, 69662, 69663, 69665, 69666, 71276, 71277, 71279, 71280, 71281, 71282, 71284, 71285, 71286, 71287, 71288, 71289, 71290, 71292, 71293, 71294, 71296, 71297, 71298, 71299, 71300, 71301, 71302, 71303, 71304, 71305, 71306, 71307, 71308, 71309, 71310, 71316, 71317, 71319, 71321, 71322, 71323, 71324, 71325, 71326, 71328, 71331, 71332, 71333, 71334, 71335, 71336, 71337, 71338, 71339, 71347, 71348, 71350, 71351, 71352, 71356, 71357, 71358, 71359, 71360, 71361, 71362, 71363, 71367, 71369, 71370, 71371, 71372, 71373, 71374, 71375, 71376, 71377, 71379, 71382, 71386, 71387, 71388, 67888, 71468, 71469, 71470, 71471, 71368, 44206, 65041, 45501, 35065, 25910, 65764, 65765, 58359, 58360, 58361, 58356, 58357, 58358, 64754, 57755, 57752, 36800, 65035, 65036, 65038, 65040, 65042, 65043, 65095, 65096, 65104, 65109, 65121, 65193, 69551, 69549, 35616, 35661, 35662, 71378, 71313, 71314, 71315, 71354, 71355, 71353, 71312, 71311, 68494, 68495, 68496, 71278, 71381, 69717, 69718, 71617, 71618, 71619, 68027, 68029, 68030, 68031, 71390, 69647, 69649, 69648, 69646, 69616, 69614, 69613, 69615, 57754, 6047, 35063, 36791, 65132, 65050, 66909, 69589, 74406, 54023, 54020, 54017, 54018, 54016, 73403, 73401, 73402, 73397, 73396, 73394, 73393, 65034, 44759, 75778, 75777, 75822, 75823, 75824, 75825, 75826, 75827, 75828, 75829, 75830, 75831, 75832, 75833, 75834, 75835, 75836, 75837, 75838, 75839, 75840, 75841, 75842, 75843, 75844, 75845, 75846, 75847, 75848, 75849, 75850, 75851, 75852, 75853, 75854, 75855, 75856, 75857, 75868, 75869, 75870, 75871, 75874, 75875, 75876, 75877, 75878, 75880, 75881, 75882, 75883, 75884, 75885, 75886, 75887, 75888, 75889, 75890, 75891, 75892, 75893, 75894, 75895, 75864, 75865, 75866, 75867, 75858, 75859, 75860, 75861, 76561, 76570, 76572, 76573, 76574, 76575, 76581, 76582, 76583, 76584, 76586, 76588, 76589, 76590, 76591, 76592, 76593, 76594, 76595, 76599, 76600, 76601, 76602, 76604, 76605, 76606, 76607, 76608, 76609, 76612, 76771, 75863, 65103, 74193, 75872, 77209, 77262, 77266, 77267, 77222, 77221, 73581, 65094, 65107, 71295, 65154, 76603, 65194, 74421, 58237, 58240, 58239, 58238, 73521, 69634, 69632, 69630, 69633, 69631, 71380, 73520, 66931, 74297, 74291, 74292, 74286, 74285, 74284, 65033, 75873, 73582, 73798, 73799, 77662, 35507, 35509, 73515, 77263, 35061, 73589, 73590, 73585, 74454, 74798, 74799, 76613, 74836, 77122, 75765, 65813, 80258, 80259, 80260, 80261, 80262, 80263, 80264, 80265, 80266, 80267, 80268, 80269, 80270, 80271, 80272, 80273, 80274, 80275, 80276, 80277, 80278, 80279, 80280, 80281, 80282, 80283, 80284, 80285, 80286, 80287, 80288, 80289, 80297, 80298, 80299, 80300, 80301, 80302, 80303, 80403, 80404, 80405, 80406, 80407, 80408, 80409, 80410, 80411, 80412, 80414, 80415, 80416, 80417, 80418, 80419, 80420, 80421, 80422, 80423, 80424, 80425, 80429, 80431, 80432, 80433, 80436, 80437, 80438, 80439, 80440, 80441, 80442, 80443, 80444, 80445, 80447, 80449, 80452, 80453, 80426, 80427, 80428, 80434, 76597, 76596, 80172, 80173, 77085, 65106, 74835, 76610, 76611, 65766, 65767, 65768, 73785, 73524, 74840, 74837, 65048, 64742, 77656, 77657, 73790, 77204, 73519, 80632, 77575, 77557, 77554, 78148, 65815, 57757, 77555, 77556, 57758, 57756, 78151, 45173, 35025, 73587, 73588, 80811, 80817, 80816, 73791, 81219, 81220, 77127, 65148, 81120, 73787, 82803, 82804, 82805, 82806, 82807, 82808, 82809, 82810, 82811, 82812, 82813, 82814, 82815, 82816, 82817, 82819, 82820, 82821, 82822, 82823, 82824, 82825, 82826, 82827, 82828, 82829, 82830, 82831, 82832, 82833, 82834, 82835, 82836, 82837, 82838, 82839, 82844, 82845, 82846, 82847, 82848, 82852, 82853, 82854, 82855, 82856, 82857, 82858, 82859, 82860, 82864, 82865, 82870, 82871, 82872, 82874, 82875, 82876, 82878, 82879, 82880, 82881, 82882, 82883, 82884, 82885, 82886, 83021, 83026, 83027, 83029, 83030, 83031, 83032, 83033, 83034, 83035, 83036, 83037, 83038, 83039, 83040, 83041, 83042, 83044, 83045, 83046, 83047, 83048, 83049, 83050, 83051, 83043, 45509, 73803, 64641, 64640, 80293, 80295, 81128, 82863, 82862, 82818, 82850, 83016, 83017, 83018, 83019, 83020, 83023, 83024, 83022, 83025, 82568, 82569, 82570, 82571, 82572, 75862, 77205, 83746, 83747, 45495, 45503, 45502, 45521, 65801, 65190, 36257, 44186, 36260, 29200, 45174, 44185, 35024, 82849, 80810, 81217, 81218, 83028, 80304, 81216, 83052, 69664, 84210, 73800, 73801, 73802, 45494, 81156, 81119, 84325, 84324, 84331, 84330, 65093, 65183, 74194, 78145, 81094, 82861, 65108, 81126, 81725, 64741, 80740, 73792, 78127, 76587, 84941, 84930, 81735, 73811, 73804, 45500, 73788, 77667, 81110, 36807, 78037, 78038, 78039, 77297, 77298, 77666, 73793, 80741, 81244, 81114, 73797, 73794, 73796, 73795, 80723, 65806, 74830, 77124, 77129, 78150, 73806, 85695, 85694, 85763, 82877, 82873, 75879, 82843, 82842, 82841, 82840, 85599, 85589, 85595, 85569, 85596, 85603, 85597, 85598, 85604, 85553, 85586, 85560, 85554, 85561, 85555, 85562, 85558, 85601, 85593, 85567, 85585, 85602, 85594, 85559, 85568, 85600, 85591, 85552, 85563, 85556, 85590, 85564, 85557, 85565, 85566, 83920, 86079, 45511, 45514, 65191, 83943, 58210, 45517, 73789, 57760, 57759, 80733, 80732, 73817, 73778, 73786, 87414, 65182, 65184, 85742, 85138, 74731, 74734, 74735, 74728, 74737, 74738, 74739, 74729, 81679, 81682, 58363, 36767, 64724, 64725, 64726, 64727, 64728, 64729, 64730, 64732, 64731, 78068, 78069, 78070, 74795, 74796, 84371, 84372, 84373, 84374, 84378, 84377, 84376, 84375, 84916, 87796, 87813, 83921, 85526, 64547, 81122, 84026, 85791, 65208, 65207, 80637, 85383, 84228, 85357, 85384, 84027, 81124, 85793, 64743, 78051, 12991, 80806, 74793, 74794, 85123, 65201, 85174, 85173, 85135, 80724, 64667, 81525, 80807, 64636, 77212, 77609, 77608, 77210, 74732, 45519, 81118, 84251, 85792, 73505, 86080, 85743, 73517, 81242, 81239, 81093, 77101, 88334, 88337, 88338, 88348, 89628, 89629, 89630, 89631, 89632, 89634, 89647, 89650, 89651, 89654, 89655, 89656, 89657, 89658, 89659, 89660, 89661, 89662, 89663, 89664, 89665, 89666, 89667, 89672, 89673, 89676, 89677, 89681, 89682, 89684, 89685, 89687, 89688, 89689, 89690, 89691, 89694, 89695, 89696, 89697, 89698, 89699, 89701, 89702, 89703, 89704, 89705, 89706, 89708, 89709, 89712, 89713, 89714, 89715, 89716, 89717, 89719, 89720, 89635, 89636, 88742, 88743, 88744, 88747, 88746, 88745, 74296, 74295, 74294, 74293, 74287, 74288, 74289, 74290, 77663, 84524, 84525, 84526, 54074, 80709, 80710, 80711, 80712, 90060, 90071, 89648, 89649, 89639, 89640, 89641, 89652, 89653, 89668, 89669, 89670, 89671, 89674, 89675, 89644, 89645, 89646, 89693, 89692, 89686, 89707, 82866, 89683, 89700, 89711, 89710, 80296, 80294, 85326, 85327, 85322, 85323, 85315, 85316, 85317, 85318, 85319, 85311, 85312, 85313, 88328, 88330, 88331, 71283, 80448, 80450, 80451, 71320, 88346, 76585, 80446, 88335, 80435, 83989, 83990, 76563, 76562, 83986, 83985, 88336, 89633, 88327, 88329, 88332, 88333, 88342, 88344, 88339, 88347, 88340, 88343, 88345, 74777, 83983, 84381, 74784, 83984, 84382, 74741, 74775, 54028, 74785, 54019, 74740, 6786, 6785, 85258, 74733, 80828, 83988, 83987, 85321, 74783, 85344, 85320, 74778, 54022, 64635, 45493, 83817, 83816, 77231, 54075, 54072, 77642, 85788, 87628, 90463, 87683, 87685, 80827, 80826, 87815, 86082, 83917, 74192, 84217, 77128, 85343, 84140, 65200, 87928, 87929, 86049, 83942, 90332, 85781, 80628, 65758, 91070, 78065, 78066, 78067, 85288, 85290, 87775, 87776, 87777, 87778, 77645, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 80718, 80719, 80720, 87684, 87686, 73808, 81129, 87259, 81127, 80832, 54052, 54055, 54054, 58262, 58261, 58265, 58263, 58264, 83995, 83994, 85329, 85314, 85325, 85324, 81680, 81683, 81684, 6787, 91399, 91120, 91121, 91124, 91125, 91129, 91136, 80825, 80824, 90906, 90907, 90908, 90909, 90910, 90911, 90912, 90913, 90914, 90915, 90916, 90917, 90918, 90919, 90920, 90921, 90922, 90923, 90924, 90925, 90926, 90927, 90928, 90929, 90930, 90931, 90932, 90933, 35027, 35026, 88250, 88249, 88252, 88251, 88254, 88253, 77646, 77647, 77648, 77649, 77650, 77643, 77644, 65220, 65221, 88209, 88210, 85165, 85166, 85167, 87892, 87894, 83829, 83830, 83831, 90994, 90995, 90996, 90997, 90998, 90999, 91000, 88237, 88236, 35624, 83828, 88232, 88231, 88230, 90993, 90992, 88235, 88234, 88233, 90677, 90676, 90675, 90674, 90681, 90680, 90679, 90678, 83813, 83812, 35640, 35638, 35639, 80730, 80729, 85169, 85168, 81520, 81518, 81517, 84528, 84529, 84531, 84532, 90729, 90728, 90727, 90726, 90725, 84536, 90724, 90723, 65199, 65198, 73807, 73805, 44764, 44763, 90758, 90759, 90760, 90761, 90762, 90763, 90694, 90692, 90693, 90691, 90688, 90686, 90687, 90685, 90438, 90439, 90437, 90436, 90433, 90435, 90434, 90690, 90689, 89718, 80583, 80584, 85790, 85789, 88341, 84002, 85345, 85346, 87773, 87774, 78062, 78063, 78064, 80829, 84379, 84380, 80831, 81675, 81676, 87769, 36784, 84003, 84004, 58362, 74730, 74736, 81677, 74781, 12992, 73594, 73595, 85298, 84322, 84321, 84323, 84326, 85300, 84385, 91509, 89679, 89680, 89678, 91652, 91651, 91650, 91653, 91728, 91727, 92002, 92003, 92004, 92005, 92006, 92007, 92008, 92009, 92010, 92011, 92012, 92013, 92014, 92015, 92016, 92017, 92018, 92019, 92020, 92021, 92022, 92023, 92024, 92025, 92026, 92027, 92028, 92029, 92030, 92031, 92032, 92033, 92034, 92035, 92036, 92037, 92038, 92039, 92040, 92041, 92042, 92043, 92679, 92680, 92681, 92682, 92683, 92684, 92685, 92686, 92689, 92690, 92691, 92692, 92693, 92694, 92695, 92696, 92697, 92698, 92699, 92700, 92701, 92702, 92703, 92704, 92705, 92706, 92708, 92709, 92710, 92711, 92712, 92713, 92717, 92718, 92719, 92720, 92721, 92722, 92723, 92724, 92725, 92726, 92727, 92728, 92729, 92730, 92731, 92732, 92733, 92734, 92735, 92736, 92737, 92738, 92739, 92740, 92741, 92742, 84523, 84521, 84522, 84530, 93945, 93939, 85267, 85268, 85269, 85270, 78058, 65810, 65812, 73516, 81101, 84934, 85382, 85515, 86081, 85785, 85734, 85735, 85736, 85737, 85738, 85739, 87802, 87703, 85285, 85286, 73586, 87689, 87688, 87687, 85287, 81678, 65757, 81686, 81685, 81681, 81688, 74776, 85289, 87705, 87704, 81687, 74774, 80833, 80830, 91732, 91731, 91729, 91730, 81238, 94322, 94321, 94326, 94325, 94324, 94323, 73593, 87706, 54024, 54021, 78093, 92716, 92715, 92714, 94347, 94369, 94348, 94368, 94359, 94350, 94349, 94439, 94440, 94441, 94437, 94436, 94446, 94438, 94445, 94444, 94443, 94442, 94459, 94462, 94461, 94460, 73809, 77211, 85126, 73816, 64634, 84333, 80739, 85171, 80721, 73815, 54073, 80738, 80716, 80731, 54071, 73814, 73813, 85257, 87388, 87390, 87389, 85172, 80722, 82867, 82868, 82869, 94544, 94543, 94542, 94541, 94540, 94539, 94538, 94545, 94568, 94567, 94566, 94565, 94570, 94569, 85130, 85131, 85133, 85134, 85148, 85149, 85150, 80717, 73779, 73776, 73777, 84539, 84543, 94502, 94506, 94498, 73810, 73812, 81521, 81523, 81524, 85699, 83814, 83815, 88208, 77254, 77255, 77256, 81522, 85151, 77257, 85120, 84533, 84534, 83807, 58209, 77258, 77664, 77259, 35629, 94628, 94664, 94627, 94663, 94624, 94660, 94714, 94623, 94659, 94711, 94620, 94674, 94710, 94619, 94617, 94671, 94724, 94670, 94626, 94662, 94625, 94661, 94713, 94622, 94676, 94712, 94621, 94675, 94673, 94709, 94618, 94672, 94723, 94669, 94722, 94668, 94721, 94667, 94666, 94665, 77116, 88257, 85782, 85405, 90465, 94850, 94851, 93949, 91393, 91394, 91395, 91396, 91397, 94863, 94864, 94865, 94866, 78050, 86109, 91744, 77669, 77670, 83808, 77315, 77316, 80812, 80813, 91318, 93979, 92687, 92688, 92001, 78052, 85127, 85129, 85128, 95146, 95145, 88255, 88273, 74191, 77577, 65814, 58328, 90891, 90889, 90890, 90893, 90892, 85299, 85297, 80713, 85147, 77230, 83822, 83820, 83821, 83819, 83818, 83827, 83825, 83826, 83824, 83823, 87886, 87887, 87888, 87889, 85121, 85122, 85124, 85125, 81509, 81510, 44762, 44760, 85701, 85702, 85703, 94435, 94434, 94431, 94433, 94432, 80727, 85170, 90683, 90684, 90682, 95182, 89637, 89638, 89642, 89643, 80430, 84908, 86047, 84907, 90467, 91507, 91317, 91319, 86087, 92707, 91054, 95357, 95345, 95344, 95342, 95341, 95340, 95415, 95416, 77665, 84527, 80714, 80715, 73780, 85132, 84535, 77668, 77633, 95563, 95562, 95561, 95554, 95553, 95552, 95551, 95568, 95567, 95566, 95565, 95564, 81689, 87701, 58329, 58327, 85284, 91391, 85381, 95618, 95619, 95620, 95621, 95661, 95660, 95659, 95658, 95655, 95654, 87702, 95759, 95774, 95772, 95784, 95782, 95781, 95780, 85803, 95791, 95792, 95793, 95794, 95819, 95820, 95821, 95822, 95823, 95824, 95825, 96470, 96471, 96472, 96473, 96474, 96475, 96476, 96477, 96478, 96482, 96483, 96484, 96884, 96885, 96886, 96887, 96888, 96889, 96890, 96891, 96892, 96893, 96894, 96895, 96896, 96897, 96898, 96899, 96900, 96901, 96902, 96906, 96907, 96908, 96909, 96910, 96911, 96912, 96913, 96914, 96915, 96916, 96917, 96918, 96919, 96920, 96921, 96922, 96923, 96924, 96925, 96926, 96927, 97360, 97386, 97359, 91063, 74782, 74780, 74779, 95418, 95419, 95420, 94571, 94572, 94573, 94574, 54050, 54049, 54051, 54053, 84327, 84328, 84329, 84332, 73591, 73592, 83991, 83992, 83993, 84383, 84384, 94327, 94328, 94329, 94330, 94331, 94332, 94333, 94334, 77106, 58208, 58207, 97640, 97658, 97676, 97712, 97639, 97657, 97675, 97638, 97656, 97637, 97655, 97673, 97636, 97654, 97672, 97635, 97653, 97671, 97634, 97652, 97670, 97633, 97651, 97669, 97632, 97650, 97668, 97631, 97649, 97667, 97630, 97648, 97666, 97647, 97665, 97646, 97664, 97645, 97663, 97699, 97644, 97662, 97698, 97643, 97661, 97697, 97715, 97642, 97660, 97714, 97641, 97659, 97677, 97713, 85697, 85696, 85698, 64637, 64639, 44761, 54076, 80725, 80728, 80726, 87392, 87391, 87393, 87385, 87387, 87386, 87406, 87405, 87306, 87304, 87303, 87305, 85700, 95346, 97387, 86048, 88156, 90468, 87246, 90461, 97794, 96903, 96904, 96905, 96479, 96480, 96481, 81125, 91330, 91390, 91126, 91127, 91138, 91128, 91135, 88259, 87447, 81102, 91743, 94351, 88226, 88224, 95559, 87893, 98048, 98067, 98086, 98066, 98085, 98028, 98047, 98065, 98084, 98027, 98046, 98083, 97988, 98026, 98045, 98082, 97987, 98025, 98044, 98081, 97986, 98024, 98043, 98080, 97985, 98023, 98042, 98079, 98022, 98041, 98097, 98040, 98096, 98039, 98095, 98038, 98094, 98037, 98093, 98036, 98092, 98035, 98091, 97996, 98034, 98090, 97995, 98033, 98089, 97994, 98032, 98069, 98088, 97993, 98031, 98049, 98068, 98087, 97992, 98030, 97991, 97990, 97989, 77651, 77652, 77653, 98021, 98029, 85046, 35643, 98161, 98160, 98123, 98159, 98158, 98152, 83952, 97728, 97729, 97730, 97731, 97732, 97733, 97734, 97735, 97736, 97737, 97738, 97739, 97740, 97741, 97742, 97743, 97744, 97745, 97746, 97747, 97748, 97749, 97750, 97751, 97752, 97753, 97754, 97755, 97756, 97757, 97758, 97759, 97760, 97761, 97762, 85140, 85139, 85141, 85136, 85137, 95513, 95512, 95515, 95514, 95517, 95516, 95523, 95522, 95519, 95518, 95521, 95520, 90858, 90709, 90857, 90860, 90859, 90862, 90710, 90861, 90864, 90863, 90866, 90711, 90865, 90868, 90867, 90870, 90712, 90869, 90872, 90871, 90874, 90873, 90876, 90875, 90878, 90714, 90877, 90880, 90879, 90882, 90715, 90881, 90884, 90883, 90886, 90716, 90885, 90888, 90887, 85156, 85155, 85154, 85159, 85158, 85157, 77655, 77654, 84520, 84519, 88202, 88203, 88201, 88199, 88200, 88198, 95543, 95544, 95541, 95542, 95545, 95548, 95549, 95546, 95547, 95550, 90973, 90974, 90976, 90975, 90972, 90978, 90979, 90981, 90980, 90977, 84540, 84538, 94516, 94517, 94515, 84537, 94503, 81512, 94504, 81513, 94501, 81511, 94507, 81515, 94508, 81516, 94505, 81514, 84544, 84542, 84545, 94514, 94513, 84541, 90960, 90961, 90962, 90963, 90964, 90965, 94499, 94500, 94497, 83811, 83809, 83810, 90420, 90419, 90418, 90423, 90422, 90421, 90426, 90425, 90424, 35018, 35059, 93972, 90323, 95088, 81121, 98416, 98426, 98425, 98413, 95783, 94820, 93950, 93948, 93947, 93946, 91398, 91392, 98453, 85153, 85152, 88238, 85144, 85143, 85142, 81519, 98564, 98579, 98563, 98578, 98562, 98577, 98561, 98576, 98560, 98575, 98574, 98559, 98573, 98558, 98572, 98557, 98571, 98570, 98569, 98568, 98567, 98566, 98565, 98580, 98589, 98590, 98591, 98592, 90722, 90721, 90720, 90719, 90718, 90717, 98102, 98101, 98100, 98099, 98098, 98104, 98105, 98103, 98107, 98106, 98072, 98071, 98070, 98073, 98075, 98074, 98076, 98078, 98077, 94646, 94641, 94645, 94644, 94643, 94642, 94652, 94651, 94650, 94649, 94648, 94647, 87402, 87401, 87400, 90966, 90971, 90970, 90969, 90968, 90967, 80734, 80735, 80736, 80737, 35625, 35626, 94655, 94654, 94653, 94658, 94656, 94657, 90959, 90958, 90957, 90956, 85164, 85688, 85689, 85693, 85692, 85691, 85690, 85687, 95556, 95555, 88225, 88227, 95558, 95557, 88223, 88222, 95560, 88220, 88221, 88219, 58211, 85145, 85146, 64638, 87309, 87310, 87307, 87308, 93971, 65223, 65222, 98652, 98653, 98654, 98655, 98656, 98974, 98975, 98976, 98977, 98978, 98979, 98980, 98981, 98982, 98983, 98984, 98985, 98986, 98987, 98988, 98989, 98990, 98991, 98992, 98993, 98994, 98995, 98996, 98997, 98998, 98999, 99000, 99001, 99002, 99003, 99004, 99005, 99006, 99007, 99008, 99009, 99010, 99011, 99012, 99013, 99014, 99015, 99016, 99017, 99018, 99019, 99020, 99021, 99022, 99023, 99024, 99025, 99026, 99327, 99328, 99329, 99330, 99331, 99332, 99333, 99334, 99335, 99530, 99531, 99532, 99533, 99534, 99535, 99536, 99537, 99538, 99539, 99540, 99541, 99542, 99543, 99544, 99545, 99546, 99547, 99548) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 28 | maybe slow |
