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

Query time 0.00062

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
92 18 0 Acer <p><p><b>Acer Inc.</b> <span><span></span></span><span></span><span></span><span></span><em></em> is a Taiwanese multinational hardware and electronics corporation headquartered in Xizhi, New Taipei City, Taiwan. Acer's products include inexpensively-targeted desktop and laptop PCs, tablet computers, servers, storage devices, displays, smartphones and peripherals. It also provides e-business services to businesses, governments and consumers. Acer is the fourth largest PC maker in the world.</p> <p>In the early 2000s, Acer implemented a new business model, shifting from a manufacturer to a designer, marketer and distributor of products, while performing production processes via contract manufacturers.</p> <p>In addition to its core business, Acer also owns the largest franchised computer retail chain in Taipei, Taiwan.</p><br></p> tr