| SELECT COUNT(*), substr( page_title, 1, 1 )
FROM page where page_namespace =... |
7 years ago |
| SELECT COUNT(*), substr( page_title, 1, 2 )
FROM page where page_namespace =... |
7 years ago |
| SELECT COUNT(*) FROM page where page_namespace = 100; |
7 years ago |
| SELECT page_title, rev_user_text, rev_comment, rev_timestamp
from page
inner... |
7 years ago |
| SELECT * from page where page_namespace = 0
and page_title like 'Main_Page/%'; |
7 years ago |
| SELECT AVG(rev_len) FROM revision where
rev_page = 15580374 ; |
7 years ago |
| SELECT AVG(rev_len), MIN(rev_len), rev_comment FROM revision where
rev_page... |
7 years ago |
| SELECT AVG(rev_length) FROM revision where
rev_page = 15580374 order by... |
7 years ago |
| SELECT rev_comment, rev_user_text, rev_timestamp FROM revision... |
7 years ago |
| SELECT * FROM revision where
rev_page = 15580374 order by rev_timestamp desc... |
7 years ago |
| SELECT * FROM revision where rev_page = 15580374; |
7 years ago |
| SELECT * FROM page WHERE page_namespace = 0
and page_title = 'Main_Page'
LIMIT 30; |
7 years ago |
| SELECT * FROM page LIMIT 30; |
7 years ago |
