Untitled query #16665

SQL

#What databases exist?
	#SHOW DATABASES;
#Select a database
USE miwiki_p;

Select * from revision LIMIT 20;
Select * from page LIMIT 20;
Select * from user LIMIT 20;

#How many times was each page edited
SELECT COUNT(rev_page) AS rev_counts FROM revision GROUP BY rev_page LIMIT 100;

#Add where namespace = 0
SELECT COUNT(rev_page) AS rev_counts, page_title FROM revision JOIN page ON rev_page = page_id WHERE page_namespace = "0" GROUP BY rev_page LIMIT 100;

#Add where user_name not like bot
SELECT COUNT(rev_page) AS rev_counts, page_title FROM revision JOIN page ON rev_page = page_id JOIN user ON rev_user = user_id WHERE user_name NOT LIKE "%bot%" WHERE page_namespace = "0" GROUP BY rev_page LIMIT 100;
SQL

Checking query status...
