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

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 page_namespace = 0 AND
               page_is_redirect = 0 AND
               pl_from = page_id
        ) * 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(1) 
          FROM page 
          JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl 
         	ON page_namespace = 0 AND
         	   page_is_redirect = 0 AND
               pl_from = page_id
          WHERE page_id NOT IN(
            SELECT pp_page
            FROM page_props
  	        WHERE pp_propname = "disambiguation"
          )
        ) * 100, 
        2), '%'
      ) AS percents_disambigless
FROM page
JOIN revision
	ON page_namespace = 0 AND 
  	page_is_redirect = 0 AND
  	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
	rev_user NOT IN (
    	SELECT ug_user
        FROM user_groups
        WHERE ug_group = "bot"
        UNION
        SELECT ufg_user
        FROM user_former_groups
        WHERE ufg_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...
