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:%'    
),
articles AS (
  	SELECT
      page_id,
	  page_title
    FROM page
    WHERE
      page_namespace = 0
      AND NOT page_is_redirect
)
SELECT
  page_title,
  COUNT(1) AS num_afd_comments
FROM revision r
INNER JOIN afd_comments afd
  ON (r.rev_comment_id = afd.comment_id)
INNER JOIN articles a
  ON (r.rev_page = a.page_id)
GROUP BY
  page_title
HAVING
  num_afd_comments > 1

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...