SELECT 
  lang.name, 
  IF(
    cscart_ult_language_values.value IS NULL, 
    lang.value, cscart_ult_language_values.value
  ) as value 
FROM 
  cscart_language_values lang 
  LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name 
  AND company_id = 1 
  AND cscart_ult_language_values.lang_code = lang.lang_code 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name IN (
    'checkout_terms_n_conditions_name', 
    'checkout_terms_n_conditions', 
    'terms_and_conditions_content', 
    'checkout_edp_terms_n_conditions', 
    'license_agreement', 'checkout_terms_n_conditions_alert', 
    'checkout_terms_n_conditions_name', 
    'checkout_terms_n_conditions', 
    'terms_and_conditions_content', 
    'checkout_edp_terms_n_conditions', 
    'license_agreement', 'checkout_terms_n_conditions_alert'
  )

Query time 0.00037

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_language_values system PRIMARY 0 const row not found
1 SIMPLE lang range PRIMARY PRIMARY 392 6 Using index condition

Result

name value
checkout_edp_terms_n_conditions I accept the terms in the
checkout_terms_n_conditions Select this check box to accept the [terms_href]
checkout_terms_n_conditions_alert In order to proceed, you need to accept our Terms and Conditions.
checkout_terms_n_conditions_name Terms and Conditions
license_agreement License agreement
terms_and_conditions_content <p>Please read these Terms and Conditions ("Terms", "Terms and Conditions") carefully before using the <a href="http://www.mywebsite.com">http://www.mywebsite.com</a> website and the My Mobile App mobile application (the "Service") operated by My Company ("us", "we", or "our").</p><p><strong>By accessing or using the Service you agree to be bound by these Terms. If you disagree with any part of the Terms then you may not access the Service.</strong></p><p><strong>Purchases</strong></p><p>If you wish to purchase any product or service made available through the Service ("Purchase"), you may be asked to supply certain information relevant to your Purchase including, without limitation, your ...</p><p><strong>Content</strong></p><p>Our Service allows you to post, link, store, share and otherwise make available certain information, text, graphics, videos, or other material ("Content"). You are responsible for the ...</p><p><strong>Changes</strong></p><p>We reserve the right, at our sole discretion, to modify or replace these Terms at any time. If a revision is material we will try to provide at least 30 days' notice prior to any new terms taking effect. What constitutes a material change will be determined at our sole discretion.</p><p><strong>Contact Us</strong></p><p>If you have any questions about these Terms, please contact us.</p>