| 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` <> 80540 AND `Item`.`id` IN (6423, 6285, 6284, 6283, 5893, 5894, 6754, 6722, 8443, 8444, 8445, 8446, 8447, 8448, 8449, 8450, 8451, 8452, 8453, 8454, 8455, 8456, 8457, 8458, 8459, 8460, 8461, 8462, 8463, 8464, 8465, 8466, 8467, 8468, 8469, 8470, 8471, 8472, 8473, 8474, 8476, 8477, 8478, 8479, 8480, 8481, 8482, 8483, 8484, 8485, 8486, 8487, 8488, 8489, 8490, 8491, 8492, 8493, 8494, 8495, 8496, 8497, 8498, 8499, 8500, 8501, 8502, 8503, 8504, 8505, 8506, 8507, 8508, 8509, 8510, 8511, 8512, 8513, 8514, 8515, 8516, 8517, 8518, 8519, 8520, 8521, 8522, 8523, 8524, 8525, 8526, 8527, 8528, 8529, 8530, 8531, 8532, 8533, 8534, 8535, 8536, 8537, 8538, 8539, 8540, 8541, 8542, 8543, 8544, 8545, 8546, 8547, 8548, 8549, 8550, 8551, 8552, 8553, 8554, 8555, 8556, 8557, 8558, 8559, 8560, 8561, 8562, 8563, 8564, 8565, 8566, 8567, 8568, 8569, 8570, 8571, 8572, 8573, 8574, 8575, 8576, 8577, 8578, 8579, 8580, 8581, 8582, 8583, 8584, 8585, 8586, 8587, 8588, 8589, 8590, 8591, 8592, 8593, 8594, 8595, 8596, 8597, 8598, 8599, 8600, 8601, 8602, 8603, 8604, 8605, 8606, 8607, 8608, 8614, 8615, 8616, 8617, 8618, 8619, 8620, 8621, 8622, 8623, 8624, 8625, 8626, 8627, 8628, 8629, 8630, 8631, 8632, 8633, 8634, 8635, 8636, 8637, 8638, 8639, 8640, 8641, 8642, 8643, 8644, 8645, 8646, 8647, 8648, 8649, 8650, 8651, 8652, 8653, 8654, 8655, 8656, 8657, 8658, 8659, 8660, 8661, 8662, 8663, 8664, 8665, 8666, 8667, 8669, 8670, 8671, 8672, 8673, 8674, 8675, 8676, 8677, 8678, 5196, 6751, 5195, 5048, 5049, 10534, 10532, 10409, 10530, 10531, 6976, 6975, 6978, 10431, 10528, 10529, 10376, 6348, 6349, 12445, 12453, 12448, 12456, 12451, 12446, 12454, 12449, 12452, 12447, 12455, 12450, 8668, 8612, 8611, 8610, 8609, 8613, 6755, 6347, 14735, 14736, 14737, 14738, 14739, 14740, 14741, 14742, 14743, 14744, 14745, 14746, 14747, 14748, 14749, 14750, 14751, 14752, 14753, 14754, 14755, 14756, 14757, 14758, 14759, 14760, 14761, 14762, 14763, 14764, 14765, 14766, 14767, 14768, 14769, 14770, 14771, 14773, 14775, 14776, 14777, 14782, 14783, 14784, 14788, 14789, 14790, 14791, 14793, 14794, 14795, 14796, 14797, 14798, 14799, 14800, 14801, 14802, 14803, 14804, 14805, 14807, 14808, 14809, 14810, 14811, 14812, 14813, 14814, 14815, 14817, 14818, 14819, 14820, 14821, 14822, 14823, 14824, 14825, 14826, 14827, 14828, 14829, 14830, 14831, 14832, 14833, 14834, 14835, 14836, 14837, 14838, 14839, 14840, 14841, 14842, 14843, 14844, 14845, 14846, 14847, 14848, 14850, 14851, 14852, 14853, 14854, 14855, 14856, 14857, 14858, 14859, 14860, 14861, 14862, 14863, 14864, 14865, 14866, 14867, 14868, 14869, 14870, 14871, 14872, 14873, 14874, 14875, 14876, 14877, 14878, 14879, 14880, 14881, 14882, 14883, 14884, 14885, 14886, 14887, 14891, 14892, 14893, 14894, 14895, 14896, 14897, 14898, 14899, 14900, 14901, 14902, 14903, 14904, 14905, 14906, 14907, 14908, 14909, 14910, 14911, 14912, 14913, 14914, 14915, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14923, 14924, 14925, 14926, 14927, 14928, 14929, 14930, 14931, 14932, 14933, 14934, 14935, 14936, 14937, 14938, 14939, 14940, 14941, 14942, 14943, 14944, 14945, 14946, 14947, 14948, 14949, 14950, 14951, 14952, 14953, 14954, 14955, 14956, 14957, 14958, 14959, 14960, 14961, 14962, 14963, 14964, 14965, 14966, 14967, 14968, 14973, 14974, 14975, 14976, 14977, 14978, 14979, 14980, 14981, 14982, 14983, 14984, 14985, 14986, 14987, 14988, 14989, 14990, 14991, 14992, 14993, 14994, 14995, 14996, 14997, 14998, 14999, 15000, 15001, 15002, 15003, 15004, 15005, 15007, 15008, 15009, 15010, 15011, 15012, 15013, 15014, 15015, 15016, 15017, 15018, 15019, 15020, 15021, 15022, 15023, 15024, 15026, 15027, 15028, 15029, 15030, 15031, 14781, 15006, 13089, 13304, 13301, 13302, 13303, 13305, 13306, 13307, 13308, 13309, 13088, 13090, 6974, 14774, 8844, 14581, 14054, 14055, 14053, 16732, 13739, 13740, 13737, 13738, 13755, 13754, 13756, 13742, 13741, 13743, 17508, 15025, 14772, 13011, 5032, 14849, 14778, 14806, 30717, 30718, 30719, 30720, 30721, 30722, 30723, 30724, 30725, 30726, 30728, 30729, 30730, 30731, 30732, 30733, 30739, 30740, 30741, 30742, 30743, 30744, 30745, 30746, 30749, 30750, 30751, 30752, 30753, 30754, 30755, 30756, 30757, 30758, 30759, 30760, 30761, 30762, 30763, 30764, 30765, 30766, 30767, 30768, 30769, 30770, 30771, 30772, 30774, 30775, 30776, 30777, 30779, 30780, 30782, 30783, 30784, 30792, 30793, 30794, 30795, 30796, 30797, 30798, 30799, 30800, 30801, 30802, 30803, 30804, 30805, 30806, 30807, 30808, 30809, 30810, 30811, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30820, 30821, 30822, 30823, 30824, 30825, 30826, 30827, 30828, 30829, 30830, 30831, 30832, 30833, 30834, 30835, 30836, 30837, 30838, 30839, 30840, 30841, 30842, 30843, 30844, 30845, 30846, 30847, 30848, 30849, 30850, 30851, 30852, 30853, 30854, 30855, 30856, 30857, 30858, 30859, 30860, 30861, 30862, 30863, 30864, 30865, 30866, 30867, 30868, 30869, 30870, 30871, 30872, 30873, 30874, 30875, 30876, 30877, 30880, 30881, 30882, 30883, 30885, 30886, 30887, 30888, 30889, 30890, 30892, 30894, 30895, 30897, 30898, 30900, 30902, 30903, 30904, 30905, 30908, 30909, 30911, 30912, 30913, 30914, 30915, 30916, 30917, 30918, 30919, 30920, 30921, 30922, 30923, 30924, 30925, 30926, 30927, 30930, 30931, 30932, 30933, 30934, 30935, 30936, 30937, 30938, 30939, 30940, 30941, 30942, 30943, 30944, 30945, 30946, 30947, 30948, 30949, 30950, 30951, 30952, 30954, 30955, 30956, 30957, 30958, 30959, 30960, 30961, 30962, 30963, 30964, 30965, 30966, 30967, 30968, 30969, 30970, 30971, 30972, 30973, 30974, 30975, 30976, 30977, 30978, 30979, 30980, 30981, 30982, 30983, 30984, 30985, 30986, 30987, 30988, 30896, 30899, 32656, 32655, 32657, 32649, 32651, 32650, 29551, 29550, 33478, 33308, 30901, 30928, 30929, 32703, 32702, 32704, 31635, 30907, 30906, 30910, 30773, 30891, 30893, 29209, 29210, 30953, 30727, 30734, 30735, 30736, 30737, 30738, 30781, 30785, 30786, 30787, 30747, 30748, 30878, 30879, 29237, 29236, 36267, 36268, 30884, 30788, 30789, 30790, 30791, 35011, 30778, 40179, 40180, 40181, 40183, 40184, 40185, 40186, 40187, 40188, 40189, 40190, 40191, 40192, 40193, 40194, 40195, 40196, 40197, 40198, 40199, 40200, 40201, 40202, 40203, 40204, 40205, 40206, 40207, 40208, 40209, 40210, 40211, 40212, 40213, 40217, 40218, 40219, 40220, 40221, 40222, 40223, 40224, 40225, 40226, 40234, 40235, 40236, 40237, 40238, 40239, 40240, 40241, 40242, 40243, 40244, 40245, 40246, 40247, 40248, 40249, 40250, 40251, 40252, 40253, 40254, 40255, 40256, 40257, 40258, 40259, 40260, 40261, 40262, 40263, 40264, 40265, 40266, 40267, 40268, 40269, 40270, 40271, 40272, 40273, 40274, 40275, 40276, 40277, 40278, 40279, 40280, 40281, 40282, 40283, 40284, 40285, 40286, 40287, 40288, 40289, 40290, 40291, 40292, 40293, 40294, 40295, 40297, 40298, 40299, 40300, 40301, 40302, 40303, 40304, 40305, 40306, 40307, 40308, 40309, 40310, 40311, 40312, 40313, 40314, 40315, 40316, 40317, 40318, 40319, 40320, 40321, 40322, 40323, 40324, 40325, 40326, 40327, 40328, 40329, 40330, 40331, 40332, 40333, 40334, 40335, 40336, 40337, 40338, 40339, 40340, 40341, 40342, 40343, 40344, 40345, 40346, 40347, 40348, 40349, 40350, 40351, 40352, 40353, 40354, 40355, 40356, 40357, 40358, 40359, 40360, 40362, 40363, 40364, 40366, 40368, 40370, 40371, 40372, 40373, 40374, 40375, 40376, 40377, 40378, 40379, 40380, 40381, 40382, 40383, 40384, 40385, 40386, 40387, 40388, 40389, 40390, 40391, 40392, 40393, 40394, 40395, 40396, 40397, 40398, 40399, 40400, 40401, 40402, 40403, 40404, 40405, 40406, 40407, 40408, 40409, 40410, 40411, 40412, 40413, 40414, 40415, 40416, 40417, 40418, 40419, 40420, 40421, 40422, 40423, 40424, 40425, 40426, 40427, 40428, 40429, 40430, 40431, 40432, 40433, 40434, 40435, 40436, 40437, 40438, 40439, 40440, 40443, 40444, 40445, 40446, 40447, 40448, 40449, 40450, 40451, 40452, 40453, 40454, 40455, 40456, 40457, 40458, 40369, 40367, 40365, 40361, 44007, 43991, 36327, 36328, 36329, 44482, 44483, 44484, 44485, 44486, 44487, 44488, 44389, 40228, 40229, 40230, 40231, 40232, 40233, 40227, 40214, 40215, 40216, 40182, 29232, 29220, 29222, 29221, 29180, 29155, 29154, 40441, 40442, 44282, 49931, 49954, 49959, 49960, 49961, 49965, 49971, 49972, 49973, 49974, 49975, 49979, 50018, 50022, 50023, 50024, 50025, 50027, 50052, 50053, 50054, 50056, 50059, 50072, 50078, 50079, 50082, 50083, 50096, 50097, 50098, 50099, 50100, 50101, 50102, 50103, 50104, 50105, 50106, 50107, 50108, 50109, 50110, 50111, 50112, 50113, 50115, 50116, 50117, 50118, 50119, 50121, 50122, 50123, 50124, 50125, 50126, 50127, 50128, 50129, 50130, 50132, 50133, 53815, 53816, 53817, 53818, 53819, 53820, 53821, 53822, 53823, 53824, 53825, 53826, 53827, 53828, 53829, 53830, 53831, 53832, 53833, 53834, 53835, 53836, 53837, 53838, 53839, 53840, 53841, 53842, 53843, 53844, 53845, 53846, 53848, 53849, 53850, 53851, 53852, 53853, 53854, 53855, 53856, 53857, 53858, 53859, 53860, 53861, 53862, 53863, 53864, 53865, 53866, 53867, 53868, 53869, 53870, 53871, 53872, 53873, 53874, 53876, 53877, 53878, 53879, 53880, 53881, 53882, 53883, 53884, 53885, 53886, 53887, 53888, 53889, 53890, 53891, 53892, 53893, 53894, 53895, 53896, 53897, 53898, 53899, 53900, 53901, 53902, 53903, 53904, 53905, 53906, 53907, 53908, 53909, 53911, 53912, 53913, 53914, 53915, 53916, 53917, 53918, 53919, 53920, 53921, 53922, 53923, 53925, 53926, 53927, 53928, 53929, 53930, 53931, 53932, 53933, 53934, 53935, 53936, 53937, 53938, 53939, 53940, 53941, 53942, 53943, 53944, 53945, 53949, 53950, 53951, 53952, 53959, 53960, 53961, 53962, 53963, 53964, 53965, 53966, 53967, 53968, 53970, 53971, 53972, 53973, 53974, 53976, 53977, 53978, 53979, 53980, 53981, 53982, 53983, 53984, 53985, 53986, 53987, 53988, 53989, 53990, 53991, 53992, 53994, 53996, 53997, 53998, 53999, 54000, 54002, 54003, 54004, 48445, 49274, 49207, 49154, 50549, 50131, 53958, 53957, 53956, 53955, 53954, 53953, 53948, 53947, 53946, 53995, 53993, 53975, 49992, 50042, 50043, 50044, 50045, 50046, 50047, 50048, 50049, 50050, 50036, 50035, 50037, 50038, 50039, 50040, 50041, 50026, 50028, 50029, 50030, 50031, 50032, 50033, 50034, 50051, 50055, 50057, 50058, 50060, 50061, 50062, 50063, 50064, 50065, 50066, 50067, 50068, 50069, 50070, 50071, 50073, 50074, 50075, 50076, 50077, 50080, 50084, 50085, 50086, 50087, 49928, 49929, 49930, 49932, 49935, 49936, 49937, 49938, 49939, 49940, 49941, 49942, 49943, 49944, 49945, 50088, 50089, 49946, 49947, 49948, 49949, 49950, 49951, 49952, 49953, 49955, 49957, 49958, 49962, 49963, 49964, 49966, 49967, 49968, 49969, 50004, 50005, 50006, 50007, 50008, 50009, 50010, 50011, 50169, 50003, 50002, 49978, 49991, 49970, 49980, 49983, 49981, 49982, 49990, 49989, 49993, 49994, 49985, 49988, 49976, 50012, 50013, 49977, 50014, 50093, 50015, 49995, 49996, 49984, 50016, 49987, 49986, 50019, 50092, 50001, 50091, 50090, 49997, 49998, 49999, 50000, 52006, 29217, 29216, 29223, 29239, 29240, 29238, 53924, 50094, 50017, 50114, 50020, 38529, 38528, 53875, 35008, 50095, 54070, 53969, 50081, 35535, 35004, 35005, 35013, 35003, 49956, 44218, 29230, 29231, 49933, 49934, 53847, 50021, 35015, 45157, 45158, 50120, 38502, 59968, 59969, 59970, 59971, 59972, 59973, 59974, 59975, 59976, 59977, 59978, 59979, 59980, 59981, 59982, 59991, 59994, 59996, 59997, 59998, 59999, 60000, 60002, 60004, 60005, 60006, 60008, 60009, 60010, 60011, 60012, 60013, 60014, 60015, 60016, 60017, 60018, 60019, 60020, 60021, 60022, 60023, 60024, 60025, 60026, 60027, 60028, 60029, 60030, 60031, 60032, 60033, 60034, 60035, 60036, 60037, 60038, 60039, 60040, 60041, 60042, 60043, 60044, 60045, 60046, 60047, 60048, 60049, 60050, 60051, 60052, 60053, 60054, 60055, 60056, 60057, 60058, 60059, 60060, 60061, 60062, 60063, 60064, 60065, 60066, 60067, 60068, 60074, 60075, 60076, 60077, 60078, 60079, 60080, 60081, 60082, 60083, 60084, 60085, 60086, 60087, 60088, 60089, 60090, 60093, 60094, 60095, 60096, 60097, 60098, 60099, 60100, 60101, 60102, 60103, 60104, 60111, 60114, 60115, 60116, 60117, 60118, 60119, 60120, 60121, 60122, 60123, 60124, 60126, 60134, 60137, 60138, 60139, 60140, 60141, 60142, 60143, 60144, 60145, 60146, 60147, 60148, 60149, 60150, 60151, 60155, 60160, 60163, 60166, 60168, 60170, 60171, 60172, 60173, 60178, 60179, 60181, 60182, 60183, 60184, 60185, 60186, 60187, 60188, 60189, 60190, 60191, 60192, 60193, 60194, 60195, 60197, 60198, 60199, 60200, 60201, 60202, 60203, 60204, 60205, 60206, 60207, 60208, 60209, 60210, 60211, 60212, 60213, 60214, 60215, 60216, 60217, 60218, 60219, 60220, 60221, 61089, 61090, 61091, 61094, 61095, 61096, 61097, 61098, 61099, 61101, 61102, 61103, 61105, 61106, 61110, 61111, 61114, 61116, 61117, 61119, 61120, 61121, 61122, 61123, 61124, 61125, 61126, 61127, 61128, 61129, 61130, 61131, 61132, 61134, 61136, 61137, 61138, 61139, 61140, 61141, 61142, 61143, 61144, 61145, 61146, 61147, 61148, 61149, 61150, 61151, 61152, 61153, 61154, 61155, 61156, 61157, 61158, 61159, 61160, 61161, 61162, 61163, 61164, 61166, 61169, 61170, 61171, 61173, 61174, 61175, 61176, 61178, 61179, 61181, 61182, 61183, 61184, 61185, 61188, 61189, 61190, 61198, 61199, 61201, 61202, 61203, 61205, 61206, 61207, 61210, 61211, 61212, 61214, 61215, 61216, 61219, 61220, 61221, 61222, 61223, 61225, 61226, 61227, 61228, 61229, 61230, 61231, 61233, 61340, 34922, 61218, 60167, 61177, 29145, 29144, 12997, 12998, 44227, 29219, 29218, 5989, 6792, 38522, 38523, 38524, 38500, 61187, 61213, 61107, 61108, 60156, 59988, 59989, 59990, 59992, 59993, 59995, 60001, 60003, 60007, 60069, 60070, 60071, 60072, 60073, 60091, 60092, 60105, 60106, 60107, 60108, 60109, 60110, 60112, 60113, 38501, 60169, 60161, 60162, 60175, 60176, 60177, 60127, 60128, 60129, 60130, 60131, 60132, 60196, 61104, 60180, 60154, 6793, 61186, 61217, 61196, 60174, 61232, 61197, 61204, 61209, 61200, 60152, 60153, 59983, 60159, 60133, 61109, 60136, 61167, 61224, 61208, 34926, 58216, 60165, 61168, 61133, 29234, 29233, 44236, 44237, 44238, 44239, 61180, 61135, 65161, 61165, 65169, 61172, 65122, 65160, 59613, 59614, 59615, 59631, 59632, 59633, 60164, 60158, 60157, 59915, 64429, 64532, 67311, 67312, 67313, 67314, 67315, 67316, 67317, 67318, 67319, 67320, 67321, 67322, 67323, 67324, 67325, 67326, 67327, 67328, 67329, 67330, 67331, 67332, 67333, 67334, 68940, 68941, 68942, 68943, 68944, 68945, 68946, 68947, 68948, 68949, 68950, 68951, 68952, 68953, 68954, 68955, 68956, 68957, 68958, 68959, 68960, 68961, 68962, 68963, 68964, 68965, 68966, 68967, 68968, 68969, 68970, 68971, 68972, 68973, 68974, 68975, 68976, 68977, 68978, 68979, 68980, 68981, 68982, 68983, 68984, 68985, 68986, 68991, 68992, 68993, 68994, 68996, 68997, 68998, 68999, 69001, 69003, 69005, 69006, 69011, 69012, 69013, 69014, 69015, 69016, 69017, 69018, 69019, 69020, 69021, 69022, 69023, 69025, 69026, 69027, 69028, 69030, 69031, 69040, 69041, 69042, 69043, 69044, 69045, 69052, 69053, 69054, 69055, 69056, 69057, 69058, 69059, 69060, 69061, 69062, 69063, 69064, 69065, 69066, 69067, 69069, 69070, 69071, 69072, 69073, 69074, 69075, 69077, 69078, 69079, 69084, 69085, 69087, 69094, 69095, 69104, 69106, 69110, 69111, 69112, 69114, 69115, 69116, 69118, 69123, 69124, 69125, 69127, 69129, 69130, 69131, 69132, 69133, 69134, 69135, 69136, 69137, 69138, 69139, 69140, 69141, 69144, 69145, 69146, 69147, 69148, 69149, 69150, 69883, 69884, 69891, 69892, 69894, 69898, 69899, 69900, 69901, 69902, 69903, 69905, 69906, 69909, 69910, 69912, 69913, 69915, 69916, 69917, 69920, 69921, 69922, 69923, 69924, 69925, 69926, 69927, 69928, 69929, 69930, 69931, 69932, 69934, 69938, 69939, 69944, 69947, 69949, 69950, 69951, 69952, 69953, 69954, 69955, 69957, 69958, 69959, 69960, 69961, 69964, 69965, 69972, 69981, 69982, 69983, 69984, 69985, 69986, 69987, 69988, 69989, 69992, 69994, 68915, 69024, 72547, 69895, 69701, 70166, 70162, 69998, 69889, 72725, 72726, 72727, 72728, 72729, 72730, 72731, 73118, 73197, 69897, 69885, 35012, 69122, 69971, 69107, 69968, 69089, 69090, 69976, 69978, 34935, 65151, 65156, 65164, 69092, 69008, 69009, 69076, 69049, 69143, 69142, 69126, 69128, 69036, 69029, 69945, 69000, 69820, 69907, 70699, 70700, 70701, 70702, 70163, 70164, 70695, 70696, 70697, 70698, 69700, 69966, 69956, 69946, 69937, 69936, 69935, 69080, 69086, 69896, 72421, 69908, 69096, 69980, 69105, 73204, 69039, 69038, 69037, 69035, 69034, 69032, 73095, 73199, 73183, 73184, 73185, 73186, 73223, 73208, 69097, 69102, 69100, 69081, 70224, 34924, 69893, 57712, 57713, 5995, 34918, 36330, 34927, 34917, 34925, 35494, 65284, 34931, 34929, 34919, 34921, 69990, 69993, 69991, 58221, 69963, 69962, 69099, 69098, 57711, 64545, 64578, 64575, 64577, 75186, 75187, 75188, 75189, 75190, 75191, 75192, 75193, 75195, 75196, 75197, 75198, 75199, 75200, 75201, 75202, 75204, 75205, 75208, 75209, 75210, 75212, 75213, 75215, 75216, 75217, 75218, 75219, 75220, 75221, 75222, 75223, 75224, 75228, 75229, 75230, 75231, 75235, 75569, 75570, 75571, 75572, 75573, 75574, 75575, 75576, 75577, 75578, 75579, 75580, 75581, 75582, 75583, 75584, 75585, 75586, 75587, 75588, 75589, 75590, 75591, 75592, 75593, 75594, 75595, 75596, 75597, 75598, 75599, 75600, 75601, 75602, 75603, 75605, 75606, 75607, 75608, 75609, 75610, 75611, 75612, 75613, 75614, 75615, 75616, 75617, 75618, 75619, 75620, 75621, 75622, 75626, 75627, 75628, 75629, 75630, 75638, 75639, 75640, 75641, 75642, 75643, 75644, 75645, 75646, 75647, 75648, 75649, 75650, 75651, 75652, 75632, 75631, 75636, 75635, 75634, 75633, 76598, 69882, 34916, 75623, 69702, 69904, 77027, 77028, 77026, 77030, 77029, 58206, 69088, 58217, 34923, 58205, 65162, 34934, 65159, 69948, 69941, 69977, 75637, 69967, 69975, 69973, 69974, 75214, 58218, 69881, 69083, 73503, 69890, 73076, 69888, 73501, 65124, 75232, 73597, 76386, 78142, 65167, 69091, 76783, 70198, 69911, 79075, 79076, 79077, 79078, 79079, 79080, 79081, 79082, 79083, 79084, 79085, 79086, 79088, 79091, 79092, 79093, 79094, 79095, 79096, 79098, 79099, 79100, 79101, 79103, 79105, 79106, 79107, 79108, 79109, 79110, 79112, 79113, 79114, 79115, 79116, 79117, 79118, 79119, 79120, 79121, 79122, 79104, 79123, 70103, 75233, 75203, 75227, 75226, 75225, 79830, 79831, 79832, 79833, 79834, 79835, 79837, 79838, 79839, 79840, 79841, 79842, 79843, 79844, 79845, 79846, 79847, 79848, 79849, 79850, 79852, 79853, 79854, 79855, 79856, 79857, 79858, 79859, 79860, 79861, 79863, 79864, 79865, 79873, 79874, 79875, 79876, 79879, 79880, 79881, 79882, 79883, 79884, 79885, 79886, 79887, 79888, 79889, 79890, 79899, 79906, 79908, 79909, 79910, 79911, 79916, 79917, 79918, 79919, 79920, 79921, 79922, 79923, 79924, 79925, 79926, 79927, 79928, 79930, 79931, 79932, 79933, 79934, 79935, 79936, 79937, 79938, 79939, 79940, 79941, 79942, 79943, 79944, 79945, 79946, 79947, 79949, 79950, 79951, 79952, 79953, 79954, 79955, 79958, 79959, 79960, 79836, 79907, 79891, 79892, 79893, 79894, 79895, 79896, 79897, 79898, 79912, 79913, 79914, 80013, 79089, 79102, 44240, 58220, 36382, 64574, 64553, 64572, 64571, 64579, 64581, 64580, 65790, 65168, 65176, 77077, 64792, 69068, 75624, 58204, 64642, 78027, 74173, 65793, 77580, 69109, 69108, 74827, 74174, 74196, 74825, 69979, 35010, 35009, 57716, 76366, 68701, 64739, 74773, 78028, 78029, 78091, 78092, 78143, 77574, 65791, 79097, 65792, 73646, 79903, 79904, 79905, 79901, 79902, 79900, 82299, 82300, 82301, 82302, 82304, 82305, 82306, 82308, 82309, 82310, 82311, 82312, 82313, 82314, 82315, 82316, 82318, 82319, 82320, 82321, 82322, 82323, 82324, 82325, 82326, 82327, 82329, 82330, 82331, 82333, 82336, 82337, 82340, 82342, 82344, 82345, 82332, 82888, 82889, 82890, 82892, 82893, 82894, 82895, 82896, 82897, 82898, 82899, 82900, 82901, 82902, 82903, 82904, 82905, 82906, 82907, 82908, 82909, 82910, 82911, 82912, 82914, 82915, 82916, 82917, 82918, 82919, 82920, 82921, 82922, 82923, 82924, 82925, 82926, 82927, 82928, 82929, 82930, 82931, 82932, 82937, 82938, 82939, 82940, 82941, 82942, 82944, 82945, 82946, 82947, 82948, 82949, 82951, 82952, 82953, 82954, 79871, 79866, 79867, 79868, 79869, 79870, 79851, 81190, 81191, 81137, 82298, 83151, 83152, 73105, 79280, 76921, 73122, 73153, 64566, 64565, 73090, 73091, 73092, 83150, 79111, 82303, 82335, 77572, 69113, 77689, 75625, 81139, 81193, 34936, 79878, 79877, 65197, 65195, 65196, 69970, 82334, 35534, 13003, 13004, 69103, 81136, 83153, 79087, 68015, 83941, 81694, 77690, 64478, 77076, 81178, 84248, 84033, 85446, 85447, 85448, 85449, 85450, 85451, 85452, 85453, 77693, 77694, 77688, 77687, 74195, 74176, 69004, 84229, 85749, 79915, 69886, 69940, 75234, 82338, 82343, 82341, 82339, 79090, 69942, 75206, 69914, 82934, 82936, 82935, 82933, 82317, 69969, 85579, 85580, 85581, 85973, 85972, 85976, 82307, 65794, 84223, 86085, 86084, 73245, 73206, 86406, 86412, 86413, 86415, 86417, 86419, 86420, 86422, 86423, 86424, 86426, 86427, 86428, 86429, 86430, 86431, 86433, 86434, 86435, 86768, 86769, 86770, 86772, 86774, 86775, 86776, 86910, 86911, 86912, 86913, 86914, 86915, 86916, 86917, 86918, 86919, 86922, 86923, 86924, 86927, 86928, 86929, 86930, 86931, 86932, 86933, 86934, 86935, 86936, 84918, 84029, 87016, 87017, 87018, 87019, 87020, 87113, 87114, 87115, 69002, 87213, 87214, 77692, 77691, 74197, 74410, 69082, 85397, 87296, 65150, 77568, 77749, 77571, 79929, 44232, 44233, 77078, 88277, 85533, 81737, 85797, 84959, 84927, 74175, 77570, 77567, 81194, 88618, 88619, 88635, 88484, 88623, 88636, 88634, 88633, 88632, 88630, 88629, 88628, 88627, 88626, 88625, 88624, 88622, 88621, 88620, 88617, 89171, 89177, 89187, 89321, 89326, 89327, 89328, 89459, 89444, 89443, 89442, 89440, 89766, 90252, 90253, 90254, 90255, 90256, 90257, 90259, 90260, 90261, 90262, 90263, 90264, 90265, 90266, 90267, 90268, 90269, 90270, 90271, 90272, 90273, 90274, 90275, 90276, 90277, 90278, 90279, 90280, 90281, 90282, 90283, 90284, 90285, 90286, 90287, 90288, 90289, 90290, 90291, 90292, 90293, 90294, 90295, 90296, 90297, 90298, 90299, 90300, 90301, 90302, 90303, 90304, 90305, 90306, 90307, 90308, 90309, 90310, 90311, 90312, 90313, 88604, 88605, 88606, 88607, 88608, 88609, 88610, 88611, 88612, 88613, 88614, 88615, 82887, 75604, 86414, 86418, 86425, 82891, 79862, 81691, 69050, 79956, 86771, 86773, 86925, 86926, 68987, 68988, 68989, 68990, 86432, 86407, 86408, 86409, 68016, 68017, 68018, 68019, 68020, 69120, 69121, 69117, 69119, 69101, 86416, 82913, 88482, 88481, 69919, 69918, 79073, 79074, 69933, 75207, 69943, 75211, 86411, 86767, 69033, 68995, 79948, 70165, 88637, 88480, 88483, 88616, 81693, 64643, 86054, 86051, 86053, 77573, 84151, 84028, 84920, 65189, 86410, 85796, 88631, 91335, 91401, 83752, 85718, 85717, 77698, 77697, 91008, 91007, 85712, 85711, 80539, 80540, 80538, 64430, 85445, 88148, 87936, 81731, 84284, 84285, 81692, 86921, 86920, 91484, 79255, 91882, 91883, 91884, 91885, 91886, 91887, 91888, 91889, 91891, 91892, 91893, 91894, 91895, 91896, 91897, 91898, 91899, 91900, 91901, 91902, 91903, 91904, 91905, 91906, 91907, 91908, 91909, 91910, 91911, 91912, 91913, 91914, 91915, 92088, 92089, 92090, 92091, 92092, 92093, 92094, 92095, 92096, 92097, 92098, 92099, 92101, 92102, 92103, 92104, 92105, 92106, 92107, 92108, 92109, 92110, 92111, 92112, 92113, 92114, 92115, 92116, 92117, 92118, 92119, 92120, 92121, 92122, 92123, 92124, 92125, 92126, 92127, 92128, 92129, 92130, 92131, 92132, 88149, 85304, 86421, 73172, 65163, 65795, 74409, 77108, 81096, 81097, 84224, 86069, 86101, 91721, 91722, 81690, 79292, 89158, 90258, 92100, 90473, 81138, 94366, 94374, 94365, 94561, 94560, 87302, 73652, 88274, 90454, 90337, 90327, 68510, 94727, 94728, 94726, 94725, 94760, 83938, 95096, 95098, 85715, 85716, 87375, 87374, 95148, 95149, 95150, 95187, 92087, 77075, 91316, 91315, 90338, 95369, 95368, 95367, 91890, 95186, 84156, 84154, 84153, 95775, 95785, 90326, 93973, 93974, 93975, 90455, 95795, 95796, 95797, 95798, 95799, 95826, 95827, 95828, 95829, 95830, 95831, 95832, 96419, 96420, 96421, 96422, 96423, 96424, 96425, 96426, 96427, 96440, 96441, 96442, 96443, 96444, 96445, 96446, 96447, 96448, 96449, 96450, 96451, 96452, 96453, 96454, 97366, 97377, 97375, 90474, 90472, 87937, 87938, 93970, 85714, 85713, 93985, 94769, 91511, 93986, 93987, 97799, 81192, 81236, 84958, 84956, 77569, 98124, 98118, 98117, 98186, 98125, 35555, 35556, 35536, 35537, 57714, 57715, 77696, 77695, 85214, 85215, 82950, 93988, 91486, 91517, 98440, 98419, 98437, 94367, 87814, 88258, 85519, 98444, 94770, 81721, 94562, 6030, 74428, 6031, 74427, 84149, 84155, 84150, 84152, 98679, 98680, 98681, 98682, 98683, 98684, 98685, 98686, 98687, 98767, 98768, 98769, 98770, 98771, 98772, 98773, 98774, 98775, 98776, 98777, 98778, 98779, 98780, 98781, 98782, 98783, 98784, 99279, 99280, 99281, 99443, 99444, 99445, 99446, 99447, 99448, 99449, 99450, 99451, 99452, 99453, 99454, 99455, 99456, 99457, 99458) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 20 | maybe slow |
