| 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` <> 97377 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, 34689, 34690, 34691, 34693, 34694, 34695, 34696, 34697, 34698, 34699, 34700, 34701, 34702, 34703, 34704, 34705, 34706, 34707, 34708, 34709, 34712, 34713, 34714, 34715, 34716, 34717, 34719, 34720, 34721, 34723, 34724, 34726, 34727, 34730, 34733, 34740, 34741, 34742, 34743, 34744, 34745, 34746, 34748, 34749, 34750, 34751, 34752, 5650, 5790, 5779, 5801, 5696, 5781, 5697, 5789, 5768, 5703, 5691, 5780, 5783, 5753, 5784, 5757, 5693, 5751, 5766, 5707, 5695, 5786, 5799, 5778, 5714, 5704, 4996, 5694, 4969, 4997, 5064, 4963, 5793, 4968, 5062, 5770, 4965, 5795, 5800, 5769, 5797, 5706, 5802, 4967, 5794, 5708, 5692, 4964, 5702, 5063, 4966, 5796, 5705, 5767, 5752, 5785, 5782, 5788, 5774, 5787, 5773, 5772, 5771, 5798, 5759, 32806, 32814, 32813, 32812, 32811, 32810, 32809, 32808, 32807, 34710, 5701, 34718, 34725, 30896, 30899, 32656, 32655, 32657, 32649, 32651, 32650, 29551, 29550, 33478, 33308, 30901, 34735, 34738, 34737, 34755, 32744, 32743, 30928, 30929, 34739, 32703, 32702, 32704, 32916, 32917, 32918, 32919, 34729, 34728, 31635, 34731, 35736, 34734, 34736, 34732, 30907, 30906, 30910, 35734, 34692, 34722, 35739, 34747, 5712, 5713, 5737, 5738, 5736, 5709, 5710, 5711, 30773, 34753, 30891, 30893, 29209, 29210, 30953, 35405, 35733, 30727, 30734, 30735, 30736, 30737, 30738, 30781, 30785, 30786, 30787, 30747, 30748, 30878, 30879, 32843, 32844, 32845, 34754, 29237, 29236, 36267, 36268, 30884, 30788, 30789, 30790, 30791, 34711, 35756, 35011, 30778, 35755, 35735, 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, 42740, 42741, 42743, 42746, 42747, 42748, 42751, 42752, 42753, 42754, 42755, 42756, 42757, 42758, 42759, 42760, 42761, 42762, 42763, 42764, 42765, 42766, 42767, 42768, 42769, 42770, 42771, 42772, 42773, 42774, 42775, 42776, 42777, 42778, 42779, 42780, 42781, 42782, 42783, 42784, 42785, 42786, 42789, 42790, 42791, 42792, 42797, 42798, 42799, 42800, 42801, 42802, 42803, 42804, 42805, 42806, 42807, 42808, 42809, 42810, 42811, 42812, 42813, 42814, 42815, 42816, 42817, 42904, 42905, 42796, 42795, 42818, 42788, 41287, 41283, 41281, 41280, 41277, 42787, 42750, 42745, 40369, 40367, 40365, 40361, 44007, 35746, 43991, 42749, 42744, 35778, 35757, 35758, 35708, 36327, 36328, 36329, 44482, 44483, 44484, 44485, 44486, 44487, 44488, 44582, 44583, 44584, 44585, 44586, 44587, 44588, 44589, 44590, 44591, 44592, 44593, 44594, 44595, 44596, 44597, 44598, 44599, 44600, 44601, 44602, 44603, 44604, 44605, 44606, 44607, 44608, 44609, 44610, 44611, 44612, 44613, 44614, 44615, 44616, 44617, 44618, 44619, 44620, 44621, 44622, 35741, 35728, 44389, 40228, 40229, 40230, 40231, 40232, 40233, 40227, 40214, 40215, 40216, 42742, 35740, 40182, 35744, 35750, 35780, 35753, 35782, 5791, 5792, 29232, 29220, 29222, 29221, 29180, 29155, 29154, 40441, 40442, 44282, 42641, 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, 53201, 53202, 53203, 53204, 53205, 53207, 53208, 53209, 53210, 53211, 53212, 53213, 53214, 53215, 53216, 53217, 53218, 53219, 53220, 53221, 53222, 53223, 53224, 53225, 53227, 53228, 53229, 53230, 53231, 53232, 53233, 53234, 53235, 53236, 53237, 53238, 53239, 53241, 53243, 53245, 53246, 53247, 53248, 53249, 53250, 53251, 53252, 53253, 53254, 53255, 53256, 53258, 53260, 53261, 53262, 53263, 53265, 53266, 53267, 53268, 53269, 53270, 53272, 53273, 53275, 53276, 53277, 53278, 53279, 53280, 53281, 53282, 53283, 53284, 53285, 53286, 53287, 53288, 53289, 53290, 53291, 53292, 53293, 53294, 53295, 53296, 53297, 53298, 53300, 53301, 53302, 53303, 53304, 53306, 53307, 53308, 53309, 53310, 53311, 53313, 53314, 53315, 53316, 53317, 53318, 53319, 53320, 53321, 53322, 53323, 53324, 53325, 53327, 53328, 53329, 53330, 50549, 50131, 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, 53326, 53226, 53271, 53299, 51400, 53242, 53305, 53312, 53206, 53244, 29217, 29216, 29223, 29239, 29240, 29238, 50094, 50017, 50114, 50020, 35712, 35713, 35714, 35718, 35716, 35720, 35721, 35008, 35737, 35738, 35772, 35774, 35775, 35776, 35777, 5756, 35742, 35789, 53259, 53264, 50095, 53257, 50081, 35715, 44765, 44767, 35717, 35773, 35784, 35004, 35005, 35727, 38479, 38478, 35013, 35003, 38481, 35467, 35709, 53240, 49956, 44218, 29230, 29231, 49933, 49934, 50021, 53274, 35711, 35707, 35710, 35747, 35015, 45157, 45158, 50120, 59324, 59325, 59334, 59336, 59337, 59340, 59353, 59357, 59358, 59361, 59363, 59367, 59368, 59369, 59371, 59373, 59374, 59375, 59378, 59382, 59384, 59385, 59387, 59388, 59389, 59392, 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, 59377, 59351, 59390, 59386, 59338, 63866, 63864, 63862, 63861, 63860, 63901, 63857, 63856, 63851, 63912, 63829, 63867, 63891, 59354, 59333, 59391, 35779, 60167, 59352, 29145, 29144, 44227, 29219, 29218, 5989, 59379, 61587, 59383, 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, 59343, 59344, 59345, 59348, 59393, 59394, 59395, 59396, 59397, 60169, 59364, 59365, 60161, 60162, 60175, 60176, 60177, 60127, 60128, 60129, 60130, 60131, 60132, 60196, 60180, 60154, 59339, 59360, 59332, 59331, 59330, 59329, 59328, 59327, 59326, 35748, 35745, 60174, 35743, 35749, 59362, 59376, 59381, 59341, 60152, 59349, 60153, 59983, 60159, 60133, 59359, 59356, 59372, 59366, 60136, 64998, 64999, 35754, 59350, 59335, 59342, 35731, 35729, 35790, 35761, 57689, 59370, 59380, 60165, 35752, 61610, 29234, 29233, 44236, 44237, 44238, 44239, 59346, 35751, 59355, 59613, 59614, 59615, 59631, 59632, 59633, 60164, 60158, 60157, 59915, 59347, 64532, 68397, 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, 68401, 68428, 68413, 68915, 69024, 70162, 69998, 72725, 72726, 72727, 72728, 72729, 72730, 72731, 73118, 73197, 69897, 35012, 69122, 35770, 69107, 68394, 35723, 68410, 58271, 58272, 69089, 69090, 35722, 35732, 68391, 64992, 64993, 64994, 64995, 64996, 64997, 65000, 65151, 65156, 69092, 69008, 69009, 69076, 69049, 69143, 69142, 69126, 69128, 69036, 69029, 69000, 69080, 69086, 72421, 35759, 69096, 68389, 68412, 68405, 68406, 68425, 68381, 68380, 68377, 68376, 68372, 68371, 68370, 68369, 68427, 69105, 73204, 69039, 69038, 69037, 69035, 69034, 69032, 73095, 73199, 73183, 73184, 73185, 73186, 73223, 73208, 69097, 69102, 69100, 35781, 69081, 70224, 35767, 35719, 44766, 5995, 36330, 35771, 35769, 35768, 68388, 65002, 65001, 68385, 68387, 68407, 58221, 69099, 69098, 64545, 64578, 64575, 64577, 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, 65003, 65004, 38480, 75623, 77027, 77028, 77026, 77030, 77029, 69088, 65367, 57693, 57694, 57692, 35730, 65006, 65007, 65009, 75637, 65008, 65005, 69083, 57691, 73076, 73501, 75310, 75311, 68392, 75313, 68393, 75312, 75315, 68398, 74186, 74187, 68400, 75314, 68403, 64450, 68404, 68408, 68409, 68415, 68416, 64448, 75316, 75317, 75318, 75319, 75320, 75321, 68423, 75322, 68421, 68418, 75323, 68386, 68384, 68379, 68378, 68373, 68374, 68375, 75324, 75325, 75326, 65124, 68368, 65800, 69091, 65369, 65354, 76783, 68382, 68383, 68419, 68420, 68395, 78664, 78684, 78659, 78660, 78661, 78662, 78663, 78665, 78666, 78699, 78687, 78688, 78689, 78690, 78691, 78692, 78693, 78694, 78695, 78696, 78697, 78698, 78671, 78672, 78673, 78674, 78675, 78676, 78677, 78678, 78679, 78680, 78681, 78682, 78683, 78685, 78686, 78667, 78668, 78669, 78670, 78700, 78701, 78702, 78703, 78704, 78705, 78706, 78707, 78710, 78719, 78720, 78721, 78722, 78723, 78724, 78726, 78727, 78737, 78738, 78739, 78740, 78713, 78714, 78715, 78716, 78717, 78729, 78730, 78731, 78734, 78735, 78736, 78733, 78732, 79788, 79796, 79790, 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, 44240, 58220, 64616, 68429, 64574, 64553, 64546, 64572, 64571, 64579, 64581, 64580, 65790, 74189, 65176, 64451, 64439, 64452, 64446, 64449, 64441, 64445, 68422, 64792, 64447, 78711, 69068, 75624, 58204, 74188, 81109, 64642, 57690, 77580, 69109, 69108, 74196, 64617, 35010, 35009, 57716, 64739, 74773, 78091, 78092, 77239, 77241, 65791, 65792, 79903, 79904, 79905, 79901, 79902, 79900, 82518, 82519, 82522, 82523, 82525, 82527, 82528, 82529, 82534, 82535, 82536, 82540, 82545, 82547, 82548, 82549, 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, 77238, 81190, 81191, 78718, 83258, 83300, 83293, 83299, 83291, 83310, 83259, 83255, 72689, 72660, 78712, 68414, 68417, 64443, 82538, 82541, 82537, 78728, 83151, 83152, 73105, 79280, 76921, 73122, 73153, 64566, 64565, 73090, 73091, 73092, 83150, 77572, 78136, 69113, 77240, 75625, 81193, 72722, 82524, 79878, 79877, 82542, 64620, 64444, 82543, 69970, 82334, 83996, 83997, 83998, 64619, 80620, 13003, 13004, 82544, 69103, 78725, 68402, 83153, 82539, 81105, 68015, 68396, 82521, 68424, 82526, 81694, 64621, 78708, 78709, 81734, 81178, 84033, 85446, 85447, 85448, 85449, 85450, 85451, 85452, 85453, 57649, 74195, 69004, 84229, 79915, 82934, 82936, 82935, 82933, 68399, 85973, 85972, 85976, 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, 86777, 86778, 86779, 86780, 86781, 86782, 86783, 86784, 86785, 86924, 86927, 86928, 86929, 86930, 86931, 86932, 86933, 86934, 86935, 86936, 84918, 87113, 87114, 87115, 69002, 87213, 87214, 68390, 74197, 74410, 83999, 84000, 84001, 69082, 84034, 87296, 77754, 81104, 79789, 79929, 82546, 82520, 44232, 44233, 84137, 85533, 81737, 85797, 84927, 81194, 89147, 89148, 89149, 89150, 89151, 89152, 89153, 89154, 89156, 89157, 89159, 89160, 89161, 89162, 89163, 89165, 89172, 89173, 89174, 89175, 89176, 89178, 89180, 89181, 89182, 89183, 89184, 89188, 89189, 89190, 89192, 89193, 89194, 89195, 89196, 89197, 89198, 89201, 89203, 89205, 88349, 88701, 88702, 88705, 88706, 88707, 88713, 88714, 89164, 89171, 89170, 89177, 89185, 89186, 89187, 89321, 89326, 89327, 89328, 89459, 89444, 89443, 89442, 89440, 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, 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, 80603, 80606, 80601, 80605, 80599, 80600, 80602, 80604, 86416, 82913, 86411, 86767, 69033, 68995, 79948, 64738, 81693, 64737, 35787, 35404, 35402, 86051, 86053, 58116, 58118, 58121, 58117, 58119, 58120, 84139, 84151, 65189, 86410, 89200, 85796, 58269, 58270, 91323, 91335, 89169, 57695, 57696, 57697, 80540, 91473, 91472, 91471, 91479, 91478, 91477, 91476, 91475, 91474, 87936, 81731, 89199, 81692, 87674, 87673, 87675, 36230, 36231, 91753, 79255, 91916, 91917, 91918, 91919, 91920, 91921, 91922, 91923, 91924, 91925, 91927, 91928, 91929, 91930, 91931, 91932, 91934, 91936, 91937, 91940, 91941, 91942, 91943, 91944, 91946, 91948, 91949, 91950, 91951, 91953, 91954, 91956, 91957, 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, 85304, 86421, 73172, 93934, 93933, 65029, 84937, 86069, 87825, 87824, 81690, 79292, 89158, 91933, 91935, 91938, 89166, 89167, 89168, 89179, 91945, 91947, 91926, 91952, 89202, 89204, 90258, 92100, 81116, 90473, 91939, 94374, 73781, 35760, 35764, 85180, 85182, 85178, 85179, 85181, 35783, 35786, 35788, 35785, 35403, 77236, 77235, 77234, 73652, 85177, 77237, 88274, 89155, 90337, 64440, 74424, 6777, 64438, 95096, 95098, 80586, 85186, 85188, 85183, 85184, 85185, 85187, 57686, 57685, 57688, 57687, 57684, 95148, 95149, 95150, 95183, 85176, 92087, 89191, 95200, 95204, 95203, 95202, 95201, 95190, 95191, 95193, 95194, 95195, 95196, 95197, 95198, 95199, 95297, 95298, 95299, 95300, 95301, 95302, 95303, 95304, 95305, 95306, 95307, 95308, 95309, 95310, 95311, 95312, 95313, 95314, 95315, 95316, 95317, 95318, 95319, 95320, 95321, 95322, 95323, 95324, 95325, 90456, 90338, 95365, 95364, 95192, 84156, 85175, 84154, 84153, 74190, 95649, 95648, 95633, 95647, 95632, 95646, 95631, 95645, 95630, 95644, 95629, 95643, 95642, 95653, 95652, 95651, 95650, 6778, 6779, 95771, 95826, 95827, 95828, 95829, 95830, 95831, 95832, 95841, 95842, 95843, 95844, 95845, 95846, 95847, 95848, 95849, 95850, 96419, 96420, 96421, 96422, 96423, 96424, 96425, 96426, 96427, 96548, 96549, 96550, 96551, 96552, 96553, 96554, 96555, 96556, 96557, 96558, 96559, 96560, 96561, 96562, 96563, 96564, 96565, 96566, 96567, 97377, 90474, 90472, 87937, 87938, 93970, 84138, 93985, 94769, 91511, 93986, 93987, 81192, 91955, 35724, 35725, 35726, 65202, 65203, 64618, 82950, 93988, 91486, 91517, 98430, 98419, 98444, 57701, 57699, 57702, 57698, 57700, 57679, 57680, 57682, 57683, 57681, 35762, 35765, 73782, 73783, 35766, 35763, 73784, 98504, 98519, 98503, 98518, 98502, 98517, 98501, 98516, 98500, 98515, 98499, 98514, 98498, 98513, 98528, 98497, 98512, 98527, 98496, 98511, 98526, 98495, 98510, 98525, 98494, 98509, 98524, 98508, 98523, 98507, 98522, 98506, 98505, 98520, 6030, 74428, 6031, 74427, 84149, 84155, 84150, 84152, 98709, 98710, 98711, 98712, 98713, 98714, 98715, 98716, 98717, 98718, 98719, 98720, 98767, 98768, 98769, 98770, 98771, 98772, 98773, 98774, 98775, 98776, 98777, 98778, 98779, 98780, 98781, 98782, 98783, 98784, 99282, 99283, 99284, 99285, 99286, 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 | 29 | maybe slow |
