| 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` <> 74210 AND `Item`.`id` IN (62076, 62075, 62074, 62073, 62093, 62072, 62092, 62071, 62091, 62114, 62112, 62111, 62110, 62130, 62085, 62109, 62129, 62084, 62108, 62128, 62148, 62127, 62193, 50893, 50898, 50897, 50896, 50895, 50894, 25887, 44209, 45533, 45541, 62107, 62122, 62123, 62124, 62125, 62126, 35240, 62115, 62116, 62117, 62194, 36766, 35215, 62113, 35241, 62192, 71187, 71188, 71189, 71230, 71231, 71232, 71233, 71235, 71094, 71191, 71192, 71193, 71194, 71195, 71196, 71197, 71198, 71199, 71200, 71234, 71088, 35242, 35173, 35200, 35205, 35213, 35216, 45525, 35218, 71089, 45528, 45535, 71093, 71156, 71157, 71151, 71152, 71153, 74201, 74203, 74205, 74206, 74208, 74210, 74212, 74213, 74215, 74217, 74219, 74220, 74221, 74225, 74226, 74227, 74229, 74230, 74231, 74234, 74238, 74239, 74240, 74241, 74256, 74257, 74259, 74262, 74263, 74264, 74268, 74269, 74271, 74273, 74275, 74276, 74280, 74281, 74282, 74283, 74242, 74247, 74245, 74243, 74249, 74252, 74251, 74250, 71092, 35182, 35183, 35208, 45538, 35214, 35206, 74406, 71190, 35174, 35186, 35201, 35204, 35207, 65066, 73606, 74456, 35176, 35175, 45515, 45536, 57745, 45537, 35203, 71095, 71155, 35185, 44655, 35202, 74838, 79207, 73040, 73039, 73034, 73033, 73032, 57744, 44654, 74455, 73605, 57734, 77193, 54040, 44653, 35184, 77629, 57729, 73703, 81232, 81233, 77195, 73715, 58353, 77619, 57727, 77626, 77630, 57724, 71174, 71173, 71175, 78895, 71170, 71169, 71172, 71171, 71182, 71181, 78894, 71184, 71183, 71186, 71185, 71180, 73705, 45534, 54041, 84320, 77620, 84633, 84632, 84631, 57725, 57728, 57726, 84294, 73706, 73713, 77622, 77618, 45531, 84293, 77621, 85336, 85658, 84975, 84976, 84967, 84965, 35181, 77192, 85542, 85570, 85571, 85572, 73697, 82244, 73716, 73711, 83762, 73701, 77194, 84981, 84966, 74451, 54039, 78893, 78892, 73694, 77623, 73712, 77625, 73702, 64744, 74448, 73699, 83760, 57738, 73700, 57737, 57735, 73710, 84912, 88731, 88732, 88733, 88734, 88735, 88736, 88737, 88715, 74233, 74232, 74228, 74255, 74254, 74253, 74207, 74274, 74272, 74270, 74237, 74236, 74235, 74279, 74278, 74277, 74267, 74266, 74265, 74204, 74202, 74200, 74218, 74216, 74214, 74261, 74260, 74258, 74244, 74248, 74246, 74224, 74223, 74222, 85380, 83761, 78043, 78044, 6075, 81668, 85335, 87761, 73707, 6069, 74211, 74209, 35344, 86077, 83763, 58346, 81673, 84312, 84311, 84310, 6068, 90708, 90707, 90706, 90705, 45529, 85663, 91410, 91419, 91409, 91418, 91408, 91417, 91407, 91416, 91406, 91415, 91405, 91414, 91404, 91413, 91403, 91412, 91402, 91411, 85647, 84309, 74449, 81669, 73714, 73717, 73709, 73708, 91490, 83765, 91766, 91774, 91775, 91776, 91777, 91778, 91779, 91780, 58351, 85757, 84295, 84296, 86027, 77176, 85653, 85655, 85654, 90451, 92276, 84446, 94375, 92275, 87360, 87359, 84447, 94380, 94379, 94378, 94377, 94376, 87357, 87358, 84449, 87364, 87948, 87946, 87947, 87950, 87949, 87746, 87745, 87744, 87747, 84448, 83764, 77628, 85652, 85649, 85646, 57736, 73698, 73685, 73704, 85659, 85660, 94533, 94531, 94530, 94532, 45516, 45539, 45518, 87362, 83757, 83758, 6074, 85651, 85650, 77177, 84905, 88154, 85648, 87864, 87865, 91702, 91703, 91704, 91708, 91709, 91710, 87341, 87337, 87338, 87339, 87340, 77627, 77624, 87361, 87363, 36247, 85656, 85657, 83759, 73691, 44678, 35343, 65313, 44664, 65309, 95505, 95504, 95503, 95502, 95497, 95496, 95495, 95494, 81667, 95812, 95813, 95814, 95815, 95816, 95817, 95818, 96357, 96358, 96359, 96360, 85334, 58355, 58354, 58344, 58345, 81670, 81671, 81672, 58349, 58350, 58348, 58347, 84317, 84318, 84319, 94281, 94280, 97687, 97686, 97703, 97702, 97701, 97700, 77178, 73688, 85661, 97810, 97809, 90372, 90373, 90378, 90379, 95205, 95206, 91711, 91712, 91713, 91714, 91715, 91716, 95256, 84453, 95257, 85672, 95258, 95259, 84454, 95260, 85673, 95261, 95262, 84455, 95263, 85674, 95264, 95265, 90703, 95266, 90704, 95267, 95268, 95269, 95270, 95271, 95272, 95273, 95274, 81636, 95253, 95254, 95255, 97877, 97915, 97972, 97876, 97914, 97971, 97913, 97855, 97912, 97854, 97911, 97853, 97910, 97909, 97908, 97984, 97983, 97887, 97982, 97867, 97886, 97981, 97885, 97980, 97884, 97979, 97883, 97978, 97882, 97977, 97881, 97976, 97880, 97975, 97879, 97917, 97974, 97878, 97916, 97973, 85540, 85541, 85539, 85538, 85537, 85535, 85534, 85536, 58236, 58235, 65296, 65297, 65298, 58234, 58233, 58231, 58232, 58222, 35306, 35312, 35307, 35305, 65359, 65360, 65361, 35311, 35310, 35304, 81633, 81634, 81632, 81631, 81635, 85033, 85034, 64681, 35260, 44707, 80651, 80650, 80648, 80649, 80652, 84458, 84456, 84457, 84459, 84462, 84460, 84461, 84463, 84466, 84464, 84465, 84467, 64683, 35230, 35231, 64682, 35232, 35233, 35274, 35574, 73683, 73684, 35178, 35179, 35180, 73686, 73687, 35188, 35189, 35190, 35243, 35244, 73689, 73690, 35245, 57747, 35252, 73692, 73693, 35253, 57748, 35254, 73695, 73696, 35255, 90832, 90834, 90835, 90831, 90833, 90829, 90830, 98150, 90839, 98166, 98165, 90841, 90842, 90838, 90840, 90836, 90837, 44680, 44681, 65314, 44679, 65312, 44677, 44667, 44666, 44668, 65311, 44669, 44665, 65310, 44663, 85085, 85082, 85083, 85086, 85084, 57731, 57732, 57733, 57730, 85090, 85087, 85088, 85089, 98422, 98607, 87326, 87324, 87323, 87325, 87868, 87869, 87866, 87867, 87942, 87943, 87944, 87945, 98627, 98628, 99305, 99306, 99307, 99308, 99309, 99310, 99311) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 5 | maybe slow |
