SQL
AخA
use fawiki_p;
select
rc_title,
SUM(
CASE
WHEN ct_tag_id = 10 THEN 1
ELSE 0
END
) AS undos,
SUM(
CASE
WHEN actor_user IS NULL THEN 1
ELSE 0
END
) AS ips
FROM recentchanges
JOIN actor_revision
ON rc_actor = actor_id
WHERE
rc_timestamp > '20200501000000'
AND (
rc_tag_id = 10
OR actor_user IS NULL
)
GROUP BY rc_title
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.