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 (911, 3116, 11974, 846, 849, 900, 901, 1728, 1791, 1834, 1835, 1842, 1861, 1868, 1872, 1873, 1874, 1875, 1876, 1877, 1879, 1880, 1882, 1941, 1942, 1969, 1989, 2043, 2046, 2049, 2051, 2053, 2057, 2059, 2061, 2065, 2066, 2073, 2074, 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, 2408, 2409, 3099, 3100, 3101, 3102, 3105, 3106, 3107, 3117, 11961, 11962, 11963, 11965, 11966, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 13279, 13400, 14633, 19014, 20802, 23561, 24598, 953, 1129, 1128, 1130, 1138, 1164, 1165, 1166, 1167, 794, 1269, 1173, 1172, 1174, 1175, 1176, 1180, 1177, 1179, 1193, 1192, 1573, 1653, 1634, 916, 1654, 1657, 1677, 1661, 1676, 1682, 1678, 1679, 1686, 1690, 1693, 1699, 1700, 1701, 1705, 1703, 1704, 1706, 1709, 1708, 1711, 1712, 1710, 1714, 1720, 1716, 1721, 1722, 1723, 1726, 1727, 1724, 1729, 1730, 1731, 1733, 1732, 1734, 1735, 1737, 1736, 1740, 1738, 1739, 1742, 1741, 1743, 1744, 1750, 1752, 1754, 1751, 1756, 1758, 1755, 1764, 1760, 1763, 1768, 1767, 1766, 1772, 1773, 1769, 1775, 2404, 2405, 2406, 3071, 3072, 3085, 3093, 1822, 1819, 951, 1824, 1681, 2063, 3110, 3113, 3112, 3111, 2076, 3114, 11956, 11958, 11957, 11959, 11960, 19191, 14741, 20545, 23598, 21778, 21759, 1823, 1833)) ORDER BY FIELD(e.entity_id,911,3116,11974,846,849,900,901,1728,1791,1834,1835,1842,1861,1868,1872,1873,1874,1875,1876,1877,1879,1880,1882,1941,1942,1969,1989,2043,2046,2049,2051,2053,2057,2059,2061,2065,2066,2073,2074,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,2408,2409,3099,3100,3101,3102,3105,3106,3107,3117,11961,11962,11963,11965,11966,11967,11968,11969,11970,11971,11972,11973,13279,13400,14633,19014,20802,23561,24598,953,1129,1128,1130,1138,1164,1165,1166,1167,794,1269,1173,1172,1174,1175,1176,1180,1177,1179,1193,1192,1573,1653,1634,916,1654,1657,1677,1661,1676,1682,1678,1679,1686,1690,1693,1699,1700,1701,1705,1703,1704,1706,1709,1708,1711,1712,1710,1714,1720,1716,1721,1722,1723,1726,1727,1724,1729,1730,1731,1733,1732,1734,1735,1737,1736,1740,1738,1739,1742,1741,1743,1744,1750,1752,1754,1751,1756,1758,1755,1764,1760,1763,1768,1767,1766,1772,1773,1769,1775,2404,2405,2406,3071,3072,3085,3093,1822,1819,951,1824,1681,2063,3110,3113,3112,3111,2076,3114,11956,11958,11957,11959,11960,19191,14741,20545,23598,21778,21759,1823,1833)

ORDER BY Clauses:

Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,911,3116,11974,846,849,900,901,1728,1791,1834,1835,1842,1861,1868,1872,1873,1874,1875,1876,1877,1879,1880,1882,1941,1942,1969,1989,2043,2046,2049,2051,2053,2057,2059,2061,2065,2066,2073,2074,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,2408,2409,3099,3100,3101,3102,3105,3106,3107,3117,11961,11962,11963,11965,11966,11967,11968,11969,11970,11971,11972,11973,13279,13400,14633,19014,20802,23561,24598,953,1129,1128,1130,1138,1164,1165,1166,1167,794,1269,1173,1172,1174,1175,1176,1180,1177,1179,1193,1192,1573,1653,1634,916,1654,1657,1677,1661,1676,1682,1678,1679,1686,1690,1693,1699,1700,1701,1705,1703,1704,1706,1709,1708,1711,1712,1710,1714,1720,1716,1721,1722,1723,1726,1727,1724,1729,1730,1731,1733,1732,1734,1735,1737,1736,1740,1738,1739,1742,1741,1743,1744,1750,1752,1754,1751,1756,1758,1755,1764,1760,1763,1768,1767,1766,1772,1773,1769,1775,2404,2405,2406,3071,3072,3085,3093,1822,1819,951,1824,1681,2063,3110,3113,3112,3111,2076,3114,11956,11958,11957,11959,11960,19191,14741,20545,23598,21778,21759,1823,1833)

Stock Distribution (Total: 234 products):

Product Samples: