Untitled query #16620

SQL

USE dewiki_p;
#0: INTRO
#SHOW TABLES;
#DESCRIBE page;
#SELECT * FROM page 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;
#---
#11 double JOIN
#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;
#12 COUNT --> failed execute command denied to user 'u2029'@'%' for routine 'dewiki_p.COUNT'
#SELECT COUNT (rev_id) FROM revision WHERE rev_user ="66249";
#13 GROUP
SELECT COUNT (rev_id) FROM revision GROUP by rev_user LIMIT 10;
SQL

Checking query status...
