select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from link_categories lc, link_categories_description lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '6' order by lcd.link_categories_name