Користувачі за числом створених статей з та без дизамбігів

SQL

USE ukwiki_p;

SELECT  @rownum := @rownum + 1 AS rank,  
		user_name, 
        created,   
        percents,
        created_disabigless,
        percents_disambigless
FROM        
(
SELECT 
	CONCAT('[[Користувач:', rev_user_text, '|]]') as user_name,
    COUNT(1) AS created, 
    CONCAT(
      ROUND(
        COUNT(1) / 
        (SELECT COUNT(1) 
          FROM page 
          JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl 
         	ON pl_from = page_id
          WHERE page_namespace = 0 AND page_is_redirect = 0
        ) * 100, 
        2), '%'
      ) AS percents,
  	COUNT(CASE WHEN pp_propname IS NULL THEN 1 ELSE NULL END ) AS created_disabigless,
  	CONCAT(
      ROUND(
        COUNT(CASE WHEN pp_propname IS NULL THEN 1 ELSE NULL END ) / 
        (SELECT COUNT(CASE WHEN pp_propname IS NULL THEN 1 ELSE NULL END) 
          FROM page 
          JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl 
         	ON pl_from = page_id
          LEFT JOIN page_props
  			ON pp_page = page_id AND
  			pp_propname = "disambiguation"
          WHERE page_namespace = 0 AND page_is_redirect = 0
        ) * 100, 
        2), '%'
      ) AS percents_disambigless
FROM page
JOIN revision
	ON rev_page = page_id AND
    rev_parent_id = 0    
JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl
  	  ON pl_from = page_id
LEFT JOIN page_props
  	ON pp_page = page_id AND
  	pp_propname = "disambiguation"
WHERE 
	page_namespace = 0 AND
    page_is_redirect = 0 AND
	NOT EXISTS (
    	SELECT 1 FROM user_groups
		WHERE ug_user = rev_user AND ug_group = 'bot'
  	)    
GROUP BY rev_user_text    
HAVING 
	created >= 30
ORDER BY created  DESC) t, 
(SELECT @rownum := 0) r
ORDER BY created DESC
SQL

Checking query status...
