תוצאות חיפוש עבור : 'שלט של סלקום עם מבלי קירור לטלוויזיה'

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 (3645, 2787, 3495, 3552, 2090, 2804, 4277, 4281, 4576, 4662, 4279, 4120, 4128, 4273, 4275, 3140, 3145, 3647, 4305, 2806, 4267, 3965, 4587, 2277, 4674, 3746, 3749, 3752, 3731, 3734, 3737, 3740, 3743, 3133, 2692, 3776, 4288, 4321, 2257, 4572, 3772, 2678, 3838, 3840, 3774, 3758, 2549, 2567, 3656, 2216, 2266, 4216, 3301, 2185, 3967, 3848, 2071, 1785, 3296, 2659, 4591, 4589, 4593, 2302, 2555, 4424, 4431, 3167, 4307, 3320, 2077, 4337, 4341, 3711, 3884, 4653, 1698, 3358, 2474, 2763, 1514, 2669, 3658, 4664, 3498, 1551, 4670, 3374, 3364, 3871, 4265, 4609, 3169, 4676, 4607, 3879, 4660, 4101, 2291, 4189, 4025, 4030, 2950, 3171, 2676, 4329, 4626, 4095, 4010, 4020, 4015, 1850, 4110, 4115, 1788, 2377, 4601, 4185, 4453, 2343, 2663, 4180, 2080, 2384, 2046, 2335, 2049, 1807, 2206, 4435, 2208, 2209, 4446, 4439, 4191, 4442, 4450, 1820, 4301, 4647, 2023, 3654, 2389, 1802, 3350, 2194, 4297, 4291, 3842, 4458, 4463, 4473, 3668, 4239, 3832, 4241, 4243, 4245, 3173, 3175, 1811, 4293, 4295, 4299, 3866, 2217, 2218, 2293, 2056, 4611, 4222, 4224, 4226, 4271, 4228, 4365, 4377, 4387, 4672, 2088, 3183, 3650, 4605, 3993, 3982, 3999, 4005, 2319, 1640)) ORDER BY FIELD(e.entity_id,3645,2787,3495,3552,2090,2804,4277,4281,4576,4662,4279,4120,4128,4273,4275,3140,3145,3647,4305,2806,4267,3965,4587,2277,4674,3746,3749,3752,3731,3734,3737,3740,3743,3133,2692,3776,4288,4321,2257,4572,3772,2678,3838,3840,3774,3758,2549,2567,3656,2216,2266,4216,3301,2185,3967,3848,2071,1785,3296,2659,4591,4589,4593,2302,2555,4424,4431,3167,4307,3320,2077,4337,4341,3711,3884,4653,1698,3358,2474,2763,1514,2669,3658,4664,3498,1551,4670,3374,3364,3871,4265,4609,3169,4676,4607,3879,4660,4101,2291,4189,4025,4030,2950,3171,2676,4329,4626,4095,4010,4020,4015,1850,4110,4115,1788,2377,4601,4185,4453,2343,2663,4180,2080,2384,2046,2335,2049,1807,2206,4435,2208,2209,4446,4439,4191,4442,4450,1820,4301,4647,2023,3654,2389,1802,3350,2194,4297,4291,3842,4458,4463,4473,3668,4239,3832,4241,4243,4245,3173,3175,1811,4293,4295,4299,3866,2217,2218,2293,2056,4611,4222,4224,4226,4271,4228,4365,4377,4387,4672,2088,3183,3650,4605,3993,3982,3999,4005,2319,1640)