User names (b43)

SQL

SELECT DISTINCT actor_name, user_registration
FROM actor_revision AS actor
INNER JOIN user ON actor.actor_user = user.user_id
WHERE
TRUE
AND user_registration >= '20200521000000'
AND user_registration <= '20200521040000'
-- AND actor_name RLIKE '^(?:B(?:r(?:e(?:ati|ta|n)?|at?|io?|o|u)|e(?:r(?:i(?:nl)?)?|n|t)|a(?:re?|tty|i)|ik|ul)|A(?:l(?:ex?|le?|an|o)|ar(?:onk?)?|n(?:dri?|n)|r(?:ijit|t)|di|er|ur)|M(?:e(?:r(?:i(?:tan|na)?)?|h)|a(?:t(?:te?)?|ur?|i|n|x)|ond?)|N(?:e(?:r(?:i(?:la|a)?|ut?)?|i)|u(?:manders|r)|a[mr]|i[nr])|R(?:e(?:a(?:t(?:in)?)?|nt?|ta)|a(?:e[nr]?|tis?|s)|u[bi]|ta)|K(?:a(?:i[jlu]?|li?|h|r|u)|i[lr]|eri?|olk?|ru|ur)|H(?:e(?:a(?:th)?|l)|a(?:rt?|l)|u[rs])|G(?:r(?:e(?:en(?:\\ )?)?|a)|e[rt]|ar)|C(?:r(?:e(?:tia)?|a|t)|henr|er|on)|J(?:a(?:ck|g|i)|i(?:la?|a)|yat)|S(?:w(?:ap?|e)|a[ams]|el|ri|to)|D(?:e(?:r(?:ain)?|n)|r[ei]|oc)|F(?:r(?:e(?:ta?)?|an?)|eri?)|Er(?:londei|at?|in|o|u)|T(?:r(?:at?|ei)|en|in)|V(?:ar[eu]|eri?|rea?)|Y(?:rats|tars)|O(?:r[aw]|ut)|P(?:er|ol|ro)|L(?:ake?|ia)|Que|Was)[a-z]*(?:a(?:n(?:s(?:ki)?|ik?|32|o|y)|s(?:in?|h|k)|i(?:ns?|sn)|t(?:ing|a)|r[din]|fan|kis|li|ve)|i(?:n(?:a(?:li?)?|s(?:tan)?|do|i)|l(?:a[kn]?|op)|a(?:ns?|l)|s[an]|ksha|tan?|ck|on|ya)|s(?:i(?:na?|an|on|k|l)|l(?:a[mn]|in)|t(?:an|in)|a[ln]|e[dr]|nal|ki|on)|n(?:s(?:in?|ai)|d(?:er|y)|t(?:an|s)|i[aks]|e[di]|get|55|al|la)|e(?:r(?:in?|a|d|o|s)|d(?:lik|n|s)|l(?:end|s)|tan?|sin|an|in)|t(?:a(?:n(?:sil)?|in|rn|l|s)|i[kn]|erin|ral?|sina)|r(?:a(?:tsian|l|n)|i(?:a[ln]|n|o)|uians|ed|op)|l(?:a(?:n(?:tri)?|m)|i(?:ns?|an|ya|k)|sin|ei)|d(?:e(?:rs?|n)|sed|ge|ik)|o(?:lan|an|na|sn)|u(?:ta[ns]|a[mn])|k(?:a[lnt]|ol)|g(?:et|ra)|h(?:al|il)|pa[ln]|ben|man|yal)$'
-- AND LENGTH(actor_name) <= 14
AND user_editcount >= 10
ORDER BY user_registration ASC
SQL

Checking query status...
