mysql@geo-db-specials-master.query.consul[specials]>SELECT * from events_local_users where user_id = 1624842 limit 20;
+---------+---------+---------------------+-------+---------------------+---------------+------------+---------------------------+----------------------------+-----------------+----------------+
| wiki_id | user_id | user_name | edits | editdate | last_revision | cnt_groups | single_group | all_groups | user_is_blocked | user_is_closed |
+---------+---------+---------------------+-------+---------------------+---------------+------------+---------------------------+----------------------------+-----------------+----------------+
| 604442 | 1624842 | | 0 | 2017-12-14 08:04:57 | 0 | 1 | poweruser | poweruser | 0 | 0 |
| 652499 | 1624842 | 3 | 0 | 2016-03-28 00:47:55 | 752875 | 0 | sysop | poweruser;bureaucrat;sysop | 127 | 0 |
| 656623 | 1624842 | 757009 | 0 | 0000-00-00 00:00:00 | 3 | 0 | H4ck3rm1k3 | 0 | 0 | 127 |
| 657117 | 1624842 | 2016-03-28 08:07:03 | 0 | 0000-00-00 00:00:00 | 0 | 3 | 757503 | 547090 | 0 | 0 |
| 657279 | 1624842 | 547090 | 0 | 2016-03-28 08:22:05 | 757666 | 0 | 3 | poweruser;bureaucrat;sysop | 0 | 0 |
| 657919 | 1624842 | 547090 | 0 | 2016-03-28 09:22:23 | 0 | 3 | poweruser;bureaucrat;syso | 758307 | 0 | 0 |
| 658532 | 1624842 | 3 | 0 | 2016-03-28 10:22:31 | 0 | 0 | 758921 | sysop | 0 | 127 |
| 659134 | 1624842 | 547090 | 0 | 0000-00-00 00:00:00 | 759523 | 3 | sysop | poweruser;bureaucrat;sysop | 0 | 0 |
| 752407 | 1624842 | H4ck3rm1k3 | 0 | 0000-00-00 00:00:00 | 547090 | 0 | 2016-03-28 00:02:43 | poweruser;bureaucrat;sysop | 0 | 127 |
| 752407 | 1624842 | sysop | 0 | 0000-00-00 00:00:00 | 0 | 3 | 0 | 2016-03-28 00:02:43 | 0 | 127 |
| 752559 | 1624842 | H4ck3rm1k3 | 0 | 2016-03-28 00:17:47 | 547090 | 0 | poweruser;bureaucrat;syso | sysop | 127 | 3 |
| 752559 | 1624842 | sysop | 0 | 0000-00-00 00:00:00 | 547090 | 2016 | H4ck3rm1k3 | 0 | 127 | 0 |
| 753686 | 1624842 | 0 | 0 | 0000-00-00 00:00:00 | 0 | 2016 | 0 | 653310 | 0 | 127 |
| 753988 | 1624842 | sysop | 0 | 0000-00-00 00:00:00 | 3 | 32767 | poweruser;bureaucrat;syso | 0 | 127 | 127 |
| 754579 | 1624842 | 0 | 0 | 0000-00-00 00:00:00 | 547090 | 32767 | 3 | poweruser;bureaucrat;sysop | 127 | 0 |
| 755547 | 1624842 | 2016-03-28 05:06:10 | 0 | 0000-00-00 00:00:00 | 0 | 3 | H4ck3rm1k3 | 0 | 127 | 0 |
| 755547 | 1624842 | 3 | 0 | 0000-00-00 00:00:00 | 0 | 0 | 547090 | poweruser;bureaucrat;sysop | 0 | 127 |
| 756370 | 1624842 | 3 | 0 | 0000-00-00 00:00:00 | 655987 | 0 | sysop | 2016-03-28 06:21:31 | 0 | 127 |
| 756370 | 1624842 | sysop | 0 | 0000-00-00 00:00:00 | 547090 | 0 | H4ck3rm1k3 | 3 | 127 | 127 |
| 756525 | 1624842 | 0 | 0 | 2016-03-28 06:36:31 | 547090 | 0 | 656142 | 0 | 3 | 0 |
+---------+---------+---------------------+-------+---------------------+---------------+------------+---------------------------+----------------------------+-----------------+----------------+
20 rows in set (0.00 sec)
Created
December 16, 2017 13:52
-
-
Save macbre/c26ce3e8dfac3caac864b65cfc82e438 to your computer and use it in GitHub Desktop.
INSERT IGNORE example
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment