Fiwiki ip-users revert ratio

SQL

SELECT 
	FLOOR(rev_timestamp/100000000) AS yearmonth, 
    SUM(1) AS total_edits, 
    SUM(ct_id IS NOT NULL) AS reverted_edits, 
    (SUM(ct_id IS NOT NULL) / SUM(1)) AS revert_ratio, 
    SUM(rev_user_text IN ("109.240.130.125", "109.240.228.85", "112.198.166.184", "112.198.169.103", "112.198.169.43", "112.198.169.91", "112.198.169.98", "131.228.2.20", "131.228.2.21", "176.72.255.75", "178.55.59.26", "178.71.162.78", "188.238.11.92", "188.238.82.239", "188.238.9.114", "193.210.231.24", "2001:14BA:A075:2300:1479:FC69:A00C:D408", "2001:14BA:A075:2300:4C94:EC15:822D:A21D", "2001:16B8:46D9:9700:784D:5FFE:EC32:9106", "212.226.152.125", "2A03:5342:F:6:0:0:0:2", "2A03:5342:F:6:0:0:0:3", "46.132.103.253", "46.132.190.246", "77.53.157.167", "78.27.67.153", "78.27.89.245", "80.223.212.193", "82.128.136.247", "82.181.205.107", "84.248.82.78", "84.250.177.51", "85.194.208.161", "85.194.208.163", "85.194.216.147", "85.76.81.23", "85.76.81.63", "86.114.245.167", "86.115.143.168", "86.115.78.73", "87.100.231.220", "87.95.104.41", "88.114.10.156", "88.115.91.112", "88.91.100.244", "89.110.12.91", "91.152.24.119", "91.154.178.14", "91.154.178.183", "91.158.44.90", "91.158.45.0", "91.158.45.16", "91.158.45.171", "91.158.45.68", "91.158.45.8", "91.158.45.84", "91.158.45.88", "93.106.182.252", "95.54.63.147")) as top_ip_users, 

    (
      SUM(
        (ct_id IS NOT NULL) AND (rev_user_text NOT IN ("109.240.130.125", "109.240.228.85", "112.198.166.184", "112.198.169.103", "112.198.169.43", "112.198.169.91", "112.198.169.98", "131.228.2.20", "131.228.2.21", "176.72.255.75", "178.55.59.26", "178.71.162.78", "188.238.11.92", "188.238.82.239", "188.238.9.114", "193.210.231.24", "2001:14BA:A075:2300:1479:FC69:A00C:D408", "2001:14BA:A075:2300:4C94:EC15:822D:A21D", "2001:16B8:46D9:9700:784D:5FFE:EC32:9106", "212.226.152.125", "2A03:5342:F:6:0:0:0:2", "2A03:5342:F:6:0:0:0:3", "46.132.103.253", "46.132.190.246", "77.53.157.167", "78.27.67.153", "78.27.89.245", "80.223.212.193", "82.128.136.247", "82.181.205.107", "84.248.82.78", "84.250.177.51", "85.194.208.161", "85.194.208.163", "85.194.216.147", "85.76.81.23", "85.76.81.63", "86.114.245.167", "86.115.143.168", "86.115.78.73", "87.100.231.220", "87.95.104.41", "88.114.10.156", "88.115.91.112", "88.91.100.244", "89.110.12.91", "91.152.24.119", "91.154.178.14", "91.154.178.183", "91.158.44.90", "91.158.45.0", "91.158.45.16", "91.158.45.171", "91.158.45.68", "91.158.45.8", "91.158.45.84", "91.158.45.88", "93.106.182.252", "95.54.63.147")
        ) as t 

FROM 
    page, 
    revision_compat 
    LEFT JOIN change_tag ON ct_rev_id=rev_id AND ct_tag_id=88 
WHERE 
	page_namespace = 0 
    AND page_id=rev_page 
    AND rev_user=0 
    AND rev_timestamp > 20201000000000 
    AND rev_id>18630374 
GROUP BY yearmonth;
SQL

Checking query status...
