Untitled query #32355

SQL

SELECT
  rev_user_text, COUNT(*)
FROM revision
JOIN page AS article ON rev_page = article.page_id
JOIN page AS usertalk ON usertalk.page_title = rev_user_text
WHERE article.page_namespace = 7
AND usertalk.page_namespace = 3
AND usertalk.page_title NOT IN 
    (
      SELECT page_title
      FROM revision_userindex
      JOIN change_tag ON ct_rev_id = rev_id
      JOIN page ON rev_page = page_id
      WHERE page_namespace = 3
      AND ct_tag = 'wikilove'
    ) 
AND rev_timestamp > (NOW() - INTERVAL 3 MONTH) 
GROUP BY rev_user_text
ORDER BY COUNT(*) DESC
LIMIT 10;
SQL

Checking query status...
