Untitled query #19968 - Quarry

This query is marked as a draft This query has been published by Slaporte.

SQL

SELECT page_title, rev_timestamp, rev_timestamp
FROM page
JOIN categorylinks
ON categorylinks.cl_from = page.page_id
JOIN revision 
ON revision.rev_page = page.page_id
AND revision.rev_timestamp = (SELECT MIN(rev_timestamp) as r FROM revision WHERE revision.rev_page = page.page_id)
WHERE cl_to = "Diabetes";

AخA
 
SELECT page_title, rev_timestamp, rev_timestampFROM pageJOIN categorylinksON categorylinks.cl_from = page.page_idJOIN revision ON revision.rev_page = page.page_idAND revision.rev_timestamp = (SELECT MIN(rev_timestamp) as r FROM revision WHERE revision.rev_page = page.page_id)WHERE cl_to = "Diabetes";

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...