-- Автор SQL запиту: Користувач:Ilya
USE ukwiki_p;

SELECT  @rownum := @rownum + 1 AS rank,  
		user_name, 
        created,   
        percents  
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
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
WHERE 
	page_namespace = 0 AND
    page_is_redirect = 0 AND
	EXISTS (
    	SELECT 1 FROM user_groups
		WHERE ug_user = rev_user AND ug_group = 'bot'
  	)    
GROUP BY rev_user_text    
ORDER BY created  DESC) t, 
(SELECT @rownum := 0) r
ORDER BY created DESC

 -- Автор SQL запиту: Користувач:NickK
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
GROUP BY rev_actor    
HAVING 
	created >= 30
ORDER BY created  DESC) t, 
(SELECT @rownum := 0) r
ORDER BY created DESC