Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
MarioGom
.
Toggle Highlighting
SQL
SELECT user_name, user_registration FROM user WHERE TRUE AND user_registration >= '20170104140000' AND user_registration < '20170104150000' -- AND user_registration >= '20201216203000' -- AND user_registration < '20201216204000' -- AND user_name RLIKE '^(?: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|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|Ra|Rae|Raer|Rati|Ratis|Re|Rea|Reat|Reatin|Ren|Reta|Ri|Rta|Si|Swap|Ta|Te|Tra|Trei|Va|Var|Vare|Vr|Vre|Vrea|Yrats|Ytars)[abcdefghijklmnoprstuvwxyz]+(?:ain|aisn|ak|akis|al|am|an|ani|anik|ans|anski|arn|as|ating|di|ean|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|sal|san|sh|si|sian|sik|sin|sina|slan|sn|snal|st|stan|stin|tain|tal|tan|tansil|tas|tin|tral|tsina|us|utan|yal)$' AND user_name RLIKE '^[A-Z][a-z]+$' AND LENGTH(user_name) <= 11 AND LENGTH(user_name) >= 6 -- AND user_editcount > 0 ORDER BY user_registration
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...