| select *
from revision
where rev_timestamp > 20121106000000 and... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
| select rev_page, rev_timestamp, rev_minor_edit, rev_len, rev_deleted
from... |
2 years ago |
|
select *
from revision
where rev_timestamp > 20121306000000 and... |
2 years ago |
| select *
from revision
where rev_timestamp > 20220101000000 and... |
2 years ago |
|
select *
from revision
where rev_timestamp > 20121106000000 and... |
2 years ago |
|
select *
from revision
where rev_timestamp > 20121106000000 and... |
2 years ago |
|
select *
from revision
where rev_timestamp > 20121106000000 and... |
2 years ago |
|
select max(rev_timestamp)
from revision; |
2 years ago |
|
select *
from revision
where rev_timestamp > 1352160000000 and... |
2 years ago |
|
select *
from revision
where rev_timestamp > 1352160000 and... |
2 years ago |
|
select *
from revision
where rev_timestamp > 1352160000 and... |
2 years ago |
| describe revision; |
2 years ago |
| USE metawiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
rev_actor... |
2 years ago |
| USE enwiki;
SELECT COUNT(*)
FROM revision_userindex
WHERE
rev_actor =... |
2 years ago |
| USE metawiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
rev_actor... |
2 years ago |
