select t1.*, _metro.text_name as metro_text from nedv_ru_catalog1 t1 left join nedv_ru_metro as _metro on _metro.id=t1.select_metro where t1.check_active=1 and t1.check_end=1 and t1.parent=links794687.php order by ord descError SQL