mysql inner join与 left jion 连用

SELECT
    a.uuid,
    a.pay_id,
    b.core_enterprise_name,
    a.financial_institutions_id,
    c.financial_institutions_name,
    d.sign_body_name,
    a.periods,
    e.suppliers_name,
    a.suppliers_account,
    a.open_account_bank,
    a.account_name,
    a.suppliers_rate_biz,
    f.item_company_name,
    a.loan_date,
    a.account_receivable,
    a.due_date,
    a.suppliers_money,
    a.contract_type,
    a.pay_priority,
    a.item_name,
    a.transfer_apply_date,
    g.region_name,
    h.contract_name,
    a.base_contract_name,
    a.base_contract_no,
    l.large_region_name,
  b1.supplement_status
FROM
    biz_pay_comfirm_info a LEFT JOIN biz_supplement_account b1 on a.pay_id = b1.pay_id and b1.sys_status = 1,
    biz_core_enterprise b,
    biz_financial_institutions c,
    biz_signing_body d,
    biz_suppliers e,
    biz_item_company f,
    biz_contract_info h,
    biz_item_region g
LEFT JOIN biz_large_region_mapping k ON g.uuid = k.item_region_uuid
AND k.sys_status = 1
LEFT JOIN biz_large_region l ON k.large_region_uuid = l.uuid
AND l.sys_status = 1
WHERE
    a.core_enterprise_id = b.uuid
AND a.financial_institutions_id = c.uuid
AND a.signing_body_id = d.uuid
AND a.suppliers_id = e.uuid
AND a.item_company_id = f.uuid
AND f.region_id = g.uuid
AND a.contract_id = h.uuid
AND a.sys_status = 1
AND b.sys_status = 1
AND c.sys_status = 1
AND d.sys_status = 1
AND f.sys_status = 1
AND g.sys_status = 1
AND h.sys_status = 1
and a.financial_institutions_id  = 'f1022' 
and a.periods = '1'