Search b43 (user space)

SQL

SELECT DISTINCT actor_name, user_registration, comment_text
FROM actor_revision AS actor
INNER JOIN revision_userindex AS revision ON actor.actor_id = revision.rev_actor
INNER JOIN page ON revision.rev_page = page.page_id
INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
INNER JOIN user ON actor.actor_user = user.user_id
WHERE
TRUE
AND user_registration >= '20190101000000'
AND rev_timestamp >= '20190101000000'
AND actor_user IS NOT NULL
AND LENGTH(actor_name) >= 6
AND LENGTH(actor_name) <= 14
AND actor_name RLIKE '^[A-Z][a-z]+$'
-- AND actor_name RLIKE '^(?:Ae|Aer|Ah|Al|Am|Ar|Art|Aur|Ba|Bai|Bar|Bare|Be|Ber|Bo|Bra|Brat|Bre|Breati|Breta|Bri|Bru|Bu|Cr|Cra|Cre|Cretia|Da|Der|Derain|Dr|Dre|Dri|Er|Erat|Fer|Fra|Fre|Fret|Freta|Gh|Gr|Gu|Ha|Hart|Hu|Ja|Ka|Kai|Kaij|Kail|Kaiu|Kal|Kau|La|Lak|Ma|Mai|Mau|Maur|Me|Meri|Meritan|Mi|Mo|Nar|Ne|Ner|Neri|Neria|Ni|Nr|Ra|Rae|Raer|Rati|Ratis|Re|Rea|Reat|Reatin|Ren|Reta|Ri|Rta|Si|Swa|Swap|Ta|Te|Tra|Trei|Va|Var|Vare|Vi|Vr|Vre|Vrea|Yrats|Ytars)[a-z]*(?:ain|aisn|ak|akis|al|am|an|ani|anik|ans|anski|any|arn|as|ating|di|ean|en|er|esin|et|etan|hal|ia|ial|ian|ians|ik|il|in|ina|inali|ini|ins|instan|io|ir|is|isa|isn|itan|ji|la|lan|lian|lins|na|nal|ni|nia|nik|nis|nl|no|ns|nsai|nsi|nsin|nt|ntan|oan|osn|ran|ratsian|ri|rin|ruians|sa|sal|san|sh|si|sian|sik|sin|sina|slan|sn|snal|st|stan|stin|ta|tain|tal|tan|tansil|tas|ti|tin|tral|tsina|us|utan|yal)$'
AND page_namespace IN (2, 3)
AND page_title = actor_name
-- enwiki:
-- AND comment_text RLIKE '^\\[\\[WP:AES\\|←\\]\\]Created page with ["\'](?:{{(?:[Uu]ser ?page|[Uu]sertalkpage|[Tt]alkpage|[Tt]alk ?header)}}| *)["\']$'
-- AND comment_hash IN (-1627196776, -270760101, 677596021, -1358969694, 869832460, 582549379, -2088904980, -541722663, 98654523, 1467009351, 736709876, 746371437)
-- simplewiki:
AND comment_text RLIKE '^Created page with "(?:{{(?:[Uu]ser ?(?:talk )?page|[Tt]alk ?page|[Tt]alk ?header)}}| *)"$'
-- itwiki:
-- AND comment_text RLIKE '^\\[\\[WP:OA\\|←\\]\\]Nuova pagina: (?:{{(?:[Pp]agina utente|[Dd]iscussione)}}| *)$'
-- eswiki:
-- AND comment_text RLIKE '^Página creada con «(?:{{(?:[Pp]ágina usuario|[Ee]ncabezado discusión|[Dd]iscusión)}}| *)»$'
-- frwiki:
-- AND comment_text RLIKE '^Nouvelle page : +(?:{{(?:[Pp]age personnelle|Page de discussion personnelle|En-tête de page de discussion)}}| *)$'
-- dewiki:
-- AND comment_text RLIKE '^.*Die Seite wurde neu angelegt: {{(?:Wikipedia-Benutzer|Diskussionsseite)}}$'
ORDER BY user_registration ASC
SQL

Checking query status...
