Untitled query #42669

SQL

SHOW DATABASES;
USE crhwiki_p;
SHOW TABLES;
SELECT * FROM page LIMIT 10;
DESCRIBE page; 
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_actor, user_name FROM revision JOIN page ON rev_page = page_id JOIN user ON rev_actor= user_id ORDER by rev_timestamp ASC limit 10;
23.	SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id) editcounts FROM revision JOIN page ON page_id = rev_page group by rev_page LIMIT 10;
SQL

Checking query status...
