SALE

SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`final_price`, `price_index`.`min_price`, `price_index`.`max_price`, IF((IF(cisi.use_config_manage_stock = 1, 1, cisi.manage_stock) = 1), cisi.is_in_stock, 1) AS `is_saleable`, `cisi`.`is_in_stock` AS `inventory_in_stock`, `cisi`.`backorders` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 2 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 1 AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_entity_varchar` AS `authors_idx` ON `authors_idx`.entity_id = e.entity_id AND `authors_idx`.attribute_id = 142 AND `authors_idx`.store_id = 0 AND `authors_idx`.value in ('3469||Поланік Чак||polanik-chak','8824||Ренберґ Туре||renberg-ture') LEFT JOIN `cataloginventory_stock_item` AS `cisi` ON (cisi.product_id=e.entity_id) LEFT JOIN (SELECT bestseller_stats.product_id AS product_id, SUM(bestseller_stats.qty_ordered - IFNULL(bestseller_stats.qty_canceled, 0)) AS qty_ordered FROM sales_flat_order_item AS bestseller_stats INNER JOIN sales_flat_order AS o ON (o.entity_id = bestseller_stats.order_id AND (o.created_at BETWEEN '2023-05-31' AND '2024-06-01')) AND o.state NOT IN ('pending_payment', 'new', 'canceled') AND o.store_id = 1 GROUP BY bestseller_stats.product_id) AS `bestseller_stats` ON bestseller_stats.product_id = e.entity_id LEFT JOIN `cataloginventory_stock_status` AS `s` ON s.product_id = e.entity_id WHERE (`e`.`entity_id` IN (215, 242, 478, 830, 883, 1074, 1525, 1660, 2098, 2241, 3215, 3256, 3389, 3496, 4272, 4358, 4508, 5016, 5255, 5483, 5494, 5531, 5602, 5606, 5616, 5709, 6152, 6324, 6441, 6547, 6696, 7217, 8548, 8550, 8605, 8873, 9246, 11047, 11052, 11061, 11123, 11203, 11404, 11574, 11931, 13343, 13523, 13673, 13719, 14376, 14377, 14476, 14478, 15106, 15224, 15226, 15393, 15465, 15688, 16559, 16847, 19027, 19419, 19557, 19071, 19128, 18922, 18921, 18920, 18919, 18918, 18380, 18924, 17599, 18241, 19868, 20158, 20176, 20314, 20489, 20510, 20592, 20707, 20876, 21022, 21043, 21130, 21427, 21428, 21429, 21447, 21448, 21577, 21578, 21579, 21580, 21581, 21582, 21583, 21584, 21585, 21586, 21587, 21588, 21589, 21590, 21591, 21592, 21595, 21596, 21597, 21598, 21599, 21600, 21601, 21603, 21604, 21605, 21606, 21607, 21608, 21609, 21610, 21611, 21613, 21614, 21616, 21618, 21619, 21620, 21622, 21623, 21624, 21627, 21628, 21977, 22043, 22826, 26065, 26067, 26439, 28020, 13292, 13295, 13394, 13396, 13397, 13398, 13522, 13525, 13643, 13644, 15221, 15222, 15329, 15330, 19821, 19822, 19824, 20270, 20271, 508, 1341, 1663, 1875, 4302, 4928, 14613, 16087, 16088, 16089, 16466, 20822, 21342, 624, 652, 653, 885, 2158, 17114, 21907, 1625, 2401, 4599, 4771, 6628, 6629, 6884, 6965, 7218, 7734, 7769, 7771, 7901, 9359, 9362, 12209, 12546, 12550, 12988, 13157, 13952, 14125, 14143, 14706, 14707, 15320, 15321, 15322, 15325, 15705, 15750, 15830, 15959, 15960, 15961, 17202, 17204, 17205, 17360, 3914, 4558, 6025, 6679, 6680, 7121, 7122, 8003, 9123, 9124, 10531, 11178, 11179, 11182, 11406, 11408, 11412, 11878, 11880, 11881, 12070, 12531, 12533, 12538, 12712, 13111, 13113, 13120, 13671, 14375, 14376, 14377, 14378, 14379, 14380, 14381, 14625, 14626, 14627, 14629, 14630, 14631, 15135, 15136, 15140, 15141, 15576, 15577, 15589, 15590, 15833, 15834, 15835, 15836, 15837, 15838, 15839, 15840, 15991, 15992, 16343, 17103, 17104, 17105, 17106, 17548, 17550, 17551, 17552, 17553, 17558, 17561, 17572, 3467, 3476, 3478, 3485, 3488, 3492, 3500, 3671, 3672, 3675, 3978, 3981, 4395, 4617, 4981, 5048, 5332, 5352, 5461, 5733, 5736, 6218, 6441, 6941, 6945, 8152, 8157, 11352, 11354, 11357, 11364, 11365, 11872, 12362, 12364, 12365, 12445, 13551, 14492, 14496, 14501, 14502, 14505, 14507, 14508, 14510, 14903, 14905, 16152, 16740, 16744, 16746, 16748, 16749, 16750, 16751, 16754, 17061, 20533, 17406, 17407, 17408, 17409, 17410, 17411, 17412, 17413, 17414, 17415, 17416, 17417, 17418, 17419, 17420, 17421, 17422, 17423, 17424, 17425, 525, 766, 837, 933, 6633, 9396, 11399, 14214, 14530, 14708, 15738, 19520, 418, 580, 768, 943, 1019, 1197, 1217, 1589, 1626, 1880, 2094, 2263, 3515, 3781, 3782, 4405, 6181, 6532, 7153, 7245, 7442, 7945, 8034, 8852, 8869, 10250, 10516, 11767, 11957, 12077, 12094, 12097, 12318, 12525, 12734, 12863, 12867, 13487, 13705, 13904, 14091, 14092, 14093, 14134, 14135, 14136, 14328, 14329, 14330, 14331, 14334, 14335, 14336, 14690, 14691, 14692, 14694, 14695, 14696, 14703, 14704, 14796, 14868, 14870, 15119, 15121, 15293, 15544, 15546, 15604, 15607, 15650, 15698, 15981, 15982, 15983, 15986, 16143, 16326, 16587, 16588, 16590, 16593, 16594, 16922, 16923, 16924, 16928, 17050, 17051, 17158, 17235, 17236, 18745, 18973, 19672, 19674, 21024, 21025, 21026, 7723, 7727, 18418, 18596, 18874, 19938, 19940, 20084, 20441, 21910, 21912, 28022, 14876, 14877, 14880, 14974, 14977, 14979, 14981, 14982, 14983, 14984, 14985, 14986, 14987, 15012, 15014, 15016, 15017, 15018, 15019, 15020, 15023, 15060, 15062, 15064, 15067, 15225, 15228, 15230, 15231, 15235, 15236, 15237, 15238, 15249, 15264, 15504, 15517, 15518, 15519, 15520, 15521, 15522, 15523, 15524, 15525, 15529, 15533, 15534, 15535, 15536, 15537, 15538, 15712, 82, 88, 594, 770, 831, 833, 997, 1020, 1155, 1156, 1174, 1351, 1593, 1944, 2165, 2254, 2262, 2458, 2589, 2590, 2698, 2751, 3106, 3342, 3514, 3698, 4134, 4135, 4476, 5044, 5104, 5105, 5106, 5291, 5662, 6092, 6096, 6098, 6429, 6430, 6641, 7140, 7143, 7146, 7409, 7410, 7414, 7654, 7656, 7658, 7670, 8083, 8611, 8624, 8976, 8982, 8985, 8988, 10451, 10622, 10682, 10684, 11139, 12111, 12112, 12113, 12119, 12121, 12122, 12192, 12194, 12595, 12808, 13533, 13534, 13573, 13574, 13575, 13576, 13675, 13676, 13706, 13708, 13709, 13710, 13711, 13712, 13713, 13714, 13824, 13825, 13826, 13827, 13991, 14083, 14084, 14085, 14086, 14087, 14173, 14470, 14482, 14488, 14595, 14596, 14600, 14601, 14602, 14684, 14685, 14963, 14964, 15415, 15416, 15420, 15427, 16021, 16022, 16233, 16234, 16235, 16236, 16655, 16926, 17181, 17182, 17266, 17267, 17396, 19233, 19273, 19519, 21274, 21289, 21290, 22612, 27324, 27430, 27646, 28037, 28038, 28041, 28042, 28044, 28045, 28046, 28047, 28048, 28049, 28050, 28051, 28052, 28055, 28056, 28057, 28058, 28059, 28060, 28061, 28062, 28063, 28064, 28065, 28067, 28068, 28069, 28070, 28071, 28072, 28074, 28075, 28076, 28077, 28079, 28080, 13829, 19826, 482, 595, 993, 1332, 1333, 1415, 1799, 1909, 2207, 2208, 2470, 3108, 3137, 3138, 3726, 3727, 4225, 4554, 4937, 5311, 6553, 7018, 7156, 7446, 7526, 8612, 9246, 10500, 10507, 11417, 11418, 11419, 11723, 12076, 12615, 13657, 13901, 13902, 14094, 14095, 14749, 14838, 15551, 15826, 15934, 17284, 18628, 18629, 18964, 19230, 19327, 19346, 19348, 19413, 19415, 19561, 19565, 19579, 19580, 19623, 19719, 19720, 20026, 20027, 20282, 20392, 20442, 20448, 20482, 20562, 20563, 20648, 20702, 20703, 20704, 20876, 20878, 20983, 21042, 21280, 21514, 21625, 21640, 21641, 21847, 22440, 22613, 22614, 22615, 25514, 25515, 25516, 26159, 26160, 26452, 26453, 26521, 26577, 26669, 26806, 26807, 26808, 26956, 26957, 27355, 27356, 27357, 27358, 27360, 27417, 27738, 27740, 27770, 27890, 27897, 27898, 27921, 27934)) GROUP BY `e`.`entity_id` ORDER BY CASE WHEN `cisi`.`backorders` = 1 THEN 1 ELSE `s`.`stock_status` END desc, `bestseller_stats`.`qty_ordered` desc, `e`.`entity_id` DESC LIMIT 24