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
Richard Sekerak (WMCZ)
.
Toggle Highlighting
SQL
SET @minEdits = 0; -- 1) number of edits the user has to have to be considered experienced SET @minTenureDays = 365; -- 2) if the user registered @minTenureDays days prior to the event (@eventDate), they're experienced SET @eventDate = '20240501000000'; -- 3) see @minTenureDays SELECT user_name, user_editcount, IF(user_registration IS NOT NULL, user_registration, 'Unknown') AS user_registration, IF( ( -- have at least @minEdits edits user_editcount >= @minEdits AND ( -- user_registration is not populated for users who registered pre-2005 user_registration IS NULL OR -- are registered for at least @minTenureDays DATEDIFF(@eventDate, user_registration) >= @minTenureDays ) ), "Experienced", "Newcomer" ) AS is_newcomer FROM user WHERE user_name IN ( 'MihaiAlinAnghel', 'Wladislaw353', 'Davidekh', 'Turambal', 'Crutch1973', 'Zrzek007', 'Mike1970Exner', 'Lubomír', 'Damak', 'Martik.happy', 'Amaterel', 'Safira241084', 'Lenka', 'Marek', 'Nela.krizova6', 'Ondřej', 'Tomáš', 'Verzo69', 'Blanka1709', 'Ľudmila', 'Wojspo', 'Stevacek', 'Lenka', 'Hajek.Tomas9', 'Eliska', 'Martin', 'Matoluk', 'Jirunda', 'Tanahajek', 'AZEWIEN', 'Jakubkaspar75', 'Angelinka1989', 'Markri~cswiki', 'Kylfas', 'ChJn', 'Vladyslav', 'IrenaKol', 'Jura', 'Themilodvorak', 'Felarion', 'Iva', 'Jiří', 'Luckhy86', 'Neytireyqa', 'Zdeněk', 'KameraJede', 'Ellssaa', 'JanaJin', 'Lazysun', 'Carculina', 'JosefZvoník', 'Semipepino', 'Dirillo', 'Black', 'Viktor.3333', 'Viktorgencur', 'Systemor', 'KKDAII', 'Ondrasin', 'L96N', 'Kozdas', 'Barbora', 'No', 'Andreas', 'Tobojvanek', 'StanleyBradley48', 'MMLXXVII', 'Tomiik', 'MichalSoboraKolar', 'Kalinmir', 'Tomas.vejtasa', 'Starochi', 'Michroucka', 'Zanzi22', 'JeanAhir13', 'Miroslav', 'Lukáš', 'BecissCZ', 'Kleki0petra', 'Vratymony', 'Omka', 'Janapink1', 'Annick', 'Semzbudejc', 'Zuzice', 'Kostelnik84', 'Marketasudikova', 'J.aladar' )
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...