| use hewiki_p;
select * from page
where page_namespace = 0
and not... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and (page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and (page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and (page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and ((page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and ((page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and (page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and page_title... |
4 years ago |
| use hewiki_p;
select * from page
where page_namespace = 0
and page_title... |
4 years ago |
| use hewiki_p;
select count(distinct(cl_to)) from categorylinks
where... |
4 years ago |
| use hewiki_p;
select count(distinct(cl_to)) from categorylinks
where... |
4 years ago |
| use hewiki_p;
select count(distinct(cl_to)) from categorylinks
limit 10
|
4 years ago |
| use hewiki_p;
select distinct(cl_to) from categorylinks
limit 10
|
4 years ago |
| use hewiki_p;
select count(*) from page
where page_namespace = 14
and... |
4 years ago |
| use hewiki_p;
select count(*) from page
where page_namespace = 14
|
4 years ago |
| use hewiki_p;
select * from page
where page_is_redirect
and page_title like... |
4 years ago |
| use hewiki_p;
select * from revision
where rev_page = 1146186
|
5 years ago |
| use hewiki_p;
select * from revision limit 100 |
5 years ago |
| use hewiki_p;
describe revision
|
5 years ago |
| use hewiki_p;
show tables
|
5 years ago |
| use hewiki_p;
select count(*) from page
where page_is_redirect |
5 years ago |
| use hewiki_p;
select count(*) from page
where not page_is_redirect |
5 years ago |
| use hewiki_p;
select count(*) from page |
5 years ago |
| use hewiki_p;
select page_title, page_namespace, page_restrictions.* from... |
5 years ago |
| use hewiki_p;
select * from page_restrictions
where pr_level =... |
5 years ago |
| use hewiki_p;
select * from page_restrictions
where pr_level = "templateeditor" |
5 years ago |
| use hewiki_p;
select distinct(pr_page) from page_restrictions
where pr_level... |
5 years ago |
| use hewiki_p;
/*select distinct(pr_page) from page_restrictions
where... |
5 years ago |
| use hewiki_p;
/*select distinct(pr_page) from page_restrictions
where... |
5 years ago |
| use hewiki_p;
/*select distinct(pr_page) from page_restrictions
where... |
5 years ago |
| use hewiki_p;
/*select distinct(pr_page) from page_restrictions
where... |
5 years ago |
| use hewiki_p;
/*select distinct(pr_page) from page_restrictions
where... |
5 years ago |
| use hewiki_p;
select distinct(pr_page) from page_restrictions
where pr_level... |
5 years ago |
| use hewiki_p;
select distinct(pr_page) from page_restrictions
where pr_level... |
5 years ago |
| use hewiki_p;
select distinct(pr_page) from page_restrictions
where pr_level... |
5 years ago |
| use hewiki_p;
select distinct(pr_page) from page_restrictions
where pr_level... |
5 years ago |
| use hewiki_p;
select distinct(pr_page) from page_restrictions
where pr_level... |
5 years ago |
| use hewiki_p;
select count(*) from page_restrictions
where pr_level =... |
5 years ago |
| use hewiki_p;
select count(*) from page_restrictions
where pr_level =... |
5 years ago |
| use hewiki_p;
select count(*) from page_restrictions
where pr_level =... |
5 years ago |
| use hewiki_p;
select count(*) from page_restrictions
where pr_level =... |
5 years ago |
| use hewiki_p;
select distinct(pr_level) from page_restrictions
limit 10
|
5 years ago |
| use hewiki_p;
select distinct(pr_type) from page_restrictions
limit 10
|
5 years ago |
| use hewiki_p;
select * from page_restrictions
limit 10
|
5 years ago |
| use hewiki_p;
describe page_restrictions
|
5 years ago |
| use hewiki_p;
show tables
|
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp, fr_page_id from flaggedrevs... |
5 years ago |
| use ruwiki_p;
select * from (
select page_title, fr_timestamp, fr_page_id... |
5 years ago |
| use ruwiki_p;
select * from (
select page_title, fr_timestamp, fr_page_id... |
5 years ago |
| use ruwiki_p;
select * from (
select page_title, fr_timestamp from... |
5 years ago |
| use ruwiki_p;
select * from (
select page_title, fr_timestamp from... |
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp from flaggedrevs as main join... |
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp from flaggedrevs as main join... |
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp from flaggedrevs as main order... |
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp from flaggedrevs order by... |
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp from flaggedrevs as main join... |
5 years ago |
| use ruwiki_p;
select page_title, fr_timestamp from flaggedrevs as main join... |
5 years ago |
| use ruwiki_p;
select * from flaggedrevs as main join page
on fr_page_id =... |
5 years ago |
| use ruwiki_p;
select * from flaggedrevs as main join page
on fr_page_id =... |
5 years ago |
| use ruwiki_p;
select * from flaggedrevs join page
on fr_page_id =... |
5 years ago |
| use ruwiki_p;
describe flaggedrevs;
describe flaggedrevs_promote;
describe... |
5 years ago |
| use ruwiki_p;
/*
describe flaggedrevs;
describe... |
5 years ago |
| use ruwiki_p;
describe flaggedrevs;
describe flaggedrevs_promote;
describe... |
5 years ago |
| use ruwiki_p;
show tables |
5 years ago |
