| USE crhwiki_p;
SELECT page_is_redirect, COUNT(page_is_redirect) AS freq
... |
4 years ago |
| USE crhwiki_p;
SELECT COUNT(page_is_redirect) AS freq
FROM revision
... |
4 years ago |
| USE scowiki_p;
SELECT actor_name, COUNT(actor_name) AS freq
FROM... |
4 years ago |
| USE banwiki_p;
SELECT actor_name, COUNT(actor_name) AS freq
FROM... |
4 years ago |
| USE tnwiki_p;
SELECT actor_name, COUNT(actor_name) AS freq
FROM... |
4 years ago |
| USE tnwiki_p;
SELECT actor_name, COUNT(rev_user_text) AS freq
FROM... |
4 years ago |
| USE dvwiki_p;
SELECT rev_user FROM revision ORDER BY rev_timestamp DESC LIMIT 1; |
4 years ago |
| USE dvwiki_p;
SELECT rev_actor FROM revision ORDER BY rev_timestamp DESC LIMIT 1; |
4 years ago |
| USE dvwiki_p;
SELECT rev_user_text FROM revision ORDER BY rev_timestamp... |
4 years ago |
| USE dvwiki_p;
SELECT rev_id FROM revision ORDER BY rev_timestamp DESC LIMIT 1; |
4 years ago |
| USE dvwiki_p;
SELECT * FROM revision ORDER BY rev_timestamp DESC LIMIT 1000; |
6 years ago |
| USE dvwiki_p;
SELECT * FROM revision WHERE rev_user=0 ORDER BY... |
6 years ago |
| USE dvwiki_p;
SELECT * FROM revision WHERE rev_parent_id=0 ORDER BY... |
6 years ago |
| USE dvwiki_p;
SELECT * FROM revision WHERE rev_id=0 ORDER BY rev_timestamp... |
6 years ago |
| USE dvwiki;
SELECT * FROM revision WHERE rev_id=0 ORDER BY rev_timestamp DESC; |
6 years ago |
