Query Run
-- 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