| 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` <> 91529 AND `Item`.`id` IN (71563, 71590, 71589, 71548, 71546, 71545, 71544, 71543, 71583, 71582, 71541, 71581, 71539, 71579, 71538, 71578, 71537, 71577, 71576, 71535, 71575, 71572, 71571, 71529, 71569, 71528, 71568, 71526, 71606, 71600, 71601, 71603, 71604, 71605, 71607, 71609, 71562, 71561, 71560, 71518, 71517, 71592, 71591, 68922, 68923, 68925, 68924, 69089, 69090, 71547, 71540, 71580, 71536, 71534, 71574, 71573, 71570, 71525, 65204, 71593, 71521, 71520, 71519, 71522, 57669, 57668, 57667, 71608, 71559, 70236, 70235, 73937, 73936, 71556, 65317, 71602, 65349, 57670, 73819, 74198, 35153, 71594, 73522, 57665, 65332, 74833, 71549, 74988, 74989, 74990, 74991, 74992, 74993, 74994, 74995, 74996, 74997, 74998, 74999, 75000, 75001, 75002, 75003, 75004, 75005, 75006, 75007, 75008, 75009, 75010, 75011, 75012, 75013, 75014, 75015, 75016, 75017, 75018, 75019, 75021, 75022, 75024, 75025, 75026, 75027, 75028, 75029, 75030, 75031, 75032, 75033, 75034, 75035, 75036, 75037, 75038, 75039, 75040, 69088, 71523, 69879, 58192, 71566, 71567, 71565, 65333, 71624, 75023, 38496, 65206, 71550, 71551, 71552, 71553, 71554, 71555, 77566, 77120, 78608, 78609, 78610, 78611, 78612, 78613, 78614, 78615, 78616, 78617, 78619, 78628, 78629, 78630, 78631, 78632, 78633, 78635, 78636, 78637, 78638, 78639, 78640, 78641, 78642, 78643, 78644, 78645, 78647, 78651, 78652, 78653, 78654, 78655, 78656, 78657, 78658, 78618, 78620, 78621, 78622, 78623, 78624, 78625, 78626, 78627, 78634, 78648, 78649, 78650, 71558, 71530, 71531, 77086, 64588, 64587, 64586, 77125, 68926, 75020, 77126, 71564, 73823, 81134, 80630, 82160, 82161, 82162, 82163, 82164, 82165, 82166, 82167, 82168, 82169, 82170, 82171, 82172, 82173, 82174, 82175, 82176, 82177, 82178, 82179, 82180, 82181, 82182, 82183, 82184, 82185, 82186, 82187, 82188, 82189, 82192, 82194, 82195, 82196, 64591, 64590, 64589, 64594, 64593, 64592, 35151, 81133, 73821, 35152, 65205, 81135, 81130, 71524, 83916, 73538, 71597, 71595, 71596, 73822, 73539, 80631, 81132, 77124, 85379, 82190, 82191, 82193, 86209, 86210, 86211, 86212, 86213, 86214, 86215, 86216, 86217, 86218, 86219, 86220, 86221, 86222, 86223, 86224, 86225, 86226, 86227, 86228, 86229, 86230, 86231, 86232, 86233, 86234, 86753, 86754, 86755, 86756, 86757, 86758, 86759, 86760, 86761, 86762, 86763, 86764, 86765, 86766, 84021, 87116, 87117, 87118, 87119, 87120, 87121, 87123, 87124, 87373, 87372, 87371, 58193, 84218, 84387, 84388, 84389, 84390, 84386, 84391, 73536, 73537, 83947, 81131, 80629, 78646, 84024, 85410, 85522, 85521, 88573, 88574, 88575, 88576, 88577, 88578, 88579, 88580, 88581, 88582, 88583, 88584, 88585, 88586, 88587, 88590, 88591, 88592, 88593, 88596, 88597, 88598, 88602, 88603, 88588, 88571, 88572, 71527, 71542, 71557, 88594, 88595, 90339, 83946, 87268, 83948, 87265, 87266, 90343, 90344, 90345, 90342, 86236, 86235, 88599, 88600, 88601, 87125, 87122, 73824, 73825, 85002, 85003, 90764, 90766, 90765, 64475, 85443, 90340, 84392, 84395, 84393, 84394, 91529, 91528, 92385, 92386, 92387, 92388, 92389, 92390, 92391, 92392, 92393, 92394, 92395, 92396, 92397, 92398, 92399, 92400, 92401, 92402, 92403, 92404, 92405, 92406, 92407, 92408, 92409, 92410, 92411, 92412, 92413, 92414, 92415, 92416, 92417, 92418, 92419, 92420, 92421, 92422, 92423, 92424, 92425, 92426, 92427, 92428, 92429, 92430, 92431, 92432, 92433, 92434, 92435, 92436, 92437, 92438, 92439, 58371, 58370, 58372, 58369, 77565, 83915, 83914, 83949, 71533, 71532, 84998, 91531, 91533, 91535, 91537, 91532, 91534, 91536, 91538, 85408, 85409, 87269, 88589, 84988, 84987, 84990, 95389, 95388, 95390, 95615, 95616, 95617, 95788, 95789, 95790, 96531, 96532, 96533, 96534, 96535, 96536, 96537, 96538, 96539, 96540, 96541, 96542, 96543, 96544, 96545, 96546, 96547, 93983, 84989, 97685, 97684, 97683, 97682, 95386, 93984, 95384, 87267, 91530, 95387, 84962, 91672, 91671, 91673, 91668, 91667, 91669, 91670, 77218, 77217, 64597, 64595, 64596, 73818, 73820, 84996, 84997, 84994, 84995, 85000, 85001, 84999, 84992, 84993, 84991, 88171, 95590, 95589, 95588, 95587, 95593, 95594, 95592, 95591, 98657, 98658, 98659, 98660, 98661, 98662, 99629, 99630, 99631, 99632, 99633, 99634, 99635, 99636, 99637, 99638, 99639, 99640, 99641, 99642, 99643, 99644, 99645, 99646, 99647, 99648, 99649) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 3 | maybe slow |
