Untitled query #42500

SQL

# SHOW DATABASES;
#USE scowiki_p;
#SHOW TABLES;
#DESCRIBE abuse_filter; 
#SELECT page_len 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_actor, user_name
FROM revision JOIN page ON rev_page = page_id
JOIN user ON rev_id= user_id ORDER by rev_timestamp ASC limit 10;

SELECT COUNT(rev_id) FROM revision WHERE rev_ = "60841";
SQL

Checking query status...
