תוצאות חיפוש עבור : 'שחור של אפל גריל 41 ספר שומן'

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`, `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_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (2266, 2257, 1850, 4674, 3358, 2216, 4216, 2567, 2549, 1551, 4277, 3552, 4281, 4189, 2023, 4279, 3364, 2555, 4576, 4273, 4275, 2185, 2291, 2678, 3656, 3776, 3772, 1807, 2343, 2659, 3301, 3774, 3296, 4297, 4291, 2335, 1820, 4572, 4301, 2763, 4265, 3350, 3145, 2804, 2302, 1698, 3654, 3658, 3668, 4293, 4295, 4299, 3746, 3749, 3752, 4271, 2077, 3743, 3731, 3734, 3737, 3740, 2217, 4305, 3140, 3879, 2676, 4589, 4424, 3965, 4591, 4593, 4185, 4431, 4458, 3498, 3866, 4307, 4463, 2384, 4473, 4626, 4365, 4377, 4195, 2319, 2692, 4387, 3133, 4199, 4329, 2377, 4180, 4025, 4030, 4110, 4115, 4010, 4020, 4015, 2806, 2776, 4601, 4095, 4101, 2673, 4267, 2090, 3328, 4201, 2314, 3852, 3335, 2293, 4203, 4321, 4587, 2218, 2277, 4288, 3979, 3647, 4407, 3976, 2299, 2046, 4603, 3650, 4662, 4579, 4319, 4583, 4581, 3477, 3848, 3838, 3840, 4446, 3482, 2781, 3487, 3967, 4435, 3993, 2071, 2049, 4450, 4439, 3982, 3999, 4005, 4191, 4670, 3711, 4647, 4653, 3871, 1514, 1785, 2389, 3374, 1802, 3842, 3645, 4337, 3832, 3320, 4660, 4609, 3495, 3167, 1990, 4664, 4341, 4607, 4611, 4222, 3884, 4224, 4226, 1811, 2474, 4228, 2088, 3183, 4676, 4453, 4605, 2669, 3169, 2950, 3171, 4128, 4120, 2080)) ORDER BY FIELD(e.entity_id,2266,2257,1850,4674,3358,2216,4216,2567,2549,1551,4277,3552,4281,4189,2023,4279,3364,2555,4576,4273,4275,2185,2291,2678,3656,3776,3772,1807,2343,2659,3301,3774,3296,4297,4291,2335,1820,4572,4301,2763,4265,3350,3145,2804,2302,1698,3654,3658,3668,4293,4295,4299,3746,3749,3752,4271,2077,3743,3731,3734,3737,3740,2217,4305,3140,3879,2676,4589,4424,3965,4591,4593,4185,4431,4458,3498,3866,4307,4463,2384,4473,4626,4365,4377,4195,2319,2692,4387,3133,4199,4329,2377,4180,4025,4030,4110,4115,4010,4020,4015,2806,2776,4601,4095,4101,2673,4267,2090,3328,4201,2314,3852,3335,2293,4203,4321,4587,2218,2277,4288,3979,3647,4407,3976,2299,2046,4603,3650,4662,4579,4319,4583,4581,3477,3848,3838,3840,4446,3482,2781,3487,3967,4435,3993,2071,2049,4450,4439,3982,3999,4005,4191,4670,3711,4647,4653,3871,1514,1785,2389,3374,1802,3842,3645,4337,3832,3320,4660,4609,3495,3167,1990,4664,4341,4607,4611,4222,3884,4224,4226,1811,2474,4228,2088,3183,4676,4453,4605,2669,3169,2950,3171,4128,4120,2080)