SELECT IF (t.DEF_LANG!='', t.DEF_LANG, t.DEF_LANG) as `Name`,IF (t1.DEF_LANG!='', t1.DEF_LANG, t1.DEF_LANG) as `Desc`,i.Id as Id FROM infoworker i LEFT JOIN texts t ON t.Id=i.TID_TEXT LEFT JOIN texts t1 ON t1.Id=i.TID_DESC WHERE 1 AND i.Id='110' ORDER BY t.DEF_LANG