Untitled query #17275

SQL


USE szlwiki_p;
#SHOW TABLES; 

#DESCRIBE revision;
#DESCRIBE page;

SELECT DISTINCT COUNT (rev_user) AS distinct_editors FROM revision,
SELECT DISTINCT COUNT (rev_id) AS edit_count FROM revision, 
SELECT page_len FROM page,
#SELECT rev_page, rev_user, rev_user_text FROM revision JOIN page ON rev_page = page_id;


ORDER BY RAND();



#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, rev_user, rev_user_text FROM revision JOIN page ON rev_page = page_id 
-- 	JOIN user ON rev_user= user_id
SQL

Checking query status...
