一表多连的sql语句

CREATE TABLE if not exists tmp_c5online_table(
        `role_name` VARCHAR(255) NOT NULL
);

insert into tmp_c5online_table
SELECT distinct(r.account)
FROM
        hdzm_gamedb.RolesTable r
        ,hdzm_log.role_duration_log as l
        ,hdzm_log.role_duration_log as l0
        ,hdzm_log.role_duration_log as l1
        ,hdzm_log.role_duration_log as l2
        ,hdzm_log.role_duration_log as l3
        ,hdzm_log.role_duration_log as l4
where
        DATEDIFF(now(), l0.online_date) = 0 and l0.role_name = l.role_name
        and DATEDIFF(now(), l1.online_date) = 1 and l1.role_id = l.role_id
        and DATEDIFF(now(), l2.online_date) = 2 and l2.role_id = l.role_id
        and DATEDIFF(now(), l3.online_date) = 3 and l3.role_id = l.role_id
        and DATEDIFF(now(), l4.online_date) = 4 and l4.role_id = l.role_id
        and r.role_id = l.role_id
;

insert into xxx_gamedb.AccountsAward (`account`, `awards`, `award_time`, `award_type`)
select role_name, "3300012:10;5040000:5;5040002:1", now(), 1001
from tmp_c5online_table c2
where
role_name not in (
        select c5.role_name from tmp_c5online_table  c5, xxx_gamedb.AccountsAward  a
        where
        c5.role_name = a.account
        and DATEDIFF( now(), a.award_time) <= 4
        and a.award_type = 1001
)
;

drop table tmp_c5online_table;