Untitled query #7610

SQL

#SHOW DATABASES;
USE simplewiki_p;
#SHOW TABLES;
#DESCRIBE page;
#SELECT * FROM revision ORDER by rev_timestamp LIMIT 10;
#SELECT rev_page FROM revision ORDER by rev_timestamp ASC limit 100
#DESC = 'descending order' (so limit to 10, in descending order)
#So, select the revision pages from the table 'revision', order them by the revision timestamps and then put in descending order, limiting to 10 entries.

SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id ORDER by rev_timestamp ASC limit 10
SQL

Checking query status...
