Усилитель бампера для автомобилей КИА

SELECT a.id_model, a.articul, a.name, a.url, c.name AS model_name, c.url AS model_url FROM zapscript_catalog_mark_detail_name a JOIN zapscript_catalog_mark_detail b ON a.id_detail = b.id AND b.url = "usilitel_bampera" JOIN zapscript_catalog_model c ON a.id_model = c.id_model WHERE a.id_mark = 1 ORDER BY a.name ASC