SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name IN (
    'vendor_directory.fe_products', 
    'vendor_directory.fe_price_range', 
    'vendor_directory.fe_style', 'vendor_directory.fe_market_segment', 
    'vendor_directory.fe_pieces', 'vendor_directory.fe_pieces_new', 
    'vendor_directory.fe_pieces', 'vendor_directory.fe_pieces_secondhand', 
    'vendor_directory.vc_question4', 
    'vendor_directory.fe_details', 
    'vendor_directory.fe_available_in', 
    'vendor_directory.fe_where_to_buy', 
    'vendor_directory.fe_sizes', 'vendor_directory.fe_products_upcycled', 
    'vendor_directory.fe_store_location', 
    'vendor_directory.vd_link_here', 
    'vendor_directory.fe_swapping', 
    'vendor_directory.fe_international_shipping', 
    'vendor_directory.fe_headquarters', 
    'vendor_directory.fe_sustainable', 
    'vendor_directory.fe_disclaimer', 
    'vendor_directory.fe_disclaimer_txt', 
    'vendor_directory.fe_products', 
    'vendor_directory.fe_price_range', 
    'vendor_directory.fe_style', 'vendor_directory.fe_market_segment', 
    'vendor_directory.fe_pieces', 'vendor_directory.fe_pieces_new', 
    'vendor_directory.fe_pieces', 'vendor_directory.fe_pieces_secondhand', 
    'vendor_directory.vc_question4', 
    'vendor_directory.fe_details', 
    'vendor_directory.fe_available_in', 
    'vendor_directory.fe_where_to_buy', 
    'vendor_directory.fe_sizes', 'vendor_directory.fe_products_upcycled', 
    'vendor_directory.fe_store_location', 
    'vendor_directory.vd_link_here', 
    'vendor_directory.fe_swapping', 
    'vendor_directory.fe_international_shipping', 
    'vendor_directory.fe_headquarters', 
    'vendor_directory.fe_sustainable', 
    'vendor_directory.fe_disclaimer', 
    'vendor_directory.fe_disclaimer_txt'
  )

Query time 0.00399

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "lang",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "392",
          "used_key_parts": ["lang_code", "name"],
          "rows": 21,
          "filtered": 100,
          "index_condition": "lang.lang_code = 'en' and lang.`name` in ('vendor_directory.fe_products','vendor_directory.fe_price_range','vendor_directory.fe_style','vendor_directory.fe_market_segment','vendor_directory.fe_pieces','vendor_directory.fe_pieces_new','vendor_directory.fe_pieces','vendor_directory.fe_pieces_secondhand','vendor_directory.vc_question4','vendor_directory.fe_details','vendor_directory.fe_available_in','vendor_directory.fe_where_to_buy','vendor_directory.fe_sizes','vendor_directory.fe_products_upcycled','vendor_directory.fe_store_location','vendor_directory.vd_link_here','vendor_directory.fe_swapping','vendor_directory.fe_international_shipping','vendor_directory.fe_headquarters','vendor_directory.fe_sustainable','vendor_directory.fe_disclaimer','vendor_directory.fe_disclaimer_txt','vendor_directory.fe_products','vendor_directory.fe_price_range','vendor_directory.fe_style','vendor_directory.fe_market_segment','vendor_directory.fe_pieces','vendor_directory.fe_pieces_new','vendor_directory.fe_pieces','vendor_directory.fe_pieces_secondhand','vendor_directory.vc_question4','vendor_directory.fe_details','vendor_directory.fe_available_in','vendor_directory.fe_where_to_buy','vendor_directory.fe_sizes','vendor_directory.fe_products_upcycled','vendor_directory.fe_store_location','vendor_directory.vd_link_here','vendor_directory.fe_swapping','vendor_directory.fe_international_shipping','vendor_directory.fe_headquarters','vendor_directory.fe_sustainable','vendor_directory.fe_disclaimer','vendor_directory.fe_disclaimer_txt')"
        }
      }
    ]
  }
}

Result

name value
vendor_directory.fe_available_in Available in:
vendor_directory.fe_details Details
vendor_directory.fe_disclaimer *DICLAIMER:
vendor_directory.fe_disclaimer_txt <p>AT FUNDAMENTALLY, WE PROMOTE TRANSPARENCY AND SUSTAINABILITY IN THE FASHION INDUSTRY. HOWEVER, DUE TO FINANCIAL RESOURCE LIMITATIONS, WE DO NOT CONDUCT INDEPENDENT VERIFICATION OF THE STATEMENTS MADE BY BRANDS AND SELLERS IN THIS DIRECTORY, ESPECIALLY IN RELATION TO SUSTAINABILITY PRACTICES AND OTHER SELF-REPORTED DATA.</p><p>WE CANNOT GUARANTEE THE ACCURACY OF THE INFORMATION PROVIDED AND TAKE NO LEGAL RESPONSIBILITY FOR ANY INCORRECT OR MISLEADING INFORMATION PROVIDED BY BRANDS OR SELLERS. WE ENCOURAGE DIRECTORY USERS TO EXERCISE THEIR OWN JUDGMENT AND CONDUCT INDEPENDENT VERIFICATION BEFORE MAKING DECISIONS BASED ON THIS INFORMATION.</p><p>WE ARE COMMITTED TO MAINTAINING THE INTEGRITY OF OUR BOARD. THEREFORE, IF WE ARE PROVIDED WITH CREDIBLE EVIDENCE THAT A BRAND OR SELLER HAS PROVIDED FALSE INFORMATION, WE WILL REMOVE THAT ENTITY FROM THE DIRECTORY TO ENSURE THE QUALITY AND RELIABILITY OF OUR PLATFORM.</p>
vendor_directory.fe_headquarters Headquarters:
vendor_directory.fe_international_shipping international shipping:
vendor_directory.fe_market_segment Segment:
vendor_directory.fe_pieces The products are:
vendor_directory.fe_pieces_new New
vendor_directory.fe_pieces_secondhand Second hand or vintage
vendor_directory.fe_price_range Price Range:
vendor_directory.fe_products Products:
vendor_directory.fe_products_upcycled Products Upcycled:
vendor_directory.fe_sizes Carry Extra Sizes:
vendor_directory.fe_store_location Store location in google maps:
vendor_directory.fe_style Style:
vendor_directory.fe_sustainable SUSTAINABLE PRACTICES*
vendor_directory.fe_swapping Swapping or swap events:
vendor_directory.fe_where_to_buy Where to buy:
vendor_directory.vc_question4 How do you ensure the quality and authenticity of your pieces?
vendor_directory.vd_link_here Link Here!