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 = 88

Query time 0.00094

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
88 18 0 ASUS <p></p><p><b>ASUSTeK Computer Inc.</b>, trading as <b>Asus</b><span><span></span></span><span></span><span></span><span></span><span></span>, is a Taiwanese multinational computer hardware and electronics company headquartered in Taipei, Taiwan. Its products include desktops, laptops, mobile phones, monitors, motherboards, servers, tablet PCs and video cards. The company's slogan is: "Inspiring Innovation. Persistent Perfection."</p> <p>Asus is the world's fifth-largest PC vendor by 2012 unit sales (after HP, Lenovo, Dell and Acer). Asus appears in <i>BusinessWeek</i>’s "InfoTech 100" and "Asia’s Top 10 IT Companies" rankings, and it ranked first in the IT Hardware category of the 2008 Taiwan Top 10 Global Brands survey with a total brand value of US$1.3 billion.</p> <p>Asus has a primary listing on the Taiwan Stock Exchange and a secondary listing on the London Stock Exchange.</p><br><p></p> tr