| select min(r.rev_timestamp), r.rev_page, p.page_title
from revision r
join... |
1 year ago |
| select min(r.rev_timestamp), r.rev_page
from revision r
join page p on... |
1 year ago |
| select distinct(r.rev_page)
from revision r
join page p on r.rev_page =... |
1 year ago |
| select count(distinct(r.rev_id))
from revision r
join page p on r.rev_page =... |
1 year ago |
| select count(distinct(r.rev_actor))
from revision r
join page p on... |
1 year ago |
| select count(distinct(r.rev_actor))
from revision r
join page p on... |
1 year ago |
| select count(distinct(r.rev_actor))
from revision r
join page p on... |
1 year ago |
| select count(distinct(rev_actor))
from revision
where rev_timestamp < 20050000000000 |
1 year ago |
| select count(distinct(rev_actor))
from revision
where rev_timestamp < 20070000000000 |
1 year ago |
| select *
from revision
where rev_id = 1493463 |
1 year ago |
