Список ботів за кількістю започаткованих статей

SQL

USE ukwiki_p;

SELECT  @rownum := @rownum + 1 AS rank,  
		actor_name, 
        created,   
        percents  
FROM        
(
SELECT 
	CONCAT('[[Користувач:', actor_name, '|]]') as actor_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
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
JOIN actor ON actor_id = rev_actor
WHERE 
	page_namespace = 0 AND
    page_is_redirect = 0 AND
	EXISTS (
    	SELECT 1 FROM user_groups
		WHERE ug_user = actor_id AND ug_group = 'bot'
  	)    
GROUP BY rev_actor
ORDER BY created  DESC) t, 
(SELECT @rownum := 0) r
ORDER BY created DESC

SQL

Checking query status...