Untitled query #17103

SQL

#SHOW DATABASES;

#USE plwiki_p;
#DESCRIBE revision; 


#SELECT COUNT (rev_user_text) AS editor_names from revision
#	WHERE rev_user_text NOT LIKE "%bot%" AND rev_user_text NOT LIKE "%Bot%";


#SELECT * FROM revision ORDER by rev_timestamp ASC LIMIT 50

#SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id ORDER by rev_timestamp ASC limit 10;
#SELECT * FROM user limit 10;

-- SELECT rev_page, page_title, rev_timestamp, rev_user, user_name FROM revision JOIN page ON rev_page = page_id 
-- 	JOIN user ON rev_user= user_id 
--     ORDER by rev_timestamp ASC 
--    limit 10;
    
#SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249";

USE zhwiki_p;

SELECT DISTINCT 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%" GROUP BY rev_user
	ORDER BY RAND()
	LIMIT 2000;
SQL

Checking query status...
