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

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, 2090, 3495, 4305, 2806, 3774, 4944, 4955, 4950, 4952, 4954, 4958, 4787, 4790, 2706, 4718, 4720, 4722, 4724, 4651, 4688, 2266, 4942, 4806, 2291, 4716, 4321, 4587, 3656, 4288, 3647, 3298, 2549, 4662, 2678, 3888, 5176, 4216, 2343, 3848, 1776, 3746, 3840, 3731, 3734, 3737, 3740, 3743, 3301, 3967, 5042, 2659, 3296, 1807, 2034, 2049, 4857, 4860, 5044, 4191, 4960, 4301, 4762, 4670, 4647, 5046, 4726, 5048, 5050, 5052, 3622, 4307, 4736, 1820, 3374, 1802, 3654, 1785, 3879, 4775, 3711, 2302, 3871, 4297, 4291, 3350, 1698, 1551, 4333, 1514, 2692, 2389, 2763, 4337, 3842, 4293, 4295, 4299, 2743, 4265, 3364, 4745, 3320, 4591, 3866, 4609, 4674, 4917, 3616, 4810, 3658, 4825, 4919, 2217, 4593, 4463, 2327, 3167, 4473, 2321, 5077, 3498, 4222, 4458, 4224, 4226, 2328, 5086, 5094, 4228, 4341, 4607, 4611, 3884, 4589, 4909, 4189, 3183, 4780, 2676, 4325, 2319, 4820, 4605, 2356, 1850, 3781, 4742, 4734, 3169, 4834, 3358, 4626, 2384, 3171, 5035, 4095, 2377, 2320, 4128, 5032, 4120, 2080)) ORDER BY FIELD(e.entity_id,3645,2090,3495,4305,2806,3774,4944,4955,4950,4952,4954,4958,4787,4790,2706,4718,4720,4722,4724,4651,4688,2266,4942,4806,2291,4716,4321,4587,3656,4288,3647,3298,2549,4662,2678,3888,5176,4216,2343,3848,1776,3746,3840,3731,3734,3737,3740,3743,3301,3967,5042,2659,3296,1807,2034,2049,4857,4860,5044,4191,4960,4301,4762,4670,4647,5046,4726,5048,5050,5052,3622,4307,4736,1820,3374,1802,3654,1785,3879,4775,3711,2302,3871,4297,4291,3350,1698,1551,4333,1514,2692,2389,2763,4337,3842,4293,4295,4299,2743,4265,3364,4745,3320,4591,3866,4609,4674,4917,3616,4810,3658,4825,4919,2217,4593,4463,2327,3167,4473,2321,5077,3498,4222,4458,4224,4226,2328,5086,5094,4228,4341,4607,4611,3884,4589,4909,4189,3183,4780,2676,4325,2319,4820,4605,2356,1850,3781,4742,4734,3169,4834,3358,4626,2384,3171,5035,4095,2377,2320,4128,5032,4120,2080)