mysql关联查询地区导出数据

SELECT
    a.ent_name,
    a.link_person,
    a.link_mobile,
    d.email,
    e. NAME AS ProvName,
    f. NAME AS CityName,
    g. NAME AS CountryName,
    c.detail,
    a.main_product,
    b.org_code
FROM
    fj_member_cloud_service AS a
LEFT JOIN fj_member_qy AS b ON a.e_id = b.id
LEFT JOIN fj_enterprise_address AS c ON a.e_id = c.e_id
LEFT JOIN fj_enterprise_contacts AS d ON a.e_id = d.e_id
LEFT JOIN fj_sme_db.fj_region AS e ON substring(c.`level`, 1, 2) = e.`level`
LEFT JOIN fj_sme_db.fj_region AS f ON substring(c.`level`, 1, 7) = f.`level`
LEFT JOIN fj_sme_db.fj_region AS g ON substring(c.`level`, 1, 14) = g.`level`;

SELECT
    count(d.e_id) as '经营情况条数',
    a.ent_code as '企业编号',
    a.zjtx_apply_time as '申请日期',
    a.direction as '确认培育方向',
    a.user_direction as '用户申请培育方向',
    b.username as '账号名称',
    b.groupid as '用户类型',
    c.ent_name as '企业名称',
    h.name as '所属行业',
    c.org_code as '组织机构代码',
    c.legal_person as '法人姓名',
    c.legal_person_tel as '法人电话',
    c.mobile as '联系电话',
    c.nickname as '联系人',
    f.name AS '所属省份',
    g.name AS '所属市区',
    c.detail as '详细地址',
    d.total_assets as '公司资产总额(万元)',
    d.business_income as '营业收入(万元)',
    d.main_business_income as '主营业收入(万元)',
    d.main_proportion_income as '主营产品占营业收入比重%',
    d.company_work_num as '从业人员数量(个)',
    d.total_profit as '利润总额(万元)',
    d.pay_taxes as '缴纳税收(万元)',
    d.rd_investment as '研发投入(万元)',
    d.rd_proportion_income as '研发投入占营业收入比重%'
FROM
    fj_sme_enterprise.fj_member_qy a
LEFT JOIN fj_sme_enterprise.fj_member b ON a.userid = b.userid
LEFT JOIN fj_sme_enterprise.fj_member_zjtx c ON a.id = c.e_id
LEFT JOIN fj_sme_enterprise.fj_enterprise_financial d ON a.id = d.e_id
LEFT JOIN fj_sme_enterprise.fj_enterprise_address AS e ON a.id = e.e_id
LEFT JOIN fj_sme_db.fj_region AS f ON substring(e.`level`, 1, 2) = f.`level`
LEFT JOIN fj_sme_db.fj_region AS g ON substring(e.`level`, 1, 7) = g.`level`
LEFT JOIN fj_sme_db.fj_linkage AS h ON a.industry_code=h.linkageid
WHERE
    a.zjtx_status != 4
AND a.zjtx_first_status != 0
GROUP BY
    a.id,
    d.e_id
ORDER BY
    zjtx_apply_time DESC,
    d.created_at DESC