Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Users linked from page with no edits in 2 years
by
Cryptic
This query is marked as a draft
This query has been published
by
Cryptic
.
Checks all user talk: links from [[Wikipedia:VisualEditor/Newsletter]] and lists those whose corresponding users have no live edits on any non-closed SUL wiki since 2018 Apr 9. For [[WP:VPT#Finding out who is still around]] circa 2020 Apr 9. Since Quarry has a 64k character limit on queries, only the first 290 databases (out of 778) are checked.
Toggle Highlighting
SQL
USE enwiki_p; -- wiki for source page; also the only wiki checked for redirects SET @timestamp = '20180409'; -- search for any edit from this or later SET @src_namespace = 4; -- examine links from this namespace; 4 == Wikipedia: SET @src_page = 'VisualEditor/Newsletter'; -- examine links from this page in @src_namespace. Replace spaces with _ SET @tgt_namespace = 3; -- look for links to this namespace. 3 == user talk:. The only other one that makes sense in this query is 2 (user:) SELECT pl_title AS 'user name (as listed)', rd_title AS 'redirects to' FROM pagelinks JOIN page srcpg ON pl_from = srcpg.page_id -- resolve redirects to other user talk: pages LEFT JOIN page rdrpg ON rdrpg.page_namespace = @tgt_namespace AND rdrpg.page_title = pl_title LEFT JOIN redirect ON rd_from = rdrpg.page_id AND rd_namespace = @tgt_namespace WHERE srcpg.page_namespace = @src_namespace AND srcpg.page_title = @src_page -- check links from [[Wikipedia:VisualEditor/Newsletter]] AND pl_namespace = @tgt_namespace -- look for user talk: links -- The really, really ugly part. Omit all but the first line to only query enwiki. -- There's better ways to do this, but all the ones I know don't work with the permissions available to Quarry users. -- The list of databases is from "SELECT CONCAT(dbname, '_p') FROM meta_p.wiki WHERE is_closed = 0" -- Less than half of the those databases are listed here, since Quarry has a 64k-character limit on queries. AND NOT EXISTS (SELECT 1 FROM enwiki_p.revision_userindex JOIN enwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM abwiki_p.revision_userindex JOIN abwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM acewiki_p.revision_userindex JOIN acewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM adywiki_p.revision_userindex JOIN adywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM afwiki_p.revision_userindex JOIN afwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM afwikibooks_p.revision_userindex JOIN afwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM afwikiquote_p.revision_userindex JOIN afwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM afwiktionary_p.revision_userindex JOIN afwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM akwiki_p.revision_userindex JOIN akwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM alswiki_p.revision_userindex JOIN alswiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM amwiki_p.revision_userindex JOIN amwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM amwikimedia_p.revision_userindex JOIN amwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM amwiktionary_p.revision_userindex JOIN amwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM angwiki_p.revision_userindex JOIN angwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM angwiktionary_p.revision_userindex JOIN angwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM anwiki_p.revision_userindex JOIN anwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM anwiktionary_p.revision_userindex JOIN anwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arcwiki_p.revision_userindex JOIN arcwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwiki_p.revision_userindex JOIN arwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwikibooks_p.revision_userindex JOIN arwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwikimedia_p.revision_userindex JOIN arwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwikinews_p.revision_userindex JOIN arwikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwikiquote_p.revision_userindex JOIN arwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwikisource_p.revision_userindex JOIN arwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwikiversity_p.revision_userindex JOIN arwikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arwiktionary_p.revision_userindex JOIN arwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM arzwiki_p.revision_userindex JOIN arzwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM astwiki_p.revision_userindex JOIN astwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM astwiktionary_p.revision_userindex JOIN astwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM aswiki_p.revision_userindex JOIN aswiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM aswikisource_p.revision_userindex JOIN aswikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM atjwiki_p.revision_userindex JOIN atjwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM avwiki_p.revision_userindex JOIN avwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM aywiki_p.revision_userindex JOIN aywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM aywiktionary_p.revision_userindex JOIN aywiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM azbwiki_p.revision_userindex JOIN azbwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM azwiki_p.revision_userindex JOIN azwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM azwikibooks_p.revision_userindex JOIN azwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM azwikiquote_p.revision_userindex JOIN azwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM azwikisource_p.revision_userindex JOIN azwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM azwiktionary_p.revision_userindex JOIN azwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM banwiki_p.revision_userindex JOIN banwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM barwiki_p.revision_userindex JOIN barwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bat_smgwiki_p.revision_userindex JOIN bat_smgwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bawiki_p.revision_userindex JOIN bawiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bawikibooks_p.revision_userindex JOIN bawikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bclwiki_p.revision_userindex JOIN bclwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bdwikimedia_p.revision_userindex JOIN bdwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM betawikiversity_p.revision_userindex JOIN betawikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bewiki_p.revision_userindex JOIN bewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bewikibooks_p.revision_userindex JOIN bewikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bewikimedia_p.revision_userindex JOIN bewikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bewikiquote_p.revision_userindex JOIN bewikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bewikisource_p.revision_userindex JOIN bewikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bewiktionary_p.revision_userindex JOIN bewiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM be_x_oldwiki_p.revision_userindex JOIN be_x_oldwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bgwiki_p.revision_userindex JOIN bgwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bgwikibooks_p.revision_userindex JOIN bgwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bgwikiquote_p.revision_userindex JOIN bgwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bgwikisource_p.revision_userindex JOIN bgwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bgwiktionary_p.revision_userindex JOIN bgwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bhwiki_p.revision_userindex JOIN bhwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM biwiki_p.revision_userindex JOIN biwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bjnwiki_p.revision_userindex JOIN bjnwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bmwiki_p.revision_userindex JOIN bmwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bnwiki_p.revision_userindex JOIN bnwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bnwikibooks_p.revision_userindex JOIN bnwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bnwikisource_p.revision_userindex JOIN bnwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bnwikivoyage_p.revision_userindex JOIN bnwikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bnwiktionary_p.revision_userindex JOIN bnwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bowiki_p.revision_userindex JOIN bowiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bpywiki_p.revision_userindex JOIN bpywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM brwiki_p.revision_userindex JOIN brwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM brwikimedia_p.revision_userindex JOIN brwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM brwikiquote_p.revision_userindex JOIN brwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM brwikisource_p.revision_userindex JOIN brwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM brwiktionary_p.revision_userindex JOIN brwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bswiki_p.revision_userindex JOIN bswiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bswikibooks_p.revision_userindex JOIN bswikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bswikinews_p.revision_userindex JOIN bswikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bswikiquote_p.revision_userindex JOIN bswikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bswikisource_p.revision_userindex JOIN bswikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bswiktionary_p.revision_userindex JOIN bswiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bugwiki_p.revision_userindex JOIN bugwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM bxrwiki_p.revision_userindex JOIN bxrwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawiki_p.revision_userindex JOIN cawiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawikibooks_p.revision_userindex JOIN cawikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawikimedia_p.revision_userindex JOIN cawikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawikinews_p.revision_userindex JOIN cawikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawikiquote_p.revision_userindex JOIN cawikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawikisource_p.revision_userindex JOIN cawikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cawiktionary_p.revision_userindex JOIN cawiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cbk_zamwiki_p.revision_userindex JOIN cbk_zamwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cdowiki_p.revision_userindex JOIN cdowiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cebwiki_p.revision_userindex JOIN cebwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cewiki_p.revision_userindex JOIN cewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM chrwiki_p.revision_userindex JOIN chrwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM chrwiktionary_p.revision_userindex JOIN chrwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM chwiki_p.revision_userindex JOIN chwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM chywiki_p.revision_userindex JOIN chywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM ckbwiki_p.revision_userindex JOIN ckbwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cnwikimedia_p.revision_userindex JOIN cnwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM commonswiki_p.revision_userindex JOIN commonswiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cowiki_p.revision_userindex JOIN cowiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cowikimedia_p.revision_userindex JOIN cowikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cowiktionary_p.revision_userindex JOIN cowiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM crhwiki_p.revision_userindex JOIN crhwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM crwiki_p.revision_userindex JOIN crwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM csbwiki_p.revision_userindex JOIN csbwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM csbwiktionary_p.revision_userindex JOIN csbwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswiki_p.revision_userindex JOIN cswiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswikibooks_p.revision_userindex JOIN cswikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswikinews_p.revision_userindex JOIN cswikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswikiquote_p.revision_userindex JOIN cswikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswikisource_p.revision_userindex JOIN cswikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswikiversity_p.revision_userindex JOIN cswikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cswiktionary_p.revision_userindex JOIN cswiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cuwiki_p.revision_userindex JOIN cuwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cvwiki_p.revision_userindex JOIN cvwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cvwikibooks_p.revision_userindex JOIN cvwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cywiki_p.revision_userindex JOIN cywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cywikibooks_p.revision_userindex JOIN cywikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cywikiquote_p.revision_userindex JOIN cywikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cywikisource_p.revision_userindex JOIN cywikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM cywiktionary_p.revision_userindex JOIN cywiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dawiki_p.revision_userindex JOIN dawiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dawikibooks_p.revision_userindex JOIN dawikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dawikiquote_p.revision_userindex JOIN dawikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dawikisource_p.revision_userindex JOIN dawikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dawiktionary_p.revision_userindex JOIN dawiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewiki_p.revision_userindex JOIN dewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewikibooks_p.revision_userindex JOIN dewikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewikinews_p.revision_userindex JOIN dewikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewikiquote_p.revision_userindex JOIN dewikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewikisource_p.revision_userindex JOIN dewikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewikiversity_p.revision_userindex JOIN dewikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewikivoyage_p.revision_userindex JOIN dewikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dewiktionary_p.revision_userindex JOIN dewiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dinwiki_p.revision_userindex JOIN dinwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM diqwiki_p.revision_userindex JOIN diqwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dkwikimedia_p.revision_userindex JOIN dkwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM donatewiki_p.revision_userindex JOIN donatewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dsbwiki_p.revision_userindex JOIN dsbwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dtywiki_p.revision_userindex JOIN dtywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dvwiki_p.revision_userindex JOIN dvwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dvwiktionary_p.revision_userindex JOIN dvwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM dzwiki_p.revision_userindex JOIN dzwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eewiki_p.revision_userindex JOIN eewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwiki_p.revision_userindex JOIN elwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwikibooks_p.revision_userindex JOIN elwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwikinews_p.revision_userindex JOIN elwikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwikiquote_p.revision_userindex JOIN elwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwikisource_p.revision_userindex JOIN elwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwikiversity_p.revision_userindex JOIN elwikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwikivoyage_p.revision_userindex JOIN elwikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM elwiktionary_p.revision_userindex JOIN elwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM emlwiki_p.revision_userindex JOIN emlwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwiki_p.revision_userindex JOIN enwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwikibooks_p.revision_userindex JOIN enwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwikinews_p.revision_userindex JOIN enwikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwikiquote_p.revision_userindex JOIN enwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwikisource_p.revision_userindex JOIN enwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwikiversity_p.revision_userindex JOIN enwikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwikivoyage_p.revision_userindex JOIN enwikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM enwiktionary_p.revision_userindex JOIN enwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eowiki_p.revision_userindex JOIN eowiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eowikibooks_p.revision_userindex JOIN eowikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eowikinews_p.revision_userindex JOIN eowikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eowikiquote_p.revision_userindex JOIN eowikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eowikisource_p.revision_userindex JOIN eowikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eowiktionary_p.revision_userindex JOIN eowiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswiki_p.revision_userindex JOIN eswiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswikibooks_p.revision_userindex JOIN eswikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswikinews_p.revision_userindex JOIN eswikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswikiquote_p.revision_userindex JOIN eswikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswikisource_p.revision_userindex JOIN eswikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswikiversity_p.revision_userindex JOIN eswikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswikivoyage_p.revision_userindex JOIN eswikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM eswiktionary_p.revision_userindex JOIN eswiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM etwiki_p.revision_userindex JOIN etwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM etwikibooks_p.revision_userindex JOIN etwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM etwikimedia_p.revision_userindex JOIN etwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM etwikiquote_p.revision_userindex JOIN etwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM etwikisource_p.revision_userindex JOIN etwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM etwiktionary_p.revision_userindex JOIN etwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM euwiki_p.revision_userindex JOIN euwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM euwikibooks_p.revision_userindex JOIN euwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM euwikiquote_p.revision_userindex JOIN euwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM euwikisource_p.revision_userindex JOIN euwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM euwiktionary_p.revision_userindex JOIN euwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM extwiki_p.revision_userindex JOIN extwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawiki_p.revision_userindex JOIN fawiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawikibooks_p.revision_userindex JOIN fawikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawikinews_p.revision_userindex JOIN fawikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawikiquote_p.revision_userindex JOIN fawikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawikisource_p.revision_userindex JOIN fawikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawikivoyage_p.revision_userindex JOIN fawikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fawiktionary_p.revision_userindex JOIN fawiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM ffwiki_p.revision_userindex JOIN ffwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiu_vrowiki_p.revision_userindex JOIN fiu_vrowiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwiki_p.revision_userindex JOIN fiwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikibooks_p.revision_userindex JOIN fiwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikimedia_p.revision_userindex JOIN fiwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikinews_p.revision_userindex JOIN fiwikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikiquote_p.revision_userindex JOIN fiwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikisource_p.revision_userindex JOIN fiwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikiversity_p.revision_userindex JOIN fiwikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwikivoyage_p.revision_userindex JOIN fiwikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fiwiktionary_p.revision_userindex JOIN fiwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fjwiki_p.revision_userindex JOIN fjwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fjwiktionary_p.revision_userindex JOIN fjwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM foundationwiki_p.revision_userindex JOIN foundationwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fowiki_p.revision_userindex JOIN fowiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fowikisource_p.revision_userindex JOIN fowikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fowiktionary_p.revision_userindex JOIN fowiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frpwiki_p.revision_userindex JOIN frpwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frrwiki_p.revision_userindex JOIN frrwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwiki_p.revision_userindex JOIN frwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwikibooks_p.revision_userindex JOIN frwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwikinews_p.revision_userindex JOIN frwikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwikiquote_p.revision_userindex JOIN frwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwikisource_p.revision_userindex JOIN frwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwikiversity_p.revision_userindex JOIN frwikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwikivoyage_p.revision_userindex JOIN frwikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM frwiktionary_p.revision_userindex JOIN frwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM furwiki_p.revision_userindex JOIN furwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fywiki_p.revision_userindex JOIN fywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fywikibooks_p.revision_userindex JOIN fywikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM fywiktionary_p.revision_userindex JOIN fywiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gagwiki_p.revision_userindex JOIN gagwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM ganwiki_p.revision_userindex JOIN ganwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gawiki_p.revision_userindex JOIN gawiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gawiktionary_p.revision_userindex JOIN gawiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gcrwiki_p.revision_userindex JOIN gcrwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gdwiki_p.revision_userindex JOIN gdwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gdwiktionary_p.revision_userindex JOIN gdwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gewikimedia_p.revision_userindex JOIN gewikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM glkwiki_p.revision_userindex JOIN glkwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM glwiki_p.revision_userindex JOIN glwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM glwikibooks_p.revision_userindex JOIN glwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM glwikiquote_p.revision_userindex JOIN glwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM glwikisource_p.revision_userindex JOIN glwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM glwiktionary_p.revision_userindex JOIN glwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gnwiki_p.revision_userindex JOIN gnwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gnwiktionary_p.revision_userindex JOIN gnwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gomwiki_p.revision_userindex JOIN gomwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gorwiki_p.revision_userindex JOIN gorwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gotwiki_p.revision_userindex JOIN gotwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM guwiki_p.revision_userindex JOIN guwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM guwikiquote_p.revision_userindex JOIN guwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM guwikisource_p.revision_userindex JOIN guwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM guwiktionary_p.revision_userindex JOIN guwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gvwiki_p.revision_userindex JOIN gvwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM gvwiktionary_p.revision_userindex JOIN gvwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hakwiki_p.revision_userindex JOIN hakwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hawiki_p.revision_userindex JOIN hawiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hawiktionary_p.revision_userindex JOIN hawiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hawwiki_p.revision_userindex JOIN hawwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewiki_p.revision_userindex JOIN hewiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewikibooks_p.revision_userindex JOIN hewikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewikinews_p.revision_userindex JOIN hewikinews_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewikiquote_p.revision_userindex JOIN hewikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewikisource_p.revision_userindex JOIN hewikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewikivoyage_p.revision_userindex JOIN hewikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hewiktionary_p.revision_userindex JOIN hewiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hifwiki_p.revision_userindex JOIN hifwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hifwiktionary_p.revision_userindex JOIN hifwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwiki_p.revision_userindex JOIN hiwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwikibooks_p.revision_userindex JOIN hiwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwikimedia_p.revision_userindex JOIN hiwikimedia_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwikiquote_p.revision_userindex JOIN hiwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwikisource_p.revision_userindex JOIN hiwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwikiversity_p.revision_userindex JOIN hiwikiversity_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwikivoyage_p.revision_userindex JOIN hiwikivoyage_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hiwiktionary_p.revision_userindex JOIN hiwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hrwiki_p.revision_userindex JOIN hrwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hrwikibooks_p.revision_userindex JOIN hrwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hrwikiquote_p.revision_userindex JOIN hrwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hrwikisource_p.revision_userindex JOIN hrwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hrwiktionary_p.revision_userindex JOIN hrwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hsbwiki_p.revision_userindex JOIN hsbwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hsbwiktionary_p.revision_userindex JOIN hsbwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM htwiki_p.revision_userindex JOIN htwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM huwiki_p.revision_userindex JOIN huwiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM huwikibooks_p.revision_userindex JOIN huwikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM huwikiquote_p.revision_userindex JOIN huwikiquote_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM huwikisource_p.revision_userindex JOIN huwikisource_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM huwiktionary_p.revision_userindex JOIN huwiktionary_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hywiki_p.revision_userindex JOIN hywiki_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) AND NOT EXISTS (SELECT 1 FROM hywikibooks_p.revision_userindex JOIN hywikibooks_p.actor_revision ON actor_id = rev_actor WHERE actor_name = REPLACE(COALESCE(rd_title, pl_title), '_', ' ') AND rev_timestamp >= @timestamp) ;
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...