select r.rev_actor, r.rev_page, r.rev_id, r.rev_timestamp
from revision... |
1 year ago |
select rev_actor, max(rev_timestamp) last_edit
from revision
where... |
1 year ago |
select distinct(rev_actor)
from revision
where rev_minor_edit = 0 and... |
1 year ago |
select rev_page, rev_timestamp, rev_id, rev_actor
from revision
where... |
1 year ago |
select *
from revision
limit 1 |
1 year ago |