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, 34, 35, 16, 17, 30, 31, 33, 759, 762, 773, 775, 779, 781, 782, 784, 787, 792, 846, 849, 879, 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, 2408, 2409, 3099, 3100, 3101, 3102, 3105, 3106, 3107, 3115, 3117, 11961, 11962, 11963, 11969, 777, 776, 1129, 1128, 1130, 1138, 785, 24, 788, 1164, 1165, 26, 28, 1166, 29, 32, 1167, 780, 794, 793, 1269, 1173, 1172, 1174, 1175, 1176, 1180, 1177, 1179, 410, 1193, 1192, 729, 415, 770, 752, 753, 2404, 2405, 2406, 3071, 3072, 774, 3085, 3093, 2063, 3110, 3113, 3112, 3111, 3114, 11956, 751, 11958, 11957, 11959, 11960, 19191, 20545, 23598, 21778, 21759, 778, 783)) ORDER BY FIELD(e.entity_id,3116,34,35,16,17,30,31,33,759,762,773,775,779,781,782,784,787,792,846,849,879,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,2408,2409,3099,3100,3101,3102,3105,3106,3107,3115,3117,11961,11962,11963,11969,777,776,1129,1128,1130,1138,785,24,788,1164,1165,26,28,1166,29,32,1167,780,794,793,1269,1173,1172,1174,1175,1176,1180,1177,1179,410,1193,1192,729,415,770,752,753,2404,2405,2406,3071,3072,774,3085,3093,2063,3110,3113,3112,3111,3114,11956,751,11958,11957,11959,11960,19191,20545,23598,21778,21759,778,783)

ORDER BY Clauses:

Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,3116,34,35,16,17,30,31,33,759,762,773,775,779,781,782,784,787,792,846,849,879,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,2408,2409,3099,3100,3101,3102,3105,3106,3107,3115,3117,11961,11962,11963,11969,777,776,1129,1128,1130,1138,785,24,788,1164,1165,26,28,1166,29,32,1167,780,794,793,1269,1173,1172,1174,1175,1176,1180,1177,1179,410,1193,1192,729,415,770,752,753,2404,2405,2406,3071,3072,774,3085,3093,2063,3110,3113,3112,3111,3114,11956,751,11958,11957,11959,11960,19191,20545,23598,21778,21759,778,783)

Stock Distribution (Total: 137 products):

Product Samples: