SELECT fc.*, IFNULL(fcd.title, CONCAT('Bez překladu - ', (SELECT title FROM #__mod_files_categories_descriptions WHERE id_category=fc.id AND lang='".DEFAULT_LANGUAGE."'))) AS title
FROM #__mod_files_categories fc
LEFT JOIN (SELECT * FROM #__mod_files_categories_descriptions WHERE lang='".ADMIN_LANG."') fcd ON fc.id=fcd.id_category
GROUP BY fc.id
ORDER BY fc.item_order ASC