USE ukwiki_p;

SELECT rev_user_text, COUNT(1) AS created

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