SELECT c.Id AS VALUE, IF (t.DEF_LANG!='', t.DEF_LANG, t.DEF_LANG) as `TXT`,c.Position ,c.Published
FROM kzot_rubrics c 
LEFT JOIN texts t ON c.TID=t.Id 
 WHERE c.Id='26'

ORDER BY c.Position,TXT;