#EXPLAIN
SELECT DISTINCT cat_folder, minor_sect, major_sect, minor_sect_lex_code, ref, pnc, `number`, name_lex_code, desc_lex_code, 
  production_from, production_to, quantity, inv_status, date_type, replaced, compatibility, body, `type`, `list`, 
  part_illust, `local`, country_iso_codes, number_search,
  COALESCE(name_desc_qual_def.lex_desc, name_desc_def.lex_desc) name_def_lex_desc,
  COALESCE(name_desc_qual_loc.lex_desc, name_desc_loc.lex_desc) name_loc_lex_desc,
  COALESCE(desc_qual_loc.lex_desc, desc_loc.lex_desc, desc_qual_def.lex_desc, desc_def.lex_desc) desc_lex_desc
FROM 
  cats_dat_parts
  # name_lex_code
  LEFT OUTER JOIN lex_lex name_desc_def ON name_desc_def.lang_code = 'EN' AND name_lex_code = name_desc_def.lex_code
  LEFT OUTER JOIN lex_lex name_desc_qual_def ON name_desc_qual_def.lang_code = 'QE' AND name_lex_code = name_desc_qual_def.lex_code
  LEFT OUTER JOIN lex_lex name_desc_loc ON name_desc_loc.lang_code = 'RU' AND name_lex_code = name_desc_loc.lex_code
  LEFT OUTER JOIN lex_lex name_desc_qual_loc ON name_desc_qual_loc.lang_code = 'QR' AND name_lex_code = name_desc_qual_loc.lex_code
  # desc_lex_code
  LEFT OUTER JOIN lex_lex desc_def ON desc_def.lang_code = 'EN' AND desc_lex_code = desc_def.lex_code
  LEFT OUTER JOIN lex_lex desc_qual_def ON desc_qual_def.lang_code = 'QE' AND desc_lex_code = desc_qual_def.lex_code
  LEFT OUTER JOIN lex_lex desc_loc ON desc_loc.lang_code = 'RU' AND desc_lex_code = desc_loc.lex_code
  LEFT OUTER JOIN lex_lex desc_qual_loc ON desc_qual_loc.lang_code = 'QR' AND desc_lex_code = desc_qual_loc.lex_code
WHERE 
  cat_folder = 'HEURPG41'
  AND minor_sect = '8686514'
ORDER BY 
  ref, pnc, `number`, production_from, production_to
;