​

USE szlwiki_p;

#SHOW TABLES; 

​

DESCRIBE revision;

DESCRIBE page;

​

#SELECT rev_user FROM revision;

​

​

#SELECT DISTINCT  (rev_user) AS distinct_editors FROM revision;

#SELECT DISTINCT (rev_id) AS edit_count FROM revision;

#SELECT page_len FROM page,

​

​

#ORDER BY RAND();

​

​

#SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id 

​

​

​

​