Fork of
Page creation date
by Jayprakash12345
This query is marked as a draft
This query has been published
by Jayprakash12345.
SQL
AخA
SELECT rev_timestamp, page.page_title
FROM revision
RIGHT JOIN page ON rev_page = page.page_id
WHERE rev_parent_id=0 AND rev_page IN (
SELECT cl_from
FROM categorylinks
INNER JOIN page ON cl_from = page.page_id
WHERE cl_to = 'Images_from_Wiki_Loves_Folklore_2022' AND page_namespace=6 AND page_is_redirect=0
)
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.