Купить Винт в Хабаровске — Сибирский металлург

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'catalog_category' AND tt.parent = 467 ORDER BY t.term_order ASC, t.name ASC