| use enwiki_p;
select
page_title,
ll_title
from page
join langlinks
on... |
3 years ago |
| use enwiki_p;
select
page_title,
ll_title
from page
join langlinks
on... |
3 years ago |
| use enwiki_p;
select
page_title,
ll_title
from page
join langlinks
on... |
3 years ago |
| use dewiki_p;
select
page_len_category,
count(*) as freq
from (
... |
5 years ago |
| use fawiki_p;
select page_title, rev_comment, rev_user_text,... |
5 years ago |
| use fawiki_p;
select *
from revision
join page
on rev_page = page_id
where... |
5 years ago |
| use fawiki_p;
select *
from revision
where rev_timestamp between... |
5 years ago |
| use fawiki_p;
select *
from revision
where rev_timestamp between... |
5 years ago |
| use fawiki_p;
select user_name
from user_former_groups
join user
on user_id... |
5 years ago |
| use fawiki_p;
select *
from user_former_groups
where ufg_group = 'templateeditor' |
5 years ago |
| use fawiki_p;
select distinct ug_group
from user_groups |
5 years ago |
