SELECT 
  PARTTYP PARTTYPE, PARTNUM, PARTREM, OMPARTT, OMPARTN OMPARTNUM, OMPARTR,
  OPTFLAG, OPTPART, REPLFLG, REPTYPE, REPPNO REPPARTNO, REPPART, 
  AN_INSERT INDENT, parts.DESCIDX, parts.NOUNIDX, SEQNO, FOOTNOT FOOTNOTES, STEER STEERING, ITEMNO, TUVSIGN, STROKE, QUANTSA, SEQNUM, 
  IFNULL(noun_L.NOUN, noun_E.NOUN) AS NOUN,
  IFNULL(des_L.DESCRIPTION, des_E.DESCRIPTION) AS DESCRIPTION, 
  NEUTRAL, VPD_IDENT 
FROM 
  alltext_sa_parts_v parts 
  #локальный язык
  LEFT OUTER JOIN alltext_part_descs_v des_L
    ON des_L.DESCIDX = parts.DESCIDX AND des_L.LANG = 'S'
  #поумолчанию язык
  LEFT OUTER JOIN alltext_part_descs_v des_E
    ON des_E.DESCIDX = parts.DESCIDX AND des_E.LANG = 'E'
  #локальный язык
  LEFT OUTER JOIN alltext_part_nouns_v noun_L
    ON noun_L.NOUNIDX = parts.NOUNIDX AND noun_L.LANG = 'S'
  #поумолчанию язык
  LEFT OUTER JOIN alltext_part_nouns_v noun_E
    ON noun_E.NOUNIDX = parts.NOUNIDX AND noun_E.LANG = 'E'
WHERE 
  (SANUM = ' 54012' AND SUBGRP = '001') 
ORDER BY SEQNO