SELECT 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'tr' 
  AND lang.name = 'state_field_required_only_for_countries_with_regions'

Query time 0.00129

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE lang const PRIMARY PRIMARY 392 const,const 1

Result

value
State field is required only for countries with states/provinces