Verifizierte User mit Edits in den letzten 6 Monaten

SQL

SELECT UserPage.page_title AS "User",
       COUNT(DISTINCT rev_id) AS "Anzahl Edits",
       COUNT(DISTINCT Article.page_id) AS "Anzahl Artikel",
       GROUP_CONCAT(DISTINCT 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 NOT EXISTS (SELECT 1
                     FROM logging
                    WHERE log_type = 'block'
                      AND log_action IN ('block', 'reblock')
                      AND log_title = UserPage.page_title
                      AND log_params LIKE "%infinity%"
                      AND log_timestamp = (SELECT MAX(log_timestamp)
                                             FROM logging
                                            WHERE log_type = 'block'
                                              AND log_action IN ('block', 'unblock', 'reblock')
                                              AND log_title = UserPage.page_title
                                              AND log_timestamp >= DATE_FORMAT(subdate(CURDATE(), INTERVAL 6 MONTH), '%Y%m%d000000')
                                          )
                  )
   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...
