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` <> 35699 AND `Item`.`id` IN (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, 4945, 32585, 33170, 33169, 33168, 33167, 33166, 33175, 33174, 33173, 33172, 33171, 29734, 33151, 33082, 33079, 33164, 33080, 29773, 33165, 34679, 29686, 29685, 33144, 34658, 34327, 34657, 34328, 29751, 34656, 34655, 29316, 33176, 33075, 33077, 34664, 33074, 33073, 33076, 33078, 4899, 4901, 4981, 33156, 33081, 4982, 29677, 29678, 29679, 29680, 29681, 34669, 4983, 5040, 6145, 35664, 35663, 35700, 6508, 6169, 6168, 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, 40960, 41003, 40985, 39759, 39746, 6144, 35705, 35706, 44635, 44636, 44095, 44096, 35701, 6146, 35702, 44091, 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, 53191, 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, 53197, 48716, 53351, 50643, 48368, 51714, 51709, 53153, 53178, 53179, 53182, 53152, 53149, 53148, 35698, 53159, 51644, 53151, 35697, 44202, 48266, 53175, 53176, 58641, 58642, 58643, 58647, 58650, 58651, 58652, 58653, 58654, 58655, 58656, 58657, 58658, 58659, 58660, 58661, 58662, 58664, 58665, 58666, 58667, 58685, 58671, 58687, 58688, 58689, 58690, 58673, 58648, 58646, 58686, 58644, 58640, 58639, 58634, 58633, 58672, 58874, 58873, 59731, 58670, 58632, 6149, 58649, 58635, 58636, 58674, 58735, 59805, 59806, 59828, 58675, 58676, 58677, 58678, 58679, 58680, 58681, 58637, 58683, 58645, 58669, 58663, 58638, 58682, 58684, 58691, 35694, 58201, 58668, 6150, 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, 67868, 54012, 67854, 67853, 68474, 4903, 66867, 35703, 35704, 66868, 66870, 73577, 73575, 73580, 73579, 73578, 73576, 73574, 73573, 73572, 73571, 73570, 73569, 67873, 75373, 75375, 75377, 75378, 75379, 75381, 75390, 75391, 75396, 75398, 75399, 54009, 66776, 66783, 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, 67882, 75369, 67871, 75370, 35647, 58200, 45138, 65753, 65754, 65755, 65756, 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, 70705, 70707, 70708, 70709, 70710, 70711, 78276, 78277, 78278, 78279, 78280, 78281, 78282, 78283, 78284, 78285, 78286, 78288, 78292, 78294, 78295, 78290, 78289, 78275, 80056, 80057, 78809, 78226, 75374, 75380, 67848, 78296, 67886, 78293, 75400, 78274, 67869, 54008, 54010, 54013, 35691, 58202, 70706, 54011, 35690, 82348, 82349, 82350, 82351, 82352, 82361, 82362, 82363, 82364, 82365, 82366, 82367, 82368, 82369, 82370, 82372, 82373, 83174, 83166, 83167, 67870, 82360, 82359, 82358, 82357, 82354, 82353, 68702, 67885, 67855, 65135, 82374, 82328, 78291, 81719, 81720, 82355, 82356, 83173, 83172, 83171, 83170, 83169, 82371, 86179, 86180, 86181, 86182, 86183, 86184, 86185, 86186, 86187, 86188, 86189, 86190, 87183, 87184, 58258, 75371, 73567, 65751, 65752, 12963, 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, 88538, 88541, 88555, 6273, 6274, 6272, 36770, 85342, 78287, 73528, 77755, 73527, 77584, 87693, 87694, 87695, 87696, 87697, 87698, 87699, 81716, 86106, 12962, 88553, 74719, 87700, 73568, 78040, 88542, 75388, 91796, 91797, 91798, 91799, 91800, 91801, 91802, 91803, 91804, 91805, 91806, 91807, 91808, 91809, 91810, 91811, 81717, 81718, 81715, 81714, 81713, 88552, 78042, 78041, 91485, 95137, 95138, 91004, 91003, 95609, 95610, 95611, 95612, 95613, 95614, 95800, 95801, 95802, 95803, 95804, 95805, 96354, 96355, 96356, 35692, 35693, 35695, 35696, 54080, 95602, 35699, 84518, 84517, 45144, 74445, 98631, 98632, 99278) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 4 | maybe slow |