$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 (4) OR g.goods_id IN ('') ) and g.goods_id in (19091,19090,19089,19088,19086,19085,19084,19083,19082,19081,19080,19079,19078,19077,19076,19075,19074,19073,19072,19071,19070,19069,19068,19067,19066,19065,19064,19063,19062,19061,19060,19059,19058,19057,19056,19055,19054,19053,19052,19051,19049,19048,19047,19045,19044,19043,19042,19041,19040,19039,19038,19037,19036,19035,19034,19033,19032,19031,19029,19028,19027,19026,19025,19024,19023,19022,19021,19020,19018,19017,19016,19015,19014,19013,19012,19011,19010,19009,19008,19007,19006,19005,19004,19003,19001,19000,19092,19093,19094,19095,19096,19097,19098,19099,19100,19101,19102,19103,19104,19105,19106,19107,19108,19109,19110,19111,19112,19113,19114,19115,19116,19117,19118,19119,19120,19121,19122,19123,19124,19125,19126,19127,19128,19129,19131,19132,19134,19135,19136,19137,19138,19139,19140,19141,19142,19143,19144,19145,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19170,19171,19172,19173,19174,19175,19176,19177,19178,19179,19180,19181,19182,19183,19184,19185,19186,19187,19188,19189,19190,19191,19192,19193,19194,19195,19196,19197,19198,19199,19200,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19277,19278,19279,19280,19281,19282,19283,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294)and g.goods_id not in (19002,19019,19030,19046,19050,19087,19130,19133,19158,19201,19219,19231,19264,19276,19284) ORDER BY in_stock desc, sort_price asc Межкомнатные перегородки раздвижные — купить недорого | Страница 3

Межкомнатные перегородки стр. 3

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