SELECT 
  lang.name, 
  lang.value 
FROM 
  cscart_language_values lang 
WHERE 
  lang.lang_code = 'tr' 
  AND lang.name IN (
    'gift_certificate', 'free_products', 
    'quick_view', 'gift_certificate', 
    'edit', 'gift_certificate', 'gift_cert_to', 
    'gift_cert_from', 'amount', 'send_via', 
    'postal_mail', 'free_products', 
    'product', 'price', 'quantity', 'subtotal', 
    'price_summary', 'gift_certificate', 
    'free_products', 'quick_view', 'gift_certificate', 
    'edit', 'gift_certificate', 'gift_cert_to', 
    'gift_cert_from', 'amount', 'send_via', 
    'postal_mail', 'free_products', 
    'product', 'price', 'quantity', 'subtotal', 
    'price_summary'
  )

Query time 0.00036

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE lang range PRIMARY PRIMARY 392 14 Using index condition

Result

name value
amount Miktar
edit Düzenle
free_products Ücretsiz ürünler
gift_certificate Hediye Çeki
gift_cert_from Kimden
gift_cert_to Kime
postal_mail Posta mail
price Fiyat
price_summary Fiyat özeti
product Ürün
quantity Miktar
quick_view Hızlı görüntüle
send_via İle gönder
subtotal Tutar