EXPLAIN SELECT
   e.*
FROM
   (
   SELECT
       a.group_id,
       a.group_name,
       a.target_return,
       a.invest_money,
       a.create_time,
       a.currency_category_rate,
       a.bond_category_rate,
       a.stock_category_rate,
       a.commodity_category_rate,
       a.deposit_rate,
       a.bank_financial_rate,
       a.public_fund_rate,
       a.risk,
       a.bank_risk,
       a.public_risk,
       a.invest_duration,
       a.group_type,
       c.customer_name,
       c.sex AS customerSex,
       d.group_name AS basicGroupName
   FROM
       assets_config_wealth_group_base a
       LEFT JOIN group_basic d ON a.group_type = d.group_id
       LEFT JOIN customer_self_group_relation b ON a.group_id = b.group_id
       LEFT JOIN customer_self_base_info c ON b.customer_id = c.customer_id
   WHERE
       a.customer_id IS NOT NULL
       AND a.user_id = 'ht4'
       AND a.org_id = 6510021
       AND a.target_return IS NULL
       AND a.is_del = 0 UNION ALL
   SELECT
       a.group_id,
       a.group_name,
       a.target_return,
       a.invest_money,
       a.create_time,
       a.currency_category_rate,
       a.bond_category_rate,
       a.stock_category_rate,
       a.commodity_category_rate,
       a.deposit_rate,
       a.bank_financial_rate,
       a.public_fund_rate,
       a.risk,
       a.bank_risk,
       a.public_risk,
       a.invest_duration,
       a.group_type,
       c.customer_name,
       c.sex AS customerSex,
       d.group_name AS basicGroupName
   FROM
       assets_config_wealth_group_base a
       LEFT JOIN group_basic d ON a.group_type = d.group_id
       LEFT JOIN customer_other_group_relation b ON a.group_id = b.group_id
       LEFT JOIN customer_other_base_info c ON b.customer_id = c.customer_id
   WHERE
       a.customer_id IS NULL
       AND a.user_id = 'ht4'
       AND a.target_return IS NULL
       AND a.org_id = 6510021
       AND a.is_del = 0
   ) e
WHERE
   1 = 1

github上的代码现在为什么下载不了

啊牛二

1个回复