+7 (903) 508-10-23
Москва, ул. Зенитчиков, дом 10
В корзине 0 товаров
Сумма 0.00 руб.

SELECT * FROM zapscript_catalog_model WHERE url = "Clarus" AND id_mark =

Запчасти

SELECT DISTINCT a.url, a.name_detail, b.name AS group_name FROM zapscript_catalog_mark_detail a JOIN zapscript_catalog_groups b ON a.id_group = b.id_group WHERE a.id_mark = ORDER BY b.sequence ASC, a.name_detail ASC