SELECT
*
FROM
(
( SELECT 'ip' AS type, id, ip_addr AS title, threat_type, CONCAT( inform_date ) AS date FROM threat_ip_db ) UNION
( SELECT 'url' AS type, id, url AS title, threat_type, CONCAT( inform_date ) AS date FROM threat_url_db )
) AS c
ORDER BY
date DESC
LIMIT 20 OFFSET 0
通过UNION
关键字将两个查询结果拼接起来