Aktive Leipziger der letzten sechs Wochen

SQL

SELECT user_name, COUNT(rev_id) AS "Anzahl Edits",
       CONCAT(MIN(REGEXP_REPLACE(rev_timestamp, "^(....)(..)(..).*$", "\\1-\\2-\\3")), ' … ', MAX(REGEXP_REPLACE(rev_timestamp, "^(....)(..)(..).*$", "\\1-\\2-\\3"))) AS "Min/Max Timestamp"
  FROM revision, actor, user, page AS UserPage, categorylinks
 WHERE UserPage.page_namespace = 2
   AND cl_from = UserPage.page_id
   AND cl_to = 'Benutzer:aus_Leipzig'
   AND user_name = REPLACE(UserPage.page_title, '_', ' ')
   AND user_id = actor_user
   AND rev_timestamp > '20231007000000'
   AND rev_actor = actor_id
 GROUP BY user_name
 ORDER BY COUNT(rev_id)

SQL

Checking query status...