SELECT DISTINCT SANUM SA, MODEL, STRKVER STROKE, SUBMOD, IFNULL(dic_L.`TEXT`, dic_E.`TEXT`) `DESC`, CONSAS, FNOTES
FROM alltext_sa_strokes_v strokes
  LEFT OUTER JOIN alltext_sa_dictionary_v dic_L
    ON dic_L.DESCIDX = strokes.DESCIDX
    AND dic_L.LANG = 'R'
  LEFT OUTER JOIN alltext_sa_dictionary_v dic_E
    ON dic_E.DESCIDX = strokes.DESCIDX
    AND dic_E.LANG = 'E'
WHERE MODEL = '437'  
  AND SUBMOD LIKE '%170%'  
  AND SANUM = ' 35951'
ORDER BY STRKVER, SEQNUM