Untitled query #16677

SQL

#What databases exist?
	#SHOW DATABASES;

USE simplewiki_p;

#16 
#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%" GROUP by rev_user DESC LIMIT 10000;
#SELECT COUNT(rev_id) AS editcounts, rev_user, user_name, user_registration FROM revision JOIN user ON user_id = rev_user JOIN page ON page_id  = rev_page WHERE user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%" AND page_namespace = "0" GROUP by rev_user ORDER BY editcounts DESC LIMIT 1000;


Create table new_table (user_id FROM user LIMIT 10)

#18
#SELECT COUNT(rev_id) AS editcounts, page_title FROM revision JOIN user ON rev_user = user_id JOIN page ON page_id  = rev_page WHERE user_name="Auntof6" and page_namespace = "0" GROUP BY rev_page ORDER BY editcounts DESC LIMIT 10;
SQL

Checking query status...
