SELECT 
  link_id, 
  link_href, 
  section_id, 
  status, 
  position, 
  link_type, 
  description, 
  object as link 
FROM 
  cscart_sitemap_links 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_sitemap_links.link_id 
  AND cscart_common_descriptions.object_holder = 'sitemap_links' 
  AND cscart_common_descriptions.lang_code = 'tr' 
WHERE 
  section_id = 2 
ORDER BY 
  position, 
  link

Query time 0.00125

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_sitemap_links ALL 4 Using where; Using temporary; Using filesort
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 hobilifedt.cscart_sitemap_links.link_id,const,const 1 Using where

Result

link_id link_href section_id status position link_type description link
4 profiles.update 2 A 10 Edit profile Edit profile
1 checkout.cart 2 A 20 View cart View cart
3 checkout.checkout 2 A 30 Checkout Checkout
2 wishlist.view 2 A 40 Wish List Wish List