| 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` <> 81150 AND `Item`.`id` IN (5648, 5649, 5197, 11899, 11900, 11901, 11902, 11903, 11904, 11905, 11906, 11907, 11908, 11909, 11910, 11911, 11912, 11913, 11914, 11915, 11916, 11917, 11918, 11919, 11920, 11921, 11922, 11923, 11924, 11925, 11926, 11927, 11928, 11930, 11942, 11943, 11944, 11945, 11946, 11947, 11948, 11949, 11950, 11951, 11952, 11953, 11954, 11955, 11956, 11957, 11958, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 11974, 11975, 11976, 11977, 11978, 11979, 11980, 11981, 11982, 11983, 11984, 11985, 11986, 11987, 11988, 11989, 11990, 11991, 11992, 11993, 11994, 11995, 11996, 11997, 11998, 11999, 12000, 12001, 12002, 12003, 12004, 12005, 12006, 12007, 12008, 12009, 12010, 12011, 12012, 12013, 12014, 12015, 12016, 12017, 12018, 12019, 12020, 12021, 12022, 12023, 12024, 12025, 12026, 12027, 12028, 12029, 12030, 12031, 12032, 12033, 12034, 12035, 12036, 12037, 12038, 12039, 12040, 12041, 12042, 12043, 12044, 12045, 12046, 12047, 12048, 12049, 12050, 12051, 12052, 12053, 12054, 12055, 12056, 12057, 12058, 12059, 12060, 12061, 12062, 12063, 12066, 12095, 12114, 12122, 12123, 12124, 12125, 12126, 12127, 12128, 12129, 12130, 12131, 12132, 12133, 12134, 12135, 12136, 12137, 12138, 12139, 12140, 12141, 12142, 12143, 12145, 12149, 12150, 12151, 12152, 12153, 12154, 12155, 12156, 12157, 12158, 12159, 12160, 12161, 12162, 12163, 12164, 12165, 12166, 12167, 12168, 12169, 12170, 12171, 12172, 12173, 12180, 12181, 12182, 12183, 12184, 12185, 12186, 12187, 12188, 12189, 12190, 12191, 12192, 12193, 12194, 12195, 12196, 12197, 12198, 12199, 12200, 12201, 12202, 12203, 12204, 12205, 12206, 12207, 12208, 12209, 12210, 12211, 12212, 12213, 12214, 12215, 12216, 12217, 12218, 12219, 12220, 12221, 12222, 12223, 12224, 12225, 12226, 12227, 12228, 12229, 12230, 12231, 12232, 12233, 12234, 12235, 12236, 12237, 12238, 12239, 12240, 12241, 12242, 12243, 12244, 12245, 12246, 12247, 12248, 12249, 12250, 12251, 12252, 12253, 12254, 12255, 12256, 12257, 12258, 12259, 12260, 12261, 12262, 12263, 12264, 12265, 12266, 12267, 12268, 12269, 12270, 12271, 12272, 12273, 12274, 12275, 12276, 12277, 12278, 12279, 12280, 12281, 12282, 12283, 12284, 12285, 12286, 12287, 12288, 12289, 12290, 12291, 12292, 12293, 12294, 12295, 12296, 12297, 12298, 12299, 12300, 12301, 12302, 12303, 12304, 12305, 12306, 12307, 12308, 12309, 12310, 12311, 12312, 12313, 12314, 12315, 12316, 12317, 12318, 12319, 12320, 12321, 12322, 12324, 12325, 12326, 12329, 12331, 12332, 12333, 12334, 12335, 12336, 12337, 12338, 12339, 12340, 12341, 12342, 12343, 12344, 12345, 12346, 12347, 12350, 12351, 12352, 12353, 12354, 12355, 12356, 12357, 12358, 12359, 12360, 12361, 12362, 12363, 12365, 12366, 12367, 12368, 12369, 12370, 6524, 6521, 6509, 6531, 6530, 6529, 6528, 6527, 6526, 6525, 6523, 6522, 12468, 12469, 12472, 12464, 12467, 12470, 12473, 12465, 12463, 12471, 12474, 12466, 12364, 18352, 18353, 18354, 18355, 18356, 18357, 18358, 18359, 18360, 18361, 18362, 18363, 18364, 18365, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18378, 18379, 18380, 18381, 18382, 18383, 18384, 18385, 18386, 18387, 18388, 18389, 18390, 18391, 18392, 18393, 18394, 18395, 18396, 18397, 18398, 18399, 18400, 18401, 18402, 18403, 18404, 18405, 18406, 18407, 18408, 18409, 18410, 18411, 18412, 18413, 18414, 18415, 18416, 18417, 18418, 18419, 18420, 18421, 18422, 18423, 18424, 18425, 18426, 18427, 18428, 18429, 18430, 18431, 18432, 18433, 18434, 18435, 18436, 18437, 18438, 18439, 18440, 18441, 18442, 18443, 18444, 18445, 18446, 18447, 18448, 18449, 18450, 18451, 18452, 18453, 18454, 18455, 18456, 18457, 18458, 18459, 18460, 18461, 18462, 18463, 18464, 18465, 18466, 18467, 18468, 18469, 18470, 18471, 18472, 18473, 18474, 18475, 18476, 18477, 18478, 18479, 18480, 18482, 18483, 18484, 18485, 18486, 18487, 18488, 18489, 18490, 18491, 18492, 18493, 18494, 18495, 18496, 18497, 18498, 18501, 18502, 18503, 18504, 18505, 18506, 18507, 18508, 18509, 18510, 18511, 18512, 18513, 18514, 18515, 18516, 18517, 18518, 18519, 18520, 18521, 18523, 18524, 18525, 18526, 18527, 18528, 18529, 18530, 18531, 18532, 18533, 18534, 18535, 18536, 18537, 18538, 18539, 18540, 18541, 18542, 18543, 18544, 18545, 18546, 18547, 18548, 18549, 18550, 18551, 18552, 18553, 18554, 18555, 18556, 18557, 18558, 18559, 18560, 18561, 18562, 18563, 18564, 18565, 18566, 18567, 18568, 18569, 18570, 18571, 18572, 18573, 18574, 18575, 18576, 18577, 18578, 18579, 18580, 18581, 18582, 18583, 18584, 18585, 18586, 18587, 18588, 18589, 18590, 18591, 18592, 18593, 18594, 18595, 18596, 18597, 18598, 18599, 18600, 18602, 18603, 18604, 18605, 18606, 18607, 18608, 18609, 18610, 18611, 18612, 18613, 18614, 18615, 18616, 18617, 18618, 18619, 18620, 18621, 18622, 18623, 18624, 18625, 18626, 18627, 18628, 18629, 18630, 18631, 18632, 18633, 18634, 18635, 18636, 18637, 18638, 18639, 18640, 18641, 18642, 18643, 18644, 18645, 18646, 18647, 18648, 18649, 18650, 18651, 18652, 18653, 18654, 18655, 18656, 18657, 18658, 18659, 18660, 18661, 18662, 18663, 18664, 18665, 18666, 18667, 18668, 18669, 18670, 18671, 18672, 18673, 18674, 18675, 18676, 18677, 18678, 18679, 18680, 18681, 18682, 18683, 18684, 18685, 18686, 18687, 18688, 18689, 18690, 18691, 18692, 18693, 18694, 18695, 18696, 18697, 18698, 18699, 18700, 18701, 18702, 18703, 18704, 18705, 18706, 18707, 18708, 18709, 18710, 18711, 18712, 18713, 18714, 18715, 18716, 18717, 18718, 18719, 18720, 18721, 18722, 18723, 18724, 18725, 18726, 18727, 18728, 18729, 18730, 18731, 18732, 18733, 18734, 18735, 18736, 18737, 18738, 18739, 18740, 18741, 18742, 18743, 18744, 18745, 18746, 18747, 18748, 18749, 18750, 18751, 18752, 18753, 18754, 18755, 18756, 18757, 18759, 18760, 18761, 18762, 18763, 18766, 18767, 18768, 18769, 18770, 18771, 18772, 18773, 18774, 18775, 18776, 18777, 18778, 18779, 18780, 18781, 18782, 18783, 18784, 18785, 18786, 18787, 18788, 18789, 18790, 18791, 18792, 18793, 18794, 18795, 18796, 18797, 18798, 18799, 18800, 18801, 18802, 18803, 18804, 18805, 18806, 18807, 18808, 18809, 18810, 18811, 18812, 18813, 18814, 18815, 18816, 18817, 18818, 18819, 18820, 18821, 18822, 18823, 18366, 18367, 18368, 18369, 18377, 15345, 15284, 15653, 15346, 15343, 15344, 14237, 14235, 14330, 14307, 14323, 14259, 14238, 14239, 14240, 14316, 14324, 14614, 14621, 14612, 14613, 14622, 18758, 16821, 16751, 16815, 16814, 16820, 13131, 16755, 16819, 13130, 16754, 16818, 16753, 16817, 16816, 16752, 16970, 18499, 18481, 18500, 18601, 18764, 18765, 18522, 34236, 34237, 34238, 34245, 34246, 34247, 34248, 34250, 34252, 34253, 34254, 34259, 34260, 34261, 34262, 34263, 34267, 34268, 34269, 34274, 34275, 34276, 34277, 34278, 34279, 34280, 34281, 34282, 34283, 34284, 34285, 34286, 34287, 34288, 34289, 34290, 34291, 34292, 34293, 34294, 34295, 34296, 34297, 34298, 34299, 34300, 34301, 34306, 34307, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34318, 34319, 34320, 34321, 34322, 34323, 34325, 34329, 34330, 34331, 34332, 34333, 34334, 34335, 34336, 34337, 34338, 34339, 34340, 34341, 34342, 34343, 34344, 34345, 34346, 34353, 34354, 34355, 34356, 34357, 34358, 34362, 34363, 34364, 34365, 34366, 34367, 34368, 34369, 34370, 34371, 34372, 34373, 34374, 34375, 34376, 34377, 34378, 34379, 34380, 34390, 34393, 34411, 34412, 34413, 34414, 34415, 34416, 34417, 34418, 34419, 34420, 34421, 34422, 34423, 34424, 34425, 34426, 34427, 34428, 34429, 34430, 34431, 34432, 34433, 34434, 34435, 34436, 34437, 34438, 34439, 34440, 34441, 34442, 34443, 34444, 34445, 34446, 34447, 34448, 34449, 34450, 34451, 34452, 34453, 34454, 34455, 34456, 34457, 34458, 34459, 34460, 34461, 34462, 34463, 34464, 34465, 34467, 34468, 34469, 34470, 34471, 34472, 34473, 34474, 34475, 34476, 34477, 34478, 34479, 34480, 34481, 34482, 34484, 34485, 34486, 34487, 34488, 34489, 34490, 34491, 34492, 34493, 34494, 34495, 34496, 34497, 34498, 34499, 34500, 34501, 34502, 34503, 34504, 34505, 34506, 34507, 34508, 34509, 34510, 34511, 34512, 34513, 34514, 34515, 34516, 34517, 34518, 34519, 34520, 34521, 34522, 34523, 34524, 34525, 34526, 34527, 34528, 34529, 34530, 34531, 34532, 34533, 34534, 34535, 34536, 34537, 34538, 34539, 34540, 34541, 34542, 34543, 34544, 34545, 34546, 34547, 34548, 34549, 34550, 34551, 34552, 34553, 34554, 34555, 34556, 34557, 34558, 34559, 34560, 34561, 34562, 34563, 34566, 34567, 34568, 34569, 34571, 34573, 34574, 34575, 34576, 34577, 34578, 34579, 34580, 34581, 34582, 34583, 34584, 34585, 34586, 34587, 34588, 34589, 34590, 34591, 34592, 34593, 34594, 34595, 34596, 34597, 34598, 34599, 34600, 34601, 34602, 34603, 34604, 34605, 34606, 34608, 34609, 34610, 34611, 34612, 34613, 34614, 34615, 34616, 34617, 34618, 34619, 34620, 34621, 34622, 34623, 34624, 34625, 34627, 34628, 34629, 34630, 34631, 34632, 34633, 34634, 34635, 34636, 34637, 34638, 34639, 34640, 34641, 34642, 34643, 34644, 34645, 34646, 34647, 34648, 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, 34327, 34328, 30547, 34303, 34304, 32875, 32873, 32874, 32876, 4896, 5134, 4950, 4897, 4898, 5687, 5688, 5689, 5690, 34565, 34564, 34626, 34483, 34264, 34265, 34266, 34803, 34804, 34805, 34806, 34807, 34808, 34809, 34810, 34811, 34812, 34813, 34814, 34815, 34816, 34817, 34818, 34819, 34820, 34821, 34822, 34823, 30546, 34324, 32762, 34793, 34794, 34795, 34302, 34305, 6695, 31292, 31293, 31294, 29528, 34326, 34348, 34349, 34347, 34361, 34653, 34654, 34652, 34651, 34650, 34649, 34781, 34270, 34272, 34273, 34350, 34351, 29187, 29188, 29189, 29190, 29191, 34271, 34466, 34572, 34607, 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, 43160, 43161, 43162, 43163, 43164, 43165, 43166, 43167, 43168, 43169, 43170, 43171, 43172, 43173, 43174, 43175, 43176, 43177, 43178, 43179, 43180, 43181, 43182, 43183, 43184, 43185, 43186, 43187, 43188, 43189, 43190, 43191, 43192, 43194, 43195, 43196, 43197, 43198, 43199, 43200, 43201, 43202, 43204, 43205, 43206, 43207, 43208, 43209, 43210, 43211, 43212, 43213, 43214, 43215, 43216, 43217, 43218, 43219, 43220, 43221, 43224, 43225, 43226, 43227, 43228, 43229, 43230, 43231, 43232, 43233, 43234, 43235, 43236, 43237, 43238, 43239, 43240, 43241, 43242, 43243, 43244, 43245, 43246, 43247, 43248, 43249, 43250, 43251, 43252, 43253, 43254, 43255, 43256, 43257, 43258, 43259, 43260, 43261, 43262, 43263, 43264, 43265, 43266, 43267, 43268, 43269, 43270, 43271, 43272, 43273, 43274, 43275, 43276, 43277, 43278, 43279, 43280, 43281, 43282, 43283, 43284, 43285, 43286, 43287, 43288, 43289, 43290, 43291, 43292, 43293, 43294, 43295, 43296, 43297, 43298, 43299, 43300, 43301, 43302, 43303, 43304, 43305, 43306, 43307, 43308, 43309, 43310, 43311, 43312, 43313, 43314, 43315, 43316, 43317, 43318, 43319, 43320, 43321, 43322, 43323, 43324, 43325, 43326, 43327, 43328, 43329, 43330, 43331, 43333, 43334, 43335, 43336, 43337, 43338, 43339, 43340, 43341, 43343, 43344, 43345, 43346, 43347, 43348, 43349, 43350, 43351, 43352, 43354, 43355, 43356, 43357, 43358, 43359, 43360, 43361, 43362, 43363, 43364, 43365, 43366, 43367, 43368, 43369, 43370, 43371, 43372, 43373, 43374, 43375, 43376, 43377, 43378, 43379, 43380, 43381, 43382, 43383, 43384, 43385, 43386, 43387, 43388, 43389, 43390, 43391, 43392, 43393, 43394, 43395, 43396, 43397, 43398, 43399, 43400, 43401, 43402, 43403, 43404, 43405, 43406, 43407, 43408, 43409, 43410, 43411, 43412, 43413, 43414, 43415, 43416, 43417, 43418, 43419, 43420, 43421, 43422, 43105, 43104, 43103, 43102, 43101, 42989, 42988, 42987, 42986, 42985, 42984, 42983, 42982, 42981, 42980, 42978, 42977, 42975, 43137, 43106, 39345, 39339, 39323, 42589, 42590, 42591, 42592, 44270, 44271, 44272, 44273, 44274, 44460, 44461, 44464, 44466, 44467, 44469, 44471, 35793, 44776, 43332, 43342, 43223, 38748, 43353, 38745, 44470, 38787, 38788, 38789, 43193, 43203, 42976, 43222, 44465, 29206, 35682, 35681, 38759, 44462, 38723, 44468, 44463, 38755, 38752, 52877, 52878, 52879, 52880, 52881, 52882, 52883, 52884, 52885, 52886, 52887, 52888, 52889, 52890, 52891, 52892, 52893, 52894, 52895, 52896, 52897, 52898, 52899, 52900, 52901, 52902, 52903, 52904, 52905, 52906, 52907, 52908, 52909, 52910, 52911, 52912, 52913, 52914, 52915, 52916, 52917, 52918, 52919, 52920, 52921, 52922, 52923, 52924, 52925, 52926, 52927, 52928, 52929, 52930, 52931, 52932, 52933, 52934, 52951, 52952, 52953, 52954, 52955, 52956, 52957, 52958, 52959, 52960, 52961, 52962, 52963, 52964, 52965, 52966, 52967, 52968, 52969, 52970, 52971, 52972, 52973, 52974, 52975, 52976, 52977, 52978, 52979, 52980, 52981, 52982, 52983, 52984, 52985, 52986, 52987, 52988, 52989, 52990, 52991, 52992, 52993, 52994, 52995, 52996, 52997, 52998, 52999, 53000, 53001, 53002, 53003, 53004, 53005, 53006, 53007, 53008, 53009, 53010, 53011, 53012, 53013, 53014, 53015, 53016, 53017, 53018, 53019, 53020, 53021, 53022, 53023, 53024, 53025, 53026, 53027, 53028, 53029, 53030, 53031, 53032, 53033, 53034, 53035, 53036, 53037, 53038, 53039, 53040, 53041, 53042, 53043, 53044, 53045, 53046, 53047, 53048, 53049, 53050, 53051, 53052, 53053, 53054, 53055, 53056, 53057, 53058, 53059, 53060, 53061, 53062, 53063, 53064, 53065, 53066, 53067, 53068, 53069, 53070, 53071, 53072, 53073, 53074, 53075, 53076, 53077, 53078, 53079, 53080, 53081, 53082, 53083, 53084, 53085, 53086, 53087, 53088, 53089, 53090, 53091, 53092, 53093, 53094, 53095, 53096, 53097, 53098, 53099, 53100, 53101, 53102, 53103, 53104, 53105, 53106, 53107, 53108, 53109, 53110, 53111, 53112, 53113, 53114, 53115, 53116, 53117, 53118, 53119, 53120, 53121, 53122, 53123, 53124, 53125, 53126, 53127, 53128, 53129, 53130, 53131, 53132, 53133, 53134, 53135, 53136, 53137, 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, 53583, 52939, 48365, 48366, 53405, 52810, 48361, 48367, 48362, 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, 53351, 48368, 36256, 36796, 36812, 36771, 38511, 38510, 36781, 36797, 38509, 38508, 36772, 36789, 48481, 48480, 53417, 53407, 53416, 53408, 53406, 52806, 53331, 35683, 53368, 44773, 44775, 48171, 53785, 53381, 53404, 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, 62758, 62759, 62760, 62761, 62762, 62763, 62764, 62765, 62766, 62767, 62768, 62769, 62770, 62771, 62772, 62773, 62774, 62775, 62776, 62777, 62778, 62779, 62780, 62781, 62782, 62783, 62784, 62785, 62786, 62787, 62788, 62789, 62790, 62791, 62792, 62793, 62794, 62795, 62796, 62797, 62798, 62799, 62800, 62804, 62805, 62806, 62807, 62808, 62809, 62810, 62811, 62812, 62813, 62814, 62815, 62816, 62817, 62818, 62819, 62820, 62821, 62822, 62823, 62824, 62825, 62826, 62827, 62828, 62829, 62830, 62831, 62832, 62833, 62834, 62835, 62836, 62837, 62838, 62839, 62840, 62841, 62842, 62843, 62844, 62845, 62846, 62847, 62848, 62849, 62850, 62851, 62852, 62853, 62854, 62855, 62856, 62857, 62858, 62859, 62860, 62861, 62862, 62863, 62864, 62865, 62866, 62867, 62868, 62869, 62870, 62871, 62873, 62874, 62875, 62877, 62878, 62879, 62880, 62881, 62882, 62883, 62884, 62885, 62886, 62887, 62888, 62892, 62913, 62915, 62916, 62917, 62928, 62929, 62930, 62933, 62934, 62935, 62936, 62937, 62938, 62939, 62940, 62942, 62943, 62944, 62945, 62946, 62947, 62948, 62949, 62950, 62951, 62952, 62953, 62959, 62961, 62962, 62963, 62964, 62965, 62966, 62967, 62968, 62969, 62970, 62971, 62972, 62973, 62974, 62975, 62976, 62977, 62978, 62980, 62981, 62982, 62983, 62984, 62985, 62986, 62989, 62990, 62991, 62992, 62993, 62994, 62995, 62996, 62997, 62998, 62999, 63000, 63006, 63007, 63008, 63009, 63010, 63011, 63012, 63013, 63014, 63015, 63016, 63017, 60511, 60507, 60506, 60558, 60398, 60399, 60516, 60515, 60514, 60463, 60513, 60802, 59888, 59886, 59885, 59884, 59883, 59882, 59881, 59880, 59879, 59878, 60927, 60928, 60929, 59827, 59826, 62801, 62802, 62803, 62979, 29198, 29199, 25898, 25899, 62876, 63517, 59871, 59872, 59873, 59874, 59875, 59876, 59877, 59829, 59830, 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, 62899, 62900, 62901, 62902, 62903, 62904, 62905, 62906, 62907, 62908, 62909, 63001, 63003, 63004, 63005, 62911, 59191, 59192, 59193, 62895, 62896, 62897, 62898, 62872, 60652, 60647, 62960, 60586, 60588, 60589, 60590, 60591, 60592, 60593, 60594, 60595, 60596, 60597, 60598, 60599, 60600, 60601, 60602, 60603, 60605, 60659, 60612, 60613, 60614, 62893, 35791, 59887, 38472, 60657, 60658, 60654, 60680, 35689, 60604, 60587, 60799, 60800, 60801, 60821, 60762, 60824, 60797, 60796, 60795, 60496, 44772, 60610, 60611, 60585, 60829, 35657, 60660, 60656, 65054, 62891, 44777, 63002, 60815, 62889, 36764, 36805, 60798, 60498, 62923, 62894, 62890, 60503, 65120, 44774, 60653, 65053, 58323, 58322, 58321, 58320, 38471, 48172, 60664, 60651, 65056, 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, 71758, 71759, 71776, 71781, 71783, 71784, 71785, 71786, 71787, 71788, 71789, 71790, 71791, 71793, 71794, 71795, 71797, 71798, 71799, 71800, 71808, 71809, 71810, 71811, 71812, 71816, 71817, 71818, 71819, 71821, 71822, 71829, 71830, 71831, 71832, 71833, 71834, 71835, 71836, 71837, 71838, 71839, 71840, 71841, 71842, 71843, 71844, 71845, 71846, 71847, 71848, 71849, 71850, 71851, 71852, 71853, 71854, 71855, 71856, 71857, 71858, 71859, 71860, 71861, 71862, 71863, 71864, 71865, 71866, 71867, 71868, 71869, 71870, 71871, 71872, 71873, 71874, 71875, 71876, 71877, 71878, 71879, 71880, 71881, 71882, 71883, 71884, 71885, 71886, 71887, 71888, 71889, 71890, 71895, 71896, 71897, 71899, 71900, 71901, 71902, 71903, 71904, 71905, 71906, 71907, 71908, 71909, 71910, 71911, 71912, 71913, 71914, 71917, 71918, 71919, 71932, 71933, 71935, 71936, 71937, 71938, 71939, 71940, 71941, 71942, 71943, 71945, 71946, 71948, 71952, 71953, 71954, 71955, 71956, 71957, 71958, 71959, 71960, 71961, 71962, 71964, 71965, 71966, 71967, 71971, 71972, 71973, 71974, 71975, 71976, 71977, 71978, 71981, 71982, 71983, 71984, 71985, 71986, 71987, 71988, 71989, 71990, 71991, 71992, 72007, 72008, 72009, 72010, 68779, 68810, 68809, 71767, 71766, 71760, 71765, 68805, 68808, 68807, 68801, 68783, 68800, 68799, 68797, 68796, 68795, 68728, 71756, 71764, 71763, 71762, 71757, 69667, 69497, 69499, 69529, 69503, 29181, 64692, 64688, 64693, 58271, 58272, 69498, 69525, 69531, 58122, 71779, 69515, 69496, 69508, 74185, 68803, 71944, 69494, 69448, 71805, 71807, 71806, 72538, 72537, 74127, 74128, 69535, 73058, 73292, 67960, 68381, 68380, 68370, 68369, 68619, 71770, 71772, 68816, 68665, 68633, 68634, 71771, 71769, 71768, 68727, 68802, 68632, 68630, 68624, 68664, 68621, 68617, 68792, 68791, 68790, 68789, 68785, 68784, 73518, 74129, 68623, 69668, 35794, 65709, 65707, 65708, 68388, 68651, 69511, 68385, 68387, 71922, 69526, 44208, 69505, 69509, 58127, 58124, 58126, 58125, 58123, 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, 76809, 76810, 76816, 76817, 76818, 76819, 76820, 76821, 76822, 76823, 76824, 76825, 76826, 76827, 76828, 76829, 76830, 76831, 76832, 76833, 76834, 76835, 76836, 76837, 76838, 76839, 76840, 76842, 76843, 76844, 76845, 76846, 76847, 76848, 76849, 76850, 76851, 76852, 76853, 76854, 76855, 76857, 76859, 76860, 76861, 77060, 77061, 77021, 75820, 75819, 75818, 75821, 77040, 77041, 77042, 77043, 77044, 77045, 77046, 77047, 77048, 77049, 77050, 77051, 77054, 77055, 77056, 77057, 77058, 77059, 77052, 77018, 64691, 64689, 64690, 73560, 77053, 73557, 48173, 35730, 74421, 74420, 48174, 45498, 75797, 76346, 76345, 68815, 68660, 68637, 76298, 68804, 76317, 76348, 76347, 76342, 76357, 76334, 76356, 76355, 68719, 68631, 71775, 68622, 68659, 71774, 71773, 68627, 68658, 68654, 68610, 68851, 68854, 68852, 68853, 67979, 71892, 71761, 71782, 71894, 67955, 67911, 68379, 68378, 71893, 35647, 44779, 45499, 65716, 65715, 44207, 73559, 73558, 29182, 73550, 74791, 78101, 78100, 78099, 78098, 78097, 78103, 78102, 77039, 69523, 65055, 75783, 77002, 75789, 67906, 68382, 68383, 68419, 78418, 78419, 78420, 78421, 78422, 78430, 78432, 78434, 78435, 78437, 78425, 78424, 78431, 78429, 78428, 78427, 78426, 78433, 78729, 78730, 78731, 78734, 78735, 78736, 78733, 78732, 78393, 78394, 78395, 78808, 78807, 78825, 78824, 78823, 78822, 78818, 78795, 78800, 78798, 78797, 78796, 78834, 78842, 78841, 78828, 78827, 78826, 76336, 79297, 73248, 76903, 76881, 76871, 76899, 76898, 76882, 76862, 76873, 76894, 76872, 76893, 76870, 71979, 73262, 73261, 73250, 73288, 73235, 73236, 73249, 79303, 79310, 79311, 79312, 79313, 79314, 79315, 79316, 79317, 79318, 79319, 79320, 79321, 79322, 79323, 79324, 79325, 79326, 79327, 79328, 79329, 79330, 79331, 79332, 79333, 79334, 79335, 79336, 79337, 79338, 79339, 79340, 79341, 79342, 79343, 79344, 79345, 79346, 79347, 79348, 79349, 79350, 79351, 79352, 79353, 79354, 79355, 79356, 79357, 79358, 79359, 79360, 79361, 79362, 79363, 79364, 79365, 79366, 79367, 79368, 79369, 79370, 79371, 79373, 79374, 79375, 79376, 78275, 79788, 79790, 80001, 80000, 80200, 80199, 80290, 80291, 80292, 73738, 64616, 78226, 75374, 75380, 69527, 67848, 64546, 35658, 35659, 79300, 79308, 79307, 79305, 77638, 77639, 73745, 73743, 74792, 74790, 75793, 69456, 65059, 81109, 79306, 35650, 65178, 73526, 64617, 69487, 78059, 78060, 78061, 64739, 74773, 65714, 78089, 78090, 73746, 81140, 75772, 82777, 82778, 82781, 82782, 82783, 82784, 82785, 82786, 82787, 82788, 82789, 82792, 82793, 82794, 82795, 82796, 82798, 82799, 82800, 82801, 82802, 75817, 83133, 83124, 83135, 83134, 83128, 83127, 83126, 83125, 83137, 83655, 83656, 83657, 83658, 83659, 83660, 83661, 83662, 83663, 83664, 83665, 83666, 83667, 83668, 83669, 83670, 83671, 83672, 83673, 83674, 83675, 83676, 83677, 83678, 83679, 83680, 83681, 83682, 83683, 83684, 83685, 83686, 83687, 83688, 83689, 83690, 83691, 83692, 83693, 83694, 83695, 83696, 83697, 83698, 83699, 83700, 83701, 83702, 83703, 83704, 83705, 83706, 83707, 83708, 83709, 83710, 83711, 83712, 83713, 83714, 83717, 83718, 83719, 83720, 83721, 83722, 83723, 83724, 83725, 83726, 83727, 83728, 83729, 83730, 83731, 83732, 83733, 83734, 83735, 83736, 83737, 83738, 83739, 83740, 83741, 83742, 83743, 83744, 81147, 81155, 81182, 81159, 83745, 83417, 83439, 83341, 83410, 83409, 83408, 83407, 83363, 83436, 83362, 83361, 83360, 83359, 83358, 82776, 82775, 83429, 83428, 83352, 83351, 83350, 83349, 83422, 83421, 83420, 83346, 83419, 83430, 82538, 68231, 68223, 68224, 68228, 68216, 68217, 82541, 82537, 78728, 73230, 73252, 73265, 73289, 44778, 81158, 69492, 69491, 69493, 83746, 83747, 78081, 81142, 69486, 78440, 69490, 82542, 73263, 64620, 81152, 82780, 78438, 77025, 81145, 64619, 65330, 81141, 81154, 81156, 68234, 78130, 81157, 81151, 79309, 82539, 68233, 77753, 80638, 77017, 76841, 77641, 77640, 78439, 82797, 84239, 84238, 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, 64584, 65713, 85339, 82779, 84243, 84244, 84942, 81235, 73744, 69521, 85606, 85607, 85608, 85550, 85551, 85609, 85605, 85610, 85991, 85976, 85975, 81153, 84129, 79023, 79024, 79025, 76858, 71898, 78417, 83715, 83716, 72448, 86643, 86644, 86645, 86646, 86647, 86648, 86649, 86650, 86651, 86652, 86653, 86654, 86655, 86656, 86657, 86658, 86659, 86660, 86661, 86662, 86663, 86664, 86665, 86666, 86667, 86668, 86669, 86670, 86671, 86672, 86673, 86674, 86675, 86676, 86677, 86678, 86679, 86680, 86681, 86682, 86683, 86684, 86685, 86686, 86687, 86688, 86689, 86690, 86691, 86692, 86693, 86694, 86695, 86816, 86817, 86818, 86819, 86820, 86821, 86822, 86823, 86824, 86825, 84237, 87000, 87003, 87004, 87005, 87006, 87007, 87008, 87009, 87010, 81148, 86697, 86739, 86723, 86738, 86737, 86736, 86716, 86727, 86726, 86742, 86741, 86740, 86729, 86734, 86733, 86730, 87287, 87284, 87295, 65185, 85741, 78441, 77136, 65177, 64761, 64762, 64760, 77317, 77318, 84246, 87665, 87664, 79372, 84023, 87292, 87294, 87296, 87291, 78131, 77754, 85740, 6789, 12985, 84025, 84242, 79789, 85282, 87779, 87780, 85283, 58326, 38521, 81505, 81488, 81494, 87260, 87261, 85518, 85517, 78132, 87001, 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, 89396, 89397, 89398, 89399, 89400, 89401, 89402, 89403, 89404, 89405, 89406, 89407, 89408, 89409, 89410, 89411, 89412, 89413, 89414, 89415, 89416, 89417, 89418, 89419, 89420, 89421, 89422, 89425, 89426, 89427, 89431, 89432, 89433, 89434, 89435, 89436, 89437, 89438, 89439, 89448, 89449, 89450, 89451, 89452, 89453, 89454, 89465, 89466, 88287, 88853, 88854, 88870, 88872, 89342, 89343, 89344, 89345, 89346, 89347, 89358, 89365, 89366, 89367, 89370, 89376, 89377, 89341, 89340, 89356, 89359, 89467, 89468, 89463, 89462, 89461, 89460, 89459, 89458, 89457, 89455, 89447, 89446, 89445, 89444, 89443, 89442, 89441, 89440, 89430, 89429, 89428, 89423, 89424, 89635, 89636, 89355, 83357, 68798, 83356, 89357, 89360, 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, 88862, 89393, 88871, 88850, 78423, 88851, 88852, 69476, 89633, 87781, 6788, 73555, 73551, 58325, 64737, 6784, 12986, 65319, 65336, 90400, 90401, 77215, 77216, 78072, 78071, 84914, 81234, 58116, 58118, 58121, 58117, 58119, 58120, 85762, 75785, 87631, 78083, 90460, 81150, 91053, 91052, 91051, 78073, 29194, 78436, 87277, 87293, 88175, 91112, 87289, 81146, 64695, 64696, 73556, 78082, 58269, 58270, 91327, 85255, 85256, 91386, 91114, 6783, 88879, 88860, 87002, 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, 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, 87288, 86999, 88849, 86815, 79304, 64694, 29195, 74789, 29197, 87772, 87771, 87764, 73552, 87782, 29193, 91585, 73237, 91659, 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, 93062, 93063, 93064, 93065, 93066, 93067, 93068, 93069, 93070, 93071, 93072, 93073, 93074, 93075, 93076, 93077, 93078, 93079, 93080, 93081, 93082, 93083, 93084, 93085, 93086, 93087, 93088, 93089, 93090, 93091, 93092, 93093, 93094, 93095, 93096, 93097, 93098, 93099, 93100, 93101, 93102, 93103, 93104, 93105, 93106, 93107, 93108, 93109, 93110, 93111, 93112, 93113, 93114, 93115, 93116, 93117, 93118, 93119, 93120, 93121, 93122, 93123, 93124, 93125, 93126, 93127, 93128, 93129, 93130, 93131, 93132, 93133, 93134, 93135, 93136, 93137, 93138, 93139, 93140, 93141, 93142, 93143, 93144, 93145, 93146, 93147, 93148, 93149, 93150, 93151, 93152, 93153, 93154, 93155, 93156, 93157, 93158, 93159, 93160, 93161, 93162, 93163, 87941, 73264, 68215, 87803, 87805, 90448, 93951, 93944, 93942, 93941, 29179, 29241, 29196, 77319, 83975, 83976, 78084, 78085, 88141, 88142, 29192, 85275, 85276, 85277, 12965, 78053, 78054, 81090, 85355, 85515, 87810, 87804, 87807, 87808, 87825, 87824, 71777, 71778, 76856, 71780, 79301, 79302, 88155, 91111, 90335, 91383, 87280, 87297, 93977, 87283, 94033, 88280, 88279, 88278, 87806, 65816, 94317, 94265, 94363, 94362, 94353, 94352, 94452, 94451, 94449, 94448, 94447, 94450, 94454, 94453, 81490, 81493, 81489, 81487, 81491, 81486, 81495, 81492, 81480, 81481, 81482, 84497, 94520, 94519, 94518, 94496, 94495, 94493, 94521, 84503, 65338, 65331, 90745, 90746, 84493, 84494, 84495, 73747, 94494, 84498, 85516, 84906, 87282, 94029, 91113, 91584, 94035, 94745, 94821, 94357, 94358, 94852, 94853, 94854, 94855, 94856, 87285, 88143, 94268, 84013, 90459, 95073, 95121, 95147, 95144, 95142, 95141, 95140, 95139, 95143, 80616, 80614, 80617, 80615, 73739, 57709, 35665, 57708, 85704, 81506, 84492, 95161, 95162, 94267, 38503, 77631, 77632, 95338, 94028, 94031, 94032, 94810, 94811, 94034, 95414, 95343, 95413, 95412, 95411, 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, 57710, 95657, 95656, 94313, 38504, 44781, 94036, 81143, 81724, 86050, 81144, 85549, 95851, 95852, 95853, 95854, 95855, 95856, 95857, 95858, 95859, 95860, 95861, 95862, 95875, 95876, 95877, 95878, 95879, 95880, 95881, 95882, 95883, 95884, 95885, 95886, 95887, 95888, 96568, 96569, 96570, 96571, 96572, 96573, 96574, 96575, 96576, 96577, 96578, 96579, 96580, 96581, 96582, 96583, 96584, 96585, 96586, 96587, 96588, 96973, 96974, 96975, 96976, 96977, 96978, 96979, 96980, 96981, 96982, 96983, 96984, 96985, 96986, 96987, 96988, 96989, 96990, 96991, 96992, 96993, 96994, 96995, 96996, 96997, 96998, 96999, 97000, 97001, 97002, 97003, 97004, 97005, 97006, 97007, 97008, 97009, 97010, 97011, 97012, 97013, 97014, 97015, 97016, 97017, 97018, 97019, 97020, 97021, 97022, 97023, 97024, 97025, 97026, 97027, 97028, 97029, 97030, 97031, 97032, 97033, 97034, 97035, 97036, 97037, 97038, 97039, 97040, 97041, 97042, 97043, 97044, 97045, 97046, 97047, 97048, 97049, 97050, 97051, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97370, 54069, 94269, 94270, 94275, 94276, 87783, 87785, 87786, 87784, 94335, 94336, 94343, 94312, 94314, 94315, 94316, 97629, 97628, 97627, 97626, 97606, 97605, 73741, 87281, 85696, 81499, 44780, 65362, 84245, 94747, 94746, 91328, 90469, 97839, 90334, 91514, 91384, 93943, 94355, 58225, 98174, 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, 35724, 35725, 35726, 64618, 97393, 95604, 95605, 95607, 95606, 95608, 93978, 94812, 94037, 95120, 88144, 97364, 73742, 98429, 98428, 98438, 98427, 94354, 94822, 94823, 94825, 94824, 94356, 87451, 91746, 91747, 98449, 98448, 98447, 98446, 98445, 98489, 94748, 83789, 83787, 83788, 84489, 84488, 84490, 84491, 95417, 54029, 54030, 58324, 64686, 74787, 74788, 84130, 87899, 90731, 90403, 90732, 90730, 90404, 90402, 90733, 90736, 90405, 90735, 90737, 90734, 90407, 90406, 35635, 65318, 91385, 98785, 98786, 98787, 98788, 98789, 98790, 98791, 98792, 98793, 98794, 98795, 98796, 98797, 98798, 98799, 98800, 98801, 98802, 98803, 98804, 99082, 99083, 99084, 99085, 99086, 99087, 99088, 99089, 99090, 99091, 99092, 99093, 99094, 99095, 99096, 99097, 99098, 99099, 99100, 99101, 99102, 99103, 99104, 99105, 99106, 99107, 99108, 99109, 99110, 99111, 99112, 99113, 99114, 99115, 99116, 99117, 99118, 99119, 99120, 99121, 99122, 99123, 99124, 99125, 99126, 99127, 99128, 99129, 99130, 99131, 99132, 99133, 99134, 99135, 99136, 99137, 99138, 99384, 99385, 99386, 99387, 99388, 99389, 99390, 99391, 99392, 99393, 99394, 99395, 99396, 99397, 99608, 99609, 99610, 99611, 99612, 99613, 99614, 99615, 99616, 99617, 99618, 99619, 99620, 99621, 99622, 99623, 99624, 99625, 99626, 99627, 99628) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 20 | maybe slow |
![ノベルティ：[記念品/贈答品] 金色のタンブラー＆アイスストーンセット](/img/item/US-2664821.jpg)
![ノベルティ：[記念品/贈答品] 金色のタンブラー＆アイスストーンセット のサンプルを請求する](/img/bt_mail.jpg){kind=small}
