Experienced users and newcomers

Fork of Experienced users and newcomers by Richard Sekerak (WMCZ)
This query is marked as a draft This query has been published by Richard Sekerak (WMCZ).
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 = '20240101000000'; -- 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 (
'.smid.21',
'Actinum982',
'Adam Nosek',
'Adelinedvorakova',
'AlekseiTe',
'Ales Dvorak Repy',
'Alisvolk',
'Anet87',
'AnnaK98',
'Archenar11',
'Arnošt Modrý',
'Artezeth',
'Barygezya',
'Bawunka24',
'Bazi',
'Bohaatstvo',
'Bojena',
'BrnoBurlesquePhoto',
'BrujaFea',
'Buček Michal',
'Capino00',
'Cigan132',
'Danca300',
'Daniel Dítě',
'Danpavfoto',
'Danuše Bauerová',
'David Čech',
'David the photographer',
'Davidciganek',
'Dirillo',
'Dominik Procházka',
'Dominik Škrobák',
'Dortík',
'Dusanhorak',
'EForcePragueFormula',
'Echolana',
'Eliska Jindriskova',
'Emve76',
'Erik Schneider2',
'Eva fotografka',
'Evada24',
'Fanándelon',
'Fanda713',
'Fandaa7',
'Fenomenomef',
'Fictili',
'Filipo de Žabo',
'Finiak2325',
'Foolercz',
'FotografGymnazista',
'Fotografpabel',
'FotoPaja',
'Funny steel',
'Gadzuzu',
'General.hanz',
'Glinomes Dmytro',
'Goitbit',
'Gull808',
'Gurmanman',
'Hanreichondrej',
'Helena Hl',
'Hellenin',
'Hepylajf',
'Honza 112',
'Honza145',
'Honzrr',
'ChuraqOndrej',
'Ihor Murakhovskskyi',
'Insidderr',
'Jajinka01',
'Jan Osička',
'Jan.h.macek',
'Jana Bujnošková',
'Janbery',
'Janosikovaneta',
'Jaroslav Karhánek',
'Jaroslav Mašek',
'Jaroslav Povolný',
'Jerama003',
'Jirfren',
'JiriMatejicek',
'Jiří Čuma',
'Jiří Ullrich',
'JKrutina',
'JosefZvoník',
'Kachně333',
'Kalinmir',
'Karolinanemecko',
'Kaschpi13',
'Katee87',
'KKK Kuriozní kohoutovický kudrnač',
'KlaOndr',
'Klara.vic',
'Klaratajovska',
'Kolomaznik',
'Konstantin zhdanov',
'Krystof025551',
'Kubametelka',
'Ladik Kudlička',
'Lenka Václavková',
'Liborovofoceni',
'Lovekapibara',
'Lubor Ferenc',
'Lucie Habichová',
'Luciechalupna',
'Luckhy86',
'LucniLenka',
'Ludmila Linková',
'Lukas Kupka',
'Lysykh Halyna',
'MakuSheee',
'Mandolinbeforesunset',
'Marek Marinč',
'Markyy81',
'Martas240',
'Martin Brneš',
'Marvit1234',
'Matěj Slezák',
'Matyasgreg',
'Matylda 905',
'Mawmaw50',
'Maxusek',
'MB1990',
'Medvidek77',
'Melinda.f',
'MIGORMCZ',
'Michal Bartůněk',
'Mijopa',
'Mikeyyy657',
'Mira1166',
'Mnichoss',
'Mykola Salometik',
'Natalli Str.',
'NatyyMan',
'NiC00L147',
'Offoto',
'Ok1fig',
'OLDAJO',
'Oleksandr blyat',
'Olga Havlíčková',
'Olwn',
'Ondra Doležal',
'Ondra526',
'Pája53',
'Pan Soudruh Fiala',
'Pav69',
'Pavel Vostárek',
'Pavel21kriz',
'PavelSevcik',
'Peckamartin',
'PetiS1',
'Petr Knezour',
'PetrVod',
'Pliva Štěpán',
'Premrke',
'R.matousek.photo',
'RadkaKon',
'Reny Kr.',
'Rézi.D.11',
'Ricipici',
'Richard-fotograf',
'Richardklofac',
'Rostislav Souček',
'Semipepino',
'Schoro29',
'Sik vendelin',
'Skulinka',
'Snekinen',
'Soltak1971',
'Spinaaa',
'Stellafoxx',
'Svajcr',
'Šaryčník',
'Štěpán Fabo',
'Temnigrayder',
'TFerenczy',
'Timon Havelka',
'TOBES006',
'Tobias456',
'TomasHrdlickaFoto',
'Tomáš Brabec',
'Tomáš Puk',
'Tonda Cerv',
'Tonda Dspl',
'Týna 0320',
'V0lkanic',
'VendySol',
'Veverin',
'Vikiaspol',
'Vikouss',
'Vit glabazna',
'Vítejte',
'Vladimír Vaněk',
'VLASTOVKA75',
'Vranafoto',
'Xhanys',
'Xsandman',
'ZdenikS',
'ZSsen',
'Екатерина Борисова'
)
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.
SQL

Checking query status...
