-- simpler but slower query:
-- select page_namespace, count(*) -... |
1 month ago |
-- simpler but slower query:
-- select page_namespace, count(*) -... |
3 years ago |
SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
3 years ago |
SELECT
page_namespace,
count(page_id) - sum(page_is_redirect) as 'not... |
3 years ago |
SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
3 years ago |
SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
3 years ago |
SELECT
page_namespace,
MAX(notredir) as 'not redirect',
MAX(redir) as... |
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) 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 |