Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT fc.*, ifnull(fcd.title, '- Bez překladu -') 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement