Untitled query #72273

SQL

SET @rev = (SELECT MIN(rev_id)
            FROM revision
            WHERE rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), "%Y%m%d%H%i%s"));
SELECT 
user_name, 
COUNT(*) as edit_count, 
user_editcount, 
user_registration, 
u.user_id, 
IFNULL(l.ll_title, 'unknown') as language
FROM revision_userindex
JOIN actor ON actor.actor_id = revision_userindex.rev_actor
JOIN user u ON u.user_id = actor.actor_user
LEFT JOIN page p ON p.page_id = revision_userindex.rev_page
LEFT JOIN langlinks l ON l.ll_from = p.page_id AND l.ll_lang = 'en'
WHERE p.page_namespace = 0 AND u.user_name IS NOT NULL
GROUP BY user_name, language
ORDER BY edit_count DESC
LIMIT 25;
SQL

Checking query status...
