| 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` <> 77755 AND `Item`.`id` IN (6006, 6308, 6309, 6311, 6312, 6313, 6315, 6317, 6318, 6319, 6320, 6321, 6322, 6323, 6324, 6343, 6486, 6299, 6298, 6297, 6331, 6330, 6329, 6328, 6327, 6326, 6342, 6316, 6338, 7332, 7333, 7334, 7335, 7336, 7337, 7338, 7339, 7340, 7341, 7342, 7343, 7344, 7345, 7346, 7347, 7348, 7349, 7350, 7351, 7352, 7353, 7354, 7355, 7356, 7357, 7358, 7359, 7360, 7361, 7362, 7363, 7364, 7365, 7366, 7367, 7368, 7369, 7370, 7371, 7372, 7373, 7374, 7375, 7376, 7377, 7378, 7379, 7380, 7381, 7382, 7383, 7384, 7385, 7386, 7387, 7388, 7389, 7390, 7391, 7392, 7393, 7394, 7395, 7396, 7397, 7398, 7399, 7400, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7412, 7413, 7414, 7415, 7416, 7417, 7418, 7419, 7420, 7421, 7422, 7423, 7424, 7425, 7426, 7427, 7428, 7429, 7430, 7431, 7432, 7433, 7435, 7436, 7437, 7438, 7439, 7440, 7441, 7442, 7443, 7444, 7447, 7448, 7449, 7450, 7451, 7452, 7453, 7455, 7456, 7457, 7458, 7459, 7460, 7461, 7462, 7463, 7464, 7465, 7466, 7467, 7468, 7469, 7470, 7471, 7473, 7474, 7476, 7477, 7478, 7479, 7480, 4947, 4936, 4953, 5068, 5069, 4946, 4954, 4955, 5023, 4939, 4934, 4942, 4940, 4943, 4941, 7475, 6325, 7472, 10281, 6333, 6334, 12496, 7446, 7445, 4937, 6021, 4944, 6310, 6340, 6341, 6332, 6337, 6335, 6336, 7434, 13638, 13639, 13640, 13644, 13645, 13646, 13647, 13648, 13649, 13650, 13651, 13652, 13653, 13654, 13655, 13656, 13657, 13658, 13659, 13660, 13661, 13662, 13663, 13664, 13665, 13666, 13667, 13668, 13669, 13670, 13686, 13687, 13688, 13689, 13690, 13691, 13692, 13693, 13694, 13695, 13696, 13697, 13698, 13699, 13700, 13701, 13702, 13703, 13704, 13705, 13706, 13707, 13708, 13709, 13710, 13711, 13712, 13713, 13714, 13715, 13716, 13717, 13718, 13719, 13720, 13721, 13722, 13723, 13724, 13725, 13726, 13727, 13728, 13729, 13730, 13731, 13732, 13733, 13734, 13735, 13736, 13744, 13752, 13753, 13757, 13758, 13759, 13760, 13761, 13762, 13763, 13764, 13765, 13766, 13767, 13768, 13769, 13770, 13771, 13772, 13773, 13774, 13775, 13776, 13777, 13778, 13779, 13780, 13781, 13782, 13784, 13785, 13786, 13787, 13788, 13791, 13108, 13103, 13104, 13105, 13106, 13107, 14972, 14971, 14970, 14969, 13636, 13999, 14199, 16720, 13789, 13643, 13641, 13642, 13675, 13673, 13674, 13676, 13739, 13740, 13683, 13747, 13737, 13738, 13746, 13748, 13749, 13672, 13671, 13680, 13677, 13678, 13679, 13755, 13754, 13756, 13742, 13741, 13743, 13750, 13790, 13745, 13681, 13684, 13685, 16727, 16728, 16729, 16730, 13751, 13682, 7454, 6314, 13783, 4935, 6300, 6301, 6302, 6303, 6304, 6305, 6306, 6307, 6339, 5026, 4938, 29152, 29650, 29651, 29652, 29653, 29654, 29658, 29659, 29660, 29661, 29666, 29667, 29669, 29670, 29671, 29672, 29673, 29674, 29687, 29688, 29689, 29692, 29693, 29694, 29695, 29696, 29697, 29698, 29699, 29700, 29701, 29702, 29705, 29706, 29707, 29709, 29711, 29715, 29716, 29717, 29718, 29719, 29720, 29721, 29722, 29724, 29725, 29729, 29730, 29731, 29732, 29733, 29736, 29737, 29738, 29739, 29740, 29741, 29742, 29747, 29748, 29749, 29750, 29752, 29753, 29754, 29755, 29756, 29757, 29758, 29759, 29761, 29762, 29763, 29764, 29765, 29766, 29767, 29768, 29769, 29770, 29771, 29772, 29775, 29776, 29777, 29779, 29780, 29781, 29782, 29783, 29784, 29785, 29786, 29787, 29788, 29789, 29792, 29793, 29794, 29795, 29796, 29797, 29798, 29799, 29801, 29802, 29803, 34659, 34660, 34661, 34662, 34663, 34665, 34666, 34667, 34668, 34670, 34671, 34672, 34673, 34674, 34675, 34676, 34677, 34678, 34680, 34681, 34682, 34683, 34684, 34685, 34686, 34687, 34688, 4902, 29684, 29683, 29682, 29746, 29745, 29744, 29743, 29676, 29675, 32575, 32577, 32576, 4945, 32585, 32589, 33179, 33170, 33169, 33168, 33167, 33166, 33175, 33174, 33173, 33172, 33171, 29734, 33151, 33082, 33079, 33164, 31097, 31094, 31098, 31066, 5235, 5283, 33080, 29773, 33165, 34679, 29735, 29686, 33391, 29685, 33144, 34658, 34327, 34657, 34328, 29751, 5025, 5024, 29723, 34656, 34655, 29316, 32622, 32578, 33176, 29649, 6009, 29800, 33075, 33077, 12973, 12974, 34664, 33074, 33073, 33076, 33078, 29760, 4899, 4901, 4981, 33156, 29790, 29791, 29774, 4956, 4957, 4958, 33081, 4982, 29704, 29655, 29656, 29657, 29662, 29663, 29664, 29665, 29668, 29677, 29678, 29679, 29680, 29681, 29690, 29703, 29708, 34669, 29778, 31091, 4983, 5040, 6023, 6024, 6145, 4933, 29728, 29726, 29714, 29712, 29727, 29713, 35664, 35663, 35700, 32573, 32574, 29710, 29691, 6508, 36220, 36219, 38519, 38520, 6169, 6168, 40850, 40851, 40852, 40853, 40854, 40855, 40856, 40859, 40867, 40868, 40869, 40870, 40871, 40872, 40873, 40874, 40875, 40876, 40877, 40878, 40879, 40880, 40881, 40882, 40883, 40884, 40885, 40888, 40889, 40890, 40891, 40893, 40894, 40895, 40896, 40897, 40898, 40899, 40900, 40901, 40905, 40906, 40907, 40908, 40909, 40910, 40911, 40912, 40913, 40914, 40915, 40916, 40917, 40918, 40919, 40920, 40921, 40923, 40924, 40925, 40926, 40927, 40928, 40929, 40930, 40931, 40932, 40933, 40934, 40935, 40936, 40937, 40938, 40939, 40940, 40941, 40942, 40943, 40944, 40945, 40948, 40949, 40950, 40951, 40952, 40953, 40954, 40955, 40956, 40957, 40958, 40959, 40962, 44092, 44093, 44094, 44097, 44098, 44099, 44100, 44101, 44102, 44103, 44104, 44105, 44106, 44107, 44108, 44109, 44110, 44111, 44112, 44113, 44114, 44115, 44116, 44117, 44118, 44119, 44120, 44121, 44122, 44123, 44124, 44125, 44126, 44127, 44128, 44129, 44130, 44131, 44132, 44133, 44134, 44135, 44136, 44137, 44138, 44139, 44140, 44141, 44142, 44143, 44144, 44145, 44146, 44147, 44148, 44149, 44150, 44151, 44152, 44153, 44154, 44155, 44156, 44157, 44158, 44159, 44160, 44161, 44162, 44163, 44164, 44165, 44166, 44090, 44089, 44088, 44086, 44087, 43098, 43136, 42967, 42881, 40960, 38709, 38708, 38707, 38706, 38705, 38701, 38682, 38681, 42979, 42916, 42917, 42918, 42929, 42928, 41003, 40985, 39759, 39746, 6144, 34880, 36387, 35705, 35706, 44578, 44579, 44580, 44581, 44635, 44636, 34881, 40892, 40946, 40947, 40857, 40858, 40860, 40861, 40863, 40864, 44095, 44096, 40886, 34884, 35701, 6146, 35702, 40887, 40849, 40848, 40865, 40922, 44712, 44711, 44710, 25878, 25879, 6008, 6010, 6011, 36225, 36226, 6131, 6132, 40961, 40862, 44091, 40866, 40902, 40903, 40904, 48621, 48622, 48623, 48624, 48625, 48627, 48628, 48629, 48632, 48638, 48649, 48650, 48652, 48653, 48657, 48662, 48666, 48673, 48676, 48677, 48678, 48683, 48689, 48691, 48692, 48694, 48695, 48697, 48698, 48700, 48701, 48702, 48703, 48705, 48706, 48711, 48713, 48717, 48718, 48719, 48720, 48722, 48723, 48724, 48725, 48726, 48727, 48728, 48729, 48730, 48731, 48732, 48733, 48736, 48739, 53138, 53141, 53146, 53150, 53163, 53164, 53167, 53168, 53169, 53170, 53171, 53172, 53173, 53180, 53185, 53187, 53189, 53190, 53192, 53193, 53195, 53196, 53198, 53199, 53200, 51825, 53191, 48735, 48734, 53186, 53188, 53139, 53140, 53142, 53143, 53144, 53145, 53147, 53154, 53165, 53155, 53156, 53157, 53158, 53160, 53161, 53162, 53166, 53177, 53174, 53181, 53183, 48333, 53184, 48665, 48667, 48668, 48669, 48670, 48671, 48674, 48675, 48679, 48680, 48681, 48682, 48684, 48685, 48686, 48687, 48688, 48690, 48693, 48696, 48699, 48704, 48707, 48712, 48714, 48708, 48618, 48619, 48620, 48626, 48630, 48631, 48633, 48634, 48635, 48636, 48637, 48639, 48640, 48641, 48642, 48643, 48645, 48646, 48647, 48648, 48651, 48654, 48655, 48656, 48658, 48659, 48660, 48661, 48663, 48664, 53197, 48716, 53351, 50643, 48368, 51714, 51709, 13009, 13010, 25876, 25877, 29146, 29147, 36235, 44230, 44231, 48738, 53153, 53178, 53179, 6019, 6020, 53182, 53152, 53149, 53148, 6013, 6014, 34871, 34873, 35698, 53159, 48721, 48710, 51644, 48672, 34883, 53151, 35697, 34870, 34872, 34889, 36374, 6028, 44202, 48715, 48644, 48266, 6027, 53175, 53176, 48709, 34876, 34877, 34882, 58641, 58642, 58643, 58647, 58650, 58651, 58652, 58653, 58654, 58655, 58656, 58657, 58658, 58659, 58660, 58661, 58662, 58664, 58665, 58666, 58667, 58685, 59442, 59443, 59444, 59445, 59446, 59447, 59448, 59449, 59450, 59457, 59458, 59459, 59460, 59461, 59462, 59463, 59465, 59466, 59467, 59468, 59469, 59470, 59471, 59472, 59473, 59474, 59475, 59476, 59477, 59478, 59479, 59480, 59481, 59482, 59483, 59484, 59486, 59488, 59490, 59491, 59492, 59493, 59494, 59495, 59496, 59497, 59498, 59499, 59500, 59501, 59502, 59503, 59505, 59506, 59507, 59508, 59509, 59514, 59515, 59516, 59517, 59518, 59519, 59520, 59521, 59522, 59523, 59524, 59525, 59526, 59527, 59528, 59529, 59534, 59535, 59536, 59537, 59538, 59539, 59541, 59542, 59543, 58671, 58687, 58688, 58689, 58690, 58673, 58648, 58646, 58686, 58644, 58640, 58639, 58634, 58633, 58672, 58874, 58873, 59563, 59672, 59731, 59781, 59451, 59452, 59453, 59454, 59455, 59456, 58670, 59464, 58632, 6026, 36218, 36223, 36224, 29151, 29153, 6012, 6015, 6025, 6022, 36217, 6149, 58649, 58635, 58636, 58674, 58735, 59805, 59806, 59828, 58675, 58676, 58677, 58678, 58679, 58680, 58681, 59564, 59532, 59533, 59540, 58637, 58683, 58645, 58669, 58663, 34888, 36383, 64384, 35019, 58638, 59530, 58682, 59531, 65129, 65174, 65170, 65115, 65128, 65137, 65138, 65165, 65117, 58684, 58691, 35694, 58201, 58668, 34869, 59489, 6016, 54006, 54007, 6150, 36376, 36375, 59487, 65127, 59485, 35062, 66767, 66768, 66769, 66770, 66772, 66773, 66775, 66777, 66778, 66784, 66786, 66787, 66788, 66865, 66871, 67843, 67844, 67845, 67846, 67847, 67851, 67852, 67856, 67857, 67859, 67861, 67862, 67874, 67877, 67878, 67880, 67881, 67883, 67884, 68466, 68467, 68468, 68469, 68470, 68471, 68472, 68473, 68475, 68476, 68477, 68478, 68479, 68480, 68484, 68485, 68486, 68487, 68488, 68489, 68490, 68493, 68498, 68499, 68502, 68503, 68504, 68505, 68506, 68507, 68508, 68509, 68522, 68525, 68526, 68531, 68532, 68533, 70160, 68528, 68529, 68530, 68655, 69885, 71349, 44717, 65192, 44716, 67868, 54012, 6007, 65126, 48182, 68500, 65193, 67854, 67853, 69051, 69907, 72853, 68474, 68527, 48175, 68518, 68519, 74150, 68513, 68514, 68515, 68516, 68481, 68482, 68483, 68540, 68541, 73186, 4903, 65116, 66867, 65166, 68523, 35703, 35704, 34891, 34892, 38491, 66868, 35063, 48176, 48180, 66870, 73577, 73575, 73580, 73579, 73578, 73576, 73574, 73573, 73572, 73571, 73570, 73569, 65291, 58212, 54023, 54020, 54017, 54018, 54016, 65686, 67873, 48177, 75373, 75375, 75377, 75378, 75379, 75381, 75390, 75391, 75396, 75398, 75399, 75977, 75978, 75979, 75980, 75981, 75982, 75983, 75984, 75985, 75986, 75987, 75988, 75989, 75990, 75991, 75992, 75995, 75996, 75997, 75998, 76002, 76003, 76004, 76005, 76036, 76037, 76790, 64749, 64750, 54009, 34887, 58276, 74727, 66776, 66783, 44715, 44718, 58213, 68654, 66785, 75376, 67867, 77015, 66774, 67858, 75386, 75385, 75384, 75383, 75401, 75382, 67876, 66771, 75392, 75397, 75389, 75395, 75394, 75387, 75393, 67850, 67860, 67849, 66866, 67879, 67875, 66869, 67872, 66782, 67866, 66781, 67865, 66780, 67864, 66779, 67863, 68534, 76023, 68524, 73503, 69890, 73076, 76008, 76007, 76006, 76031, 76030, 76029, 76040, 76028, 76038, 76039, 76022, 76001, 76021, 76000, 76020, 75999, 76019, 76018, 76017, 76016, 76015, 75994, 76014, 76013, 76027, 76035, 76012, 76026, 76034, 76011, 76025, 76033, 76010, 76024, 76032, 76009, 74823, 68497, 68492, 68491, 68512, 69888, 68511, 67882, 75369, 67871, 75370, 35647, 57642, 38507, 48181, 48179, 58200, 45138, 65753, 65754, 65755, 65756, 77282, 65680, 65679, 74725, 74724, 68440, 75366, 75365, 75364, 75363, 68450, 68441, 68451, 68449, 68448, 68447, 68446, 68445, 68439, 68438, 68437, 68436, 68435, 68434, 68433, 68432, 78160, 78161, 78162, 78163, 78164, 78165, 78166, 78216, 78215, 78214, 78213, 78212, 78211, 78210, 78209, 78208, 78207, 78167, 78206, 78205, 78168, 78169, 78204, 78170, 78203, 78202, 78171, 78201, 78200, 78172, 78199, 78173, 78198, 78197, 78174, 78196, 78183, 78195, 78184, 78194, 78185, 78193, 78186, 78192, 78187, 78191, 78188, 78189, 78190, 78182, 78175, 78181, 78176, 78180, 78177, 78179, 78178, 78217, 78218, 78219, 78220, 78221, 78222, 78223, 78224, 78225, 78227, 78228, 78229, 78230, 78231, 78232, 78233, 78234, 78235, 78236, 78237, 78238, 78239, 78240, 78241, 78242, 78243, 78244, 78245, 78246, 78247, 78248, 78249, 78250, 78251, 78252, 78253, 78254, 78255, 78256, 78257, 78258, 78259, 78260, 78261, 78262, 78263, 78264, 78265, 78266, 78267, 78268, 78269, 78270, 78271, 78272, 78273, 77014, 75993, 70705, 70707, 70708, 70709, 70710, 70711, 78276, 78277, 78278, 78279, 78280, 78281, 78282, 78283, 78284, 78285, 78286, 78288, 78292, 78294, 78295, 78290, 78289, 79104, 75203, 78275, 73679, 80039, 80040, 80041, 80043, 80044, 80045, 80046, 80047, 80048, 80049, 80050, 80051, 80055, 80065, 80066, 80067, 80068, 80069, 80070, 80071, 80072, 80073, 80074, 80075, 80076, 80077, 80079, 80080, 80081, 80082, 80083, 80084, 80085, 80086, 80059, 80060, 80061, 80062, 80063, 80064, 80056, 80057, 80428, 80413, 78809, 79807, 79808, 67899, 67904, 67905, 73680, 78226, 75374, 75380, 67848, 78296, 64465, 67886, 78293, 75400, 78274, 78021, 12972, 80042, 68501, 76041, 67869, 65803, 77130, 54008, 54010, 74827, 74177, 54013, 35691, 58202, 12971, 68517, 70706, 29148, 29149, 29150, 54011, 74726, 77283, 77284, 77286, 77285, 77287, 77281, 78023, 78022, 78020, 35690, 73673, 73674, 36356, 58214, 68520, 69887, 82348, 82349, 82350, 82351, 82352, 82361, 82362, 82363, 82364, 82365, 82366, 82367, 82368, 82369, 82370, 82372, 82373, 82654, 82655, 82656, 82657, 82658, 82659, 82660, 82661, 82662, 82664, 82665, 82666, 82667, 82668, 82671, 82672, 82673, 82674, 82675, 83174, 83166, 83167, 67870, 82360, 82359, 82358, 82357, 82354, 82353, 68702, 67885, 67855, 65135, 65187, 78136, 73656, 77689, 73655, 48178, 36357, 83954, 83955, 83956, 83957, 57641, 77225, 82663, 12966, 84014, 77137, 77138, 83929, 82374, 82328, 65678, 65681, 65682, 65683, 78291, 84282, 84283, 83941, 73653, 12967, 81719, 81720, 77690, 73654, 65685, 65684, 83937, 84919, 80644, 80645, 80696, 80699, 80700, 80702, 77688, 77687, 81563, 82355, 82356, 80078, 83173, 83172, 83171, 83170, 83169, 82371, 73661, 86179, 86180, 86181, 86182, 86183, 86184, 86185, 86186, 86187, 86188, 86189, 86190, 86882, 86886, 86887, 86888, 86891, 86894, 86895, 86896, 86897, 86899, 86906, 86908, 86909, 87151, 87150, 87147, 87146, 87148, 87149, 85395, 87175, 87176, 87183, 87184, 73676, 81561, 73659, 73662, 73660, 64615, 85374, 85375, 85373, 74408, 78024, 78025, 78026, 83958, 83959, 83960, 83961, 58258, 85795, 82669, 87908, 87907, 87906, 73529, 77612, 77613, 83928, 64477, 75371, 73567, 65751, 65752, 44232, 44233, 84281, 80701, 73677, 12963, 84944, 88375, 88379, 88380, 88381, 88382, 88384, 88385, 88386, 88389, 88390, 88391, 88392, 88393, 88394, 88395, 88539, 88540, 88543, 88544, 88545, 88546, 88547, 88548, 88549, 88558, 88559, 88560, 88566, 88568, 88569, 88570, 88550, 88551, 88554, 88556, 88557, 88561, 88562, 88563, 88564, 88565, 88567, 89319, 89320, 89325, 88376, 88377, 88378, 86892, 86893, 86889, 86890, 86885, 86884, 86883, 86907, 82670, 80603, 80594, 80592, 80606, 80601, 80053, 80052, 80054, 80590, 80591, 80605, 80599, 80600, 80602, 80604, 88538, 88541, 88374, 88373, 88383, 88387, 88388, 88555, 54019, 85307, 85308, 54022, 81562, 80698, 85210, 88276, 88271, 87442, 6273, 6274, 6272, 36770, 85342, 78287, 73528, 77755, 73527, 77584, 91013, 91012, 65189, 85008, 85009, 91015, 91016, 91017, 91018, 88191, 87693, 87694, 87695, 87696, 87697, 87698, 87699, 81716, 86106, 12962, 91137, 87690, 87691, 91019, 77232, 91021, 91020, 34875, 34874, 73657, 73658, 77611, 77610, 88553, 74719, 88172, 87629, 87926, 85705, 85706, 87692, 84284, 84285, 87700, 73568, 78040, 88542, 91487, 75388, 91647, 91677, 91676, 91739, 91755, 91756, 91757, 91758, 91759, 91760, 91761, 91762, 91763, 91764, 91765, 91796, 91797, 91798, 91799, 91800, 91801, 91802, 91803, 91804, 91805, 91806, 91807, 91808, 91809, 91810, 91811, 87905, 81717, 81718, 81715, 81714, 81713, 88552, 81564, 88269, 94256, 94255, 94292, 94339, 94291, 94290, 94258, 94277, 94257, 88396, 54024, 54021, 81559, 80697, 81560, 73675, 94559, 87851, 73678, 94697, 94696, 94698, 94695, 86102, 94830, 91718, 78042, 78041, 91130, 91522, 91524, 91485, 95137, 95136, 95135, 95138, 80612, 80613, 80607, 80608, 80596, 80597, 80598, 80587, 80616, 80588, 80595, 80589, 80593, 80611, 80609, 80610, 80614, 80617, 80615, 77616, 77617, 84421, 91589, 91592, 91591, 91590, 91004, 91003, 77614, 77615, 77233, 87913, 87914, 95309, 95363, 95362, 94828, 93930, 77223, 77224, 87903, 87904, 91014, 93931, 95609, 95610, 95611, 95612, 95613, 95614, 91066, 94740, 95800, 95801, 95802, 95803, 95804, 95805, 96354, 96355, 96356, 96386, 96387, 96388, 96389, 96390, 96391, 96392, 96393, 97383, 97619, 97618, 65209, 85708, 85707, 94775, 94772, 94596, 94595, 94598, 94599, 86103, 84958, 87425, 98153, 34885, 34886, 73665, 58215, 73666, 57632, 94701, 94699, 94700, 94702, 87407, 87408, 90428, 90427, 90751, 90753, 90752, 90750, 35692, 35693, 35695, 35696, 54080, 95602, 35699, 84518, 84517, 91322, 94858, 94857, 94829, 45144, 74445, 91071, 98631, 98632, 98721, 98722, 98723, 98724, 98725, 98726, 98727, 98728, 98729, 98730, 98731, 98732, 98733, 98734, 99278, 99287, 99288, 99289, 99290, 99291, 99292) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 12 | maybe slow |
