SELECT 
  a.localization_id, 
  a.status, 
  b.localization, 
  a.is_default 
FROM 
  netting_localizations AS a 
  LEFT JOIN netting_localization_descriptions AS b ON a.localization_id = b.localization_id 
  AND b.lang_code = 'en' 
  LEFT JOIN netting_localization_elements AS c ON a.localization_id = c.localization_id 
  AND c.element_type = 'L' 
  RIGHT JOIN netting_languages AS d ON c.element = d.lang_code 
  AND d.status = 'A' 
WHERE 
  a.status = 'A' 
ORDER BY 
  localization

Query time 0.00023

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}