SELECT 
  * 
FROM 
  cscart_product_feature_variants 
  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id 
  AND cscart_product_feature_variant_descriptions.lang_code = 'tr' 
WHERE 
  cscart_product_feature_variants.variant_id = 96

Query time 0.00059

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_feature_variants const PRIMARY PRIMARY 3 const 1
1 SIMPLE cscart_product_feature_variant_descriptions const PRIMARY PRIMARY 9 const,const 1

Result

variant_id feature_id url color position variant description page_title meta_keywords meta_description lang_code gr__sf_seo_variant
96 18 0 Concord Records <p>Concord Records is a U.S. record label now based in Beverly Hills, California. Originally known as Concord Jazz, it was established in 1972 as an off-shoot of the Concord Jazz Festival in Concord, California, by festival founder Carl Jefferson, a local automobile dealer and jazz fan who sold his Lincoln Mercury dealership to found "the jazz label I can never find in record stores." Since then, the label has achieved international recognition, as well as 88 Grammy Award nominations and 14 Grammy Awards.<br></p> tr