Possible hoax articles on zhwiki

Fork of Possible hoax articles on zhwiki by WhitePhosphorus

This query is marked as a draft This query has been published by Ericliu1912.

SQL

SELECT
    page_title,
    COUNT(*) AS edit_count
FROM
    revision_userindex rev
JOIN page
    ON rev.rev_page = page.page_id
JOIN actor
    ON rev.rev_actor = actor.actor_id
WHERE actor.actor_name = "折毛"
    AND page.page_namespace = 10
GROUP BY
    page.page_id

AخA
 
SELECT    page_title,    COUNT(*) AS edit_countFROM    revision_userindex revJOIN page    ON rev.rev_page = page.page_idJOIN actor    ON rev.rev_actor = actor.actor_idWHERE actor.actor_name = "折毛"    AND page.page_namespace = 10GROUP BY    page.page_id

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