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

Query time 0.00011

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
Alfabetik olarak sırala: A dan Z ye