Query Run
select row_number() over (order by page_latest desc) as ord, ... 1 year ago
select row_number() over (order by page_latest desc) as ord, ... 1 year ago
select row_number() over (order by page_latest desc) as ord, ... 1 year ago
select row_number() over (order by page_latest desc) as ord, ... 1 year ago
select row_number() over (order by page_latest desc) as ord, ... 1 year ago
select row_number() over (order by page_latest desc) as ord, ... 1 year ago
select page_title, max(page_latest) as latest_rev_id from page ... 1 year ago