| use commonswiki_p;
DESCRIBE revision;
#SELECT * FROM revision limit 100 |
4 years ago |
| use commonswiki_p;
SELECT *
FROM revision
limit 100 |
4 years ago |
| use commonswiki_p;
SELECT *
FROM revision
where rev_user_text="JarektBot"
limit 100 |
4 years ago |
| use commonswiki_p;
SELECT rev_user, rev_timestamp
FROM revision
where... |
4 years ago |
| use commonswiki_p;
SELECT rev_user rev_timestamp
FROM revision
where... |
4 years ago |
| use commonswiki_p;
SELECT rev_user_id rev_timestamp
FROM revision
where... |
4 years ago |
| use commonswiki_p;
SELECT *
FROM wfm.mediawiki_history
limit 100 |
5 years ago |
| use commonswiki_p;
SELECT *
FROM mediawiki_history
limit 100 |
5 years ago |
| use commonswiki_p;
SELECT *
FROM wmf.mediawiki_history
limit 100 |
5 years ago |
| use commonswiki_p;
SELECT tl_title, count(*) as tot
FROM... |
6 years ago |
| use commonswiki_p;
SELECT tl_namespace, tl_title, count(*) as tot
FROM... |
6 years ago |
| use commonswiki_p;
SELECT tl_namespace, tl_title, count(*) as tot
group by... |
6 years ago |
| use commonswiki_p;
SELECT tl_namespace, tl_title, count(*) as tot
group by... |
6 years ago |
| use commonswiki_p;
SELECT page_id as pid, count(*) as tot
FROM... |
6 years ago |
| use commonswiki_p;
SELECT count(*)
FROM
page
INNER JOIN templatelinks... |
8 years ago |
| use commonswiki_p;
SELECT count(*)
FROM
page
INNER JOIN templatelinks... |
8 years ago |
