Verifizierte User mit Edits in den letzten 6 Monaten

Siee https://de.wikipedia.org/wiki/Wikipedia_Diskussion:WikiProjekt_Umgang_mit_bezahltem_Schreiben/Treffen2022#c-Itti-2021-11-24T11%3A15%3A00.000Z-Zum_Punkt_Bestandsaufnahme

SQL

SELECT UserPage.page_title AS "User",
       COUNT(DISTINCT rev_id) AS "Anzahl Edits",
       COUNT(DISTINCT Article.page_id) AS "Anzahl Artikel",
       GROUP_CONCAT(Article.page_title SEPARATOR ", ") AS "Artikel"
  FROM page AS UserPage, categorylinks, user, actor, revision_userindex, page AS Article
 WHERE UserPage.page_namespace = 2
   AND cl_from = UserPage.page_id
   AND cl_to = 'Benutzer:Verifiziert'
   AND user_name = REPLACE(UserPage.page_title, '_', ' ')
   AND actor_user = user_id
   AND rev_actor = actor_id
   AND rev_timestamp > DATE_FORMAT(subdate(CURDATE(), INTERVAL 6 MONTH), '%Y%m%d000000')
   AND Article.page_id = rev_page
   AND Article.page_namespace = 0
 GROUP BY actor_id
HAVING COUNT(DISTINCT rev_id) <= 10

SQL

Checking query status...