Multiple AfD nominations

This query is marked as a draft This query has been published by Isaac (WMF).

Example query for extracting articles with edit comments that match some character string at least k times. In this, AfD mentions.

NOTE: doesn't run to completion on enwiki.

SQL

WITH afd_comments AS (
	SELECT
      comment_id
    FROM comment
    WHERE
      comment_text LIKE 'AfD:%'    
)
SELECT
  rev_page,
  COUNT(1) AS num_afd_comments
FROM revision r
INNER JOIN afd_comments afd
  ON (r.rev_comment_id = afd.comment_id)
GROUP BY
  rev_page
ORDER BY
  num_afd_comments DESC

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...