$sql=SELECT g.goods_id, g.goods_name, g.goods_name_long, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, g.z_price, g.goods_sn, mp.user_price, g.shop_price, g.z_price, g.goods_type, g.promote_price, c.sales_start_date, c.goods_in_parent, c.parent_subst, g.sales_start, g.sales_days_on, g.sales_days_off, g.is_promote, g.sales_percent, g.sales_price, g.sales_good, g.promote_start_date, g.promote_end_date, g.goods_brief, gg.name as goods_thumb, g.goods_number, g.goods_url, '' as ceo_goods_descr, '' as ceo_goods_label, g.short_description, g.complect_price, g.cat_id, if(g.goods_number > 0, 1, 0) as in_stock, if(g.sales_price>0, g.sales_price, IFNULL(mp.user_price, g.shop_price * '1')) as sort_price, g.hide_search FROM `alfadb`.`ecs_goods` AS g LEFT JOIN `alfadb`.`ecs_goods_img` AS gg on gg.goods_id = g.goods_id and gg.default_image = 1 LEFT JOIN `alfadb`.`ecs_category` AS c ON g.cat_id = c.cat_id LEFT JOIN `alfadb`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id in (16) OR g.goods_id IN ('') ) and g.goods_id in (16004,16005,16041,16044,16045,16046,16173,16174,16175,16176,16177,16179,16180,16181,16201,16204,16131,16001,16002,16008,16014,16015,16029,16031,16033,16034,16035,16036,16038,16039,16040,16042,16043,16059,16061,16063,16064,16066,16067,16068,16069,16071,16072,16073,16074,16075,16076,16077,16078,16079,16080,16081,16082,16084,16086,16088,16089,16093,16097,16099,16102,16119,16120,16122,16000,16183,16186,16187,16195,16144,16145,16146,16147,16149,16152,16155,16158,16159,16138,16139,16142,16130,16188,16189,16190,16198,16157,16156,16154,16153,16151,16150,16148,16143,16140,16136,16135,16134,16132,16129,16128,16127,16126,16125,16104,16103,16101,16098,16096,16095,16094,16091,16090,16087,16085,16083,16182,16184,16191,16192,16193,16194,16196,16197,16199,16202,16203,16205)and g.goods_id not in (16003,16006,16007,16009,16010,16011,16012,16013,16016,16028,16030,16032,16037,16060,16062,16065,16070,16092,16100,16118,16121,16123,16124,16133,16137,16141,16178,16185,16200,16206) ORDER BY in_stock desc, sort_price asc Межкомнатные раздвижные двери купе — купить сдвижные двери от производителя с доставкой | Страница 3

Раздвижные двери купе стр. 3

РаспродажаСкидки
В наличии
Подбор по параметрам
Показать ещё 32 из 32
2 3 4
Свяжитесь с намиПоможем с выбором и рассчитаем заказ бесплатно
Выберите город с нашими салонами: