Experienced users and newcomers

SQL

SET @minEdits = 0; -- 1) number of edits the user has to have to be considered experienced
SET @minTenureDays = 370; -- 2) if the user registered @minTenureDays days prior to the event (@eventDate), they're experienced
SET @eventDate = '20221101000000'; -- 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 (
  'Brion VIBBER',
  'Martin Urbanec',
  'Janbery',
  'Svajcr',
  'Michal Daneš',
  'Littleomig',
  'Martin Šlais',
  'Ing. Lukáš Zeman',
  'Mars123',
  'Verunecka007',
  'Schoro29',
  'Pavel21kriz',
  'David Jeřábek',
  'Verunecka007',
  'Jan.urbanek85',
  'BrujaFea',
  'Prunelle92',
  'Lukáš Krátký',
  'Alena Turková',
  'Klára Hášová',
  'Davidddddddddddddd',
  'Karlíkovo foto',
  'Nikolesa',
  'Petrekfoto',
  'ZdendaPraha',
  'Bazi',
  'Jan.urbanek85',
  'Pendolino53',
  'LksNjmn',
  'Nojono159',
  'Lukas.stas',
  'Woodcraft.photo',
  'Miroslav Frais',
  'Eliska Jindriskova',
  'Hozakzbynek',
  'Fionek',
  'Vladi1978',
  'Nadkachna',
  'Rybnikárová Adriana',
  'JiriMatejicek',
  'Zuzankaobr'
 
)
SQL

Checking query status...
