/usr/sbin/mysqld, Version: 5.5.54-0+deb8u1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 170214  7:06:45
# User@Host: root[root] @  [127.0.0.1]
# Query_time: 7.109967  Lock_time: 0.000147 Rows_sent: 0  Rows_examined: 958638
use fange_x100_multicraft;
SET timestamp=1487045205;
DELETE FROM character_skills WHERE character_skills.charId NOT IN (SELECT charId FROM characters);
# Time: 170214  7:06:55
# User@Host: root[root] @  [127.0.0.1]
# Query_time: 8.449721  Lock_time: 0.000140 Rows_sent: 0  Rows_examined: 928019
SET timestamp=1487045215;
DELETE FROM items WHERE loc <> 'clanwh' and items.owner_id NOT IN (SELECT charId FROM characters) && items.owner_id > 1000000;
# Time: 170214  7:07:08
# User@Host: root[root] @  [127.0.0.1]
# Query_time: 9.963569  Lock_time: 0.000116 Rows_sent: 0  Rows_examined: 928019
SET timestamp=1487045228;
INSERT INTO temporaryObjectTable (object_id) SELECT object_id FROM items;