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
Pols12
.
List all pages which have a page content language different from subpage name which should be the explicit language code. v2
Toggle Highlighting
SQL
SELECT page_lang AS lang, page_namespace, page_title FROM page WHERE ( page_title LIKE '%/ab' OR page_title LIKE '%/abs' OR page_title LIKE '%/ace' OR page_title LIKE '%/ady' OR page_title LIKE '%/ady-cyrl' OR page_title LIKE '%/aeb' OR page_title LIKE '%/aeb-arab' OR page_title LIKE '%/aeb-latn' OR page_title LIKE '%/af' OR page_title LIKE '%/ak' OR page_title LIKE '%/aln' OR page_title LIKE '%/alt' OR page_title LIKE '%/am' OR page_title LIKE '%/ami' OR page_title LIKE '%/an' OR page_title LIKE '%/ang' OR page_title LIKE '%/ann' OR page_title LIKE '%/anp' OR page_title LIKE '%/ar' OR page_title LIKE '%/arc' OR page_title LIKE '%/arn' OR page_title LIKE '%/arq' OR page_title LIKE '%/ary' OR page_title LIKE '%/arz' OR page_title LIKE '%/as' OR page_title LIKE '%/ase' OR page_title LIKE '%/ast' OR page_title LIKE '%/atj' OR page_title LIKE '%/av' OR page_title LIKE '%/avk' OR page_title LIKE '%/awa' OR page_title LIKE '%/ay' OR page_title LIKE '%/az' OR page_title LIKE '%/azb' OR page_title LIKE '%/ba' OR page_title LIKE '%/ban' OR page_title LIKE '%/ban-bali' OR page_title LIKE '%/bar' OR page_title LIKE '%/bbc' OR page_title LIKE '%/bbc-latn' OR page_title LIKE '%/bcc' OR page_title LIKE '%/bci' OR page_title LIKE '%/bcl' OR page_title LIKE '%/be' OR page_title LIKE '%/be-tarask' OR page_title LIKE '%/bg' OR page_title LIKE '%/bgn' OR page_title LIKE '%/bh' OR page_title LIKE '%/bho' OR page_title LIKE '%/bi' OR page_title LIKE '%/bjn' OR page_title LIKE '%/blk' OR page_title LIKE '%/bm' OR page_title LIKE '%/bn' OR page_title LIKE '%/bo' OR page_title LIKE '%/bpy' OR page_title LIKE '%/bqi' OR page_title LIKE '%/br' OR page_title LIKE '%/brh' OR page_title LIKE '%/bs' OR page_title LIKE '%/btm' OR page_title LIKE '%/bto' OR page_title LIKE '%/bug' OR page_title LIKE '%/bxr' OR page_title LIKE '%/ca' OR page_title LIKE '%/cbk-zam' OR page_title LIKE '%/cdo' OR page_title LIKE '%/ce' OR page_title LIKE '%/ceb' OR page_title LIKE '%/ch' OR page_title LIKE '%/chr' OR page_title LIKE '%/chy' OR page_title LIKE '%/ckb' OR page_title LIKE '%/co' OR page_title LIKE '%/cps' OR page_title LIKE '%/cr' OR page_title LIKE '%/crh' OR page_title LIKE '%/crh-cyrl' OR page_title LIKE '%/crh-latn' OR page_title LIKE '%/cs' OR page_title LIKE '%/csb' OR page_title LIKE '%/cu' OR page_title LIKE '%/cv' OR page_title LIKE '%/cy' OR page_title LIKE '%/da' OR page_title LIKE '%/dag' OR page_title LIKE '%/de' OR page_title LIKE '%/de-at' OR page_title LIKE '%/de-ch' OR page_title LIKE '%/de-formal' OR page_title LIKE '%/dga' OR page_title LIKE '%/din' OR page_title LIKE '%/diq' OR page_title LIKE '%/dsb' OR page_title LIKE '%/dtp' OR page_title LIKE '%/dty' OR page_title LIKE '%/dv' OR page_title LIKE '%/dz' OR page_title LIKE '%/ee' OR page_title LIKE '%/egl' OR page_title LIKE '%/el' OR page_title LIKE '%/eml' OR page_title LIKE '%/en' OR page_title LIKE '%/en-ca' OR page_title LIKE '%/en-gb' OR page_title LIKE '%/eo' OR page_title LIKE '%/es' OR page_title LIKE '%/es-formal' OR page_title LIKE '%/et' OR page_title LIKE '%/eu' OR page_title LIKE '%/ext' OR page_title LIKE '%/fa' OR page_title LIKE '%/fat' OR page_title LIKE '%/ff' OR page_title LIKE '%/fi' OR page_title LIKE '%/fit' OR page_title LIKE '%/fj' OR page_title LIKE '%/fo' OR page_title LIKE '%/fon' OR page_title LIKE '%/fr' OR page_title LIKE '%/frc' OR page_title LIKE '%/frp' OR page_title LIKE '%/frr' OR page_title LIKE '%/fur' OR page_title LIKE '%/fy' OR page_title LIKE '%/ga' OR page_title LIKE '%/gaa' OR page_title LIKE '%/gag' OR page_title LIKE '%/gan' OR page_title LIKE '%/gan-hans' OR page_title LIKE '%/gan-hant' OR page_title LIKE '%/gcr' OR page_title LIKE '%/gd' OR page_title LIKE '%/gl' OR page_title LIKE '%/gld' OR page_title LIKE '%/glk' OR page_title LIKE '%/gn' OR page_title LIKE '%/gom' OR page_title LIKE '%/gom-deva' OR page_title LIKE '%/gom-latn' OR page_title LIKE '%/gor' OR page_title LIKE '%/got' OR page_title LIKE '%/gpe' OR page_title LIKE '%/grc' OR page_title LIKE '%/gsw' OR page_title LIKE '%/gu' OR page_title LIKE '%/guc' OR page_title LIKE '%/gur' OR page_title LIKE '%/guw' OR page_title LIKE '%/gv' OR page_title LIKE '%/ha' OR page_title LIKE '%/hak' OR page_title LIKE '%/haw' OR page_title LIKE '%/he' OR page_title LIKE '%/hi' OR page_title LIKE '%/hif' OR page_title LIKE '%/hif-latn' OR page_title LIKE '%/hil' OR page_title LIKE '%/hr' OR page_title LIKE '%/hrx' OR page_title LIKE '%/hsb' OR page_title LIKE '%/hsn' OR page_title LIKE '%/ht' OR page_title LIKE '%/hu' OR page_title LIKE '%/hu-formal' OR page_title LIKE '%/hy' OR page_title LIKE '%/hyw' OR page_title LIKE '%/ia' OR page_title LIKE '%/id' OR page_title LIKE '%/ie' OR page_title LIKE '%/ig' OR page_title LIKE '%/igl' OR page_title LIKE '%/ii' OR page_title LIKE '%/ik' OR page_title LIKE '%/ike-cans' OR page_title LIKE '%/ike-latn' OR page_title LIKE '%/ilo' OR page_title LIKE '%/inh' OR page_title LIKE '%/io' OR page_title LIKE '%/is' OR page_title LIKE '%/it' OR page_title LIKE '%/iu' OR page_title LIKE '%/ja' OR page_title LIKE '%/jam' OR page_title LIKE '%/jbo' OR page_title LIKE '%/jut' OR page_title LIKE '%/jv' OR page_title LIKE '%/ka' OR page_title LIKE '%/kaa' OR page_title LIKE '%/kab' OR page_title LIKE '%/kbd' OR page_title LIKE '%/kbd-cyrl' OR page_title LIKE '%/kbp' OR page_title LIKE '%/kcg' OR page_title LIKE '%/kea' OR page_title LIKE '%/kg' OR page_title LIKE '%/khw' OR page_title LIKE '%/ki' OR page_title LIKE '%/kiu' OR page_title LIKE '%/kjh' OR page_title LIKE '%/kjp' OR page_title LIKE '%/kk' OR page_title LIKE '%/kk-arab' OR page_title LIKE '%/kk-cn' OR page_title LIKE '%/kk-cyrl' OR page_title LIKE '%/kk-kz' OR page_title LIKE '%/kk-latn' OR page_title LIKE '%/kk-tr' OR page_title LIKE '%/kl' OR page_title LIKE '%/km' OR page_title LIKE '%/kn' OR page_title LIKE '%/ko' OR page_title LIKE '%/ko-kp' OR page_title LIKE '%/koi' OR page_title LIKE '%/kr' OR page_title LIKE '%/krc' OR page_title LIKE '%/kri' OR page_title LIKE '%/krj' OR page_title LIKE '%/krl' OR page_title LIKE '%/ks' OR page_title LIKE '%/ks-arab' OR page_title LIKE '%/ks-deva' OR page_title LIKE '%/ksh' OR page_title LIKE '%/ksw' OR page_title LIKE '%/ku' OR page_title LIKE '%/ku-arab' OR page_title LIKE '%/ku-latn' OR page_title LIKE '%/kum' OR page_title LIKE '%/kus' OR page_title LIKE '%/kv' OR page_title LIKE '%/kw' OR page_title LIKE '%/ky' OR page_title LIKE '%/la' OR page_title LIKE '%/lad' OR page_title LIKE '%/lb' OR page_title LIKE '%/lbe' OR page_title LIKE '%/lez' OR page_title LIKE '%/lfn' OR page_title LIKE '%/lg' OR page_title LIKE '%/li' OR page_title LIKE '%/lij' OR page_title LIKE '%/liv' OR page_title LIKE '%/lki' OR page_title LIKE '%/lld' OR page_title LIKE '%/lmo' OR page_title LIKE '%/ln' OR page_title LIKE '%/lo' OR page_title LIKE '%/loz' OR page_title LIKE '%/lrc' OR page_title LIKE '%/lt' OR page_title LIKE '%/ltg' OR page_title LIKE '%/lus' OR page_title LIKE '%/luz' OR page_title LIKE '%/lv' OR page_title LIKE '%/lzh' OR page_title LIKE '%/lzz' OR page_title LIKE '%/mad' OR page_title LIKE '%/mag' OR page_title LIKE '%/mai' OR page_title LIKE '%/map-bms' OR page_title LIKE '%/mdf' OR page_title LIKE '%/mg' OR page_title LIKE '%/mhr' OR page_title LIKE '%/mi' OR page_title LIKE '%/min' OR page_title LIKE '%/mk' OR page_title LIKE '%/ml' OR page_title LIKE '%/mn' OR page_title LIKE '%/mni' OR page_title LIKE '%/mnw' OR page_title LIKE '%/mo' OR page_title LIKE '%/mos' OR page_title LIKE '%/mr' OR page_title LIKE '%/mrh' OR page_title LIKE '%/mrj' OR page_title LIKE '%/ms' OR page_title LIKE '%/ms-arab' OR page_title LIKE '%/mt' OR page_title LIKE '%/mwl' OR page_title LIKE '%/my' OR page_title LIKE '%/myv' OR page_title LIKE '%/mzn' OR page_title LIKE '%/na' OR page_title LIKE '%/nah' OR page_title LIKE '%/nan' OR page_title LIKE '%/nap' OR page_title LIKE '%/nb' OR page_title LIKE '%/nds' OR page_title LIKE '%/nds-nl' OR page_title LIKE '%/ne' OR page_title LIKE '%/new' OR page_title LIKE '%/nia' OR page_title LIKE '%/niu' OR page_title LIKE '%/nl' OR page_title LIKE '%/nl-informal' OR page_title LIKE '%/nmz' OR page_title LIKE '%/nn' OR page_title LIKE '%/nod' OR page_title LIKE '%/nog' OR page_title LIKE '%/nov' OR page_title LIKE '%/nqo' OR page_title LIKE '%/nrm' OR page_title LIKE '%/nso' OR page_title LIKE '%/nv' OR page_title LIKE '%/ny' OR page_title LIKE '%/nyn' OR page_title LIKE '%/nys' OR page_title LIKE '%/oc' OR page_title LIKE '%/ojb' OR page_title LIKE '%/olo' OR page_title LIKE '%/om' OR page_title LIKE '%/or' OR page_title LIKE '%/os' OR page_title LIKE '%/pa' OR page_title LIKE '%/pag' OR page_title LIKE '%/pam' OR page_title LIKE '%/pap' OR page_title LIKE '%/pcd' OR page_title LIKE '%/pcm' OR page_title LIKE '%/pdc' OR page_title LIKE '%/pdt' OR page_title LIKE '%/pfl' OR page_title LIKE '%/pi' OR page_title LIKE '%/pih' OR page_title LIKE '%/pl' OR page_title LIKE '%/pms' OR page_title LIKE '%/pnb' OR page_title LIKE '%/pnt' OR page_title LIKE '%/prg' OR page_title LIKE '%/ps' OR page_title LIKE '%/pt' OR page_title LIKE '%/pt-br' OR page_title LIKE '%/pwn' OR page_title LIKE '%/qu' OR page_title LIKE '%/qug' OR page_title LIKE '%/rgn' OR page_title LIKE '%/rif' OR page_title LIKE '%/rki' OR page_title LIKE '%/rm' OR page_title LIKE '%/rmc' OR page_title LIKE '%/rmy' OR page_title LIKE '%/rn' OR page_title LIKE '%/ro' OR page_title LIKE '%/roa-tara' OR page_title LIKE '%/rsk' OR page_title LIKE '%/ru' OR page_title LIKE '%/rue' OR page_title LIKE '%/rup' OR page_title LIKE '%/ruq' OR page_title LIKE '%/ruq-cyrl' OR page_title LIKE '%/ruq-latn' OR page_title LIKE '%/rw' OR page_title LIKE '%/ryu' OR page_title LIKE '%/sa' OR page_title LIKE '%/sah' OR page_title LIKE '%/sat' OR page_title LIKE '%/sc' OR page_title LIKE '%/scn' OR page_title LIKE '%/sco' OR page_title LIKE '%/sd' OR page_title LIKE '%/sdc' OR page_title LIKE '%/sdh' OR page_title LIKE '%/se' OR page_title LIKE '%/se-fi' OR page_title LIKE '%/se-no' OR page_title LIKE '%/se-se' OR page_title LIKE '%/sei' OR page_title LIKE '%/ses' OR page_title LIKE '%/sg' OR page_title LIKE '%/sgs' OR page_title LIKE '%/sh' OR page_title LIKE '%/sh-cyrl' OR page_title LIKE '%/sh-latn' OR page_title LIKE '%/shi' OR page_title LIKE '%/shn' OR page_title LIKE '%/shy' OR page_title LIKE '%/shy-latn' OR page_title LIKE '%/si' OR page_title LIKE '%/sjd' OR page_title LIKE '%/sje' OR page_title LIKE '%/sk' OR page_title LIKE '%/skr' OR page_title LIKE '%/skr-arab' OR page_title LIKE '%/sl' OR page_title LIKE '%/sli' OR page_title LIKE '%/sm' OR page_title LIKE '%/sma' OR page_title LIKE '%/smn' OR page_title LIKE '%/sms' OR page_title LIKE '%/sn' OR page_title LIKE '%/so' OR page_title LIKE '%/sq' OR page_title LIKE '%/sr' OR page_title LIKE '%/sr-ec' OR page_title LIKE '%/sr-el' OR page_title LIKE '%/srn' OR page_title LIKE '%/sro' OR page_title LIKE '%/ss' OR page_title LIKE '%/st' OR page_title LIKE '%/stq' OR page_title LIKE '%/sty' OR page_title LIKE '%/su' OR page_title LIKE '%/sv' OR page_title LIKE '%/sw' OR page_title LIKE '%/syl' OR page_title LIKE '%/szl' OR page_title LIKE '%/szy' OR page_title LIKE '%/ta' OR page_title LIKE '%/tay' OR page_title LIKE '%/tcy' OR page_title LIKE '%/tdd' OR page_title LIKE '%/te' OR page_title LIKE '%/tet' OR page_title LIKE '%/tg' OR page_title LIKE '%/tg-cyrl' OR page_title LIKE '%/tg-latn' OR page_title LIKE '%/th' OR page_title LIKE '%/ti' OR page_title LIKE '%/tk' OR page_title LIKE '%/tl' OR page_title LIKE '%/tly' OR page_title LIKE '%/tn' OR page_title LIKE '%/to' OR page_title LIKE '%/tok' OR page_title LIKE '%/tpi' OR page_title LIKE '%/tr' OR page_title LIKE '%/tru' OR page_title LIKE '%/trv' OR page_title LIKE '%/ts' OR page_title LIKE '%/tt' OR page_title LIKE '%/tt-cyrl' OR page_title LIKE '%/tt-latn' OR page_title LIKE '%/tum' OR page_title LIKE '%/tw' OR page_title LIKE '%/ty' OR page_title LIKE '%/tyv' OR page_title LIKE '%/tzm' OR page_title LIKE '%/udm' OR page_title LIKE '%/ug' OR page_title LIKE '%/ug-arab' OR page_title LIKE '%/ug-latn' OR page_title LIKE '%/uk' OR page_title LIKE '%/ur' OR page_title LIKE '%/uz' OR page_title LIKE '%/ve' OR page_title LIKE '%/vec' OR page_title LIKE '%/vep' OR page_title LIKE '%/vi' OR page_title LIKE '%/vls' OR page_title LIKE '%/vmf' OR page_title LIKE '%/vmw' OR page_title LIKE '%/vo' OR page_title LIKE '%/vot' OR page_title LIKE '%/vro' OR page_title LIKE '%/wa' OR page_title LIKE '%/wal' OR page_title LIKE '%/war' OR page_title LIKE '%/wls' OR page_title LIKE '%/wo' OR page_title LIKE '%/wuu' OR page_title LIKE '%/xal' OR page_title LIKE '%/xh' OR page_title LIKE '%/xmf' OR page_title LIKE '%/xsy' OR page_title LIKE '%/yi' OR page_title LIKE '%/yo' OR page_title LIKE '%/yrl' OR page_title LIKE '%/yue' OR page_title LIKE '%/za' OR page_title LIKE '%/zea' OR page_title LIKE '%/zgh' OR page_title LIKE '%/zh' OR page_title LIKE '%/zh-cn' OR page_title LIKE '%/zh-hans' OR page_title LIKE '%/zh-hant' OR page_title LIKE '%/zh-hk' OR page_title LIKE '%/zh-mo' OR page_title LIKE '%/zh-my' OR page_title LIKE '%/zh-sg' OR page_title LIKE '%/zh-tw' OR page_title LIKE '%/zu' ) AND page_title NOT LIKE CONCAT('%/', IFNULL(page_lang, 'en'))
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...