Untitled query #17103

SQL

USE simplewiki_p;
#SHOW TABLES; 
#DESCRIBE page;

#SELECT * FROM page LIMIT 10
#SELECT * FROM revision LIMIT 10

#SELECT * FROM revision ORDER by rev_timestamp ASC LIMIT 50

#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  pl_title FROM pagelinks 
	JOIN page ON page_id = pl_from
    WHERE page_title = "Oxford" AND pl_namespace = "0" AND page_namespace = "0" 
    LIMIT 10;
SQL

Checking query status...
