| blank query |
3 years ago |
| select * from user
order by user_editcount desc
limit 10;
use... |
3 years ago |
| select * from user
order by user_editcount desc
limit 10;
use... |
3 years ago |
| select * from jawiki_p.user
order by jawiki_p.user_editcount desc
limit... |
3 years ago |
| select * from jawiki_p.user
order by jawiki_p.user_editcount desc
limit 10 |
3 years ago |
| select * from user
order by user_editcount desc
limit 10 |
3 years ago |
| select * from user
order by user_editcount
limit 10 |
3 years ago |
| select * from user
order by user_editcount
limit 10 |
3 years ago |
| select *
from user
limit 10
order by user_editcount; |
3 years ago |
| select *
from user
limit 10
order by user_editcount; |
3 years ago |
| select *
from user
limit 10
order by user_editcount; |
3 years ago |
| select *
from user
limit 10
order by user_editcount; |
3 years ago |
| select *
from user
limit 10
order by user_editcount |
3 years ago |
| select *
from user
limit 10
order by user_editcount desc |
3 years ago |
| select *
from user
limit 10
/*order by user_editcount desc*/ |
3 years ago |
| select *
from user
limit 100
/*order by user_editcount desc |
3 years ago |
| select *
from user
limit 100
/*order by user_editcount desc |
3 years ago |
| select *
from user
limit 100
order by user_editcount desc |
3 years ago |
| select *
from user
limit 100 |
3 years ago |
| select *
from user
limit 100 |
3 years ago |
| use jawiki_p;
select rev_id, rev_actor, rev_len, rev_len
from... |
3 years ago |
| use jawiki_p;
select diff_rev.rev_id, diff_rev.rev_actor, orig_rev.rev_len,... |
3 years ago |
| use jawiki_p;
select diff_rev.rev_id, diff_rev.rev_actor, orig_rev.rev_len,... |
3 years ago |
| use jawiki_p;
select rev_id, rev_actor, rev_len, rev_parent_id
from... |
3 years ago |
| use jawiki_p;
select *
from
(select rev_id, rev_actor, rev_len,... |
3 years ago |
| use jawiki_p;
select
from
(select rev_id, rev_actor, rev_len,... |
3 years ago |
| use jawiki_p;
(select rev_id, rev_actor, rev_len, rev_parent_id
from... |
3 years ago |
| use jawiki_p;
select *
from revision
where rev_page = 6 |
3 years ago |
| use jawiki_p;
select *
from revision
limit 100 |
3 years ago |
| use jawiki_p;
select *
from revision
limit 100 |
3 years ago |
| blank query |
3 years ago |
| use ptwiki_p;
select left(log_timestamp,8), count(*)
from logging
where... |
3 years ago |
| use ptwiki_p;
select left(log_timestamp,8), count(*)
from logging
where... |
3 years ago |
| use ptwiki_p;
select left(log_timestamp,8), count(*)
from logging
where... |
3 years ago |
| use ptwiki_p;
select log_timestamp, log_id
from logging
where log_type =... |
3 years ago |
| use ptwiki_p;
select *
from logging
where log_type = 'newusers' and... |
3 years ago |
| use ptwiki_p;
select *
from logging
where log_type = 'newusers'
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from logging
where log_type = 'accountcreate'
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from logging
where log_type = 'create'
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from logging
where logtype = 'create'
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from logging
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from logging_log
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where afl_action = 'edit' and
... |
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where afl_action = 'edit' and
... |
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where afl_action = 'edit' and
... |
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where afl_action = 'edit' and
... |
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where alf_action = 'edit' and
... |
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where afl_filter = 180
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
limit 100
|
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
where afl_timestamp > 20200801000000 |
3 years ago |
| use ptwiki_p;
select *
from abuse_filter_log
limit 100 |
3 years ago |
| blank query |
3 years ago |
| "I am Quarry User." |
3 years ago |
| print "I am Quarry User." |
3 years ago |
| comment "I am Quarry User." |
3 years ago |
| comment "I am Quarry User." |
3 years ago |
| use jawiki_p;
select ug_group, count(*) from user_groups
group by ug_group |
3 years ago |
| use jawiki_p;
select * from user_groups
limit 100 |
3 years ago |
| use jawiki_p;
select * from user_groups
limit 10 |
3 years ago |
| use jawiki_p;
select pt_expiry, pt_create_perm, count(*)
from... |
3 years ago |
| use jawiki_p;
select *
from protected_titles |
3 years ago |
| use jawiki_p;
select count(*)
from protected_titles |
3 years ago |
| use jawiki_p;
select *
from protected_titles
where pt_title like '%犯罪%'
limit 100 |
3 years ago |
| use jawiki_p;
select *
from protected_titles
where pt_title like... |
3 years ago |
| use jawiki_p;
select *
from protected_titles
limit 100 |
3 years ago |
| use dewiki_p;
select up_value, count(*) as 'deusers by gender' from... |
3 years ago |
| use enwiki_p;
select up_value, count(*) as 'number' from... |
3 years ago |
| use enwiki_p;
select * from user_properties
where up_property = 'gender'
limit 100 |
3 years ago |
| use enwiki_p;
select * from user_properties
limit 100 |
3 years ago |
| use enwiki_p;
select * from user
limit 100 |
3 years ago |
