| use fawiki_p;
select af_id
from abuse_filter_action
join abuse_filter
on... |
6 years ago |
| use fawiki_p;
select *
from abuse_filter_action
join abuse_filter
on... |
6 years ago |
| use fawiki_p;
select *
from abuse_filter_action
where afa_consequence = 'block' |
6 years ago |
| use fawiki_p;
select *
from abuse_filter_action |
6 years ago |
| use fawiki_p;
select *
from abuse_filter
where af_enabled = 1 |
6 years ago |
| use fawiki_p;
select * from abuse_filter |
6 years ago |
| use fawiki_p;
select count(*) from abuse_filter |
6 years ago |
| use fawiki_p;
select count(*) from abusefilter |
6 years ago |
| use enwiki_p;
select count(*) from user_groups where ug_group = 'extendedconfirmed'; |
7 years ago |
| use enwiki_p;
select distinct ug_group from user_groups;
-- select count(*)... |
7 years ago |
| use fawiki_p;
select * from user where user_id in (446675, 464044, 486431,... |
7 years ago |
| use fawiki_p;
select * from user where user_id in (446675, 489444, 514788,... |
7 years ago |
| use fawiki_p;
select * from user where user_id in (446675, 489444, 514788, 515131) |
7 years ago |
| use fawiki_p;
select * from user where user_id = 489444 |
7 years ago |
| use fawiki_p;
select rev_user_text, min(rev_timestamp) from revision where... |
7 years ago |
| use fawiki_p;
select rev_user_text, min(rev_timestamp) from revision where... |
7 years ago |
| use fawiki_p;
select min(rev_timestamp) from revision where rev_user = 3964; |
7 years ago |
| use fawiki_p;
select min(rev_timestamp) from revision where rev_user = 3964; |
7 years ago |
| use fawiki_p;
select min(rev_timestamp) from revision where rev_user = 3964; |
7 years ago |
| use fawiki_p;
select min(rev_timestamp) from revision were rev_user = 3964; |
7 years ago |
| use fawiki_p;
select distinct page_id, page_title from page join iwlinks on... |
7 years ago |
| use fawiki_p;
select distinct page_id, page_title from page join iwlinks on... |
7 years ago |
| use fawiki_p;
select distinct page_title from page join iwlinks on page_id =... |
7 years ago |
