Untitled query #24968

SQL

# SHOW DATABASES;
USE simplewiki_p;
# SHOW TABLES;
# DESCRIBE page;
# DESCRIBE revision;
# SELECT * FROM page LIMIT 10;
# SELECT * FROM revision LIMIT 10;
# SELECT * FROM revision ORDER by rev_timestamp LIMIT 10;
# SELECT rev_page FROM revision ORDER by rev_timestamp DESC 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 = "66249";
# SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10;
# SELECT COUNT(rev_id) AS editcounts FROM revision 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(*) AS langcounts, ll_from, page_title FROM langlinks JOIN page on ll_from = page_id WHERE page_namespace  = 0 GROUP BY ll_from ORDER BY langcounts DESC LIMIT 10;
SQL

Checking query status...
