You didn't say whats the problem...
but I can suggest you search Union
query clause
To make union work all query should have same columns number ans name,
I cannot help you more, my database doesn't have those tables, im not logging all this
only
Logins and commands here is an example
SELECT `time`, `user`, CONCAT(loginlog.log,' (', loginlog.ip, ')') as log
FROM `loginlog`
WHERE ip NOT IN ('127.0.0.1', '0.0.0.0', '192.168.2.60')
UNION SELECT atcommand_date as time, account_id as user, CONCAT(char_name,' ', map, ' ', command) as log
FROM atcommandlog
ORDER BY `time` ASC
time user log
2016-06-17 13:46:31 andreia login ok (192.168.2.12)
2016-06-17 13:52:53 andreia login ok (192.168.2.12)
2016-06-17 13:53:36 2000001 Habilis payon @commands
2016-06-17 14:04:17 andreia login ok (192.168.2.12)
2016-06-17 14:08:18 andreia login ok (192.168.2.12)
2016-06-17 14:17:27 2000001 Habilis prontera @go prontera
2016-06-17 14:18:06 andreia login ok (192.168.2.12)
2016-06-17 14:19:02 2000001 Habilis izlude @go izlude
2016-06-17 14:19:53 2000001 Habilis prontera @go prontera
2016-06-17 14:22:45 2000001 Habilis prontera @dye 1
2016-06-17 14:22:51 2000001 Habilis prontera @dye 2
2016-06-17 14:22:54 2000001 Habilis prontera @dye 4
This is a log of logins and atcommands