Untitled query #84380

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'
)
SQL

Checking query status...
