Find number of non-EC users commenting on the last RfX

Fork of Find non-EC users commenting on a certain page by SoWhy

This query is marked as a draft This query has been published by SoWhy.

SQL

SELECT DISTINCT usr.user_name AS `user`, DATE_FORMAT(usr.user_registration, "%d %M %Y") AS `registration date`, DATEDIFF(CURDATE(),usr.user_registration) AS `account age in days`, usr.user_editcount AS `edits`
FROM revision_userindex AS rev 
LEFT JOIN user AS usr ON rev.rev_user = usr.user_id
LEFT JOIN page AS pg ON pg.page_id = rev.rev_page
LEFT JOIN user_groups AS ug ON usr.user_id = ug.ug_user
WHERE pg.page_title LIKE "Requests_for_adminship/Robert_McClenon_2"
AND pg.page_namespace = 4
AND ug.ug_group IS NULL
ORDER BY usr.user_registration ASC

SQL

Checking query status...