SQL
x
USE fawiki_p;
SELECT DISTINCT page_title, page_namespace
FROM revision AS R1 JOIN page ON R1.rev_page = page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND R1.rev_actor = 481
AND R1.rev_page IN (
SELECT R2.rev_page
FROM revision AS R2
WHERE R2.rev_actor = 1985
)
AND R1.rev_timestamp > 20160000000000
LIMIT 100
;
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.