SELECT 
  cscart_payment_processors.processor_id, 
  cscart_payment_processors.processor, 
  cscart_payment_processors.type, 
  cscart_payment_processors.addon, 
  cscart_language_values.value AS description, 
  IF (
    ISNULL(cscart_addons.status), 
    "A", 
    cscart_addons.status
  ) AS processor_status 
FROM 
  cscart_payment_processors 
  LEFT JOIN cscart_language_values ON cscart_language_values.name = CONCAT(
    'processor_description_', 
    REPLACE(
      cscart_payment_processors.processor_script, 
      '.php', ''
    )
  ) 
  AND lang_code = 'vi' 
  LEFT JOIN cscart_addons ON cscart_addons.addon = cscart_payment_processors.addon 
WHERE 
  1 
ORDER BY 
  processor

Query time 0.00104

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_payment_processors.processor",
        "table": {
          "table_name": "cscart_payment_processors",
          "access_type": "ALL",
          "rows": 62,
          "filtered": 100
        }
      }
    },
    "table": {
      "table_name": "cscart_language_values",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "392",
      "used_key_parts": ["lang_code", "name"],
      "ref": ["const", "func"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_language_values.`name` = concat('processor_description_',replace(cscart_payment_processors.processor_script,'.php','')) and cscart_language_values.lang_code = 'vi')"
    },
    "table": {
      "table_name": "cscart_addons",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "98",
      "used_key_parts": ["addon"],
      "ref": ["vietpom_dev.cscart_payment_processors.addon"],
      "rows": 1,
      "filtered": 100
    }
  }
}

Result

processor_id processor type addon description processor_status
6 2Checkout P A
54 Alpha e-Pay P A
42 Atos P A
2 Authorize.Net AIM P A
37 Barclaycard ePDQ P A
33 ChronoPay P A
50 CM-CIC P A
69 CRE Secure P A
58 Datatrans P A
90 Deko P A
21 Deprecated eWAY P A
19 Deprecated eWAY Direct Payment P A
80 Deprecated eWAY Shared Payment P A
62 DIBS P A
82 DirectOne P A
29 DPS PX Access P A
28 DPS PX Post P A
39 ECHO (Intuit Payment Solutions) P A
83 eMerchantPay (Secure Payment Form) P A
92 eWAY Direct Payment (Rapid API) P A
95 eWAY Responsive Shared (Rapid API) P A
10 FirstData Connect P A
53 FRIbetaling P A
65 Gate2Shop P A
99 Global Payments Redirect P A
98 Global Payments Remote P A
13 HSBC P A
56 iDEAL P A
24 iDEAL Buckaroo P A
44 Ingenico (ex Ogone Direct) P A
45 Ingenico (ex Ogone Web) P A
27 Innovative P A
49 Intuit Merchant Services (QuickBooks Payments) P A
64 iTransact Split Form P A
63 iTransact Standard Form P A
79 Merchant Warrior P A
20 Nochex P A
43 PayBox P A
32 Payer P A
55 PayJunction P A
81 PayLeap P A
73 Payment 21 Simple API P A
84 Paysite-cash P A
74 PayTrace P A
26 Redsys P A
100 RocketGate Native P A
14 Sage Pay direct P A
15 Sage Pay form P A
30 Sage Payment Solutions P A
40 SCB P A
76 Skrill eWallet (ex Moneybookers) P A
75 Skrill QuickCheckout (ex Moneybookers) P A
71 Sofort Banking P A
48 SP Plus P A
7 ThaiePay P A
59 Total Web Solutions Pay Page P A
5 Virtual Merchant P A
52 Westpac P A
70 Winbank (Piraeus) Redirection P A
68 WorldNet TPS XML Gateway P A
31 Worldpay P A
101 WorldPayHpp P worldpayhpp A
77 Worldpay Cardsave P A