Search b43 (main 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 >= '20150101000000'
AND rev_timestamp >= '20150101000000'
AND actor_user IS NOT NULL
AND LENGTH(actor_name) >= 6
AND LENGTH(actor_name) <= 14
AND actor_name RLIKE '^[A-Z][a-z]+[0-9]{0,2}$'
AND page_namespace IN (0)
AND comment_text = 'deOrphaned'
ORDER BY user_registration ASC
SQL

Checking query status...
