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

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