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` <> 73774 AND `Item`.`id` IN (71385, 76555, 76557, 76556, 71384, 71383, 71341, 71340, 71342, 71291, 71330, 71329, 71389, 76558, 76559, 76560, 76770, 76571, 76569, 76568, 76580, 76579, 76578, 76577, 76576, 69716, 69715, 71318, 78106, 78107, 78108, 78111, 78112, 78115, 78122, 78123, 78124, 64655, 80383, 80384, 80385, 80386, 80389, 80390, 80391, 80392, 80393, 80394, 80395, 80396, 80399, 80400, 80413, 69722, 69721, 69714, 69713, 80388, 80387, 76567, 76566, 76565, 76564, 38459, 80397, 80398, 54045, 73583, 45508, 78147, 73584, 77201, 38460, 57720, 38461, 81214, 77115, 74839, 81730, 38456, 82406, 82407, 82408, 82409, 82410, 82411, 82414, 82205, 82202, 81213, 81215, 80402, 80401, 77553, 80640, 84637, 77206, 77207, 54044, 54047, 84292, 77155, 74405, 77169, 85587, 85543, 85544, 85588, 85573, 85574, 85575, 85582, 84553, 84552, 84551, 84550, 84555, 84556, 84554, 84020, 77180, 77174, 64526, 84011, 84963, 84964, 87758, 77170, 77172, 77154, 80627, 84932, 77158, 77156, 77179, 83849, 77160, 74786, 88152, 87792, 88295, 88296, 88297, 88298, 88299, 88300, 88301, 88302, 88303, 88304, 88305, 88306, 88307, 88308, 88309, 88310, 88318, 83897, 88328, 88330, 88331, 88321, 88323, 82413, 82412, 88313, 88312, 78120, 78119, 78118, 78121, 78113, 78117, 78116, 78114, 78104, 78110, 78109, 78105, 86076, 88327, 88329, 88317, 88332, 88320, 88319, 88333, 88322, 88342, 88324, 88325, 88314, 88315, 88326, 88344, 88311, 85294, 81646, 80808, 77175, 77208, 85523, 80775, 85404, 64467, 84291, 80776, 83853, 80768, 80769, 80770, 6079, 6081, 83848, 54062, 54061, 54048, 81621, 81622, 81623, 83838, 83839, 83847, 90371, 81626, 81625, 81624, 83833, 87410, 73650, 73651, 85444, 64486, 91424, 91423, 91422, 91421, 91420, 90330, 80809, 87682, 85295, 85296, 91812, 91813, 91814, 91816, 91817, 91818, 91819, 91820, 91821, 91822, 91823, 91824, 91825, 91826, 91827, 91828, 91829, 91830, 91831, 77181, 87748, 87749, 87750, 87751, 85525, 87679, 87680, 87681, 54059, 80777, 92237, 92238, 77171, 80778, 77200, 81618, 81617, 77159, 77168, 94537, 94536, 94535, 94534, 94564, 94563, 85103, 85685, 85100, 85686, 83858, 81627, 80771, 45507, 88260, 77072, 77074, 77073, 85400, 91062, 88316, 91815, 85055, 85056, 85054, 83834, 83832, 83855, 83854, 84559, 84557, 84558, 84560, 85058, 90397, 81613, 81614, 81615, 81616, 83898, 85107, 64672, 64670, 64671, 85064, 85065, 88185, 88184, 88183, 88182, 88181, 88190, 88186, 88189, 88188, 88187, 88228, 88229, 95189, 83857, 85060, 85059, 85794, 95355, 85057, 85061, 81619, 77161, 90395, 90396, 83856, 95506, 95525, 95524, 95511, 95510, 95529, 95509, 95528, 95508, 95527, 95507, 95526, 80763, 83869, 85038, 80767, 77153, 87722, 87723, 87760, 87759, 58219, 96589, 96590, 96591, 96592, 96593, 96594, 96595, 96596, 96597, 96598, 96599, 96600, 96605, 96606, 96607, 96608, 96609, 96610, 54057, 54056, 54058, 54060, 54043, 54042, 54046, 77157, 97694, 97693, 97614, 97613, 97612, 97696, 97695, 84546, 85106, 85104, 85108, 85105, 80668, 84547, 96601, 96602, 96603, 96604, 91636, 91634, 91635, 91642, 91641, 91640, 90374, 90375, 95223, 95222, 95231, 95232, 95233, 95234, 95235, 95236, 90382, 90383, 90380, 90381, 90792, 90699, 90791, 90794, 90793, 90804, 90702, 90803, 90806, 90805, 91605, 91606, 91607, 35269, 97858, 97896, 97953, 98010, 97857, 97895, 97952, 98009, 97856, 97894, 97951, 98008, 97893, 97950, 97988, 98007, 97892, 97949, 97987, 98006, 97891, 97948, 97986, 98005, 97852, 97871, 97947, 97985, 98004, 97851, 98003, 97850, 97907, 98002, 97906, 98001, 98020, 97905, 98000, 98019, 97866, 97904, 97999, 98018, 97865, 97903, 97998, 98017, 97864, 97902, 97997, 98016, 97863, 97901, 97996, 98015, 97862, 97900, 97995, 98014, 97861, 97956, 97994, 98013, 97860, 97955, 97993, 98012, 97859, 97954, 97992, 98011, 97991, 97990, 97989, 77142, 77143, 77144, 77145, 77146, 77148, 77147, 77149, 83861, 83863, 83862, 83864, 85042, 85044, 85043, 85037, 85035, 85036, 80667, 80665, 80666, 80766, 80764, 80765, 80762, 80760, 80761, 83865, 83868, 83866, 83867, 77152, 77150, 77151, 85049, 85048, 85050, 85047, 85045, 85046, 81630, 81628, 81629, 85053, 85051, 85052, 85670, 85671, 35270, 35578, 35579, 73768, 73769, 73770, 73771, 83835, 83836, 83837, 83840, 83844, 83845, 83846, 83851, 83852, 83841, 83842, 83843, 85067, 85068, 85066, 85063, 85062, 90827, 98128, 95723, 95724, 95725, 95726, 95727, 95728, 95729, 95730, 95731, 95732, 95733, 95734, 95735, 95736, 95737, 95738, 85112, 85109, 85110, 85111, 91632, 91631, 91633, 95211, 95210, 95212, 95214, 95213, 95215, 95217, 95216, 95218, 90390, 90391, 90384, 90385, 90386, 90387, 90388, 90389, 91637, 91638, 91639, 90895, 90392, 90894, 90897, 90896, 90899, 90393, 90898, 90901, 90900, 90903, 90394, 90902, 90905, 90904, 95249, 83859, 95250, 95251, 83860, 95252, 35575, 35576, 35577, 73772, 73773, 73774, 73775, 85162, 85160, 85161, 95684, 95685, 95686, 95687, 95688, 95689, 95690, 95691, 95692, 95693, 95694, 95695, 95696, 95697, 95698, 95699, 95700, 95701, 95702, 95703, 95704, 95705, 95706, 95707, 95708, 95709, 95710, 95711, 90398, 90399, 88193, 88194, 88192, 88196, 88197, 88195, 95245, 90370, 95747, 94346, 94345, 83850, 45524, 84549, 84548, 81620, 98609, 98608, 98606, 98605, 98620, 98619, 98618, 98610, 98550, 98538, 98539, 98540, 98541, 98542, 98543, 98544, 98545, 98546, 98547, 98548, 98549, 98551, 98552, 98553, 98554, 98555, 98556, 98581, 98582, 98583, 98584, 98585, 98586, 98587, 98588, 98589, 98590, 98591, 98592, 98537, 85163, 85102, 85101, 85099, 87872, 87873, 87870, 87871, 98635, 98636, 98637) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 4 | maybe slow |