SELECT
a.TOPIC_NAME topicName,
max(a.END_TIME) timeDate,
( SELECT COUNT(a.LOG_ID) ) interFre,
( SELECT sys_name FROM b_sys_info d WHERE SYS_ID = c.SRC_SYS_ID ) src,
( SELECT sys_name FROM b_sys_info d WHERE SYS_ID = c.TGT_SYS_ID ) tgt
FROM
b_topic_log a,
xxl_job_info b,
b_topic_model c
WHERE
a.TASK_ID = b.ID
AND b.EXECUTOR_PARAM = c.MODEL_ID group by a.TOPIC_ID order by timeDate desc ;