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