IP reverts top distribution example

SQL

SELECT 
  top_ip_reverts,  
  total_ip_reverts,
  top_ip_reverts/total_ip_reverts
FROM 

(
	SELECT 
	  SUM(1) AS total_ip_reverts
	FROM 
	  revision,
	  page 
	WHERE 
	  rev_page=page_id 
	  AND page_namespace=0
	  AND rev_comment REGEXP "(ontributions|uokkaukset)/[0-9A-F]{1,4}[.:][0-9A-F]{1,4}[.:]" 
	  AND rev_comment NOT LIKE concat("%", rev_user_text, "%")
	  AND rev_timestamp > 20160000000000
) 
AS total,
(
	SELECT 
  	  SUM(page_reverts) AS top_ip_reverts 
	FROM
	(
	   SELECT 
	      SUM(1) AS page_reverts,
	   FROM 
	     revision,
	     page 
  	   WHERE 
	     rev_page=page_id 
	     AND page_namespace=0
	     AND rev_comment REGEXP "(ontributions|uokkaukset)/[0-9A-F]{1,4}[.:][0-9A-F]{1,4}[.:]" 
	     AND rev_comment NOT LIKE concat("%", rev_user_text, "%")
	     AND rev_timestamp > 20160000000000 
	   GROUP BY page_id
	   ORDER BY page_reverts DESC
	   LIMIT 400
	) as page
) as top
SQL

Checking query status...
