|
select wat.user_id, count(wat.user_id)
from (select... |
8 years ago |
| select wat.user_id, count(wat.user_id)
from (select r.rev_user as... |
8 years ago |
| select * from revision_userindex where rev_user_text = 'YuviPanda'; |
8 years ago |
| select * from revision_userindex where rev_user = '17347449'; |
8 years ago |
| select * from revision_userindex where rev_user = 17347449; |
8 years ago |
| use metawiki_p;
select * from revision_userindex limit 5; |
8 years ago |
| use metawiki_p;
select * from revision_userindex where rev_user = 17347449; |
8 years ago |
| use metawiki_p;
select * from revision_userindex where rev_user = 3480841 LIMIT 5;
|
8 years ago |
| use metawiki_p;
select wat.user_id, count(wat.user_id)
from (select... |
8 years ago |
| use metawiki_p;
select wat.user_id, count(wat.user_id)
from (select... |
8 years ago |
| use metawiki_p;
select wat.user_id, count(wat.user_id)
from (select... |
8 years ago |
| select * from revision limit 5; |
8 years ago |
| use metawiki_p;
select wat.user_id, count(wat.user_id)
from (select... |
8 years ago |
| use metawiki_p;
select wat.user_id, count(wat.user_id)
from (select... |
8 years ago |
| select wat.user_id, count(wat.user_id)
from (select r.rev_user... |
8 years ago |
| describe user; |
8 years ago |
| -- select user_id from user_groups join user on user_id = ug_user where... |
8 years ago |
| -- select user_id from user_groups join user on user_id = ug_user where... |
8 years ago |
| -- select user_id from user_groups join user on user_id = ug_user where... |
8 years ago |
| select * from user_groups join user on user_id = ug_user where ug_group='bot'; |
8 years ago |
| select count(*) from user_groups where ug_group='bot'; |
8 years ago |
| select * from user_groups where ug_group='bot' limit 5; |
8 years ago |
| select * from user_groups limit 5; |
8 years ago |
| describe user;
|
8 years ago |
