Fork of
Peek one record from the page table
by Davesh0
This query is marked as a draft
This query has been published
by Davesh0.
SQL
x
select p.page_title as 'Title', group_concat(c.cl_to) as 'Categories', r.rev_timestamp as 'Last edit date',
concat('https://war.wikipedia.org/wiki/', p.page_title) as 'URL'
from page p
join revision r on p.page_latest=r.rev_id
join categorylinks c on c.cl_from=p.page_id
where p.page_namespace=0
and p.page_is_redirect=0
and r.rev_timestamp<'20200101000000'
group by p.page_title
limit 2;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.