Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
SSastry (WMF)
.
6 - self-closed-tag 7 - deletable-table-tag 9 - pwrap-bug-workaround 10- tidy-whitespace-bug 12 - html5-misnesting 13 - tidy-font-bug 14 - multiple-unclosed-formatting-tags; 15 - unclosed-quotes-in-heading 16 - multiline-html-table-in-list
Toggle Highlighting
SQL
use afwiki_p; select "afwiki", 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 and linter_cat != 11 group by linter_cat; use anwiki_p; select "anwiki", 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 and linter_cat != 11 group by linter_cat; use arwiki_p; select "arwiki", 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 and linter_cat != 11 group by linter_cat; use aswiki_p; select "aswiki", 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 and linter_cat != 11 group by linter_cat; use astwiki_p; select "astwiki", 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 and linter_cat != 11 group by linter_cat; use avwiki_p; select "avwiki", 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 and linter_cat != 11 group by linter_cat; use azwiki_p; select "azwiki", 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 and linter_cat != 11 group by linter_cat; use azbwiki_p; select "azbwiki", 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 and linter_cat != 11 group by linter_cat; use bawiki_p; select "bawiki", 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 and linter_cat != 11 group by linter_cat; use bewiki_p; select "bewiki", 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 and linter_cat != 11 group by linter_cat; use bnwiki_p; select "bnwiki", 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 and linter_cat != 11 group by linter_cat; use bpywiki_p; select "bpywiki", 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 and linter_cat != 11 group by linter_cat; use cewiki_p; select "cewiki", 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 and linter_cat != 11 group by linter_cat; use ckbwiki_p; select "ckbwiki", 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 and linter_cat != 11 group by linter_cat; use cywiki_p; select "cywiki", 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 and linter_cat != 11 group by linter_cat; use dawiki_p; select "dawiki", 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 and linter_cat != 11 group by linter_cat; use diqwiki_p; select "diqwiki", 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 and linter_cat != 11 group by linter_cat; use elwiki_p; select "elwiki", 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 and linter_cat != 11 group by linter_cat; use enwiki_p; select "enwiki", 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 and linter_cat != 11 group by linter_cat; use eowiki_p; select "eowiki", 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 and linter_cat != 11 group by linter_cat; use eswiki_p; select "eswiki", 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 and linter_cat != 11 group by linter_cat; use euwiki_p; select "euwiki", 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 and linter_cat != 11 group by linter_cat; use frwiki_p; select "frwiki", 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 and linter_cat != 11 group by linter_cat; use fywiki_p; select "fywiki", 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 and linter_cat != 11 group by linter_cat; use gdwiki_p; select "gdwiki", 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 and linter_cat != 11 group by linter_cat; use guwiki_p; select "guwiki", 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 and linter_cat != 11 group by linter_cat; use hakwiki_p; select "hakwiki", 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 and linter_cat != 11 group by linter_cat; use hiwiki_p; select "hiwiki", 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 and linter_cat != 11 group by linter_cat; use hrwiki_p; select "hrwiki", 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 and linter_cat != 11 group by linter_cat; use huwiki_p; select "huwiki", 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 and linter_cat != 11 group by linter_cat; use hywiki_p; select "hywiki", 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 and linter_cat != 11 group by linter_cat; use idwiki_p; select "idwiki", 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 and linter_cat != 11 group by linter_cat; use jawiki_p; select "jawiki", 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 and linter_cat != 11 group by linter_cat; use kawiki_p; select "kawiki", 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 and linter_cat != 11 group by linter_cat; use kkwiki_p; select "kkwiki", 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 and linter_cat != 11 group by linter_cat; use knwiki_p; select "knwiki", 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 and linter_cat != 11 group by linter_cat; use koiwiki_p; select "koiwiki", 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 and linter_cat != 11 group by linter_cat; use kvwiki_p; select "kvwiki", 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 and linter_cat != 11 group by linter_cat; use lrcwiki_p; select "lrcwiki", 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 and linter_cat != 11 group by linter_cat; use lvwiki_p; select "lvwiki", 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 and linter_cat != 11 group by linter_cat; use mgwiki_p; select "mgwiki", 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 and linter_cat != 11 group by linter_cat; use mkwiki_p; select "mkwiki", 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 and linter_cat != 11 group by linter_cat; use mlwiki_p; select "mlwiki", 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 and linter_cat != 11 group by linter_cat; use mrwiki_p; select "mrwiki", 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 and linter_cat != 11 group by linter_cat; use mswiki_p; select "mswiki", 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 and linter_cat != 11 group by linter_cat; use myvwiki_p; select "myvwiki", 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 and linter_cat != 11 group by linter_cat; use nahwiki_p; select "nahwiki", 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 and linter_cat != 11 group by linter_cat; use nnwiki_p; select "nnwiki", 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 and linter_cat != 11 group by linter_cat; use ocwiki_p; select "ocwiki", 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 and linter_cat != 11 group by linter_cat; use pamwiki_p; select "pamwiki", 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 and linter_cat != 11 group by linter_cat; use plwiki_p; select "plwiki", 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 and linter_cat != 11 group by linter_cat; use pnbwiki_p; select "pnbwiki", 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 and linter_cat != 11 group by linter_cat; use ptwiki_p; select "ptwiki", 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 and linter_cat != 11 group by linter_cat; use rowiki_p; select "rowiki", 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 and linter_cat != 11 group by linter_cat; use roa_rupwiki_p; select "roa_rupwiki", 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 and linter_cat != 11 group by linter_cat; use sdwiki_p; select "sdwiki", 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 and linter_cat != 11 group by linter_cat; use shwiki_p; select "shwiki", 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 and linter_cat != 11 group by linter_cat; use simplewiki_p; select "simplewiki", 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 and linter_cat != 11 group by linter_cat; use slwiki_p; select "slwiki", 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 and linter_cat != 11 group by linter_cat; use srwiki_p; select "srwiki", 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 and linter_cat != 11 group by linter_cat; use suwiki_p; select "suwiki", 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 and linter_cat != 11 group by linter_cat; use swwiki_p; select "swwiki", 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 and linter_cat != 11 group by linter_cat; use tawiki_p; select "tawiki", 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 and linter_cat != 11 group by linter_cat; use tewiki_p; select "tewiki", 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 and linter_cat != 11 group by linter_cat; use tgwiki_p; select "tgwiki", 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 and linter_cat != 11 group by linter_cat; use thwiki_p; select "thwiki", 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 and linter_cat != 11 group by linter_cat; use trwiki_p; select "trwiki", 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 and linter_cat != 11 group by linter_cat; use ttwiki_p; select "ttwiki", 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 and linter_cat != 11 group by linter_cat; use ugwiki_p; select "ugwiki", 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 and linter_cat != 11 group by linter_cat; use ukwiki_p; select "ukwiki", 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 and linter_cat != 11 group by linter_cat; use urwiki_p; select "urwiki", 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 and linter_cat != 11 group by linter_cat; use viwiki_p; select "viwiki", 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 and linter_cat != 11 group by linter_cat; use xmfwiki_p; select "xmfwiki", 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 and linter_cat != 11 group by linter_cat; use yiwiki_p; select "yiwiki", 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 and linter_cat != 11 group by linter_cat; use yowiki_p; select "yowiki", 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 and linter_cat != 11 group by linter_cat; use zhwiki_p; select "zhwiki", 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 and linter_cat != 11 group by linter_cat; use zh_min_nanwiki_p; select "zh_min_nanwiki", 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 and linter_cat != 11 group by linter_cat; use zh_yuewiki_p; select "zh_yuewiki", 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 and linter_cat != 11 group by linter_cat; use bgwiktionary_p; select "bgwiktionary", 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 and linter_cat != 11 group by linter_cat; use eowiktionary_p; select "eowiktionary", 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 and linter_cat != 11 group by linter_cat; use euwiktionary_p; select "euwiktionary", 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 and linter_cat != 11 group by linter_cat; use frwiktionary_p; select "frwiktionary", 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 and linter_cat != 11 group by linter_cat; use iowiktionary_p; select "iowiktionary", 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 and linter_cat != 11 group by linter_cat; use kawiktionary_p; select "kawiktionary", 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 and linter_cat != 11 group by linter_cat; use ltwiktionary_p; select "ltwiktionary", 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 and linter_cat != 11 group by linter_cat; use mnwiktionary_p; select "mnwiktionary", 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 and linter_cat != 11 group by linter_cat; use ruwiktionary_p; select "ruwiktionary", 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 and linter_cat != 11 group by linter_cat; use thwiktionary_p; select "thwiktionary", 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 and linter_cat != 11 group by linter_cat; use uzwiktionary_p; select "uzwiktionary", 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 and linter_cat != 11 group by linter_cat; use wawiktionary_p; select "wawiktionary", 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 and linter_cat != 11 group by linter_cat; use enwikibooks_p; select "enwikibooks", 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 and linter_cat != 11 group by linter_cat; use frwikibooks_p; select "frwikibooks", 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 and linter_cat != 11 group by linter_cat; use sourceswiki_p; select "sourceswiki", 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 and linter_cat != 11 group by linter_cat; use arwikisource_p; select "arwikisource", 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 and linter_cat != 11 group by linter_cat; use enwikisource_p; select "enwikisource", 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 and linter_cat != 11 group by linter_cat; use fawikisource_p; select "fawikisource", 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 and linter_cat != 11 group by linter_cat; use frwikisource_p; select "frwikisource", 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 and linter_cat != 11 group by linter_cat; use hewikisource_p; select "hewikisource", 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 and linter_cat != 11 group by linter_cat; use ruwikisource_p; select "ruwikisource", 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 and linter_cat != 11 group by linter_cat; use sawikisource_p; select "sawikisource", 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 and linter_cat != 11 group by linter_cat; use slwikisource_p; select "slwikisource", 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 and linter_cat != 11 group by linter_cat; use srwikisource_p; select "srwikisource", 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 and linter_cat != 11 group by linter_cat; use incubatorwiki_p; select "incubatorwiki", 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 and linter_cat != 11 group by linter_cat;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...