Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT m.name, s.str_value, m.DESCRIPTION
- FROM gui_users gu
- JOIN gu_module gm ON gu.gui_user_id=gm.gui_user_id
- JOIN module m ON gm.module_id=m.module_id
- LEFT OUTER JOIN str s ON m.title_str_id=s.str_id
- LEFT OUTER JOIN str k ON m.description_str_id=k.str_id
- WHERE gu.LANGUAGE=s.LANGUAGE
- AND gu.gui_user_id=101452;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement