Untitled query #16587

SQL

#SHOW DATABASES;
USE simplewiki_p;
#SHOW TABLES;
#DESCRIBE revision;
#DESCRIBE page;
#SELECT * FROM page LIMIT 10;
#select * from revision limit 10;
#SELECT * FROM revision LIMIT 10; 
#SELECT * FROM revision ORDER by rev_timestamp ASC limit 10;
#SELECT page_id FROM page LIMIT 10;


#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 LIKE "66249";
#SELECT COUNT(rev_id), rev_user, user_name FROM revision JOIN user on rev_user=user_id GROUP by rev_user LIMIT 10;
#SELECT COUNT(rev_id) AS editcounts, rev_user, user_name FROM revision JOIN user on rev_user=user_id GROUP by rev_user ORDER BY editcounts DESC LIMIT 10;

#SELECT COUNT(rev_id) AS editcounts, rev_user, user_name FROM revision JOIN user ON user_id = rev_user GROUP by rev_user ORDER BY editcounts DESC LIMIT 10;

#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 ORDER BY editcounts DESC LIMIT 10;

#SELECT COUNT(rev_id) AS editcounts, page_title, rev_page FROM revision JOIN user ON rev_user = user_id JOIN page ON page_id  = rev_page WHERE user_name="Auntof6" GROUP BY rev_page ORDER BY editcounts DESC LIMIT 10;
#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;

#SELECT  pl_from, page_title FROM pagelinks JOIN page ON page_id = pl_from WHERE pl_title = "Oxford" AND pl_namespace = "0" LIMIT 10;

#DESCRIBE pagelinks
#SELECT  pl_from, page_title FROM pagelinks JOIN page ON page_id = pl_from WHERE pl_title = "Cambridge" AND pl_namespace = "0" LIMIT 10;
#SELECT COUNT(*) AS linkscount, pl_title FROM pagelinks WHERE pl_namespace = "0" GROUP BY pl_title ORDER BY linkscount DESC LIMIT 10;
SQL

Checking query status...
