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

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