תוצאות חיפוש עבור : 'שלט של סגנון עם מיכל'

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