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, rev_timestamp, Article.page_title
  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
 LIMIT 20

SQL

Checking query status...