Advertisement
DimitarVasilev

Untitled

Jul 12th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. SELECT DISTINCT  m.name,  s.str_value, m.DESCRIPTION
  2. FROM gui_users gu
  3. JOIN gu_module gm ON gu.gui_user_id=gm.gui_user_id
  4. JOIN module m ON gm.module_id=m.module_id
  5. LEFT OUTER JOIN str s ON m.title_str_id=s.str_id
  6. LEFT OUTER JOIN str k ON m.description_str_id=k.str_id
  7. WHERE gu.LANGUAGE=s.LANGUAGE
  8. AND gu.gui_user_id=101452;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement