| 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` <> 98437 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, 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, 29551, 29550, 30168, 29631, 29632, 29606, 29573, 29634, 29633, 29635, 29636, 29556, 29559, 29557, 29558, 29561, 29560, 6534, 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, 29621, 33782, 29554, 29555, 29428, 29429, 29430, 29601, 29602, 29603, 6533, 31014, 33223, 31018, 31017, 31015, 31016, 30257, 29469, 29461, 29618, 30269, 25911, 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, 41744, 41743, 41742, 41733, 36360, 36361, 36362, 36363, 34867, 34868, 44448, 44449, 44450, 44451, 44452, 41871, 41872, 41873, 41976, 39862, 44793, 6133, 6134, 6097, 6098, 29203, 29204, 29206, 29205, 36388, 41797, 41805, 41807, 41971, 41974, 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, 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, 52365, 52366, 52367, 52368, 52362, 52363, 52357, 52358, 49154, 48599, 53958, 53957, 53956, 53955, 53954, 53953, 53948, 53947, 53946, 53995, 53993, 53975, 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, 13009, 13010, 6005, 29239, 29240, 29238, 53924, 13007, 13008, 38473, 52826, 38529, 38528, 53875, 36314, 36345, 48450, 48563, 48521, 54070, 53969, 6505, 36315, 35535, 38490, 36317, 48560, 58257, 36312, 53847, 34864, 38502, 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, 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, 61270, 61269, 61004, 61005, 61006, 61007, 61008, 61268, 63516, 63514, 63515, 63631, 63630, 63511, 63512, 63513, 61340, 60927, 60928, 60929, 60895, 61044, 34922, 36316, 61218, 61177, 12997, 12998, 45176, 45179, 54031, 54032, 54033, 54034, 54035, 36790, 6792, 38522, 38523, 38524, 38527, 38525, 38500, 61187, 61213, 61107, 61108, 60881, 60882, 60930, 60931, 60932, 60956, 60959, 60962, 60963, 60982, 60906, 38501, 60903, 61071, 61072, 61073, 61074, 61075, 61076, 61077, 61078, 61079, 61063, 61104, 61058, 61029, 61030, 6793, 60877, 61186, 61217, 61196, 61057, 36311, 61232, 61033, 61056, 61197, 61204, 61084, 6504, 61209, 61200, 61031, 60887, 60893, 61109, 61028, 61167, 61035, 61224, 61208, 61055, 34926, 38470, 58216, 36346, 61032, 61168, 61133, 36258, 36259, 36313, 61065, 61066, 61180, 61135, 65161, 61165, 65169, 61172, 65122, 65127, 65160, 61062, 64429, 64431, 64432, 64433, 64437, 65100, 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, 67311, 67312, 67313, 67314, 67315, 67316, 67317, 67318, 67319, 67320, 67321, 67322, 67323, 67324, 67325, 67326, 67327, 67328, 67329, 67330, 67331, 67332, 67333, 67334, 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, 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, 69444, 69443, 72547, 72369, 72370, 72371, 69895, 69701, 70166, 69889, 69858, 69857, 69773, 69777, 69776, 69775, 69774, 69897, 69885, 69971, 38486, 36319, 69968, 69976, 69978, 34863, 65211, 65210, 69828, 34935, 65101, 65123, 65164, 69945, 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, 69907, 70699, 70700, 70701, 70702, 70163, 70164, 70695, 70696, 70697, 70698, 69700, 69966, 69956, 69946, 69937, 69936, 69935, 69080, 69086, 69896, 70086, 70083, 70082, 70081, 70080, 70079, 70216, 69851, 69850, 69849, 71265, 71275, 69717, 69718, 69908, 6501, 69980, 6503, 69733, 34924, 69856, 69893, 57712, 57713, 34918, 34927, 34917, 34925, 35794, 35494, 65284, 34931, 34929, 34919, 34921, 66390, 73513, 69990, 69993, 69991, 69963, 69962, 45175, 65689, 65687, 65688, 45177, 57711, 64544, 64545, 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, 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, 77084, 69882, 76761, 34916, 48167, 77107, 69702, 69904, 77004, 77005, 77006, 77007, 77003, 77013, 77012, 77008, 77009, 77010, 77011, 65690, 65691, 65692, 45178, 45146, 58206, 65094, 71252, 71253, 71254, 58217, 34923, 58205, 65162, 34934, 65159, 69948, 69941, 69977, 66535, 69967, 69975, 69973, 69974, 75214, 71270, 58218, 69881, 71251, 73503, 69890, 69888, 69872, 75232, 73597, 76386, 69716, 69715, 78142, 34904, 73514, 65167, 77122, 70198, 77002, 76047, 69695, 69696, 69697, 69698, 69699, 76107, 69911, 78594, 78595, 78596, 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, 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, 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, 79089, 79102, 36382, 73635, 73633, 73634, 64548, 64539, 64541, 65168, 77077, 58203, 58204, 69870, 64642, 78027, 73519, 74173, 65793, 74827, 74174, 74825, 65102, 69979, 73596, 64644, 57716, 76366, 68701, 78028, 78029, 81168, 81167, 78143, 65074, 77574, 64436, 79097, 65792, 77071, 73646, 64540, 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, 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, 81161, 76092, 79548, 76106, 81190, 81191, 81137, 83016, 83017, 83018, 83019, 83020, 83025, 82612, 82607, 82608, 82609, 82610, 82611, 82298, 69840, 69839, 79111, 82303, 82335, 76118, 65097, 81092, 81113, 83746, 83747, 25885, 64669, 77689, 81139, 81160, 34936, 71240, 71237, 71239, 71238, 69859, 69860, 69861, 69862, 82653, 82651, 82652, 82650, 82649, 77064, 82604, 82605, 82643, 82642, 82645, 82598, 82593, 82629, 82592, 82851, 79576, 69739, 76043, 69876, 69875, 69877, 65197, 65195, 65196, 83933, 69970, 82334, 35534, 83939, 81225, 83930, 83912, 65093, 77113, 80642, 83932, 83931, 84396, 65075, 83945, 81164, 81162, 81163, 81136, 65098, 79087, 69735, 76054, 79580, 79589, 69829, 79563, 79544, 82637, 82638, 83941, 64668, 81110, 77690, 64478, 77076, 84126, 84248, 84016, 85356, 65073, 77083, 77693, 77694, 77688, 77687, 74405, 74176, 85520, 84929, 85749, 25913, 25912, 69886, 69940, 75234, 82338, 82343, 82341, 82339, 79090, 69942, 75206, 69914, 82317, 84911, 69969, 85579, 85580, 85581, 82307, 65794, 84223, 86085, 86084, 76065, 84125, 65099, 86191, 86192, 86193, 86194, 86195, 86196, 86197, 86198, 86199, 86200, 86201, 86202, 86203, 86204, 5998, 86910, 86911, 86912, 86913, 86914, 86915, 86916, 86917, 86918, 86919, 86922, 86923, 86996, 86997, 86998, 87011, 87012, 84029, 84909, 87016, 87017, 87018, 87019, 87020, 87161, 87162, 87163, 87164, 87165, 87166, 87167, 87168, 87169, 87170, 87171, 87172, 87173, 87174, 77692, 77691, 64526, 87448, 69672, 85374, 85375, 85373, 84216, 83913, 81165, 64542, 85397, 85407, 65145, 65150, 77568, 77749, 77571, 85353, 85357, 85360, 85363, 84928, 87627, 80646, 64435, 85354, 77605, 77078, 88277, 85533, 84910, 83953, 87792, 83926, 86088, 86086, 81237, 77750, 84959, 74175, 77570, 77567, 88248, 88247, 88618, 88619, 88635, 88941, 88946, 88947, 88949, 88950, 88951, 88958, 88961, 88970, 88977, 88979, 88980, 88981, 88982, 88983, 88984, 88985, 88986, 88987, 88484, 88623, 88636, 88634, 88633, 88632, 88630, 88629, 88628, 88627, 88626, 88625, 88624, 88622, 88621, 88620, 88617, 89171, 89187, 89318, 89766, 88604, 88605, 88606, 88607, 88608, 88609, 88610, 88611, 88612, 88613, 88614, 88615, 79549, 69795, 69801, 79551, 88968, 88973, 88955, 88956, 88971, 86206, 86207, 86208, 88482, 88481, 69919, 69918, 79073, 79074, 69933, 75207, 69943, 75211, 69033, 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, 70165, 88637, 88480, 88483, 88616, 85307, 85308, 64643, 83910, 86054, 88147, 84915, 90449, 85350, 85359, 84217, 77573, 82630, 82641, 82631, 69846, 84028, 84920, 90325, 88150, 85352, 65149, 86205, 85008, 85009, 85271, 88631, 91401, 91120, 91121, 91122, 91129, 74802, 74803, 85018, 83752, 85718, 85717, 77698, 77697, 91008, 91007, 85712, 85711, 64473, 64486, 80539, 80540, 80538, 64430, 85445, 64434, 88148, 91072, 84284, 84285, 86921, 86920, 91484, 91586, 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, 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, 93938, 65163, 65795, 74409, 77108, 81096, 81097, 84224, 84934, 85351, 85358, 86101, 91721, 91722, 85272, 85274, 85273, 87640, 91041, 81138, 93956, 88266, 85349, 94265, 94264, 94344, 94366, 94341, 94365, 94342, 73641, 90451, 90452, 83877, 83878, 77102, 94561, 94560, 87302, 85017, 85512, 85511, 91037, 93957, 90454, 90327, 87264, 68510, 94727, 94728, 94726, 94725, 94760, 94819, 94817, 90333, 93962, 83938, 93958, 91119, 94340, 94816, 77604, 91589, 91592, 91591, 91590, 85715, 85716, 87375, 87374, 95187, 95189, 91587, 91588, 92672, 77075, 81166, 90324, 91316, 91315, 84017, 90447, 95359, 95369, 95368, 95367, 95361, 91890, 95186, 93931, 95776, 95775, 95774, 95785, 95779, 95778, 95777, 90326, 87930, 94743, 95064, 94742, 95067, 95068, 93973, 93974, 93975, 90455, 95795, 95796, 95797, 95798, 95799, 95937, 95938, 95939, 95940, 95941, 95942, 95943, 95944, 95945, 95946, 95947, 95948, 95949, 95950, 95951, 95952, 95953, 95954, 96440, 96441, 96442, 96443, 96444, 96445, 96446, 96447, 96448, 96449, 96450, 96451, 96452, 96453, 96454, 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, 97369, 97382, 97368, 97367, 97366, 97362, 97375, 97360, 91067, 94343, 88151, 91489, 97727, 97726, 85714, 85713, 85708, 85707, 80647, 93976, 97796, 97799, 95534, 91039, 90453, 94744, 94601, 94600, 94602, 94604, 94603, 81236, 84958, 84956, 77569, 94351, 98124, 98122, 98121, 98138, 98137, 98118, 98136, 98117, 98135, 98186, 98147, 98146, 98127, 98126, 98125, 91632, 91631, 91633, 87891, 87890, 35555, 35556, 35536, 35537, 57714, 57715, 77696, 77695, 85214, 85215, 90751, 90753, 90752, 90750, 34865, 34866, 83754, 83755, 83756, 95360, 91337, 90450, 90462, 93961, 95379, 98440, 98437, 94815, 93928, 87819, 94367, 87814, 88258, 85519, 94606, 94605, 87639, 94770, 98624, 98623, 98622, 98625, 91515, 81721, 94562, 84117, 84120, 84119, 84118, 84112, 84113, 84114, 84115, 84116, 84121, 84122, 84123, 84124, 98642, 98643, 98644, 98645, 98646, 98679, 98680, 98681, 98682, 98683, 98684, 98685, 98686, 98687, 99279, 99280, 99281, 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 | 18 | maybe slow |
![ノベルティ：[アウトドア/レジャー] キャンプス クラシカルCOBランタンライト のサンプルを請求する](/img/bt_mail.jpg){kind=small}
