SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'en' 
  AND lang.name IN (
    'cannot_buy', 
    'no_products_selected', 
    'error_no_items_selected', 
    'delete_confirmation', 
    'text_out_of_stock', 
    'items', 
    'text_required_group_product', 
    'save', 
    'close', 
    'notice', 
    'warning', 
    'error', 
    'empty', 
    'text_are_you_sure_to_proceed', 
    'text_invalid_url', 
    'error_validator_email', 
    'error_validator_phone', 
    'error_validator_phone_mask', 
    'error_validator_integer', 
    'error_validator_multiple', 
    'error_validator_password', 
    'error_validator_required', 
    'error_validator_zipcode', 
    'error_validator_message', 
    'text_page_loading', 
    'error_ajax', 
    'text_changes_not_saved', 
    'text_data_changed', 
    'placing_order', 
    'file_browser', 
    'browse', 
    'text_no_products_found', 
    'cookie_is_disabled', 
    'insert_image', 
    'image_url', 
    'loading', 
    'loader.text.cart_item_decrease', 
    'loader.text.cart_item_increase', 
    'loader.text.cart_item_update', 
    'loader.text.adding_to_wishlist', 
    'loader.text.adding_to_comparison_list', 
    'loader.text.adding_to_cart', 
    'loader.text.removing_element', 
    'loader.text.creating_collection', 
    'loader.text.deleting_collection', 
    'loader.text.order_page', 
    'loader.text.shop_again_page', 
    'loader.text.shop_gift_page', 
    'loader.text.wishlist_page', 
    'loader.text.collection_page', 
    'loader.text.pdp_page', 
    'loader.text.review_page', 
    'loader.text.reorder_page', 
    'loader.text.superkind_page', 
    'loader.text.kc_page', 
    'loader.text.loginsecurity_page', 
    'loader.text.address_page', 
    'loader.text.public_page', 
    'loader.text.accountall_page', 
    'loader.text.content_page', 
    'loader.text.category_page', 
    'loader.text.video_page', 
    'loader.text.proceeding_to_checkout', 
    'loader.text.sorting', 
    'loader.text.load_pdp_review', 
    'loader.text.voting_up', 
    'loader.text.voting_down', 
    'loader.text.add_filter', 
    'loader.text.remove_filter', 
    'loader.text.remove_from_cart', 
    'loader.text.move_to_wishlist', 
    'loader.text.apply_coupon', 
    'loader.text.remove_coupon', 
    'loader.text.apply_points', 
    'loader.text.remove_points', 
    'loader.text.guest_register', 
    'loader.text.wishlist_type_change', 
    'loader.text.clear_wishlist', 
    'loader.text.preparing_for_address_add', 
    'loader.text.preparing_for_address_edit', 
    'loader.text.switching_address', 
    'loader.text.changing_address', 
    'loader.text.getting_address', 
    'saving_address', 
    'updating_address', 
    'lt.address_updated', 
    'lt.creating_account', 
    'cannot_buy', 
    'no_products_selected', 
    'error_no_items_selected', 
    'delete_confirmation', 
    'text_out_of_stock', 
    'items', 
    'text_required_group_product', 
    'save', 
    'close', 
    'notice', 
    'warning', 
    'error', 
    'empty', 
    'text_are_you_sure_to_proceed', 
    'text_invalid_url', 
    'error_validator_email', 
    'error_validator_phone', 
    'error_validator_phone_mask', 
    'error_validator_integer', 
    'error_validator_multiple', 
    'error_validator_password', 
    'error_validator_required', 
    'error_validator_zipcode', 
    'error_validator_message', 
    'text_page_loading', 
    'error_ajax', 
    'text_changes_not_saved', 
    'text_data_changed', 
    'placing_order', 
    'file_browser', 
    'browse', 
    'text_no_products_found', 
    'cookie_is_disabled', 
    'insert_image', 
    'image_url', 
    'loading', 
    'loader.text.cart_item_decrease', 
    'loader.text.cart_item_increase', 
    'loader.text.cart_item_update', 
    'loader.text.adding_to_wishlist', 
    'loader.text.adding_to_comparison_list', 
    'loader.text.adding_to_cart', 
    'loader.text.removing_element', 
    'loader.text.creating_collection', 
    'loader.text.deleting_collection', 
    'loader.text.order_page', 
    'loader.text.shop_again_page', 
    'loader.text.shop_gift_page', 
    'loader.text.wishlist_page', 
    'loader.text.collection_page', 
    'loader.text.pdp_page', 
    'loader.text.review_page', 
    'loader.text.reorder_page', 
    'loader.text.superkind_page', 
    'loader.text.kc_page', 
    'loader.text.loginsecurity_page', 
    'loader.text.address_page', 
    'loader.text.public_page', 
    'loader.text.accountall_page', 
    'loader.text.content_page', 
    'loader.text.category_page', 
    'loader.text.video_page', 
    'loader.text.proceeding_to_checkout', 
    'loader.text.sorting', 
    'loader.text.load_pdp_review', 
    'loader.text.voting_up', 
    'loader.text.voting_down', 
    'loader.text.add_filter', 
    'loader.text.remove_filter', 
    'loader.text.remove_from_cart', 
    'loader.text.move_to_wishlist', 
    'loader.text.apply_coupon', 
    'loader.text.remove_coupon', 
    'loader.text.apply_points', 
    'loader.text.remove_points', 
    'loader.text.guest_register', 
    'loader.text.wishlist_type_change', 
    'loader.text.clear_wishlist', 
    'loader.text.preparing_for_address_add', 
    'loader.text.preparing_for_address_edit', 
    'loader.text.switching_address', 
    'loader.text.changing_address', 
    'loader.text.getting_address', 
    'saving_address', 
    'updating_address', 
    'lt.address_updated', 
    'lt.creating_account'
  )

Query time 0.00287

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "39.55"
    },
    "table": {
      "table_name": "lang",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "lang_code",
        "name"
      ],
      "key_length": "392",
      "rows_examined_per_scan": 87,
      "rows_produced_per_join": 56,
      "filtered": "100.00",
      "index_condition": "((`cscart_db`.`lang`.`lang_code` = 'en') and (`cscart_db`.`lang`.`name` in ('cannot_buy','no_products_selected','error_no_items_selected','delete_confirmation','text_out_of_stock','items','text_required_group_product','save','close','notice','warning','error','empty','text_are_you_sure_to_proceed','text_invalid_url','error_validator_email','error_validator_phone','error_validator_phone_mask','error_validator_integer','error_validator_multiple','error_validator_password','error_validator_required','error_validator_zipcode','error_validator_message','text_page_loading','error_ajax','text_changes_not_saved','text_data_changed','placing_order','file_browser','browse','text_no_products_found','cookie_is_disabled','insert_image','image_url','loading','loader.text.cart_item_decrease','loader.text.cart_item_increase','loader.text.cart_item_update','loader.text.adding_to_wishlist','loader.text.adding_to_comparison_list','loader.text.adding_to_cart','loader.text.removing_element','loader.text.creating_collection','loader.text.deleting_collection','loader.text.order_page','loader.text.shop_again_page','loader.text.shop_gift_page','loader.text.wishlist_page','loader.text.collection_page','loader.text.pdp_page','loader.text.review_page','loader.text.reorder_page','loader.text.superkind_page','loader.text.kc_page','loader.text.loginsecurity_page','loader.text.address_page','loader.text.public_page','loader.text.accountall_page','loader.text.content_page','loader.text.category_page','loader.text.video_page','loader.text.proceeding_to_checkout','loader.text.sorting','loader.text.load_pdp_review','loader.text.voting_up','loader.text.voting_down','loader.text.add_filter','loader.text.remove_filter','loader.text.remove_from_cart','loader.text.move_to_wishlist','loader.text.apply_coupon','loader.text.remove_coupon','loader.text.apply_points','loader.text.remove_points','loader.text.guest_register','loader.text.wishlist_type_change','loader.text.clear_wishlist','loader.text.preparing_for_address_add','loader.text.preparing_for_address_edit','loader.text.switching_address','loader.text.changing_address','loader.text.getting_address','saving_address','updating_address','lt.address_updated','lt.creating_account','cannot_buy','no_products_selected','error_no_items_selected','delete_confirmation','text_out_of_stock','items','text_required_group_product','save','close','notice','warning','error','empty','text_are_you_sure_to_proceed','text_invalid_url','error_validator_email','error_validator_phone','error_validator_phone_mask','error_validator_integer','error_validator_multiple','error_validator_password','error_validator_required','error_validator_zipcode','error_validator_message','text_page_loading','error_ajax','text_changes_not_saved','text_data_changed','placing_order','file_browser','browse','text_no_products_found','cookie_is_disabled','insert_image','image_url','loading','loader.text.cart_item_decrease','loader.text.cart_item_increase','loader.text.cart_item_update','loader.text.adding_to_wishlist','loader.text.adding_to_comparison_list','loader.text.adding_to_cart','loader.text.removing_element','loader.text.creating_collection','loader.text.deleting_collection','loader.text.order_page','loader.text.shop_again_page','loader.text.shop_gift_page','loader.text.wishlist_page','loader.text.collection_page','loader.text.pdp_page','loader.text.review_page','loader.text.reorder_page','loader.text.superkind_page','loader.text.kc_page','loader.text.loginsecurity_page','loader.text.address_page','loader.text.public_page','loader.text.accountall_page','loader.text.content_page','loader.text.category_page','loader.text.video_page','loader.text.proceeding_to_checkout','loader.text.sorting','loader.text.load_pdp_review','loader.text.voting_up','loader.text.voting_down','loader.text.add_filter','loader.text.remove_filter','loader.text.remove_from_cart','loader.text.move_to_wishlist','loader.text.apply_coupon','loader.text.remove_coupon','loader.text.apply_points','loader.text.remove_points','loader.text.guest_register','loader.text.wishlist_type_change','loader.text.clear_wishlist','loader.text.preparing_for_address_add','loader.text.preparing_for_address_edit','loader.text.switching_address','loader.text.changing_address','loader.text.getting_address','saving_address','updating_address','lt.address_updated','lt.creating_account')))",
      "cost_info": {
        "read_cost": "28.25",
        "eval_cost": "5.65",
        "prefix_cost": "39.55",
        "data_read_per_join": "22K"
      },
      "used_columns": [
        "lang_code",
        "name",
        "value"
      ]
    }
  }
}

Result

name value
browse Browse...
cannot_buy You cannot buy the product with these option variants
close Close
cookie_is_disabled For a complete shopping experience, please <a href="http://www.wikihow.com/Enable-Cookies-in-Your-Internet-Web-Browser" target="_blank">set your browser to accept cookies</a>
delete_confirmation Are you sure you want to delete the selected items?
empty Empty
error Error
error_ajax Oops, something went wrong ([error]). Please try again.
error_no_items_selected No items selected! At least one check box must be selected to perform this action.
error_validator_email The email address in the <b>[field]</b> field is invalid.
error_validator_integer The value of the <b>[field]</b> field is invalid. It should be integer.
error_validator_message The value of the <b>[field]</b> field is invalid.
error_validator_multiple The <b>[field]</b> field does not contain the selected options.
error_validator_password The passwords in the <b>[field2]</b> and <b>[field]</b> fields do not match.
error_validator_phone The phone number in the <b>[field]</b> field is invalid. The correct format is (555) 555-55-55 or 55 55 555 5555.
error_validator_phone_mask The phone number in the <b>[field]</b> field is invalid.
error_validator_required The <b>[field]</b> field is mandatory.
error_validator_zipcode The ZIP / Postal code in the <b>[field]</b> field is incorrect. The correct format is [extra].
file_browser File browser
image_url Image URL
insert_image Insert image
items items
loader.text.accountall_page Loading All
loader.text.adding_to_cart Adding To Cart
loader.text.adding_to_comparison_list Adding to comparison list
loader.text.adding_to_wishlist Adding to wishlist
loader.text.address_page Address
loader.text.add_filter Filtering
loader.text.apply_coupon Applying Coupon
loader.text.apply_points Applying kinders
loader.text.cart_item_decrease Updating
loader.text.cart_item_increase Updating
loader.text.cart_item_update Updating
loader.text.category_page Loading Category
loader.text.changing_address Changing Address
loader.text.clear_wishlist Clearing Wishlist
loader.text.collection_page collection
loader.text.content_page Loading Content
loader.text.creating_collection Creating Collection
loader.text.deleting_collection Deleting Collection
loader.text.getting_address Updating Cart
loader.text.guest_register Opening Registration Page
loader.text.kc_page Kind champion
loader.text.load_pdp_review Loading review
loader.text.loginsecurity_page Login and security
loader.text.move_to_wishlist Moving To Wishlist
loader.text.order_page Loading orders
loader.text.pdp_page Loading Product
loader.text.preparing_for_address_add Preparing For Adding Address
loader.text.preparing_for_address_edit Preparing For Editing Address
loader.text.proceeding_to_checkout Proceeding to checkout
loader.text.public_page Public page
loader.text.remove_coupon Removing Coupon
loader.text.remove_filter Removing
loader.text.remove_from_cart Removing From Cart
loader.text.remove_points Removing kinders
loader.text.removing_element Deleting item
loader.text.reorder_page Reordering
loader.text.review_page Loading Review
loader.text.shop_again_page Shop Again
loader.text.Shop_gift_page Gift page
loader.text.sorting Sorting
loader.text.superkind_page Superkind
loader.text.switching_address Selecting Address
loader.text.video_page Loading Video
loader.text.voting_down Voting Down
loader.text.voting_up Voting Up
loader.text.wishlist_page wishlist
loader.text.wishlist_type_change Changing Wishlist Type
loading Loading...
lt.address_updated Address successfully updated
lt.creating_account Creating Account
notice Notice
no_products_selected No products selected
placing_order Placing the order
save Save
saving_address Saving Address
text_are_you_sure_to_proceed Are you sure you want to proceed?
text_changes_not_saved Your changes have not been saved.
text_data_changed Your changes have not been saved.Press OK to continue, or Cancel to stay on the current page.
text_invalid_url You have entered an invalid URL
text_no_products_found No products found
text_out_of_stock Out of stock
text_page_loading Loading... Your request is being processed, please wait.
text_required_group_product Please select a product for the required group [group_name]
updating_address Updating Address
warning Warning