Experienced users and newcomers / POP 2025

SQL

SET @minEdits = 1000; -- 1) number of edits the user has to have to be considered experienced
SET @minTenureDays = 20; -- 2) if the user registered @minTenureDays days prior to the event (@eventDate), they're experienced
SET @eventDate = '20250115000000'; -- 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 (
'Bazi',
'Jan Spousta',
'Petr1888',
'Fil.Zaj2002',
'Jrnka ka',
'Petr Kinšt',
'Hedvika Šimková',
'Dirillo',
'Ikcur',
'Kvetinka48',
'Historylove Man',
'JanaJin',
'Hanz.97',
'Dobroš',
'Lukáš Nekolný',
'IrenaKol',
'ČsrVK',
'Tynako',
'Aktron',
'Sanktusník',
'Bedinek',
'Markri~cswiki',
'Halfirien',
'Transbedy',
'PetaB94',
'Jiří Ptáček',
'KKDAII',
'Karelkam',
'Zagothal',
'Jan Polák',
'Frettie',
'Samikhorak'
)
SQL

Checking query status...
