#EXPLAIN
SELECT DISTINCT
    # lex_sys.lex_desc lex_sys_desc, lex_lang.lex_desc lex_lang_desc - не все могут быть
    UPPER(lex_sys.lex_desc) lex_sys_desc, 
    IF(lex_lang.lex_desc <> '', lex_lang.lex_desc, lex_sys.lex_desc) lex_lang_desc
FROM mc_lexicon lex_sys
  JOIN mc_lexicon lex_lang 
    ON lex_lang.lex_code = lex_sys.lex_code
    AND lex_lang.lang_code = 'RU'
WHERE lex_sys.lang_code = 'EN'
  AND (
    lex_sys.lex_desc IN (
      'Attention',
      'Brand', 'Build Date',
      'Canada', 'Car Line', 'Catalogue', 'Check Build Date', 'Check Date', 'CIS', 'Colour Code', 'Colour Details', 'Country', 'countries',
      'Displays Section:', 'Down',
      'End Date', 'Engine Code', 'Engine Number', 'Enter filter criteria', 'Error', 'Exclude',
      'General',
      'Image', 'Include', 'India',
      'Japan',
      'Language', 'Line', 'Load',
      'Major Section', 'Maximum Search Results',
      'Middle East', 'Minor Section', 'Model', 'Model Description', 'Multiple VIN Selection',
      'None', 'No Results',
      'Option Codes', 
      'Part Name', 'Passenger', 'Production Date', 'Plant',
      'Qty',
      'Search', 'Select', 'Special', 'Start Date',
      'Transmission Code', 'Turkey',
      'Up', 'Upload File', 'USA',
      'Vehicle Details', 'Vehicle Information', 'Vehicle line', 'VIN not found', 'Vehicle Search',
      'Year'
    )
    OR lex_sys.lex_code IN (72, 138, 184, 734, 828, 1325, 1077, 2127, 2248, 2353, 2354, 2936, 2943, 2956, 3565, 3688, 3689, 4387, 4388, 4510, 5321, 5436, 6147, 6166, 6324, 7389, 7803, 9125)
  );