Fork of trwiki:evolutionoftheuniverse's edits which summaries have "priority=high" by Evolutionoftheuniverse
This query is marked as a draft This query has been published by Evolutionoftheuniverse.

SQL

AخA
 
USE wikidatawiki_p;
SELECT trwpl.pl_title,page_title,rev_timestamp
FROM revision_userindex 
JOIN page ON rev_page=page_id
JOIN comment_revision on rev_comment_id=comment_id
JOIN actor_revision ON actor_id = rev_actor AND actor_name="Vito Genovese"
JOIN trwiki_p.pagelinks trwpl ON 
trwpl.pl_title=REPLACE(REPLACE(comment_text, "/* clientsitelink-remove:1||trwiki */ ","")," ","_")
AND trwpl.pl_from = 2219492 AND trwpl.pl_from_namespace = 4 AND trwpl.pl_namespace = 0
WHERE 
NOT EXISTS
(SELECT p1.page_title FROM trwiki_p.page AS p1
WHERE p1.page_title = trwpl.pl_title
AND trwpl.pl_namespace = 0
AND p1.page_namespace = 0)
AND rev_timestamp <= (SELECT TIMESTAMP("2017-03-29 16:26:55"))
AND rev_timestamp >= (SELECT TIMESTAMP("2017-03-29 15:48:47"))
GROUP BY trwpl.pl_title;
/*SELECT comment_text FROM comment_revision JOIN revision_userindex on rev_comment_id=comment_id JOIN actor ON actor_id = rev_actor WHERE actor_name="Vito Genovese" AND rev_timestamp LIKE "20170329%" LIMIT 1;*/
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.

Checking query status...