Untitled query #32512

SQL

/*SELECT DISTINCT user_name, user_editcount
FROM user
JOIN  revision
ON rev_user = user_id
WHERE revision.rev_page = 2535875
*/

/*SELECT rev_user_text, COUNT(*) 
FROM revision
WHERE revision.rev_page = 2535875

# AND rev_user_text = 'Materialscientist';
AND rev_user_text IN (SELECT DISTINCT rev_user_text as un
                      FROM revision
                      WHERE revision.rev_page = 2535875
                     );
                     
*/

SELECT rev_user_text, COUNT(*)
FROM revision
JOIN page
ON rev_page = page_id
WHERE rev_page = 2535875
GROUP BY rev_user_text
ORDER BY COUNT(*) DESC
LIMIT 50;
SQL

Checking query status...
