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

Query time 0.00059

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
sayfa [n]