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 >= '20170101000000' -- AND user_registration < '20220101000000' AND user_registration >= '20200610060000' AND user_registration <= '20200610090000' AND user_name RLIKE '^(?:A|Aer|Ah|Al|Am|Ar|Art|Aur|B|Ba|Bai|Bar|Bare|Be|Ber|Bo|Bra|Brat|Bre|Breati|Breta|Bri|Bru|Bu|C|Cr|Cra|Cre|Cretia|D|Der|Derain|Dr|Dre|Dri|E|Er|Erat|F|Fer|Fra|Fre|Fret|Freta|G|Gh|Gr|Gu|H|Ha|Hart|Hu|I|J|Ja|K|Ka|Kai|Kaij|Kail|Kaiu|Kal|Kau|L|La|Lak|M|Ma|Mai|Mau|Maur|Me|Meri|Meritan|Mi|Mo|N|Nar|Ne|Ner|Neri|Neria|Ni|O|P|R|Ra|Rae|Raer|Rati|Ratis|Re|Rea|Reat|Reatin|Ren|Reta|Ri|Rta|S|Si|Swap|T|Ta|Te|Tra|Trei|V|Va|Var|Vare|Vr|Vre|Vrea|W|X|Y|Yrats|Ytars)[abcdefghijklmnoprstuvwxyz]+(?:a|ain|aisn|ak|akis|al|am|an|ani|anik|ans|anski|arn|as|ating|b|di|e|ean|er|esin|et|etan|g|h|hal|i|ia|ial|ian|ians|ik|il|in|ina|inali|ini|ins|instan|io|ir|is|isa|isn|itan|ji|k|l|la|lan|lian|lins|m|n|na|nal|ni|nia|nik|nis|nl|no|ns|nsai|nsi|nsin|nt|ntan|o|oan|osn|r|ran|ratsian|ri|rin|ruians|s|sal|san|sh|si|sian|sik|sin|sina|slan|sn|snal|st|stan|stin|t|tain|tal|tan|tansil|tas|tin|tral|tsina|us|utan|y|yal)$' -- AND user_name RLIKE '^[A-Z][a-z]+$' AND LENGTH(user_name) <= 14 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...