USE tewiki_p;

SELECT CONCAT('[[', replace(rc_title, '_', ' '), ']]') AS article, COUNT(*) AS edits, 

  COUNT(DISTINCT rc_user_text) AS editors, -- used to be rc_user which counted all IPs as same

  ROUND(LN(COUNT(*)) * (LN(COUNT(DISTINCT rc_user_text))+1.4), 2) AS weighted_rank

FROM recentchanges

WHERE rc_namespace = 0 

  AND rc_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%s')

GROUP BY article ORDER BY weighted_rank DESC

LIMIT 200;