| use fawiki_p;
SELECT
page_title,
COUNT(*) reverts
FROM revision
JOIN... |
6 years ago |
| use fawiki_p;
SELECT
page_title,
COUNT(*) reverts
FROM revision
JOIN... |
6 years ago |
| use fawiki_p;
select page_title, count(*) reverts
from revision
join page
... |
6 years ago |
| use fawiki_p;
select page_namespace, page_title, count(*) reverts
from... |
6 years ago |
| use fawiki_p;
select page_namespace, page_title, count(*) reverts
from... |
6 years ago |
| use fawiki_p;
select page_namespace, page_title, count(*) reverts
from... |
6 years ago |
| use fawiki_p;
select rev_page, count(*)
from revision
where rev_comment like... |
6 years ago |
| use enwiki_p;
select rev_page, count(*)
from revision
where rev_comment like... |
6 years ago |
| use enwiki_p;
select rev_page, count(*)
from revision
use index... |
6 years ago |
| use enwiki_p;
select rev_page, count(*)
from revision
use index... |
6 years ago |
| use enwiki_p;
select rev_page, count(*)
from revision
/*join page
on... |
6 years ago |
| use enwiki_p;
select rev_page, count(*)
from revision
/*join page
on... |
6 years ago |
| use enwiki_p;
select rev_page, count(*)
from revision
/*join page
on... |
6 years ago |
| use enwiki_p;
select page_namespace, page_title, count(*)
from revision
join... |
6 years ago |
| use enwiki_p;
select page_namespace, page_title, count(*)
from revision
join... |
6 years ago |
| use enwiki_p;
select page_namespace, page_title, count(*)
from revision
join... |
6 years ago |
| use enwiki_p;
select *
from langlinks
where ll_from = 17181314 |
6 years ago |
| use enwiki_p;
show tables; |
6 years ago |
| use en_wiki;
show tables; |
6 years ago |
| use fawiki_p;
select
user_name,
user_editcount,
user_registration,
... |
7 years ago |
| use fawiki_p;
select
user_name,
user_editcount,
user_registration,
... |
7 years ago |
| use fawiki_p;
select user_name, user_editcount, user_registration
from... |
7 years ago |
| use fawiki_p;
select user_id
from user
left join user_groups
on ug_user =... |
7 years ago |
| use fawiki_p;
select *
from user
left join user_groups
on ug_user =... |
7 years ago |
| use fawiki_p;
select *
from user
left join user_groups
on ug_user =... |
7 years ago |
| use fawiki_p;
select *
from user
where user_editcount > 15000; |
7 years ago |
| use fawiki_p;
select *
from user
limit 10; |
7 years ago |
