Нить швейная 40/2 цв. 1149 New Star

SELECT p .* , g.name AS group_name, g.url AS group_url, pg.name AS parent_group_name, pg.url AS parent_group_url FROM shop_products p JOIN shop_groups g ON p.group_id = g.id AND g.publish = 1 AND g.parent = 0 LEFT JOIN shop_groups pg ON g.parent = pg.id AND pg.publish = 1 WHERE 1 AND g.url = "nitki" AND g.publish = 1 AND p.url = "nitki-1149" AND p.publish = 1 ORDER BY p . sort Нить швейная 40/2 цв. 1149 New Star

Главная

Каталог

Нитки швейные

Нитка 40/2 цв.1149

Минимальный заказ - 1 упаковка

Цена за шт. (1 шт.):

105 руб.

Цена за 1 шт.:

105 руб.