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 |