Untitled query #16666

SQL

USE dawiki_p;  #just means 'use this wiki'

#the LCASE() or LOWER() function didn't work for me for some reason
#SELECT COUNT(rev_id) AS editcounts, rev_user, user_name, user_registration FROM revision JOIN user ON user_id = rev_user WHERE user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%" AND user_name NOT LIKE "%BoT%" AND user_name NOT LIKE "%BOT%" GROUP by rev_user ORDER BY editcounts;

SELECT COUNT(rev_id) AS editcounts, rev_user, LOWER(user_name), user_registration FROM revision JOIN user ON user_id = rev_user WHERE user_name NOT LIKE "%bot%" GROUP by rev_user ORDER BY editcounts DESC;
SQL

Checking query status...
