Untitled query #86872

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 = '20240901000000'; -- 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 (
'Gumruch ',
'Stepri1993',
'Bazi',
'Podroužek',
'Anaj7',
'JAn Dudík',
'Semipepino',
'Flukes69',
'Actomin',
'Eliska Jindriskova',
'Jaspi17',
'RomanM82',
'JiriMatejicek',
'Pavka2106',
'Wwery',
'Foto-FP',
'Insidderr',
'MONUDET',
'Martinapour',
'Ladislavvvv',
'Kvetinka48',
'Pohled 111',
'Czeva',
'Arciol24',
'Zanzi22',
'Souputnik',
'Transbedy',
'F.ponizil',
'Mahtiel cz',
'Stepan.hasek',
'Frettie',
'L96N',
'J.Broukal',
'Paddej',
'Bara Jul',
'Wrbic',
'ČsrVK',
'JosefZvoník',
'TFerenczy',
'KPX8',
'V0lkanic',
'Jerryzu',
'Jaroslav Povolný',
'Romantesi',
'Alex Jane Rider'
)
SQL

Checking query status...
