USE fawiki_p;

SELECT DISTINCT page_title, page_namespace

FROM revision AS R1 JOIN page ON R1.rev_page = page_id JOIN revision AS R2 ON R2.rev_page = page_id

WHERE page_namespace = 0

AND page_is_redirect = 0

AND R1.rev_actor = 481

AND R2.rev_actor = 1985

AND R1.rev_timestamp > 20150000000000

#AND R2.rev_timestamp > 20140000000000

​

LIMIT 5

​

;