| 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` <> 96148 AND `Item`.`id` IN (6436, 6437, 6438, 6439, 6440, 6444, 5764, 5765, 5760, 5761, 6454, 6147, 10655, 10656, 10657, 10659, 10660, 10662, 10663, 10664, 10665, 10667, 10668, 10670, 10671, 10672, 10673, 10675, 10676, 10678, 10679, 10680, 10681, 10683, 10684, 10686, 10687, 10688, 10689, 10691, 10692, 10694, 10695, 10696, 10697, 10699, 10700, 10702, 10703, 10704, 10705, 10707, 10708, 10710, 10711, 10712, 10713, 10715, 10716, 10718, 10719, 10720, 10721, 10723, 10724, 10725, 10726, 10727, 10728, 10729, 10731, 10732, 10733, 10734, 10735, 10736, 10737, 10738, 10739, 10740, 10741, 10742, 10743, 10744, 10745, 10747, 10748, 10749, 10750, 10751, 10753, 10755, 10756, 10757, 10758, 10759, 10760, 10761, 10763, 10764, 10765, 10766, 10767, 10768, 10769, 10771, 10772, 10773, 10774, 10775, 10776, 10777, 10779, 10780, 10781, 10782, 10783, 10784, 5735, 5740, 5727, 5728, 5718, 5726, 5755, 5721, 5729, 5739, 5716, 5719, 5717, 5754, 5720, 5715, 5723, 10701, 10661, 10693, 10685, 10717, 10677, 10709, 10669, 10770, 10730, 10762, 10754, 10746, 10778, 10666, 10698, 10658, 10690, 10722, 10682, 10714, 10674, 10706, 10487, 10470, 10482, 10449, 10466, 10448, 10447, 10476, 10498, 10486, 10508, 10464, 10485, 10507, 10463, 10496, 10512, 10452, 10474, 10506, 10462, 10484, 10511, 10451, 10473, 10495, 10461, 10483, 10505, 10510, 10450, 10472, 10494, 10460, 10504, 10471, 10493, 10459, 10481, 10503, 10492, 10469, 10458, 10480, 10502, 10491, 10446, 10468, 10479, 10501, 10490, 10445, 10467, 10489, 10456, 10478, 10500, 10488, 10455, 10477, 10499, 10465, 10509, 6456, 6457, 6157, 6158, 5699, 5698, 5700, 5734, 5733, 5732, 5744, 5741, 5743, 5742, 6148, 5762, 5763, 6448, 6449, 6435, 6441, 6442, 6443, 6451, 6452, 6453, 6455, 6461, 6460, 6459, 6458, 6450, 6446, 6447, 6445, 10752, 10454, 17087, 17088, 17089, 17090, 17091, 17092, 17093, 17094, 17095, 17096, 17097, 17098, 17099, 17100, 17101, 17102, 17103, 17104, 17105, 17106, 17107, 17108, 17109, 17110, 17111, 17112, 17113, 17114, 17115, 17116, 17117, 17118, 17119, 17120, 17121, 17122, 17123, 17124, 17125, 17126, 17127, 17128, 17129, 17130, 17131, 17132, 17133, 17134, 17135, 17136, 17137, 17138, 17139, 17140, 17141, 17142, 17143, 17144, 17145, 17146, 17147, 17148, 17149, 17150, 17151, 17152, 17153, 17154, 17155, 17156, 17157, 17158, 17159, 17160, 17161, 17162, 17163, 17164, 17165, 17166, 17167, 17168, 17169, 17170, 17171, 17172, 17173, 17174, 17175, 17176, 17177, 17178, 17179, 17180, 17181, 17182, 17183, 17184, 17185, 17186, 17187, 17188, 17189, 17190, 17191, 17192, 17193, 17194, 17195, 17196, 17197, 17198, 17199, 17200, 17201, 17202, 17203, 17204, 17205, 17206, 17207, 17208, 17209, 17210, 17211, 17212, 17213, 17214, 17215, 17216, 17217, 17218, 17219, 17220, 17221, 17222, 17223, 17224, 17225, 17226, 17227, 17228, 17229, 17230, 17231, 17232, 17233, 17234, 17235, 17236, 17237, 17238, 17239, 17240, 17241, 17242, 17243, 17244, 17245, 17246, 17247, 17248, 17249, 17250, 17251, 17252, 17253, 17254, 17255, 17256, 17257, 17258, 17032, 16760, 17000, 17040, 17008, 16744, 17024, 16824, 17072, 17080, 17048, 17056, 16995, 17035, 17003, 16731, 17043, 17011, 17019, 17067, 16835, 17075, 17083, 17051, 17059, 17030, 16998, 17038, 17006, 16734, 17046, 17022, 16718, 17062, 16961, 16830, 17070, 17078, 17086, 17054, 16822, 16993, 17033, 17001, 17041, 17009, 17025, 17065, 17073, 17081, 17049, 17057, 17028, 16996, 16724, 17036, 17004, 17044, 17012, 17020, 17068, 17076, 17084, 17052, 16951, 17060, 17031, 16759, 16999, 17039, 17007, 16735, 16743, 17023, 16719, 16823, 17063, 16962, 16831, 17071, 17079, 17047, 17055, 16994, 17034, 17002, 17042, 17010, 17018, 17026, 17066, 16834, 17074, 17045, 17013, 17021, 17061, 16960, 17069, 16936, 17077, 17085, 17053, 14711, 14724, 14716, 14712, 14715, 14734, 14729, 14698, 8438, 8419, 5750, 5749, 5758, 5776, 5775, 5777, 17014, 17015, 17016, 17017, 5746, 5747, 5748, 5745, 32800, 32802, 32803, 32804, 32805, 32818, 32819, 32820, 32821, 32822, 32823, 32824, 32825, 32826, 32827, 32828, 32829, 32830, 32831, 32832, 32833, 32834, 32835, 32840, 32841, 32842, 32846, 32847, 32848, 32849, 32854, 32855, 32857, 32858, 32859, 32860, 32861, 32862, 32863, 32864, 32865, 32868, 32869, 32870, 32871, 32872, 32879, 32880, 32881, 32882, 32883, 32884, 32885, 32886, 32887, 32888, 32889, 32890, 32891, 32892, 32893, 32894, 32895, 32896, 32897, 32898, 32899, 32900, 32901, 32902, 32903, 32904, 32905, 32906, 32907, 32908, 32909, 32910, 32911, 32912, 32913, 32914, 32915, 32920, 32921, 32922, 32923, 32924, 32925, 32926, 32927, 32928, 32929, 32930, 32931, 32932, 32933, 32934, 32935, 32936, 32937, 32938, 32939, 32940, 32941, 32942, 32943, 32944, 32945, 32946, 32947, 32949, 32954, 32955, 32956, 32957, 32958, 32959, 32960, 32961, 32964, 32965, 32966, 32967, 32968, 32969, 32970, 32972, 32973, 32974, 32975, 32976, 32977, 32978, 32979, 32980, 32981, 32982, 32984, 32985, 32986, 32987, 32988, 32989, 32990, 32991, 32992, 32993, 32997, 32971, 32948, 32875, 32873, 32874, 32876, 32815, 32816, 32817, 32877, 32878, 32950, 32951, 32952, 32953, 32801, 32866, 32867, 32996, 32995, 32994, 32963, 32962, 5725, 5724, 32856, 32983, 42551, 42552, 42553, 42554, 42555, 42556, 42557, 42558, 42560, 42561, 42562, 42563, 42564, 42565, 42567, 42568, 42569, 42570, 42571, 42572, 42573, 42574, 42575, 42576, 42577, 42578, 42579, 42580, 42581, 42582, 42583, 42584, 42585, 42586, 42587, 42588, 42593, 42594, 42595, 42596, 42597, 42598, 42599, 42600, 42601, 42602, 42603, 42604, 42605, 42606, 42607, 42608, 42609, 42610, 42611, 42612, 42613, 42614, 42615, 42616, 42617, 42619, 42620, 42621, 42622, 42623, 42624, 42625, 42626, 42627, 42628, 42629, 42630, 42631, 42632, 42633, 42634, 42635, 42636, 42637, 42638, 42639, 42642, 42643, 42644, 42645, 42646, 42647, 42648, 42649, 42650, 42651, 42652, 42658, 42659, 42660, 42663, 42664, 42665, 42666, 42667, 42668, 42669, 42670, 42671, 42672, 42673, 42674, 42675, 42676, 42677, 42678, 42679, 42680, 42681, 42682, 42683, 42684, 42689, 42690, 42691, 42692, 42693, 42694, 42695, 42696, 42697, 42698, 42699, 42700, 42701, 42702, 42704, 42705, 42706, 42707, 42708, 42709, 42710, 42711, 42715, 42716, 42717, 42718, 42719, 42720, 42721, 42722, 42723, 42724, 42725, 42726, 42727, 42728, 42729, 42730, 42731, 42732, 42733, 42734, 42735, 42736, 42737, 42739, 42956, 42955, 42954, 42953, 42952, 42951, 42950, 42949, 42948, 42947, 42946, 42945, 42944, 42943, 42942, 42941, 42940, 42939, 42938, 42937, 42936, 42935, 42934, 42566, 42653, 42654, 42655, 42656, 42657, 42661, 42662, 42738, 44623, 44624, 44625, 44626, 44627, 44628, 44629, 44630, 44631, 44632, 44633, 44634, 42703, 42640, 42686, 42685, 42687, 42688, 42713, 42714, 42712, 51430, 51431, 51432, 51433, 51434, 51435, 51436, 51437, 51438, 51439, 51441, 51442, 51444, 51445, 51446, 51447, 51448, 51449, 51450, 51451, 51452, 51453, 51454, 51455, 51456, 51457, 51458, 51459, 51460, 51461, 51462, 51463, 51464, 51465, 51466, 51467, 51468, 51469, 51470, 51471, 51472, 51473, 51474, 51475, 51476, 51477, 51478, 51479, 51480, 51481, 51482, 51483, 51484, 51485, 51486, 51487, 51488, 51489, 51490, 51491, 51492, 51493, 51494, 51495, 51497, 51498, 51499, 51500, 51501, 51502, 51503, 51504, 51505, 51506, 51507, 51508, 51509, 51510, 51511, 51512, 51513, 51514, 51515, 51516, 51517, 51518, 51519, 51520, 51521, 51522, 51523, 51524, 51525, 51526, 51527, 51528, 51529, 51530, 51531, 51532, 51533, 51534, 51535, 51536, 51537, 51538, 51539, 51540, 51541, 51542, 51543, 51544, 51545, 51546, 51547, 51548, 51549, 51552, 51553, 51554, 51555, 51556, 51557, 51558, 51559, 51560, 51561, 51562, 51563, 51564, 51565, 51566, 51567, 51568, 51569, 51570, 51571, 51572, 51573, 51574, 51575, 51576, 51577, 51578, 51579, 51580, 51581, 51582, 51583, 51584, 51585, 51586, 51587, 51588, 51589, 51590, 51591, 51592, 51593, 51594, 51595, 51596, 51597, 51598, 51599, 51600, 51601, 51602, 51603, 51604, 51605, 51606, 51607, 53611, 53608, 53610, 53607, 53606, 53605, 53604, 53603, 53599, 53600, 53601, 53602, 53569, 53570, 53571, 53572, 53574, 42559, 51551, 51443, 51440, 51550, 51496, 59172, 59173, 59174, 59181, 59182, 59279, 59295, 59296, 59297, 59298, 59299, 59300, 59301, 59302, 59303, 59304, 59305, 59306, 59183, 59184, 59185, 59186, 59187, 59188, 59190, 59195, 59197, 59198, 59199, 59200, 59201, 59202, 59203, 59204, 59205, 59206, 59207, 59208, 59209, 59211, 59212, 59213, 59214, 59215, 59216, 59217, 59218, 59220, 59221, 59222, 59223, 59224, 59226, 59229, 59234, 59235, 59236, 59307, 59308, 59309, 59310, 59316, 59320, 59321, 59322, 59323, 59294, 59288, 59290, 59291, 59292, 59293, 59241, 59243, 59244, 59248, 59249, 59252, 59257, 59258, 59259, 59260, 59313, 59261, 59262, 59263, 59264, 59266, 59268, 59286, 59275, 59278, 59280, 59283, 59284, 59269, 59271, 59272, 59273, 59253, 59276, 59312, 59265, 59281, 59179, 59318, 59317, 59319, 59285, 59175, 59227, 59225, 59189, 59247, 59246, 59210, 59178, 59176, 59177, 59277, 59311, 59254, 59231, 59232, 59267, 59282, 59240, 59287, 59289, 59228, 59230, 59237, 59196, 59194, 59180, 59219, 59233, 59256, 59251, 59250, 59238, 59239, 59255, 59242, 59270, 59314, 59315, 59274, 59245, 68219, 68220, 68221, 68222, 68225, 68226, 68227, 68241, 68242, 68247, 68248, 68249, 68250, 68251, 68252, 68253, 68254, 68255, 68256, 68257, 68258, 68261, 68262, 68263, 68264, 68290, 68291, 68292, 68295, 68296, 68306, 68308, 68332, 68342, 68343, 68345, 68350, 68351, 68352, 68353, 68354, 68355, 68360, 68103, 68338, 68339, 68184, 68185, 68186, 68187, 68188, 68101, 68294, 68309, 68289, 68293, 68329, 68334, 68337, 68318, 68319, 68320, 68321, 68322, 68323, 68316, 68265, 68266, 68267, 68201, 68202, 68203, 68243, 68244, 68245, 68246, 68341, 68259, 68260, 68297, 68298, 68299, 68300, 68214, 68211, 68212, 68213, 68208, 68209, 68210, 68207, 68204, 68205, 68206, 68286, 68285, 68287, 68288, 68283, 68284, 68324, 68363, 68361, 68198, 68199, 68200, 68356, 68357, 68358, 68359, 68195, 68196, 68235, 68236, 68310, 68312, 68313, 68269, 68270, 68271, 68229, 68325, 68326, 68327, 68328, 68344, 68333, 68317, 68311, 68331, 68102, 68330, 68307, 68362, 68190, 68191, 68194, 68193, 68192, 68189, 75236, 75237, 75238, 75239, 75240, 75241, 75242, 75243, 75244, 75247, 75249, 75250, 75251, 75252, 75253, 75254, 75255, 75256, 75257, 75258, 75259, 75260, 75261, 75262, 75263, 75264, 75265, 75266, 75267, 75268, 75269, 75270, 75271, 75272, 75273, 75274, 75275, 75276, 75277, 75278, 75279, 75280, 75281, 75282, 75283, 75286, 75287, 75288, 75289, 75290, 75291, 75292, 75293, 75294, 75295, 75296, 75297, 75299, 75300, 75301, 75302, 75303, 75304, 75305, 75306, 75307, 75309, 77034, 75246, 68183, 68315, 77033, 75248, 68230, 68232, 68218, 75308, 57671, 75245, 68281, 68279, 44655, 68340, 68268, 68240, 68239, 78382, 78390, 78391, 78392, 78396, 78397, 78398, 78399, 78402, 78403, 78414, 78415, 78416, 78383, 78384, 78385, 78386, 78410, 78411, 78412, 78413, 78409, 78408, 78407, 78404, 78405, 78406, 78401, 78400, 78387, 78388, 78389, 78377, 78378, 78379, 78380, 78393, 78394, 78395, 75284, 68238, 68237, 77302, 77303, 77304, 77308, 77309, 77310, 78376, 78374, 78375, 82433, 82434, 82435, 82436, 82437, 82438, 82439, 82440, 82441, 82442, 82443, 82444, 82445, 82446, 82447, 82448, 82449, 82450, 82451, 82452, 82453, 82454, 82455, 82456, 82457, 82458, 82459, 82460, 82461, 82462, 82463, 82464, 82466, 82468, 82469, 82470, 82471, 82472, 82473, 82476, 82483, 82484, 82485, 82486, 82487, 82488, 82489, 82490, 82491, 82492, 82495, 82496, 82497, 82498, 82499, 82500, 82501, 82502, 82503, 82504, 82505, 82506, 82507, 82508, 82509, 82510, 82511, 82512, 82513, 82514, 82515, 82516, 82517, 82530, 82531, 82532, 82533, 68231, 68223, 68224, 68228, 68216, 68217, 68282, 65763, 65762, 77305, 77306, 77307, 77311, 77312, 68234, 82493, 68349, 68346, 68347, 68348, 68233, 78034, 78035, 78036, 75285, 82480, 82482, 82481, 86237, 86238, 86239, 86240, 86241, 86242, 86243, 86244, 86245, 86246, 86247, 86248, 86249, 86250, 86251, 86252, 86253, 86254, 86255, 86256, 86257, 86260, 86261, 86262, 86263, 86264, 86743, 86744, 86745, 86746, 86747, 86748, 86749, 86750, 86751, 68301, 82494, 82477, 65759, 65760, 78381, 68335, 68336, 82465, 82475, 82467, 68280, 88422, 88423, 88424, 88425, 88426, 88427, 88428, 88429, 88430, 88431, 88432, 88433, 88434, 88435, 88436, 88437, 88438, 88439, 88440, 88441, 88442, 88443, 88444, 88445, 88446, 88447, 88448, 88449, 88450, 88451, 88452, 88453, 88454, 88455, 88456, 88457, 88458, 88459, 88460, 88461, 88462, 88463, 88469, 88470, 88471, 88472, 88473, 88474, 88475, 88476, 88477, 82474, 65761, 75298, 77299, 77300, 92180, 92181, 92182, 92183, 92184, 92185, 92186, 92187, 92188, 92189, 92190, 92191, 92192, 92193, 92194, 92195, 92196, 92197, 92198, 92199, 92200, 92201, 92202, 92203, 92204, 92205, 92206, 92207, 92208, 92209, 92210, 92211, 92212, 92213, 92214, 92215, 92216, 92217, 92218, 92219, 92220, 92221, 92222, 92223, 92224, 92225, 92226, 92227, 92228, 92229, 68273, 68272, 68274, 68215, 86258, 86259, 77301, 68314, 88464, 88465, 88466, 88467, 88468, 82479, 92179, 82478, 65327, 96151, 96152, 96153, 96154, 96155, 96156, 96157, 96158, 96159, 96160, 96161, 96162, 96163, 96164, 96165, 96166, 96167, 96168, 96169, 96170, 96171, 96172, 96173, 96174, 96175, 96176, 96177, 96485, 96486, 96487, 96488, 96489, 96490, 96491, 96492, 96493, 96494, 96495, 96496, 96497, 96498, 96499, 96148, 96149, 96150, 68276, 68278, 68277, 68275, 68364, 68367, 68365, 68366, 65248, 68302, 86752, 68303, 68304, 68305, 99027, 99028, 99029, 99030, 99031, 99032, 99033, 99034, 99035, 99036, 99037, 99038, 99039, 99040, 99041, 99042, 99043, 99044, 99045, 99046, 99047, 99048, 99049, 99050, 99051, 99052, 99053, 99054, 99055, 99056, 99057, 99058, 99059, 99060, 99061, 99062, 99063, 99064, 99065, 99066, 99067, 99068, 99069, 99070, 99071, 99072, 99073, 99074, 99075, 99076, 99077, 99078, 99079, 99080, 99081, 99752, 99753, 99754, 99755, 99756, 99757, 99758, 99759, 99760, 99761, 99762, 99763, 99764, 99765, 99766, 99767, 99768, 99769, 99770, 99771, 99772, 99773, 99774, 99775, 99776, 99777, 99778, 99779, 99780, 99781) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 9 | maybe slow |
![ノベルティ：[ボールペン&シャープペン] 三菱鉛筆 ピュアモルト 2&1 3機能ペン](/img/item/25153G09.jpg)
![ノベルティ：[ボールペン&シャープペン] 三菱鉛筆 ピュアモルト 2&1 3機能ペン のサンプルを請求する](/img/bt_mail.jpg){kind=small}
