SELECT 
  c.company_id, 
  c.storefront, 
  c.email, 
  l.name, 
  l.lang_code 
FROM 
  cscart_languages as l 
  INNER JOIN cscart_ult_objects_sharing as s ON (
    s.share_object_id = l.lang_id 
    AND s.share_object_type = 'languages'
  ) 
  LEFT JOIN cscart_companies as c ON c.company_id = s.share_company_id 
WHERE 
  c.status = 'A' 
  AND l.status = 'A' 
ORDER BY 
  l.lang_code = 'fa' DESC

Query time 0.00094

Result

company_id storefront email name lang_code
12 spss.daewoo.ir پارسی fa
1 ecommerce.entekhabgroup.ir simtech@example.com پارسی fa
7 shop.araks-co.ir پارسی fa
13 seller.daewoo.ir پارسی fa
5 shop.snowa.ir پارسی fa
8 www.smartir.ir پارسی fa
6 shop.daewoo.ir پارسی fa