Comparison of IP edits by removal

Fork of Comparison of tagged semi-automated tool edits by Chlod

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

SQL

SELECT 			-- Add the following columns...
	COUNT(CASE WHEN ct_tag_id = 59 THEN 1 END) as "reverted",
    COUNT(CASE WHEN 1=1 THEN 1 END) as "all"
FROM revision as rev   					-- ... from all Wikipedia revisions
JOIN change_tag ON change_tag.ct_rev_id = rev.rev_id        -- Combines revision tags with the query
JOIN actor ON rev.rev_actor = actor.actor_id
WHERE rev.rev_deleted = 0 			-- vidljive izmjene
 AND actor.actor_user IS NULL		-- IP izmjene 
 AND   rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), "%Y%m%d%H%i%s") AND (  -- Minus one year
        ct_tag_id = 7  -- HG
        OR ct_tag_id = 63  -- ST
        OR ct_tag_id = 577  -- RW
        OR ct_tag_id = 583  -- TW
    )

-- limit 10

SQL

Checking query status...