select t.topics_id,t.topics_type,t.link_type,t.show_child, t.topics_link,t.target_type, td.topics_name from topics t, topics_description td where t.parent_id = '0' and visible ='1' and t.topics_recommend = 1 and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name limit 9