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

SQL

AخA
 
USE wikidatawiki_p;
SELECT MAX(rev_id) AS rev_id, DATE(rev_timestamp) AS date, page_title, "Aaron Halfaker" AS label 
FROM revision INNER JOIN page ON rev_page = page_id 
WHERE page_namespace = 0 AND page_title = "Q18627581"
GROUP BY date
ORDER BY date;
SELECT MAX(rev_id) AS rev_id, DATE(rev_timestamp) AS date, page_title, "Jimmy Wales" AS label
FROM revision INNER JOIN page ON rev_page = page_id 
WHERE page_namespace = 0 AND page_title = "Q181"
GROUP BY date
ORDER BY date;
SELECT MAX(rev_id) AS rev_id, DATE(rev_timestamp) AS date, page_title, "Douglas Adams" AS label
FROM revision INNER JOIN page ON rev_page = page_id 
WHERE page_namespace = 0 AND page_title = "Q42"
GROUP BY date
ORDER BY date;
SELECT MAX(rev_id) AS rev_id, DATE(rev_timestamp) AS date, page_title, "Biology" AS label
FROM revision INNER JOIN page ON rev_page = page_id 
WHERE page_namespace = 0 AND page_title = "Q420"
GROUP BY date
ORDER BY date;
SELECT MAX(rev_id) AS rev_id, DATE(rev_timestamp) AS date, page_title, "leet" AS label
FROM revision INNER JOIN page ON rev_page = page_id 
WHERE page_namespace = 0 AND page_title = "Q1337"
GROUP BY date
ORDER BY date;
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
All SQL code is licensed under CC0 License.

Checking query status...