SELECT 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 AND m.description_str_id=s.str_id
WHERE gu.LANGUAGE=s.LANGUAGE
AND gu.gui_user_id=101452;