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

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, 4189, 3495, 4662, 2090, 4128, 5032, 4120, 5035, 2319, 1785, 2806, 4305, 2299, 1788, 4787, 4321, 4288, 1551, 2293, 3298, 2678, 3840, 3647, 2549, 3656, 4716, 4293, 4295, 4942, 4299, 4806, 2266, 3301, 4579, 2023, 3296, 3350, 4587, 5042, 3888, 5044, 2743, 4834, 3746, 3731, 3734, 3737, 3740, 3743, 4591, 5176, 2302, 1776, 4917, 4589, 4593, 2291, 4857, 1514, 5077, 5086, 5094, 4860, 4674, 1640, 4670, 2321, 3358, 4734, 3498, 4333, 4609, 2343, 4607, 1807, 3320, 3884, 4736, 2763, 4762, 4307, 4742, 2049, 4810, 3658, 1820, 5046, 5048, 5050, 5052, 3364, 3374, 5054, 5056, 5058, 5060, 4909, 5062, 5064, 5066, 5068, 4265, 4919, 3879, 4095, 2389, 4626, 3871, 3622, 3616, 2217, 4775, 4745, 2356, 2676, 4808, 4784, 4786, 5236, 5238, 5240, 5242, 5244, 1811, 1850, 2377, 4672, 2080, 5167, 2384, 4239, 4241, 5163, 5248, 5251, 4301, 4726, 1802, 4960, 4297, 4291, 3654, 4458, 3982, 3993, 3999, 4222, 4224, 3866, 2328, 4780, 2327, 4611, 3650, 4820, 3781, 4605, 2320)) ORDER BY FIELD(e.entity_id,3645,4189,3495,4662,2090,4128,5032,4120,5035,2319,1785,2806,4305,2299,1788,4787,4321,4288,1551,2293,3298,2678,3840,3647,2549,3656,4716,4293,4295,4942,4299,4806,2266,3301,4579,2023,3296,3350,4587,5042,3888,5044,2743,4834,3746,3731,3734,3737,3740,3743,4591,5176,2302,1776,4917,4589,4593,2291,4857,1514,5077,5086,5094,4860,4674,1640,4670,2321,3358,4734,3498,4333,4609,2343,4607,1807,3320,3884,4736,2763,4762,4307,4742,2049,4810,3658,1820,5046,5048,5050,5052,3364,3374,5054,5056,5058,5060,4909,5062,5064,5066,5068,4265,4919,3879,4095,2389,4626,3871,3622,3616,2217,4775,4745,2356,2676,4808,4784,4786,5236,5238,5240,5242,5244,1811,1850,2377,4672,2080,5167,2384,4239,4241,5163,5248,5251,4301,4726,1802,4960,4297,4291,3654,4458,3982,3993,3999,4222,4224,3866,2328,4780,2327,4611,3650,4820,3781,4605,2320)