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, 20, 21, 1721, 1720, 1716, 1726, 1729, 1727, 1733, 1734, 1735, 1740, 1741, 1739, 1751, 1750, 1760, 1756, 1758, 1768, 1767, 1769, 2404, 2406, 2405, 3085, 1819, 1824, 3111, 3110, 11958, 11957, 11959, 11960, 1823, 23598, 21778, 14, 15, 1834, 18, 1842, 23, 25, 27, 1873, 1875, 1877, 2061, 2059, 2356, 2364, 2363, 2361, 2370, 2368, 2374, 2377, 2379, 2386, 2389, 2392, 2399, 2398, 2397, 2409, 1791, 3102, 3101, 3107, 11969, 11961, 1724, 1722, 1723, 1730, 1732, 1731, 1738, 1737, 1736, 1742, 1744, 1743, 1752, 1754, 1755, 1764, 1763, 1766, 1772, 1773, 1775, 3071, 3072, 3093, 1822, 2063, 3113, 3112, 3114, 11956, 19191, 21759, 20545, 1833, 19, 1835, 1868, 1861, 1872, 1874, 1876, 1879, 1882, 1880, 2359, 2360, 2358, 2366, 2365, 2367, 2371, 2373, 2381, 2383, 2380, 2394, 2396, 2393, 2402, 2403, 2408, 3099, 3100, 3105, 3106, 1728, 3115, 3117, 11963, 11962)) ORDER BY FIELD(e.entity_id,3116,20,21,1721,1720,1716,1726,1729,1727,1733,1734,1735,1740,1741,1739,1751,1750,1760,1756,1758,1768,1767,1769,2404,2406,2405,3085,1819,1824,3111,3110,11958,11957,11959,11960,1823,23598,21778,14,15,1834,18,1842,23,25,27,1873,1875,1877,2061,2059,2356,2364,2363,2361,2370,2368,2374,2377,2379,2386,2389,2392,2399,2398,2397,2409,1791,3102,3101,3107,11969,11961,1724,1722,1723,1730,1732,1731,1738,1737,1736,1742,1744,1743,1752,1754,1755,1764,1763,1766,1772,1773,1775,3071,3072,3093,1822,2063,3113,3112,3114,11956,19191,21759,20545,1833,19,1835,1868,1861,1872,1874,1876,1879,1882,1880,2359,2360,2358,2366,2365,2367,2371,2373,2381,2383,2380,2394,2396,2393,2402,2403,2408,3099,3100,3105,3106,1728,3115,3117,11963,11962)

ORDER BY Clauses:

Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,3116,20,21,1721,1720,1716,1726,1729,1727,1733,1734,1735,1740,1741,1739,1751,1750,1760,1756,1758,1768,1767,1769,2404,2406,2405,3085,1819,1824,3111,3110,11958,11957,11959,11960,1823,23598,21778,14,15,1834,18,1842,23,25,27,1873,1875,1877,2061,2059,2356,2364,2363,2361,2370,2368,2374,2377,2379,2386,2389,2392,2399,2398,2397,2409,1791,3102,3101,3107,11969,11961,1724,1722,1723,1730,1732,1731,1738,1737,1736,1742,1744,1743,1752,1754,1755,1764,1763,1766,1772,1773,1775,3071,3072,3093,1822,2063,3113,3112,3114,11956,19191,21759,20545,1833,19,1835,1868,1861,1872,1874,1876,1879,1882,1880,2359,2360,2358,2366,2365,2367,2371,2373,2381,2383,2380,2394,2396,2393,2402,2403,2408,3099,3100,3105,3106,1728,3115,3117,11963,11962)

Stock Distribution (Total: 143 products):

Product Samples: