Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +-----------------------------------+------------------------------+---------------+---------------------+----------+
- | id | encounter_id | spawnpoint_id | scan_time | tth_secs |
- +-----------------------------------+------------------------------+---------------+---------------------+----------+
- | MTMyMTg1NjEyOTIzNjAyOTg3MDc=_3116 | MTMyMTg1NjEyOTIzNjAyOTg3MDc= | 6acd4c5f7a5 | 2017-03-22 05:51:56 | NULL |
- | MTMyMTg1NjEyOTIzNjAyOTg3MDc=_150 | MTMyMTg1NjEyOTIzNjAyOTg3MDc= | 6acd4c5f7a5 | 2017-03-22 06:02:30 | NULL |
- | ODA1OTgwNTUwNDEyNDk3MjI3OA==_384 | ODA1OTgwNTUwNDEyNDk3MjI3OA== | 6acd4c5f7a5 | 2017-03-22 09:06:24 | NULL |
- | MTEyMTIyNTgxMDA0OTYxOTk1MzQ=_718 | MTEyMTIyNTgxMDA0OTYxOTk1MzQ= | 6acd4c5f7a5 | 2017-03-22 13:11:58 | NULL |
- | NzIyMjgyODYzNTY1NTA5NDYwMQ==_2930 | NzIyMjgyODYzNTY1NTA5NDYwMQ== | 6acd4c5f7a5 | 2017-03-22 13:48:50 | NULL |
- | NzIyMjgyODYzNTY1NTA5NDYwMQ==_2943 | NzIyMjgyODYzNTY1NTA5NDYwMQ== | 6acd4c5f7a5 | 2017-03-22 13:49:03 | NULL |
- | NzIyMjgyODYzNTY1NTA5NDYwMQ==_508 | NzIyMjgyODYzNTY1NTA5NDYwMQ== | 6acd4c5f7a5 | 2017-03-22 14:08:28 | NULL |
- | NzIyMjgyODYzNTY1NTA5NDYwMQ==_808 | NzIyMjgyODYzNTY1NTA5NDYwMQ== | 6acd4c5f7a5 | 2017-03-22 14:13:28 | 825 |
- | NTQ3MjA4NjY5ODczMzM3NTc1NA==_2797 | NTQ3MjA4NjY5ODczMzM3NTc1NA== | 6acd4c5f7a5 | 2017-03-22 14:46:37 | NULL |
- | NTQ3MjA4NjY5ODczMzM3NTc1NA==_516 | NTQ3MjA4NjY5ODczMzM3NTc1NA== | 6acd4c5f7a5 | 2017-03-22 15:08:36 | NULL |
- | MTIzMTQwMjIwODE1NjQyMjM4ODc=_2682 | MTIzMTQwMjIwODE1NjQyMjM4ODc= | 6acd4c5f7a5 | 2017-03-22 15:44:42 | NULL |
- | MTIzMTQwMjIwODE1NjQyMjM4ODc=_519 | MTIzMTQwMjIwODE1NjQyMjM4ODc= | 6acd4c5f7a5 | 2017-03-22 16:08:39 | NULL |
- | MTUzNTc5MDAwOTA4MzYzMDE0NTM=_3001 | MTUzNTc5MDAwOTA4MzYzMDE0NTM= | 6acd4c5f7a5 | 2017-03-22 16:50:01 | NULL |
- | MTUzNTc5MDAwOTA4MzYzMDE0NTM=_501 | MTUzNTc5MDAwOTA4MzYzMDE0NTM= | 6acd4c5f7a5 | 2017-03-22 17:08:21 | NULL |
- | MTQ4NzMwNjcyNjY0NzYyNDQwMTc=_3006 | MTQ4NzMwNjcyNjY0NzYyNDQwMTc= | 6acd4c5f7a5 | 2017-03-22 17:50:06 | NULL |
- | MTQ4NzMwNjcyNjY0NzYyNDQwMTc=_470 | MTQ4NzMwNjcyNjY0NzYyNDQwMTc= | 6acd4c5f7a5 | 2017-03-22 18:07:50 | NULL |
- | ODkxNjAyMDE3NDI1NjEwMDcyOA==_2867 | ODkxNjAyMDE3NDI1NjEwMDcyOA== | 6acd4c5f7a5 | 2017-03-22 18:47:47 | NULL |
- | ODkxNjAyMDE3NDI1NjEwMDcyOA==_498 | ODkxNjAyMDE3NDI1NjEwMDcyOA== | 6acd4c5f7a5 | 2017-03-22 19:08:18 | NULL |
- | NzA1MzAxNzQ1ODk3MDk5NzMxNA==_2838 | NzA1MzAxNzQ1ODk3MDk5NzMxNA== | 6acd4c5f7a5 | 2017-03-22 19:47:18 | NULL |
- | NzA1MzAxNzQ1ODk3MDk5NzMxNA==_509 | NzA1MzAxNzQ1ODk3MDk5NzMxNA== | 6acd4c5f7a5 | 2017-03-22 20:08:29 | NULL |
- | MTY3NDA3NjgyNTQ2MTY0ODc4Mzk=_2805 | MTY3NDA3NjgyNTQ2MTY0ODc4Mzk= | 6acd4c5f7a5 | 2017-03-22 20:46:45 | NULL |
- | MTY3NDA3NjgyNTQ2MTY0ODc4Mzk=_529 | MTY3NDA3NjgyNTQ2MTY0ODc4Mzk= | 6acd4c5f7a5 | 2017-03-22 21:08:49 | NULL |
- | MTQ5MzAxMDAwNDEzNjA4NTQ3ODI=_2739 | MTQ5MzAxMDAwNDEzNjA4NTQ3ODI= | 6acd4c5f7a5 | 2017-03-22 21:45:39 | NULL |
- | MTQ5MzAxMDAwNDEzNjA4NTQ3ODI=_533 | MTQ5MzAxMDAwNDEzNjA4NTQ3ODI= | 6acd4c5f7a5 | 2017-03-22 22:08:53 | NULL |
- | MTAzMDc4Nzg0NDYxMDg3NTQ3OTA=_2777 | MTAzMDc4Nzg0NDYxMDg3NTQ3OTA= | 6acd4c5f7a5 | 2017-03-22 22:46:17 | NULL |
- | MTAzMDc4Nzg0NDYxMDg3NTQ3OTA=_520 | MTAzMDc4Nzg0NDYxMDg3NTQ3OTA= | 6acd4c5f7a5 | 2017-03-22 23:08:40 | NULL |
- | MTE4MDQ1NTU3MDA1OTE1MjM2ODI=_2769 | MTE4MDQ1NTU3MDA1OTE1MjM2ODI= | 6acd4c5f7a5 | 2017-03-22 23:46:09 | NULL |
- | MTE4MDQ1NTU3MDA1OTE1MjM2ODI=_510 | MTE4MDQ1NTU3MDA1OTE1MjM2ODI= | 6acd4c5f7a5 | 2017-03-23 00:08:30 | NULL |
- | MTM1MjUyMDE1MTg2MjU1NzcwNDc=_2716 | MTM1MjUyMDE1MTg2MjU1NzcwNDc= | 6acd4c5f7a5 | 2017-03-23 00:45:16 | NULL |
- | MTM1MjUyMDE1MTg2MjU1NzcwNDc=_495 | MTM1MjUyMDE1MTg2MjU1NzcwNDc= | 6acd4c5f7a5 | 2017-03-23 01:08:15 | NULL |
- | MTA2OTAzOTMyMjk1MDcyNzU4OTY=_2798 | MTA2OTAzOTMyMjk1MDcyNzU4OTY= | 6acd4c5f7a5 | 2017-03-23 01:46:38 | NULL |
- | MTA2OTAzOTMyMjk1MDcyNzU4OTY=_510 | MTA2OTAzOTMyMjk1MDcyNzU4OTY= | 6acd4c5f7a5 | 2017-03-23 02:08:30 | NULL |
- | NjgzMTU1NDI0ODA4OTMwMDc4MA==_2854 | NjgzMTU1NDI0ODA4OTMwMDc4MA== | 6acd4c5f7a5 | 2017-03-23 02:47:34 | NULL |
- | NjgzMTU1NDI0ODA4OTMwMDc4MA==_487 | NjgzMTU1NDI0ODA4OTMwMDc4MA== | 6acd4c5f7a5 | 2017-03-23 03:08:07 | NULL |
- | MTE1MzQyNTUwODMyMzExNjYwMDk=_2955 | MTE1MzQyNTUwODMyMzExNjYwMDk= | 6acd4c5f7a5 | 2017-03-23 03:49:15 | NULL |
- | MTE1MzQyNTUwODMyMzExNjYwMDk=_473 | MTE1MzQyNTUwODMyMzExNjYwMDk= | 6acd4c5f7a5 | 2017-03-23 04:07:53 | NULL |
- +-----------------------------------+------------------------------+---------------+---------------------+----------+
- 36 rows in set (0.25 sec)
- mysql> select id, last_scanned, kind, links, missed_count, latest_seen, earliest_unseen from spawnpoint where earliest_unseen != latest_seen;
- +-------------+---------------------+------+-------+--------------+-------------+-----------------+
- | id | last_scanned | kind | links | missed_count | latest_seen | earliest_unseen |
- +-------------+---------------------+------+-------+--------------+-------------+-----------------+
- | 6acd4c5f7a5 | 2017-03-23 04:07:54 | hhss | hh?? | 1 | 764 | 1107 |
- +-------------+---------------------+------+-------+--------------+-------------+-----------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement