Untitled query #84382

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 (
'Amaterel',
'Andreas Jordanidis',
'Angelinka1989',
'Annick green',
'AZEWIEN',
'Barbora 2530945',
'BecissCZ',
'Black Rose aus Rosental',
'Blanka1709',
'Carculina',
'Crutch1973',
'Damak',
'Davidekh',
'Dirillo',
'Eliska Jindriskova',
'Ellssaa',
'Felarion',
'Hajek.Tomas9',
'ChJn',
'IrenaKol',
'Iva Casarova',
'J.aladar',
'Jakubkaspar75',
'JanaJin',
'Janapink1',
'JeanAhir13',
'Jirunda',
'Jiří Komárek',
'JosefZvoník',
'Jura Žák',
'Kalinmir',
'KameraJede',
'KKDAII',
'Kleki0petra',
'Kostelnik84',
'Kozdas photography',
'Kylfas',
'L96N',
'Lazysun',
'Lenka Kinclová',
'Lenka Tylšarová',
'Lubomír Dajč',
'Luckhy86',
'Ľudmila Broklová',
'Lukáš Franc',
'Marek Šašek',
'Marketasudikova',
'Markri~cswiki',
'Martik.happy',
'Martin Culek',
'Matoluk',
'MihaiAlinAnghel',
'MichalSoboraKolar',
'Michroucka',
'Mike1970Exner',
'Miroslav Timura',
'MMLXXVII',
'Nela.krizova6',
'Neytireyqa',
'No thanks, didnt ask',
'Omka Pajunk',
'Ondrasin',
'Ondřej Floriš',
'Safira241084',
'Semipepino',
'Semzbudejc',
'StanleyBradley48',
'Starochi',
'Stevacek',
'Systemor',
'Tanahajek',
'Themilodvorak',
'Tobojvanek',
'Tomas.vejtasa',
'Tomáš Machytka',
'Tomiik te',
'Turambal',
'Verzo69',
'Viktor.3333',
'Viktorgencur',
'Vladyslav Zolotarevskyi',
'Vratymony',
'Wladislaw353',
'Wojspo',
'Zanzi22',
'Zdeněk',
'Zrzek007',
'Zuzice'
)
SQL

Checking query status...
