| 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` <> 96361 AND `Item`.`id` IN (41562, 41563, 41564, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41576, 41577, 41578, 41579, 41580, 41581, 41582, 41583, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41607, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41637, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41721, 53418, 53419, 53420, 53421, 53422, 53423, 53424, 53425, 53426, 53427, 53428, 53429, 53430, 53431, 53432, 53433, 53434, 53435, 53436, 53437, 53438, 53439, 53440, 53441, 53442, 53443, 53444, 53445, 53446, 53447, 53448, 53449, 53450, 53451, 53452, 53453, 53454, 53455, 53456, 53457, 53458, 53459, 53460, 53461, 53462, 53463, 53464, 53465, 53466, 53467, 53468, 53469, 53470, 53471, 53472, 53473, 53474, 53475, 53476, 53477, 53478, 53479, 53480, 53481, 53482, 53483, 53484, 53485, 53486, 53487, 53488, 53489, 53490, 53491, 53492, 53493, 53494, 53495, 53496, 53497, 53498, 53499, 53500, 53501, 53502, 53503, 53504, 53505, 53506, 53507, 53508, 53509, 53510, 53511, 53512, 53513, 53514, 53515, 53516, 53517, 53518, 53519, 53520, 53521, 53522, 53523, 53524, 53525, 53526, 53527, 53528, 53529, 53530, 53531, 53532, 53533, 53534, 53535, 53536, 53537, 53538, 53539, 53540, 53541, 53542, 53543, 53544, 53545, 53546, 53547, 53548, 53549, 53550, 53551, 53552, 53553, 53554, 53555, 53556, 53557, 53558, 53559, 53560, 53561, 53562, 53563, 53564, 53565, 48273, 63948, 63949, 63950, 63951, 63952, 63953, 63954, 63955, 63956, 63957, 63958, 63959, 63960, 63961, 63962, 63963, 63964, 63965, 63966, 63967, 63968, 63969, 63970, 63971, 63972, 63973, 63974, 63975, 63976, 63977, 63978, 63979, 63980, 63981, 63982, 63983, 63984, 63985, 63986, 63987, 63988, 63989, 63990, 63991, 63992, 63993, 63994, 63995, 63996, 63997, 63998, 63999, 64000, 64001, 64002, 64003, 64004, 64005, 64006, 64007, 64008, 64009, 64010, 64011, 64012, 64013, 64014, 64015, 64016, 64017, 64018, 64019, 64020, 64021, 64022, 64023, 64024, 64025, 64026, 64027, 64028, 64029, 64030, 64031, 64032, 64033, 64034, 64035, 64036, 64037, 64038, 64039, 64040, 64041, 64042, 64043, 64044, 64045, 64046, 64047, 64048, 64049, 64050, 64051, 64052, 64053, 64054, 64055, 64056, 64057, 64058, 64059, 64060, 64061, 64062, 64063, 64064, 64065, 64066, 64067, 64068, 64069, 64070, 64071, 64072, 64073, 64074, 64075, 64085, 64086, 64087, 64088, 64089, 64090, 64091, 64092, 64093, 64094, 64095, 64096, 64097, 64098, 64099, 64100, 64101, 64102, 64103, 64104, 64105, 64106, 64107, 64108, 64110, 64112, 64113, 64114, 64115, 64116, 64117, 64118, 64119, 64120, 64121, 64122, 64123, 64124, 64125, 64126, 64127, 64128, 64129, 64130, 64131, 64132, 64133, 64134, 64135, 64136, 64137, 64138, 64139, 64140, 64141, 64142, 64143, 64144, 64145, 64146, 64147, 64148, 64149, 64150, 64151, 64152, 64153, 64154, 64155, 64156, 64157, 64158, 64159, 64160, 64161, 64162, 64163, 64164, 64165, 64166, 64167, 64168, 64169, 64170, 64171, 64172, 64173, 64175, 64176, 64178, 64179, 64180, 64181, 64182, 64183, 63630, 64177, 63938, 63939, 63940, 63941, 63942, 63943, 63944, 63945, 63946, 63947, 64076, 64077, 64078, 64079, 64080, 64081, 64082, 64083, 64084, 45485, 64111, 64109, 64174, 65839, 65840, 65841, 65842, 65843, 65844, 65845, 65846, 65847, 65848, 65849, 65850, 65851, 65852, 65853, 65854, 65855, 65856, 65857, 65858, 65859, 65860, 65861, 65862, 65863, 65864, 65865, 65866, 65867, 65868, 65869, 65870, 65871, 65872, 65873, 65874, 65875, 65876, 65877, 65878, 65879, 65880, 65881, 65882, 65883, 65884, 65885, 65886, 65887, 65888, 65889, 65890, 65891, 65892, 65893, 65894, 65895, 65896, 65897, 65898, 65899, 65900, 65901, 65902, 65903, 65904, 65905, 65906, 65907, 65908, 65909, 65910, 65911, 65912, 65913, 65914, 65915, 65916, 65917, 65918, 65919, 65920, 65921, 65922, 65923, 65924, 65925, 65926, 65927, 65928, 65929, 65930, 65931, 65932, 65933, 65934, 65935, 65936, 65937, 65938, 65939, 65940, 65941, 65942, 65943, 65944, 65945, 65946, 65947, 65948, 65949, 65950, 65951, 65952, 65953, 65954, 65955, 65956, 65957, 65958, 65959, 65961, 65962, 65963, 65964, 65965, 65966, 65967, 65968, 65969, 65970, 65971, 65972, 65973, 65974, 65975, 65976, 65977, 65978, 65979, 65980, 65981, 65982, 65983, 65984, 65985, 65986, 65987, 65988, 65989, 65990, 65991, 65992, 65993, 65994, 65995, 65996, 65997, 65998, 65999, 66000, 66001, 66002, 66003, 66004, 66005, 66006, 66007, 66008, 66009, 66010, 66011, 66012, 66013, 66014, 66015, 66016, 66017, 66018, 66019, 66020, 66021, 66022, 66023, 66024, 66025, 66026, 66027, 66028, 66029, 66030, 66031, 66032, 66033, 66034, 66035, 66036, 66037, 66038, 66039, 66041, 66042, 66043, 66044, 66045, 66046, 66047, 66048, 66049, 66050, 66052, 66053, 66054, 66055, 66056, 66057, 66058, 66059, 66060, 66061, 66062, 66063, 66064, 66065, 66066, 66067, 66068, 66069, 66070, 66071, 66072, 66073, 66074, 66075, 66076, 66077, 66078, 66079, 66080, 66081, 66082, 66083, 66084, 66085, 66086, 66087, 66088, 66089, 66090, 66091, 66092, 66093, 66094, 66095, 66096, 66097, 66098, 66099, 66100, 66101, 66102, 66103, 66104, 66105, 66106, 66109, 66110, 66111, 66112, 66113, 66114, 66115, 66116, 66117, 66118, 66119, 66120, 66121, 66122, 66123, 66124, 66125, 66126, 66127, 66128, 66129, 66130, 66131, 66132, 66133, 66137, 66138, 66139, 66140, 66141, 66142, 72732, 72733, 72734, 72735, 72736, 72738, 72743, 72745, 72747, 72748, 72751, 72757, 72758, 72760, 72761, 72762, 72763, 72765, 72766, 72767, 72769, 72771, 72772, 72773, 72779, 72780, 72781, 72782, 72783, 72784, 72785, 72786, 72787, 72788, 72789, 72791, 72792, 72797, 72798, 72800, 72801, 72802, 72803, 72804, 72807, 72808, 72809, 72810, 72811, 72812, 72813, 72814, 72815, 72816, 72817, 72818, 72820, 72821, 72822, 72823, 72824, 72825, 72826, 72828, 72829, 72830, 72831, 72833, 72837, 72849, 72851, 72852, 72854, 72855, 72856, 72857, 72858, 72859, 72860, 72861, 72862, 72863, 72864, 72865, 72866, 72867, 72868, 72869, 72870, 72871, 72872, 72873, 72874, 72875, 72876, 72878, 72879, 72880, 72881, 72882, 72883, 72884, 72885, 72886, 72887, 72888, 72889, 72890, 72891, 72892, 72893, 72894, 72895, 72896, 72897, 72898, 72899, 72900, 72901, 72902, 72903, 72905, 72906, 72907, 72908, 72909, 72910, 72911, 72912, 72913, 72914, 72915, 72916, 72917, 72918, 72919, 72920, 72921, 72922, 72923, 72924, 72925, 72928, 72929, 72930, 72931, 72934, 72936, 72942, 72943, 72944, 72945, 72946, 72952, 72959, 72960, 72961, 72962, 72963, 72964, 72965, 72966, 72967, 72968, 72970, 72974, 72975, 72976, 72977, 72980, 72981, 72982, 72985, 72986, 72988, 72989, 72990, 72991, 72992, 72993, 72994, 72995, 72996, 72997, 72998, 72999, 73000, 73001, 73002, 73003, 73004, 73005, 73007, 73008, 73009, 73010, 73011, 73012, 73013, 73014, 73015, 73016, 73017, 73018, 73019, 73020, 73021, 73022, 73023, 73024, 73025, 72725, 72726, 72727, 72728, 72729, 72730, 72731, 72939, 72932, 72933, 72724, 72723, 72984, 72983, 72958, 72957, 72956, 72955, 72954, 72953, 72951, 72950, 72949, 72979, 72978, 65960, 45486, 76943, 76944, 76945, 76946, 76947, 76948, 76951, 76952, 76953, 76955, 76956, 76957, 76958, 76959, 76960, 76961, 76962, 76963, 76964, 76965, 76966, 76967, 76974, 76975, 76976, 76979, 76980, 76981, 76982, 76983, 76984, 76985, 76986, 76987, 76977, 76969, 65027, 77069, 66040, 72877, 79127, 79131, 79133, 79135, 79136, 79137, 79138, 79139, 79140, 79141, 79142, 79144, 79145, 79146, 79148, 79149, 79150, 79151, 79152, 79153, 79155, 79156, 79157, 79158, 79161, 79162, 79163, 79164, 79165, 79167, 79169, 79170, 79171, 79172, 79173, 79174, 79175, 79176, 79177, 79178, 79179, 79180, 79181, 79182, 79183, 79184, 79185, 79186, 79187, 79188, 79189, 79190, 79191, 79192, 79193, 79194, 79196, 79197, 79198, 79199, 79200, 79201, 79202, 79208, 73031, 73030, 73029, 73028, 73027, 73026, 73034, 73033, 73032, 45490, 45487, 45491, 45492, 79195, 45489, 45484, 45488, 72938, 82378, 82380, 82386, 82390, 82391, 82392, 82394, 82395, 82396, 82397, 82398, 82399, 82400, 82401, 82402, 82403, 82404, 72739, 72740, 72742, 72741, 72744, 72759, 79129, 72749, 72750, 72752, 72753, 72754, 72755, 72756, 72774, 72775, 72776, 72777, 72778, 72790, 79134, 76972, 79143, 72850, 72838, 72839, 72840, 72841, 72940, 66051, 76950, 72987, 83746, 83747, 76949, 82389, 82387, 82385, 82384, 76954, 82383, 82382, 82381, 82377, 82376, 82375, 82405, 79203, 79204, 79205, 79206, 79160, 84035, 84036, 84039, 84045, 84072, 84095, 84110, 84057, 84049, 84051, 84277, 66108, 73006, 66107, 66135, 66136, 66134, 82393, 79166, 72948, 72947, 72941, 72926, 82388, 72972, 72973, 72969, 72935, 79147, 79154, 86542, 86543, 86544, 86545, 86546, 86547, 86548, 86549, 86550, 86551, 86552, 86553, 86554, 86555, 86556, 86557, 86566, 86567, 86568, 86569, 86570, 86571, 86572, 86573, 86574, 86575, 86576, 86577, 86578, 86579, 86580, 86581, 86582, 86583, 86584, 86585, 86586, 86587, 86588, 86589, 86590, 86591, 86592, 86593, 86594, 87217, 84276, 84063, 72846, 72847, 72848, 88397, 88398, 88399, 88400, 88401, 88402, 88403, 88404, 88406, 88407, 88408, 88409, 88410, 88411, 88412, 88413, 88414, 88415, 88416, 88417, 88418, 88419, 88420, 88421, 44167, 44168, 44170, 44173, 44171, 44169, 44172, 84107, 84108, 86565, 86564, 86563, 86562, 86561, 86559, 86558, 86560, 82379, 79168, 84086, 84087, 84080, 91570, 92555, 92556, 92557, 92558, 92559, 92560, 92561, 92562, 92563, 92564, 92565, 92566, 92567, 92568, 92569, 92570, 92571, 92572, 92573, 92574, 92575, 92576, 92577, 92578, 92579, 92580, 92581, 92582, 92583, 92584, 92585, 92586, 92587, 92588, 92589, 92590, 92591, 92592, 92593, 92594, 92595, 92596, 92597, 92598, 92599, 92600, 92601, 92602, 92603, 92604, 92605, 92606, 92607, 92608, 92609, 92610, 92611, 92612, 92613, 92614, 72971, 72937, 91546, 91562, 91563, 91574, 91575, 91581, 94021, 94430, 94429, 94428, 94427, 94592, 94591, 94588, 94587, 94584, 94583, 94580, 94590, 94589, 94586, 94585, 94582, 94581, 94579, 94578, 94577, 94576, 94594, 94575, 94593, 91569, 91571, 91572, 91573, 93959, 93960, 93991, 93992, 93994, 93995, 93997, 93999, 94023, 91576, 91577, 91561, 91550, 91551, 91552, 91553, 91556, 91564, 91565, 91566, 91545, 94730, 94729, 94727, 94728, 94726, 94725, 94000, 94001, 72843, 72842, 72844, 72845, 88405, 72927, 72904, 95440, 95459, 95439, 95458, 95438, 95457, 95456, 95540, 95455, 95539, 95454, 95538, 95453, 95537, 95452, 95451, 95450, 95449, 95448, 95447, 95446, 95445, 95444, 95443, 95442, 95461, 95441, 95460, 96016, 96017, 96018, 96019, 96020, 96021, 96022, 96023, 96024, 96025, 96026, 96027, 96028, 96029, 96030, 96031, 96032, 96033, 96034, 96035, 96036, 96037, 96038, 96361, 96362, 96363, 96364, 96365, 96366, 97366, 91510, 97616, 97615, 97718, 97717, 97716, 94399, 94400, 94401, 94402, 94403, 94404, 94405, 94406, 94407, 94408, 94409, 94410, 94411, 94412, 94413, 94414, 94415, 94416, 94417, 94418, 94421, 94422, 94423, 94424, 94425, 94426, 94731, 94735, 94732, 94733, 94736, 94734, 94737, 95531, 95532, 95536, 95535, 95533, 95534, 95530, 98045, 98063, 98044, 98062, 98043, 98061, 98042, 98060, 98059, 98058, 98057, 98056, 98055, 98054, 98053, 98052, 98051, 98050, 98049, 98064, 98185, 83753, 83754, 83755, 83756, 98688, 98689, 98690, 98691, 98692, 98693, 98694, 98695, 98696, 98697, 99650, 99651, 99652, 99653, 99654, 99655, 99656, 99657, 99658, 99659, 99660, 99661, 99662, 99663, 99664, 99665, 99666, 99667, 99668, 99669, 99670, 99671, 99672) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 16 | maybe slow |
![ノベルティ：[イベント景品セット] 日用品大集合抽選会Ｎ 100人用](/img/item/25239G05.jpg)
![ノベルティ：[イベント景品セット] 日用品大集合抽選会Ｎ 100人用 のサンプルを請求する](/img/bt_mail.jpg){kind=small}
