SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) AS `api_stock_status`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_entity_text` AS `at_api_stock_status_default` ON (`at_api_stock_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_api_stock_status_default`.`attribute_id` = '478') AND `at_api_stock_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_text` AS `at_api_stock_status` ON (`at_api_stock_status`.`entity_id` = `e`.`entity_id`) AND (`at_api_stock_status`.`attribute_id` = '478') AND (`at_api_stock_status`.`store_id` = 1) LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (`e`.`entity_id` NOT IN(45634, 45649, 45660, 45673, 45674, 45675, 45676, 45678, 45679, 45680, 45681, 45682, 45683, 45685, 45696, 45700, 45701, 45724, 45729, 45820, 45821, 45822, 45823, 45826, 45865, 45866, 45867, 45868, 45869, 45870, 45871, 45872, 45902, 45903, 45905, 45906, 45910, 45911, 45912, 45913, 45915, 45917, 45918, 45919, 45922, 45923, 45924, 45925, 45927, 45930, 45935, 45945, 45953, 45957, 45958, 45959, 45960, 45961, 45962, 45963, 45964, 45967, 45969, 45974, 45975, 45979, 45981, 45987, 45988, 45989, 46029, 46038, 46039, 46040, 46041, 46042, 46044, 46045, 46049, 46051, 46054, 46065, 46109, 46116, 46117, 46123, 46124, 46126, 46128, 46130, 46132, 46133, 46141, 46148, 46149, 46150, 46151, 46154, 46155, 46156, 46157, 46159, 46166, 46167, 46178, 46190, 46191, 46380, 46385, 46386, 46388, 46530, 46531, 46534, 46545, 46546, 46547, 46548, 46551, 46554, 46557, 46558, 46561, 46566, 46570, 46571, 46573, 46574, 46575, 46577, 46578, 46579, 46582, 46584, 46585, 46586, 46587, 46589, 46591, 46592, 46594, 46595, 46596, 46597, 46599, 46600, 46601, 46602, 46603, 46604, 46607, 46610, 46611, 46613, 46614, 46615, 46617, 46618, 46620, 46624, 46626, 46630, 46634, 46635, 46637, 46639, 46641, 46642, 46644, 46645, 46646, 46648, 46650, 46651, 46652, 46653, 46655, 46656, 46660, 46662, 46663, 46666, 46667, 46668, 46669, 46858, 46860, 46866, 46876, 46877, 46878, 46879, 46887, 46888, 46889, 46890, 46891, 46893, 46894, 46897, 46898, 46899, 46901, 46911, 46915, 46930, 46934, 46935, 46942, 46944, 46952, 46953, 46954, 46955, 46961, 46962, 46963, 46964, 46965, 46971, 46972, 46974, 46978, 46979, 46980, 46981, 46982, 46983, 46985, 46986, 46987, 46988, 46989, 46990, 46991, 46992, 46993, 46994, 46997, 47000, 47002, 47003, 47004, 47005, 47007, 47008, 47010, 47011, 47013, 47015, 47017, 47020, 47022, 47023, 47030, 47031, 47032, 47033, 47034, 47035, 47036, 47038, 47041, 47046, 47057, 47062, 47067, 47073, 47082, 47116, 47118, 47120, 47121, 47135, 47139, 47151, 47152, 49786, 49787, 49788, 49801, 49803, 49806, 49807, 49808, 49814, 49816, 49817, 49818, 49819, 49820, 49821, 49822, 49823, 49824, 49825, 49826, 49827, 49828, 49829, 49830, 49831, 49832, 49833, 49834, 49835, 49836, 49837, 49838, 49839, 49840, 49841, 49848, 49852, 49853, 49854, 49855, 49856, 49857, 49858, 49859, 49861, 49862, 49864, 49866, 49867, 49868, 49869, 49870, 49871, 49872, 49873, 49874, 49875, 49876, 49877, 49878, 49879, 49880, 49881, 49882, 49883, 49884, 49885, 49886, 49887, 49888, 49889, 49890, 49891, 49893, 49896, 49897, 49898, 49899, 49900, 49901, 49902, 49903, 49904, 49905, 49906, 49907, 49908, 49909, 49910, 49911, 49912, 49913, 49914, 49915, 49916, 49917, 49918, 49919, 49920, 49921, 49922, 49923, 49924, 49925, 49926, 49927, 49928, 49929, 49930, 49931, 49932, 49933, 49934, 49935, 49936, 49937, 49938, 49939, 49940, 49941, 49942, 49943, 49944, 49945, 49946, 49947, 49948, 49949, 49950, 49951, 49952, 49953, 49954, 49955, 49956, 49957, 49958, 49959, 49960, 49961, 49962, 49963, 49964, 49965, 49966, 49967, 49968, 49969, 49970, 49971, 49972, 49976, 49981, 49982, 49983, 49984, 49986, 49987, 49988, 49989, 49990, 49994, 49995, 50010, 50011, 50012, 50013, 50014, 50015, 50016, 50017, 50018, 50019, 50020, 50021, 50022, 50023, 50024, 50025, 50028, 50029, 50030, 50031, 50032, 50033, 50034, 50035, 50036, 50037, 50038, 50039, 50040, 50041, 50042, 50043, 50044, 50045, 50046, 50047, 50048, 50049, 50050, 50051, 50052, 50053, 50054, 50055, 50056, 50057, 50058, 50059, 50060, 50061, 50062, 50063, 50064, 50065, 50066, 50067, 50068, 50069, 50070, 50071, 50072, 50073, 50074, 50075, 50076, 50077, 50078, 50079, 50089, 50093, 50094, 50117, 50118, 50119, 50120, 50121, 50122, 50123, 50124, 50125, 50126, 50127, 50128, 50129, 50130, 50131, 50132, 50133, 50134, 50135, 50136, 50137, 50138, 50139, 50140, 50141, 50142, 50143, 50144, 50145, 50146, 50147, 50148, 50149, 50150, 50151, 50152, 50153, 50154, 50155, 50156, 50157, 50158, 50159, 50160, 50161, 50162, 50163, 50164, 50165, 50166, 50167, 50168, 50170, 50171, 50172, 50173, 50174, 50175, 50176, 50186, 50187, 50189, 50193, 50194, 50195, 50233, 50234, 50244, 50247, 50248, 50249, 50259, 50266, 50269, 50271, 50272, 50274, 50276, 50277, 50278, 50280, 50281, 47187, 47189, 47191, 47193, 47194, 47197, 47198, 47206, 47208, 47229, 47235, 47246, 47280, 47281, 47282, 47300, 47301, 47302, 47303, 47306, 47307, 47309, 47384, 47398, 47399, 47400, 47401, 47402, 47418, 47419, 47420, 47421, 47423, 47425, 47428, 47429, 47430, 47451, 47492, 47527, 47539, 47540, 47543, 47544, 47587, 47588, 47589, 47590, 47600, 47652, 47664, 47679, 47689, 47695, 48742, 48769, 48791, 48792, 48801, 48802, 48803, 48804, 48805, 48807, 48808, 48809, 48810, 48901, 48902, 48904, 48905, 48908, 48923, 48938, 48967, 48986, 48987, 48988, 48989, 48991, 48999, 49002, 49003, 49006, 49007, 49008, 49012, 49013, 49020, 49032, 49034, 49035, 49036, 49037, 49039, 49040, 49041, 49042, 49043, 49044, 49047, 49048, 49049, 49050, 49051, 49052, 49053, 49054, 49055, 49056, 49057, 49058, 49060, 49061, 49062, 49064, 49066, 49069, 49070, 49071, 49073, 49075, 49077, 49079, 49082, 49085, 49086, 49088, 49089, 49091, 49093, 49095, 49097, 49100, 49101, 49102, 49104, 49106, 49107, 49108, 49109, 49111, 49113, 49134, 49135, 49138, 49143, 49144, 49147, 49179, 49182, 49183, 49185, 49187, 49188, 49189, 49192, 49193, 49195, 47698, 47716, 47719, 47720, 47721, 47726, 47728, 47729, 47730, 47731, 47737, 47738, 47740, 47742, 47744, 47749, 47753, 47754, 47755, 47756, 47757, 47758, 47759, 47761, 47762, 47799, 47800, 47890, 47903, 47940, 47941, 47942, 47986, 47987, 47988, 47990, 47991, 47994, 47995, 48004, 48010, 48045, 48051, 48081, 48082, 48083, 48152, 48187, 48212, 48213, 48228, 48229, 48244, 48245, 48252, 48253, 48256, 48257, 48278, 48279, 48280, 48281, 48282, 48283, 48284, 48285, 48303, 48304, 48392, 48393, 48520, 48557, 48559, 48606, 49250, 49251, 49281, 49283, 49284, 49291, 49292, 49293, 49294, 49295, 49296, 49297, 49298, 49337, 49338, 49359, 49363, 49387, 49394, 49396, 49397, 49398, 49400, 49401, 49402, 49403, 49404, 49405, 49410, 49413, 49414, 49415, 49422, 49423, 49424, 49433, 49438, 49439, 49440, 49441, 49444, 49445, 49446, 49447, 49448, 49449, 49450, 49451, 49454, 49456, 49457, 49458, 49459, 49461, 49462, 49463, 49464, 49465, 49466, 49467, 49468, 49471, 49473, 49474, 49475, 49476, 49477, 49478, 49479, 49480, 49481, 49482, 49483, 49484, 49485, 49486, 49487, 49488, 49489, 49491, 49492, 49494, 49495, 49497, 49498, 49500, 49501, 49503, 49504, 49505, 49506, 49507, 49508, 49509, 49510, 49512, 49513, 49514, 49515, 49518, 49519, 49520, 49521, 49522, 49523, 49524, 49525, 49526, 49527, 49528, 49529, 49530, 49531, 49532, 49533, 49534, 49535, 49536, 49537, 49538, 49539, 49540, 49541, 49543, 49544, 49545, 49546, 49547, 49548, 49549, 49550, 49551, 49552, 49553, 49554, 49555, 49557, 49558, 49559, 49560, 49561, 49562, 49563, 49565, 49566, 49567, 49568, 49569, 49570, 49571, 49573, 49574, 49575, 49576, 49577, 49578, 49579, 49580, 49581, 49582, 49583, 49584, 49585, 49586, 49587, 49588, 49589, 49590, 49591, 49592, 49593, 49594, 49595, 49596, 49597, 49598, 49599, 49600, 49602, 49603, 49604, 49605, 49606, 49607, 49608, 49609, 49610, 49611, 49612, 49613, 49614, 49615, 49616, 49617, 49618, 49619, 49620, 49621, 49622, 49623, 49624, 49631, 49632, 49633, 49635, 49636, 49637, 49641, 49642, 49643, 49644, 49645, 49646, 49647, 49653, 49661, 49666, 49667, 49668, 49670, 49676, 49677, 49678, 49679, 49680, 49681, 49690, 49691, 49692, 49693, 49694, 49695, 49696, 49697, 49698, 49700, 49701, 49747, 49772, 49774, 47182, 47183, 49203, 49210, 49233, 54862, 54877, 54880, 54885, 54899, 54942, 54977, 54982, 55014, 55071, 55133, 55155, 55163, 55176, 55202, 55228, 55229, 55235, 55249, 55254, 55257, 55298, 55300, 55342, 55381, 55944, 55961, 55995, 55998, 55999, 56004, 56014, 56026, 56036, 56049, 56067, 56123, 56125, 56135, 56157, 56165, 56166, 56167, 56168, 56169, 56170, 56171, 56173, 56178, 56185, 56186, 56187, 56188, 56190, 56195, 56197, 56198, 56199, 56200, 56201, 56203, 56204, 56206, 56213, 56228, 56234, 56247, 56254, 56268, 56273, 56275, 56276, 56277, 56289, 56307, 56308, 56327, 56328, 56344, 56345, 56363, 56379, 56382, 56384, 56385, 56387, 56391, 56398, 56401, 56405, 56440, 56451, 56452, 56453, 56461, 56478, 56479, 56482, 56493, 56519, 56524, 56539, 56540, 56542, 56543, 56544, 56545, 56546, 56582, 56583, 56584, 56590, 56596, 56657, 56663, 56678, 56689, 56690, 56691, 56694, 56711, 56713, 56716, 56720, 56722, 56723, 56724, 56725, 56726, 56727, 56728, 56729, 56736, 56737, 56746, 56747, 56779, 56795, 56799, 56802, 56804, 56818, 56827, 56860, 56864, 56865, 56880, 56884, 56913, 56914, 56916, 56917, 56918, 56919, 56943, 56956, 56957, 56958, 56959, 56960, 56961, 56962, 56963, 56981, 56985, 57000, 57001, 57002, 57003, 57004, 57009, 57010, 57013, 57017, 57018, 57019, 57020, 57021, 57022, 57023, 57024, 57025, 57026, 57027, 57028, 57038, 57040, 57045, 57046, 57047, 57060, 57095, 57105, 57122, 58641, 58642, 58643, 58644, 58649, 58651, 58652, 58653, 58662, 58663, 58664, 58665, 58666, 58667, 58669, 58670, 58671, 58672, 58673, 58674, 58675, 58676, 58677, 58678, 58679, 58680, 58681, 58683, 58684, 58685, 58686, 58687, 58695, 58696, 58698, 58699, 58708, 58710, 58711, 58712, 58713, 58714, 58715, 58716, 58717, 58718, 58719, 58720, 58721, 58722, 58723, 58724, 58725, 58726, 58727, 58728, 58729, 58730, 58731, 58732, 58733, 58734, 58735, 58736, 58737, 58738, 58739, 58740, 58741, 58750, 58756, 58764, 58773, 58774, 58775, 58776, 58777, 58785, 58792, 58796, 58803, 58804, 58807, 58810, 58813, 58816, 58835, 58852, 58853, 58855, 58856, 58858, 58859, 58860, 58861, 58862, 58863, 58864, 58866, 58867, 58872, 58873, 58878, 58879, 58880, 58881, 58883, 58886, 58888, 58902, 58903, 58909, 58910, 58911, 58920, 58922, 58931, 58932, 58934, 58938, 58942, 58943, 58944, 58949, 58950, 58951, 58953, 58954, 58957, 58958, 58959, 58961, 58962, 58963, 58964, 58971, 58973, 58977, 58978, 58979, 58981, 58983, 58984, 58985, 58991, 58992, 58993, 58994, 58995, 58997, 58998, 58999, 59001, 59002, 59005, 59006, 59008, 59009, 59010, 59011, 59012, 59013, 59014, 59015, 59016, 59017, 59018, 59020, 59021, 59022, 59023, 59024, 59025, 59026, 59027, 59028, 59029, 59030, 59031, 59032, 59034, 59047, 59085, 59125, 59136, 59149, 59150, 59151, 58161, 58162, 58165, 58176, 58192, 58202, 58220, 58228, 58230, 58243, 58251, 58252, 58256, 58263, 58266, 58267, 58270, 58271, 58272, 58273, 58276, 58277, 58286, 58289, 58290, 58296, 58298, 58301, 58302, 58304, 58307, 58308, 58321, 58324, 58325, 58331, 58334, 58335, 58344, 58345, 58347, 58349, 58354, 58355, 58357, 58368, 58372, 58373, 58374, 58375, 58377, 58378, 58379, 58380, 58381, 58382, 58383, 58384, 58385, 58386, 58387, 58388, 58390, 58392, 58394, 58395, 58396, 58397, 58398, 58400, 58402, 58403, 58405, 58406, 58407, 58408, 58411, 58412, 58413, 58417, 58418, 58419, 58420, 58421, 58426, 58433, 58436, 58442, 58443, 58445, 58446, 58452, 58456, 58457, 58459, 58460, 58472, 58473, 58474, 58475, 58476, 58478, 58479, 58480, 58481, 58482, 58485, 58486, 58488, 58489, 58490, 58497, 58501, 58503, 58504, 58506, 58508, 58512, 58518, 58519, 58520, 58525, 58526, 58527, 58532, 58534, 58536, 58538, 58539, 58544, 58547, 58553, 58554, 58558, 58561, 58573, 58574, 58575, 58580, 58588, 58590, 58591, 58598, 58599, 58602, 58606, 58608, 58610, 58622, 58623, 58625, 58626, 58627, 58628, 58629, 58632, 58639, 58640, 57124, 57125, 57126, 57127, 57128, 57129, 57130, 57136, 57138, 57139, 57140, 57141, 57142, 57143, 57144, 57145, 57146, 57147, 57148, 57149, 57151, 57152, 57155, 57156, 57157, 57158, 57159, 57160, 57163, 57164, 57165, 57166, 57167, 57168, 57169, 57170, 57171, 57172, 57173, 57174, 57175, 57176, 57178, 57179, 57180, 57181, 57182, 57183, 57184, 57185, 57186, 57187, 57188, 57189, 57190, 57192, 57193, 57195, 57196, 57197, 57198, 57199, 57200, 57202, 57203, 57205, 57206, 57207, 57208, 57209, 57210, 57211, 57212, 57213, 57214, 57215, 57216, 57217, 57218, 57219, 57220, 57221, 57222, 57223, 57224, 57225, 57226, 57227, 57228, 57229, 57230, 57231, 57232, 57234, 57235, 57236, 57237, 57245, 57246, 57247, 57250, 57251, 57253, 57267, 57380, 57460, 57461, 57462, 57463, 57464, 57471, 57472, 57473, 57481, 57483, 57492, 57493, 57494, 57495, 57496, 57497, 57498, 57499, 57500, 57501, 57502, 57503, 57504, 57505, 57506, 57507, 57508, 57509, 57510, 57511, 57512, 57513, 57514, 57525, 57526, 57527, 57528, 57529, 57530, 57547, 57557, 57574, 57575, 57576, 57579, 57580, 57581, 57583, 57584, 57585, 57587, 57589, 57606, 57607, 57608, 57609, 57610, 57611, 57615, 57616, 57619, 57620, 57621, 57622, 57623, 57624, 57625, 57627, 57628, 57629, 57630, 57632, 57633, 57634, 55393, 55402, 55414, 55418, 55465, 55488, 55499, 55513, 55527, 55537, 55538, 55546, 55549, 55550, 55604, 55619, 55621, 55622, 55623, 55626, 55647, 55651, 55652, 55654, 55655, 55660, 55668, 55670, 55702, 55705, 55710, 55716, 55717, 55718, 55719, 55723, 55730, 55740, 55741, 55827, 55907, 55908, 55927, 55929, 57637, 57638, 57644, 57645, 57646, 57647, 57749, 57750, 57759, 57777, 57779, 57780, 57781, 57782, 57783, 57784, 57785, 57786, 57787, 57788, 57789, 57790, 57791, 57792, 57793, 57794, 57795, 57796, 57797, 57798, 57799, 57800, 57827, 57828, 57829, 57830, 57831, 57858, 57859, 57860, 57861, 57870, 57871, 57872, 57873, 57874, 57876, 57877, 57886, 57887, 57888, 57889, 57890, 57891, 57892, 57893, 57894, 57895, 57896, 57897, 57898, 57899, 57901, 57902, 57903, 57904, 57905, 57910, 57914, 57921, 57924, 57929, 57952, 57955, 57956, 57957, 57965, 57973, 57974, 57979, 57983, 57984, 57985, 57986, 57987, 57992, 57993, 57995, 57996, 57997, 58029, 58032, 58049, 58050, 58051, 58052, 58053, 58054, 58055, 58056, 58063, 58065, 58066, 58067, 58068, 58076, 58077, 58078, 58079, 58080, 58081, 58084, 58085, 58086, 58087, 58089, 58094, 58097, 58099, 58100, 58105, 58123, 58124, 58126, 58134, 58136, 56558, 64484, 64485, 64620, 64621, 64622, 64641, 64649, 64650, 64664, 64665, 64668, 64669, 64670, 64673, 64674, 64732, 64819, 64933, 64935, 64997, 64998, 65020, 65039, 65073, 65097, 65098, 65123, 65140, 65146, 65224, 65225, 65226, 65227, 65228, 65229, 65230, 65231, 65232, 65321, 65322, 65325, 65326, 65328, 65329, 65330, 65331, 65413, 65415, 65416, 65549, 65584, 65585, 65586, 65587, 65588, 65589, 65594, 65599, 65625, 65627, 65634, 65642, 65643, 65694, 65695, 65696, 65697, 65698, 65699, 65700, 65701, 65702, 65703, 65721, 65726, 65729, 65733, 65740, 65743, 65744, 65768, 65784, 65814, 65819, 65827, 65829, 65830, 65838, 65844, 65878, 65880, 65891, 65905, 65906, 65925, 65952, 65958, 65972, 65973, 65974, 65975, 65978, 65979, 65980, 65984, 65994, 65995, 65996, 66009, 66011, 66012, 66019, 66020, 66021, 66022, 66023, 66024, 66025, 66026, 66027, 66028, 66029, 66030, 66031, 66032, 66042, 66062, 66063, 66064, 66077, 66084, 66085, 66086, 66087, 66111, 66132, 66218, 66223, 66235, 66236, 66241, 66250, 66360, 66378, 66380, 66389, 66462, 66469, 66470, 66472, 66498, 66514, 66516, 66517, 66556, 66670, 66692, 66699, 66791, 66853, 66890, 66901, 66931, 66933, 66942, 66943, 66949, 66966, 66972, 67100, 67151, 67201, 67218, 67252, 67365, 67376, 67377, 67393, 67409, 67410, 67445)) AND (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (IF(at_api_stock_status.value_id > 0, at_api_stock_status.value, at_api_stock_status_default.value) != 'not available') AND (e.entity_id IN (46297, 46288, 46278, 46277, 46268, 46259, 46250, 46241, 46232, 46223, 46214, 46205, 46196, 45324, 45315, 45306, 45297, 45288, 45279, 45268, 45259, 45250, 45241, 45232, 45223, 45214, 45205, 45196, 45180)) ORDER BY FIELD(e.entity_id,46297,46288,46278,46277,46268,46259,46250,46241,46232,46223,46214,46205,46196,45324,45315,45306,45297,45288,45279,45268,45259,45250,45241,45232,45223,45214,45205,45196,45180)