List of articles created by Ahonc in ukwiki

SQL

ELECT  @rownum := @rownum + 1 AS rank,  
		user_name, 
        created,   
        percents  
FROM        
(
SELECT 
    page.page_id, page_title
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
	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...