Home & Garden

SQL Query:

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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock`.`stock_status`, `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'
 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'))
 LEFT JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id AND stock.website_id = 0
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (3116, 11974, 846, 849, 1998, 2043, 2046, 2049, 2051, 2053, 2057, 2059, 2061, 2065, 2066, 2073, 2074, 2076, 2078, 2080, 2081, 2082, 2084, 2085, 2088, 2344, 2346, 2347, 2350, 2353, 2354, 2356, 2358, 2359, 2360, 2361, 2363, 2364, 2365, 2366, 2367, 2368, 2370, 2371, 2373, 2374, 2377, 2379, 2380, 2381, 2383, 2386, 2389, 2392, 2393, 2394, 2396, 2397, 2398, 2399, 2402, 2403, 2404, 2405, 2406, 2408, 2409, 3071, 3072, 3085, 3093, 3099, 3100, 3101, 3102, 3105, 3106, 3107, 3110, 3111, 3112, 3113, 3114, 3115, 3117, 11956, 11957, 11958, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11966, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 13279, 13400, 14633, 14741, 19014, 20802, 23561, 24598, 1129, 1128, 1164, 26, 1167, 1269, 1174, 1173, 1175, 1193, 1192, 1180, 1130, 1138, 1165, 1166, 1172, 1177, 1179, 1176)) ORDER BY FIELD(e.entity_id,3116,11974,846,849,1998,2043,2046,2049,2051,2053,2057,2059,2061,2065,2066,2073,2074,2076,2078,2080,2081,2082,2084,2085,2088,2344,2346,2347,2350,2353,2354,2356,2358,2359,2360,2361,2363,2364,2365,2366,2367,2368,2370,2371,2373,2374,2377,2379,2380,2381,2383,2386,2389,2392,2393,2394,2396,2397,2398,2399,2402,2403,2404,2405,2406,2408,2409,3071,3072,3085,3093,3099,3100,3101,3102,3105,3106,3107,3110,3111,3112,3113,3114,3115,3117,11956,11957,11958,11959,11960,11961,11962,11963,11964,11965,11966,11967,11968,11969,11970,11971,11972,11973,13279,13400,14633,14741,19014,20802,23561,24598,1129,1128,1164,26,1167,1269,1174,1173,1175,1193,1192,1180,1130,1138,1165,1166,1172,1177,1179,1176)

ORDER BY Clauses:

Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,3116,11974,846,849,1998,2043,2046,2049,2051,2053,2057,2059,2061,2065,2066,2073,2074,2076,2078,2080,2081,2082,2084,2085,2088,2344,2346,2347,2350,2353,2354,2356,2358,2359,2360,2361,2363,2364,2365,2366,2367,2368,2370,2371,2373,2374,2377,2379,2380,2381,2383,2386,2389,2392,2393,2394,2396,2397,2398,2399,2402,2403,2404,2405,2406,2408,2409,3071,3072,3085,3093,3099,3100,3101,3102,3105,3106,3107,3110,3111,3112,3113,3114,3115,3117,11956,11957,11958,11959,11960,11961,11962,11963,11964,11965,11966,11967,11968,11969,11970,11971,11972,11973,13279,13400,14633,14741,19014,20802,23561,24598,1129,1128,1164,26,1167,1269,1174,1173,1175,1193,1192,1180,1130,1138,1165,1166,1172,1177,1179,1176)

Stock Distribution (Total: 131 products):

Product Samples: