| -- simpler but slower query:
-- select page_namespace, count(*) -... |
2 years ago |
| SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
2 years ago |
| SELECT
page_namespace,
count(page_id) - sum(page_is_redirect) as 'not... |
2 years ago |
| SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
2 years ago |
| SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
2 years ago |
| SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
2 years ago |
| use enwiktionary_p;
SELECT
page_namespace,
MAX(notredir) as 'not... |
3 years ago |
| use enwiktionary_p;
SELECT
page_namespace,
MAX(notredir) as 'not... |
3 years ago |
| use enwiktionary_p;
SELECT
page_namespace,
MAX(notredir) as 'not... |
4 years ago |
| use enwiktionary_p;
SELECT
page_namespace,
MAX(notredir),
... |
4 years ago |
| use enwiktionary_p;
SELECT
rev_page AS page_id,
... |
4 years ago |
| use enwiktionary_p;
SELECT
rev_page AS page_id,
... |
4 years ago |
| use enwiktionary_p
SELECT
rev_page AS page_id,
... |
4 years ago |
