Untitled query #42502

SQL

#SHOW DATABASES;
USE scowiki_p;
#SHOW TABLES; #see all tables
#DESCRIBE page; #decide one page called page 
#SELECT * FROM page LIMIT 10; #* all the columns, just show me 10 rows 
#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 page_title, rev_timestamp, rev_actor, user_name FROM revision JOIN page ON rev_actor = page_id JOIN user ON rev_actor= user_id ORDER by rev_timestamp ASC limit 10;
12.	SELECT COUNT(rev_id) FROM revision WHERE rev_user = "66249";
SQL

Checking query status...
