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` <> 94343 AND `Item`.`id` IN (5997, 6287, 6498, 6500, 6499, 6764, 7033, 7034, 7035, 7036, 7037, 7038, 7039, 7040, 7041, 7042, 7043, 7044, 7045, 7046, 7047, 7048, 7049, 7050, 7051, 7052, 7053, 7054, 7055, 7056, 7057, 7058, 7059, 7060, 7061, 7062, 7063, 7064, 7065, 7066, 7067, 7068, 7069, 7070, 7071, 7072, 7073, 7074, 7075, 7076, 7077, 7078, 7079, 7080, 7081, 7082, 7083, 7084, 7085, 7086, 7087, 7088, 7089, 7090, 7091, 7092, 7093, 7094, 7095, 7096, 7097, 7098, 7099, 7100, 7101, 7102, 7103, 7104, 7105, 7106, 7107, 7108, 7109, 7110, 7111, 7112, 7113, 7114, 7115, 7116, 7117, 7118, 7119, 7120, 7121, 7122, 7124, 7125, 7126, 7127, 7128, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7136, 7137, 7138, 7139, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7147, 7148, 7149, 7150, 7151, 7152, 7153, 7154, 7155, 7156, 7157, 7158, 7159, 7160, 7161, 7162, 7163, 7164, 7165, 7166, 7167, 7174, 7175, 7176, 7177, 7178, 7179, 7180, 7181, 7182, 7183, 7184, 7185, 7192, 7193, 7194, 7195, 7196, 7197, 7198, 7199, 7200, 7201, 7202, 7204, 7205, 7206, 7207, 7208, 7209, 7210, 7211, 7212, 7213, 7214, 7215, 7216, 7217, 7218, 7219, 7220, 7221, 7222, 7223, 7224, 7225, 7226, 7227, 7228, 7229, 7230, 7231, 7232, 7233, 7234, 7235, 7236, 7237, 7238, 7239, 7240, 7241, 7242, 7243, 7244, 7245, 7246, 7247, 7248, 7249, 7250, 7251, 7252, 7253, 7254, 7255, 7256, 7257, 7258, 7259, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7267, 7268, 7269, 7270, 7271, 7272, 7273, 7274, 7275, 7276, 7277, 7278, 7279, 7281, 7282, 7283, 7285, 7286, 7287, 7288, 7289, 7290, 7291, 7292, 7294, 7295, 7296, 7297, 7298, 7299, 7300, 7301, 7302, 7303, 7305, 7307, 7308, 7309, 7310, 7311, 7312, 7313, 7315, 7319, 7320, 7321, 7322, 7325, 7326, 7327, 7328, 7329, 7330, 7331, 4923, 4925, 4928, 4929, 4930, 7280, 7203, 6137, 8475, 12392, 12435, 12385, 7314, 7304, 7317, 7318, 7316, 7123, 5295, 7293, 7306, 7171, 7173, 7172, 7186, 7187, 7188, 7189, 7190, 7191, 7168, 7169, 7170, 6763, 5999, 6294, 6000, 6293, 6286, 13310, 13311, 13312, 13313, 13314, 13315, 13316, 13317, 13318, 13319, 13321, 13327, 13329, 13332, 13333, 13334, 13335, 13336, 13337, 13338, 13339, 13340, 13341, 13343, 13344, 13345, 13346, 13347, 13348, 13349, 13350, 13351, 13352, 13353, 13354, 13355, 13356, 13357, 13358, 13359, 13360, 13361, 13362, 13363, 13364, 13365, 13366, 13369, 13370, 13371, 13372, 13373, 13374, 13375, 13376, 13377, 13378, 13379, 13380, 13381, 13382, 13383, 13384, 13385, 13387, 13388, 13389, 13390, 13393, 13394, 13395, 13396, 13402, 13403, 13404, 13405, 13406, 13410, 13411, 13412, 13413, 13414, 13415, 13417, 13418, 13422, 13423, 13424, 13425, 13426, 13427, 13428, 13429, 13430, 13431, 13432, 13433, 13434, 13435, 13436, 13437, 13438, 13439, 13440, 13441, 13442, 13443, 13444, 13445, 13446, 13447, 13448, 13449, 13450, 13451, 13452, 13453, 13454, 13455, 13456, 13457, 13458, 13459, 13460, 13461, 13462, 13463, 13464, 13465, 13466, 13467, 13468, 13469, 13471, 13477, 13478, 13479, 13480, 13481, 13482, 13483, 13484, 13485, 13486, 13487, 13488, 13489, 13490, 13491, 13492, 13493, 13494, 13495, 13496, 13497, 13498, 13499, 13500, 13501, 13502, 13503, 13504, 13505, 13506, 13507, 13508, 13509, 13510, 13511, 13515, 13516, 13517, 13518, 13519, 13520, 13521, 13522, 13523, 13524, 13525, 13526, 13527, 13528, 13529, 13530, 13531, 13532, 13533, 13534, 13535, 13536, 13537, 13538, 13539, 13540, 13541, 13543, 13544, 13545, 13546, 13547, 13548, 13549, 13550, 13551, 13552, 13553, 13554, 13555, 13556, 13557, 13558, 13559, 13560, 13561, 13562, 13563, 13564, 13565, 13566, 13567, 13568, 13569, 13570, 13571, 13573, 13574, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13583, 13584, 13585, 13586, 13587, 13588, 13589, 13592, 13593, 13594, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602, 13604, 13605, 13606, 13607, 13608, 13609, 13610, 13611, 13612, 13613, 13614, 13615, 13616, 13617, 13618, 13619, 13620, 13621, 13623, 13624, 13625, 13627, 13629, 13632, 13572, 7323, 7324, 7284, 13542, 13408, 13630, 13633, 13636, 13470, 13628, 13409, 13631, 13635, 13634, 13626, 14126, 18214, 18211, 18212, 18213, 18215, 18216, 18217, 18218, 18219, 18220, 18202, 18203, 18204, 18168, 18169, 18170, 18171, 18186, 18184, 18185, 18187, 18188, 18189, 18190, 18191, 18196, 18197, 18198, 18199, 18205, 18206, 18207, 18208, 18209, 18210, 18200, 18201, 18172, 18173, 18174, 18175, 13637, 6291, 6296, 6295, 6292, 13419, 13322, 13331, 13330, 13328, 13421, 13325, 13420, 6288, 6289, 6290, 13323, 13324, 6002, 6001, 6003, 6096, 13326, 13407, 13398, 13399, 13400, 13401, 13416, 13391, 13392, 13397, 13320, 13342, 13367, 13368, 13386, 4927, 29460, 29462, 29463, 29464, 29465, 29466, 29467, 29468, 29471, 29472, 29473, 29474, 29475, 29476, 29477, 29478, 29479, 29480, 29481, 29493, 29494, 29495, 29496, 29497, 29508, 29509, 29510, 29511, 29512, 29513, 29514, 29515, 29516, 29517, 29518, 29519, 29520, 29521, 29522, 29523, 29524, 29525, 29526, 29527, 29529, 29530, 29531, 29532, 29533, 29534, 29535, 29536, 29537, 29538, 29539, 29540, 29541, 29542, 29543, 29544, 29545, 29546, 29547, 29552, 29553, 29562, 29563, 29564, 29565, 29566, 29567, 29568, 29569, 29570, 29571, 29572, 29574, 29575, 29576, 29577, 29578, 29579, 29580, 29581, 29582, 29583, 29584, 29585, 29586, 29587, 29588, 29589, 29590, 29591, 29592, 29604, 29605, 29613, 29614, 29615, 29617, 29630, 29637, 29638, 29639, 29644, 29647, 29648, 34756, 34757, 34758, 34759, 34760, 34761, 34762, 34763, 34764, 34765, 34766, 34767, 34768, 34769, 34770, 34771, 34772, 34773, 34774, 34775, 34776, 34777, 34778, 34779, 34780, 34782, 34783, 34784, 34785, 34786, 34787, 34788, 34789, 34790, 34791, 34792, 34796, 34797, 34798, 34799, 34800, 34801, 34802, 29596, 29597, 29598, 29599, 29619, 29486, 29640, 29506, 29507, 29629, 29485, 29484, 29595, 29626, 29627, 29628, 29483, 29594, 29482, 29593, 29625, 29492, 29646, 29624, 29491, 29645, 29490, 29623, 29489, 29622, 29643, 29600, 29487, 29488, 29642, 29620, 29641, 30198, 30196, 30265, 30185, 30193, 30262, 30192, 30239, 30190, 30258, 30268, 30135, 30199, 29616, 30270, 30994, 30995, 30996, 30993, 31173, 31010, 31011, 33436, 30547, 34303, 34304, 29551, 29550, 30168, 34803, 34804, 34805, 34806, 34807, 34808, 34809, 34810, 34811, 34812, 34813, 34814, 34815, 34816, 34817, 34818, 34819, 34820, 34821, 34822, 34823, 29631, 29632, 29606, 29573, 29634, 29633, 29635, 29636, 30546, 29556, 29559, 29557, 29558, 29561, 29560, 6534, 34793, 34794, 34795, 34302, 34305, 6695, 31292, 31293, 31294, 29549, 29548, 29470, 29528, 4926, 30250, 29502, 29503, 29504, 29505, 30187, 30188, 30194, 30195, 30197, 30264, 33783, 33784, 29607, 29608, 29609, 29610, 29611, 29612, 30558, 30559, 30560, 29498, 29499, 29501, 29500, 34781, 29621, 33782, 29554, 29555, 29428, 29429, 29430, 29601, 29602, 29603, 29187, 29188, 29189, 29190, 29191, 6533, 31014, 33223, 31018, 31017, 31015, 31016, 30257, 29469, 29461, 29618, 30269, 25911, 38710, 38711, 38712, 38713, 38714, 38715, 38716, 38717, 38718, 38719, 38720, 38721, 38722, 38724, 38725, 38726, 38727, 38728, 38729, 38730, 38731, 38732, 38733, 38734, 38735, 38736, 38737, 38738, 38739, 38740, 38741, 38742, 38743, 38744, 38746, 38747, 38749, 38750, 38751, 38753, 38754, 38756, 38757, 38758, 38760, 38761, 38762, 38763, 38764, 38765, 38766, 38767, 38768, 38769, 38770, 38771, 38772, 38773, 38774, 38775, 38776, 38777, 38778, 38779, 38780, 38781, 38782, 38783, 38784, 38785, 38786, 38790, 38791, 38792, 38793, 41722, 41723, 41724, 41725, 41726, 41727, 41728, 41729, 41736, 41737, 41738, 41739, 41740, 41741, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41756, 41757, 41758, 41759, 41760, 41761, 41762, 41763, 41764, 41765, 41766, 41767, 41768, 41769, 41770, 41771, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41779, 41780, 41781, 41782, 41783, 41784, 41785, 41786, 41787, 41788, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41806, 41808, 41809, 41810, 41811, 41812, 41813, 41814, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41822, 41823, 41824, 41825, 41826, 41827, 41828, 41829, 41830, 41831, 41832, 41833, 41834, 41835, 41836, 41837, 41838, 41839, 41840, 41841, 41842, 41843, 41844, 41845, 41846, 41847, 41848, 41849, 41850, 41851, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 41891, 41892, 41893, 41894, 41895, 41896, 41897, 41898, 41899, 41900, 41901, 41902, 41903, 41904, 41905, 41906, 41907, 41908, 41909, 41910, 41911, 41912, 41913, 41914, 41915, 41916, 41917, 41918, 41919, 41920, 41921, 41922, 41923, 41924, 41925, 41926, 41927, 41928, 41929, 41930, 41931, 41932, 41933, 41934, 41935, 41936, 41937, 41938, 41939, 41940, 41941, 41942, 41943, 41944, 41945, 41946, 41947, 41948, 41949, 41950, 41951, 41952, 41953, 41954, 41955, 41956, 41957, 41958, 41959, 41960, 41961, 41962, 41963, 41964, 41965, 41966, 41967, 41968, 41969, 41970, 41972, 41973, 41975, 41977, 41978, 41979, 41980, 41981, 41982, 41983, 41984, 41985, 41986, 41987, 41988, 41989, 41990, 41991, 41992, 41993, 41994, 41995, 41996, 41997, 41998, 41999, 42000, 42001, 42002, 42003, 39345, 39339, 39323, 41744, 41743, 41742, 41733, 36360, 36361, 36362, 36363, 34867, 34868, 44448, 44449, 44450, 44451, 44460, 44461, 44464, 44466, 44467, 44469, 44471, 44452, 35793, 44776, 41871, 41872, 41873, 41976, 39862, 38748, 38745, 44470, 38787, 38788, 38789, 44465, 44793, 6133, 6134, 6097, 6098, 29203, 29204, 29206, 29205, 38759, 36388, 41797, 41805, 41807, 41971, 41974, 44462, 38723, 44468, 44463, 38755, 38752, 6092, 6004, 48397, 48399, 48401, 48403, 48405, 48407, 48409, 48411, 48412, 48413, 48418, 48419, 48420, 48422, 48423, 48424, 48435, 48436, 48440, 48447, 48448, 48449, 48452, 48453, 48454, 48459, 48460, 48461, 48463, 48464, 48465, 48467, 48468, 48471, 48472, 48474, 48475, 48476, 48478, 48485, 48488, 48496, 48497, 48498, 48499, 48500, 48501, 48502, 48506, 48509, 48512, 48513, 48522, 48523, 48524, 48536, 48545, 48546, 48549, 48550, 48553, 48554, 48561, 48562, 48564, 48582, 48583, 48584, 48585, 48588, 48589, 48591, 48592, 48596, 48597, 48598, 48600, 48601, 48602, 48603, 48604, 48605, 48606, 48607, 48608, 48609, 48610, 48611, 48612, 48613, 48614, 48615, 48616, 48617, 53335, 53339, 53340, 53341, 53352, 53353, 53354, 53355, 53356, 53357, 53358, 53359, 53360, 53361, 53362, 53363, 53364, 53365, 53366, 53367, 53369, 53370, 53371, 53373, 53374, 53375, 53377, 53378, 53384, 53385, 53390, 53391, 53392, 53393, 53394, 53395, 53396, 53397, 53398, 53399, 53400, 53401, 53402, 53403, 53409, 53410, 53411, 53412, 53413, 53414, 53415, 52365, 52366, 52367, 52368, 52362, 52363, 52357, 52358, 53405, 52810, 48599, 53388, 53380, 53343, 53389, 53347, 53346, 53344, 53345, 53337, 53338, 53379, 53333, 53383, 53342, 53386, 53332, 53334, 50429, 50433, 53372, 53348, 53350, 53376, 53336, 53382, 53349, 48416, 48417, 52359, 52364, 52369, 52399, 48593, 48455, 48520, 48525, 48451, 48421, 48595, 48425, 48594, 48519, 48426, 48427, 48428, 48429, 48430, 48431, 48432, 48433, 48434, 48437, 48438, 48439, 48441, 48442, 48443, 48444, 48446, 48515, 48516, 48517, 48518, 48526, 48527, 48528, 48529, 48530, 48531, 48532, 48533, 48534, 48535, 48537, 48538, 48539, 48540, 48541, 48542, 48543, 48544, 48547, 48548, 48551, 48552, 48555, 48556, 48557, 48558, 48559, 48565, 48566, 48567, 48568, 48569, 48570, 48571, 48572, 48573, 48574, 48575, 48576, 48577, 48456, 48457, 48458, 48462, 48466, 48469, 48470, 48473, 48477, 48479, 48482, 48483, 48484, 48486, 48487, 48489, 48490, 48491, 48492, 48493, 48494, 48495, 48503, 48504, 48505, 48507, 48508, 48510, 48511, 48514, 48398, 48400, 48402, 48404, 48406, 48408, 48410, 48414, 48415, 48578, 48579, 48580, 48581, 48586, 48587, 48590, 53351, 13009, 13010, 6005, 36256, 36796, 36812, 36771, 29239, 29240, 29238, 38511, 38510, 36781, 36797, 38509, 38508, 36772, 36789, 53417, 53407, 53416, 53408, 53406, 52806, 13007, 13008, 38473, 52826, 53331, 38529, 38528, 36314, 36345, 48450, 48563, 48521, 6505, 53368, 44773, 44775, 36315, 38490, 36317, 48171, 48560, 58257, 36312, 53381, 53404, 34864, 53387, 35792, 60606, 60607, 60608, 60609, 60615, 60616, 60617, 60618, 60619, 60620, 60621, 60622, 60623, 60624, 60625, 60626, 60627, 60646, 60648, 60649, 60650, 60655, 60674, 60675, 60676, 60679, 60681, 60682, 60683, 60684, 60830, 60831, 60832, 60833, 60834, 60835, 60836, 60837, 60838, 60839, 60840, 60841, 60842, 60843, 60844, 60845, 60846, 60847, 60848, 60849, 60850, 60851, 60852, 60853, 60854, 60855, 60856, 60857, 60858, 60859, 60860, 60861, 60862, 60863, 60864, 60865, 60866, 60867, 60868, 60869, 60870, 60871, 60872, 60873, 60874, 60875, 60876, 60878, 60879, 60880, 60883, 60884, 60885, 60886, 60888, 60889, 60890, 60891, 60892, 60894, 60896, 60897, 60898, 60899, 60900, 60901, 60902, 60904, 60905, 60907, 60908, 60909, 60910, 60911, 60912, 60913, 60914, 60915, 60916, 60917, 60918, 60919, 60920, 60921, 60922, 60923, 60924, 60925, 60926, 60933, 60934, 60935, 60936, 60937, 60938, 60939, 60940, 60941, 60942, 60943, 60944, 60945, 60946, 60947, 60948, 60949, 60950, 60951, 60952, 60953, 60954, 60955, 60957, 60958, 60960, 60961, 60964, 60965, 60966, 60967, 60968, 60969, 60970, 60971, 60972, 60973, 60974, 60975, 60976, 60977, 60978, 60979, 60980, 60981, 60983, 60984, 60985, 60986, 60987, 60988, 60989, 60990, 60991, 60992, 60993, 60994, 60995, 60996, 60997, 60998, 60999, 61000, 61001, 61002, 61003, 61009, 61010, 61011, 61012, 61013, 61014, 61015, 61016, 61017, 61018, 61019, 61020, 61021, 61022, 61023, 61024, 61025, 61026, 61027, 61034, 61036, 61037, 61038, 61039, 61040, 61041, 61042, 61043, 61045, 61046, 61047, 61048, 61049, 61050, 61051, 61052, 61053, 61054, 61059, 61060, 61061, 61064, 61067, 61068, 61069, 61070, 61080, 61081, 61082, 61083, 61085, 61086, 61087, 61088, 61270, 61269, 61004, 61005, 61006, 61007, 61008, 60507, 60506, 60558, 60398, 60399, 60516, 60515, 60514, 60463, 60513, 60802, 61268, 63516, 63514, 63515, 63631, 63630, 63511, 63512, 63513, 60927, 60928, 60929, 60895, 61044, 36316, 45176, 45179, 54031, 54032, 54033, 54034, 54035, 36790, 29198, 29199, 25898, 25899, 38522, 38523, 38524, 38527, 38525, 60881, 60882, 60930, 60931, 60932, 60956, 60959, 60962, 60963, 60982, 60906, 60665, 60666, 60667, 60668, 60669, 60670, 60671, 60672, 60673, 60677, 60678, 60628, 60629, 60630, 60631, 60632, 60633, 60634, 60635, 60636, 60637, 60638, 60639, 60640, 60641, 60642, 60643, 60644, 60645, 60685, 60686, 60687, 60688, 60689, 60903, 60652, 60647, 60586, 60588, 60589, 60590, 60591, 60592, 60593, 60594, 60595, 60596, 60597, 60598, 60599, 60600, 60601, 60602, 60603, 60605, 61071, 61072, 61073, 61074, 61075, 61076, 61077, 61078, 61079, 60659, 60612, 60613, 60614, 61063, 35791, 61058, 61029, 61030, 38472, 60657, 60877, 60658, 60654, 60680, 61057, 36311, 61033, 60604, 60587, 60799, 60800, 60801, 60821, 60762, 60824, 60797, 60796, 60795, 60496, 61056, 44772, 61084, 6504, 60610, 61031, 60887, 60893, 60611, 60585, 60829, 61028, 61035, 35657, 60660, 60656, 61055, 65054, 38470, 44777, 60815, 36346, 61032, 36764, 36805, 36258, 36259, 36313, 61065, 61066, 60798, 60498, 60503, 65120, 44774, 60653, 65053, 65127, 61062, 58323, 58322, 58321, 58320, 38471, 48172, 60664, 60651, 64431, 64432, 64433, 64437, 65100, 65056, 6502, 66362, 66363, 66364, 66365, 66366, 66367, 66368, 66369, 66370, 66371, 66372, 66373, 66374, 66375, 66376, 66377, 66378, 66379, 66380, 66381, 66382, 66383, 66384, 66385, 66386, 66387, 66388, 66389, 66391, 66392, 66393, 66394, 66395, 66396, 66397, 66398, 66399, 66400, 66401, 66402, 66403, 66404, 66405, 66406, 66407, 66408, 66409, 66410, 66411, 66412, 66413, 66414, 66415, 66416, 66417, 66418, 66419, 66420, 66421, 66422, 66423, 66424, 66425, 66426, 66427, 66428, 66429, 66430, 66431, 66432, 66433, 66434, 66435, 66436, 66437, 66438, 66439, 66440, 66441, 66442, 66443, 66444, 66445, 66446, 66447, 66448, 66449, 66450, 66451, 66452, 66453, 66454, 66455, 66456, 66457, 66458, 66459, 66460, 66461, 66462, 66463, 66464, 66465, 66466, 66467, 66468, 66469, 66470, 66471, 66472, 66473, 66474, 66475, 66476, 66477, 66478, 66479, 66480, 66481, 66482, 66483, 66484, 66485, 66486, 66487, 66488, 66489, 66490, 66491, 66492, 66493, 66494, 66495, 66496, 66497, 66498, 66499, 66500, 66501, 66502, 66503, 66504, 66505, 66506, 66507, 66508, 66509, 66510, 66511, 66512, 66513, 66514, 66515, 66516, 66517, 66518, 66519, 66520, 66521, 66522, 66523, 66524, 66525, 66526, 66527, 66528, 66529, 66531, 66532, 66533, 66534, 66536, 66537, 66538, 66539, 69442, 69445, 69446, 69447, 69449, 69450, 69451, 69452, 69453, 69454, 69455, 69457, 69458, 69459, 69460, 69461, 69462, 69463, 69464, 69465, 69466, 69467, 69468, 69469, 69470, 69471, 69472, 69473, 69474, 69475, 69477, 69478, 69479, 69480, 69481, 69482, 69483, 69484, 69485, 69488, 69489, 69495, 69500, 69501, 69502, 69504, 69506, 69507, 69510, 69512, 69513, 69514, 69516, 69517, 69518, 69519, 69520, 69522, 69524, 69528, 69530, 69532, 69533, 69534, 69536, 69537, 69538, 69539, 69540, 69541, 69542, 69543, 69544, 69545, 69546, 69547, 69548, 69669, 69670, 69671, 69673, 69676, 69677, 69678, 69679, 69680, 69681, 69682, 69683, 69684, 69685, 69686, 69687, 69688, 69689, 69690, 69691, 69692, 69693, 69694, 69703, 69704, 69705, 69706, 69710, 69711, 69712, 69719, 69720, 69723, 69724, 69725, 69726, 69727, 69728, 69729, 69741, 69742, 69743, 69744, 69745, 69746, 69747, 69748, 69749, 69750, 69751, 69752, 69753, 69754, 69755, 69756, 69757, 69758, 69759, 69760, 69761, 69762, 69763, 69764, 69765, 69766, 69767, 69768, 69769, 69770, 69771, 69772, 69778, 69779, 69780, 69781, 69782, 69783, 69784, 69785, 69786, 69787, 69788, 69789, 69790, 69791, 69792, 69793, 69794, 69796, 69797, 69798, 69799, 69800, 69802, 69803, 69804, 69805, 69806, 69807, 69808, 69809, 69810, 69811, 69812, 69813, 69814, 69815, 69816, 69817, 69818, 69819, 69821, 69822, 69823, 69824, 69825, 69826, 69827, 69830, 69831, 69832, 69833, 69834, 69835, 69836, 69838, 69841, 69842, 69844, 69845, 69847, 69848, 69853, 69854, 69855, 69863, 69864, 69865, 69866, 69867, 69868, 69869, 69871, 69873, 69874, 69880, 69444, 69443, 72369, 72370, 72371, 69667, 69858, 69857, 69773, 69777, 69776, 69775, 69774, 69499, 69529, 38486, 36319, 69503, 29181, 64692, 64688, 64693, 69498, 69525, 69531, 34863, 65211, 65210, 69828, 69515, 69496, 65101, 65123, 69508, 74185, 69494, 69448, 71222, 69738, 69737, 69736, 69734, 71250, 71249, 71248, 71247, 72368, 72367, 72366, 72365, 72364, 72375, 72376, 72373, 72374, 72372, 72453, 69707, 69708, 69709, 72383, 72384, 72385, 69852, 69878, 69843, 69837, 69820, 69700, 70086, 70083, 70082, 70081, 70080, 70079, 70216, 69851, 69850, 69849, 71265, 71275, 69717, 69718, 69535, 6501, 73518, 6503, 69733, 69856, 69668, 35794, 65709, 65707, 65708, 66390, 73513, 69511, 69526, 44208, 45175, 65689, 65687, 65688, 45177, 69505, 69509, 64544, 64545, 75766, 75767, 75768, 75769, 75770, 75771, 75773, 75774, 75775, 75776, 75779, 75780, 75781, 75782, 75784, 75786, 75787, 75788, 75790, 75791, 75792, 75794, 75795, 75796, 75798, 75799, 75800, 75801, 75802, 75803, 75804, 75805, 75806, 75807, 75808, 75809, 75810, 75811, 75812, 75813, 75814, 75815, 75816, 76042, 76044, 76045, 76046, 76048, 76049, 76050, 76051, 76052, 76053, 76055, 76056, 76057, 76058, 76059, 76060, 76061, 76062, 76063, 76064, 76066, 76067, 76068, 76069, 76070, 76071, 76072, 76073, 76074, 76075, 76076, 76077, 76078, 76079, 76080, 76081, 76082, 76083, 76084, 76085, 76086, 76087, 76088, 76089, 76090, 76091, 76093, 76094, 76095, 76096, 76097, 76098, 76099, 76100, 76101, 76102, 76103, 76104, 76105, 76108, 76109, 76110, 76111, 76112, 76113, 76114, 76115, 76116, 76117, 76119, 76120, 76121, 76122, 76123, 76124, 76125, 76126, 76127, 76128, 76130, 76131, 76132, 76133, 76134, 76136, 76137, 76138, 76139, 76140, 76141, 76142, 76143, 76144, 76145, 76146, 76147, 77060, 77061, 77021, 77084, 76761, 75820, 75819, 75818, 75821, 48167, 77107, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77047, 77048, 77049, 77050, 77051, 77054, 77055, 77056, 77057, 77058, 77059, 77004, 77005, 77006, 77007, 77003, 77013, 77052, 77012, 77008, 77009, 77010, 77011, 65690, 65691, 65692, 64691, 64689, 64690, 73560, 45178, 45146, 77053, 73557, 58206, 65094, 71252, 71253, 71254, 48173, 58205, 66535, 74420, 48174, 45498, 75797, 71270, 71251, 35647, 44779, 45499, 69872, 65716, 65715, 44207, 73559, 73558, 29182, 73550, 74791, 78101, 78100, 78099, 78098, 78097, 78103, 78102, 77039, 69716, 69715, 69523, 34904, 73514, 65055, 77122, 75783, 77002, 76047, 69695, 69696, 69697, 69698, 69699, 75789, 76107, 78418, 78419, 78420, 78421, 78422, 78430, 78432, 78434, 78435, 78437, 78425, 78424, 78431, 78429, 78428, 78427, 78426, 78433, 78594, 78595, 78596, 79123, 70103, 79524, 79525, 79526, 79527, 79528, 79529, 79530, 79531, 79532, 79540, 79542, 79543, 79545, 79546, 79547, 79550, 79552, 79553, 79554, 79555, 79556, 79557, 79558, 79559, 79560, 79561, 79562, 79564, 79565, 79566, 79567, 79568, 79569, 79570, 79571, 79572, 79573, 79574, 79575, 79577, 79578, 79579, 79581, 79582, 79583, 79584, 79585, 79586, 79587, 79588, 79590, 79591, 79592, 79595, 79596, 79597, 79598, 79599, 79600, 79601, 79602, 79603, 79604, 79605, 79606, 79607, 79608, 79609, 79610, 79611, 79612, 79613, 79614, 79615, 79616, 79617, 79618, 79619, 79620, 79621, 79622, 79623, 79684, 79872, 80200, 80199, 80290, 80291, 80292, 79541, 79533, 79534, 79535, 79536, 79537, 79538, 79539, 75181, 76135, 75184, 75183, 69730, 69732, 69731, 69722, 69721, 69714, 69713, 80388, 80387, 76567, 76566, 76565, 76564, 73738, 69527, 73635, 73633, 73634, 64548, 64539, 64541, 35658, 35659, 77638, 77639, 58203, 73745, 73743, 74792, 74790, 58204, 75793, 69870, 69456, 65059, 35650, 73519, 65178, 73526, 65102, 69487, 78059, 78060, 78061, 73596, 64644, 65714, 78089, 78090, 73746, 81168, 81140, 81167, 75772, 65074, 64436, 77071, 64540, 82594, 82595, 82596, 82597, 82599, 82600, 82601, 82602, 82603, 82606, 82613, 82614, 82615, 82616, 82617, 82618, 82619, 82620, 82621, 82622, 82623, 82624, 82625, 82626, 82627, 82628, 82632, 82633, 82634, 82635, 82636, 82639, 82640, 82644, 82646, 82647, 82648, 82777, 82778, 82781, 82782, 82783, 82784, 82785, 82786, 82787, 82788, 82789, 82792, 82793, 82794, 82795, 82796, 82798, 82799, 82800, 82801, 82802, 81161, 76092, 79548, 76106, 75817, 81147, 81182, 81159, 82776, 82775, 83016, 83017, 83018, 83019, 83020, 83025, 82612, 82607, 82608, 82609, 82610, 82611, 69840, 69839, 44778, 81158, 76118, 65097, 81092, 81113, 69492, 69491, 69493, 83746, 83747, 78081, 25885, 64669, 81142, 81160, 69486, 71240, 71237, 71239, 71238, 69859, 69860, 69861, 69862, 82653, 82651, 82652, 82650, 82649, 78440, 69490, 77064, 82604, 82605, 82643, 82642, 82645, 82598, 82593, 82629, 82592, 82851, 79576, 69739, 76043, 69876, 69875, 69877, 81152, 82780, 83933, 78438, 77025, 81145, 65330, 81141, 83939, 81225, 81154, 83930, 83912, 65093, 77113, 80642, 83932, 83931, 84396, 65075, 81157, 81151, 83945, 81164, 81162, 81163, 65098, 80638, 69735, 76054, 79580, 79589, 69829, 79563, 79544, 82637, 82638, 77641, 77640, 64668, 78439, 82797, 81110, 77320, 77323, 77324, 77322, 77321, 78074, 78075, 78076, 83977, 73553, 73554, 65710, 65711, 65712, 80818, 80819, 12970, 64701, 64699, 64703, 64704, 64702, 64700, 64705, 64697, 64698, 81149, 84126, 84016, 85356, 65073, 65713, 85339, 77083, 82779, 74405, 85520, 84243, 84244, 84929, 81235, 73744, 25913, 25912, 69521, 84911, 85606, 85607, 85608, 85550, 85551, 85609, 85605, 85610, 76065, 81153, 84129, 84125, 79023, 79024, 79025, 78417, 65099, 86191, 86192, 86193, 86194, 86195, 86196, 86197, 86198, 86199, 86200, 86201, 86202, 86203, 86204, 86816, 86817, 86818, 86819, 86820, 86821, 86822, 86823, 86824, 86825, 84237, 5998, 86996, 86997, 86998, 87011, 87012, 81148, 84909, 87161, 87162, 87163, 87164, 87165, 87166, 87167, 87168, 87169, 87170, 87171, 87172, 87173, 87174, 64526, 65185, 85741, 87448, 78441, 69672, 85374, 85375, 85373, 84216, 77136, 83913, 81165, 65177, 64542, 77317, 77318, 84246, 85407, 65145, 85353, 85357, 85360, 85363, 84928, 85740, 6789, 12985, 87627, 84025, 84242, 80646, 64435, 85282, 87779, 87780, 85283, 85354, 58326, 38521, 81505, 77605, 81488, 81494, 87260, 87261, 84910, 83953, 87792, 83926, 86088, 86086, 85518, 85517, 81237, 77750, 88248, 88247, 88757, 88758, 88759, 88760, 88761, 88762, 88763, 88764, 88765, 88766, 88767, 88768, 88769, 88770, 88771, 88772, 88773, 88774, 88775, 88776, 88777, 88778, 88779, 88780, 88781, 88782, 88783, 88784, 88785, 88786, 88787, 88788, 88789, 88790, 88791, 88792, 88793, 88794, 88795, 88796, 88797, 88798, 88799, 88800, 88801, 88802, 88803, 88804, 88805, 88806, 88807, 88808, 88809, 88810, 88811, 88812, 88813, 88814, 88815, 88816, 88817, 88818, 88819, 88820, 88821, 88822, 88823, 88824, 88825, 88826, 88827, 88828, 88829, 88830, 88831, 88832, 88833, 88834, 88835, 88836, 88837, 88838, 88839, 88840, 88841, 88842, 88843, 88844, 88845, 88846, 88847, 88855, 88861, 88865, 88866, 88867, 88868, 88869, 88873, 88874, 88875, 88876, 88877, 88878, 88880, 88881, 88882, 88883, 88884, 88885, 88886, 88887, 88889, 88890, 88891, 88941, 88946, 88947, 88949, 88950, 88951, 88958, 88961, 88970, 88977, 88979, 88980, 88981, 88982, 88983, 88984, 88985, 88986, 88987, 88617, 88853, 88854, 88870, 88872, 89318, 88605, 88606, 88607, 88863, 88864, 88848, 82790, 82791, 87765, 87766, 87768, 87770, 87767, 64721, 64718, 64722, 64719, 64723, 64720, 64717, 64716, 64715, 64706, 64707, 64708, 64709, 64710, 64711, 64712, 64713, 64714, 79549, 69795, 69801, 79551, 88968, 88973, 88955, 88956, 88971, 86206, 86207, 86208, 88862, 88850, 78423, 88851, 88852, 69476, 88945, 88967, 88972, 88963, 88954, 88960, 88962, 66530, 69674, 88965, 88974, 88948, 88957, 88942, 88966, 88943, 69675, 79593, 88959, 88975, 88938, 88978, 88939, 69740, 88940, 88952, 88964, 88969, 88976, 88953, 87781, 6788, 73555, 73551, 85307, 85308, 58325, 6784, 12986, 65319, 65336, 83910, 90400, 90401, 77215, 77216, 78072, 78071, 88147, 84915, 84914, 90449, 81234, 85762, 85350, 85359, 84217, 82630, 82641, 82631, 75785, 69846, 87631, 78083, 90325, 88150, 90460, 81150, 85352, 65149, 86205, 85008, 85009, 91053, 91052, 91051, 78073, 29194, 78436, 81146, 64695, 64696, 73556, 85271, 78082, 91327, 85255, 85256, 91386, 91114, 91120, 91121, 91122, 91129, 74802, 74803, 6783, 88879, 88860, 85018, 90982, 90983, 90984, 90985, 90986, 84487, 84486, 84485, 84484, 88888, 90744, 90743, 90742, 90741, 90740, 90739, 90738, 88218, 88217, 88216, 90755, 90754, 81504, 81503, 90757, 90756, 81502, 81501, 90410, 90408, 90409, 77214, 77213, 87902, 87901, 87900, 87898, 87897, 87896, 87895, 64473, 64486, 80538, 64434, 88856, 88857, 88859, 88858, 91446, 91455, 91464, 91445, 91454, 91463, 91444, 91453, 91462, 91443, 91452, 91461, 91470, 91442, 91451, 91460, 91469, 91441, 91450, 91459, 91468, 91440, 91449, 91458, 91467, 91448, 91457, 91466, 91447, 91456, 91465, 64687, 88148, 91072, 88849, 86815, 64694, 29195, 74789, 29197, 87772, 87771, 87764, 73552, 87782, 29193, 91659, 91586, 91658, 91657, 86110, 91745, 92332, 92333, 92334, 92335, 92336, 92337, 92338, 92339, 92340, 92341, 92342, 92343, 92344, 92345, 92346, 92347, 92348, 92349, 92350, 92351, 92352, 92353, 92354, 92355, 92356, 92357, 92358, 92359, 92360, 92361, 92362, 92363, 92364, 92365, 92366, 92367, 92368, 92369, 92370, 92371, 92372, 92373, 92374, 92375, 92376, 92377, 92378, 92379, 92380, 92381, 92382, 92383, 92384, 92615, 92616, 92617, 92618, 92619, 92620, 92621, 92622, 92623, 92624, 92625, 92626, 92627, 92628, 92629, 92630, 92631, 92632, 92633, 92634, 92635, 92636, 92637, 92638, 92639, 92640, 92641, 92642, 92643, 92644, 92645, 92646, 92647, 92648, 92649, 92650, 92651, 92652, 92653, 92654, 92655, 92656, 92657, 92658, 92659, 92660, 92661, 92662, 92663, 92664, 92665, 92666, 92667, 92668, 92669, 92670, 92671, 92673, 92674, 92675, 92676, 92677, 92678, 88149, 88944, 87803, 87805, 90448, 93951, 93944, 93942, 93941, 93938, 29179, 29241, 29196, 77319, 83975, 83976, 78084, 78085, 88141, 88142, 29192, 85275, 85276, 85277, 12965, 78053, 78054, 81090, 84934, 85351, 85355, 85358, 87810, 87804, 87807, 87808, 85272, 85274, 85273, 87640, 91041, 88155, 90335, 93977, 93956, 88280, 88279, 88278, 88266, 87806, 65816, 85349, 94317, 94265, 94264, 94363, 94362, 94353, 94344, 94352, 94341, 94342, 73641, 90451, 90452, 94452, 94451, 94449, 94448, 94447, 94450, 94454, 94453, 81490, 81493, 81489, 81487, 81491, 83877, 83878, 81486, 81495, 81492, 81480, 81481, 81482, 84497, 94520, 94519, 94518, 94496, 94495, 94493, 94521, 77102, 84503, 65338, 65331, 90745, 90746, 84493, 84494, 84495, 73747, 85017, 85512, 85511, 94494, 84498, 85516, 91037, 84906, 93957, 87264, 94745, 94821, 94819, 94817, 94357, 94358, 94852, 94853, 94854, 94855, 94856, 88143, 94268, 90333, 93962, 93958, 84013, 90459, 95073, 95147, 95144, 95142, 95141, 95140, 95139, 95143, 91119, 94340, 94816, 73739, 57709, 35665, 57708, 77604, 85704, 91589, 91592, 91591, 91590, 81506, 84492, 95189, 91587, 91588, 94267, 92672, 38503, 77631, 77632, 95338, 81166, 90324, 84017, 90447, 95359, 95369, 95361, 93940, 73740, 95582, 95581, 95580, 95579, 95578, 95577, 95576, 95575, 95574, 95573, 95572, 95571, 95570, 95569, 95584, 95583, 91723, 91724, 91725, 91726, 94338, 94337, 88284, 95339, 73735, 73736, 73737, 73734, 84131, 84132, 93931, 57710, 95657, 95656, 94313, 38504, 44781, 95776, 95775, 95774, 95779, 95778, 95777, 90326, 87930, 94743, 81143, 81724, 86050, 81144, 95064, 94742, 95067, 95068, 85549, 95851, 95852, 95853, 95854, 95855, 95856, 95857, 95858, 95859, 95860, 95861, 95862, 95937, 95938, 95939, 95940, 95941, 95942, 95943, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 95954, 96568, 96569, 96570, 96571, 96572, 96573, 96574, 96575, 96576, 96577, 96578, 96579, 96580, 96581, 96582, 96583, 96584, 96585, 96586, 96587, 96588, 96659, 96660, 96661, 96662, 96663, 96664, 96665, 96666, 96667, 96668, 96669, 96670, 96671, 96672, 96673, 96674, 96675, 96676, 96677, 96678, 96679, 96680, 96681, 96682, 96683, 97370, 97369, 97382, 97368, 97367, 97362, 97360, 91067, 54069, 94269, 94270, 94275, 94276, 87783, 87785, 87786, 87784, 94335, 94336, 94343, 94312, 94314, 94315, 94316, 88151, 97629, 97628, 97627, 97626, 97606, 97605, 73741, 91489, 97727, 97726, 81499, 44780, 65362, 85708, 85707, 80647, 84245, 94747, 94746, 91328, 90469, 93976, 97796, 90334, 95534, 91039, 90453, 94744, 94601, 94600, 94602, 94604, 94603, 91384, 93943, 94351, 94355, 58225, 98124, 98122, 98121, 98138, 98174, 98137, 98136, 98135, 98147, 98146, 98127, 98126, 98125, 91632, 91631, 91633, 87891, 87890, 90713, 95358, 91505, 90988, 90989, 90991, 90990, 90987, 95130, 95131, 95132, 95133, 95134, 81478, 81479, 81477, 84499, 84500, 94512, 94511, 84496, 94635, 94636, 94638, 94639, 94640, 94637, 81498, 81500, 81496, 81497, 81485, 81483, 81484, 35651, 57706, 35652, 57707, 65329, 65337, 77637, 77636, 77634, 77635, 81508, 81507, 84504, 84502, 84505, 94510, 94509, 84501, 94629, 94630, 94631, 94632, 94633, 94634, 91656, 91655, 91654, 80742, 80743, 80744, 80745, 90751, 90753, 90752, 90750, 34865, 34866, 83754, 83755, 83756, 97393, 95604, 95605, 95607, 95606, 95608, 93978, 95360, 91337, 90450, 88144, 90462, 93961, 95379, 97364, 73742, 98440, 98429, 98428, 98438, 98427, 98437, 94815, 93928, 94354, 94822, 94823, 94825, 94824, 94356, 87451, 91746, 91747, 87819, 98449, 98448, 98447, 98446, 98445, 94606, 94605, 87639, 94748, 98624, 98623, 98622, 98625, 83789, 83787, 83788, 84489, 84488, 84490, 84491, 91515, 95417, 54029, 54030, 58324, 64686, 74787, 74788, 84117, 84120, 84119, 84118, 84112, 84113, 84114, 84115, 84116, 84130, 84121, 84122, 84123, 84124, 87899, 90731, 90403, 90732, 90730, 90404, 90402, 90733, 90736, 90405, 90735, 90737, 90734, 90407, 90406, 35635, 65318, 91385, 98642, 98643, 98644, 98645, 98646, 98785, 98786, 98787, 98788, 98789, 98790, 98791, 98792, 98793, 98794, 98795, 98796, 98797, 98798, 98799, 98800, 98801, 98802, 98803, 98804, 99384, 99385, 99386, 99387, 99388, 99389, 99390, 99391, 99392, 99393, 99394, 99395, 99396, 99397, 99412, 99413, 99414, 99415, 99416, 99417, 99418, 99419, 99420, 99421, 99422, 99423, 99424, 99425, 99426) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 24 | maybe slow |