wiktionaries:ns0:linter_counts

SQL

use bgwiktionary_p;
select 'bg', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use eowiktionary_p;
select 'eo', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use euwiktionary_p;
select 'eu', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use frwiktionary_p;
select 'fr', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use iowiktionary_p;
select 'io', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use kawiktionary_p;
select 'ka', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use ltwiktionary_p;
select 'lt', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use mnwiktionary_p;
select 'mn', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use ruwiktionary_p;
select 'ru', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use thwiktionary_p;
select 'th', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use uzwiktionary_p;
select 'uz', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
use wawiktionary_p;
select 'wa', linter_cat, count(*) from linter join page on page.page_id = linter.linter_page where page.page_namespace=0 and linter_cat > 5 and linter_cat != 8 group by linter_cat;
SQL

Checking query status...
