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
LD
.
Toggle Highlighting
SQL
set @template = 'Aa','Ab','Ace','Ach','Ady','Ae','Aeb','Af','Akk','Als','Am','An','Ang','Ar','Ary','Arz','As','Ast','Atj','Avk','Ay','Az','Az+en','Az+en+ru','Az+en+ru+fr','Az+ru','Ba','Ban','Bar','Bcl','Be','Be-tarask','Ber','Bg','Bh','Bi','Bia','Bjn','Bm','Bn','Bo','Bpy','Br','Bs','Bua','Bxm','Bxr','Bxu','Ca','Ca+en','Ca+en+es','Ca+eu+en+es+gl','Ca+es','Ca+fr','Cbk','Ce','Ceb','Ch','Ckb','Cmn','Cnr','Cnr-cyrl','Cnr-latn','Co','Cpf','Cr','Crh','Crs','Cs','Cv','Cy','Da','Dag','Dak','De','De+fr','Dta','Dv','Dyu','Dz','Egl','Ekk','El','El+en','El+fr','En','En+ar','Simple','En-gb','En-us','En+cs','En+da','En+de','En+es','En+fa','En+fi','En+grc','En+hu','En+id','En+it','En+ja','En+ka','En+ko','En+nl','En+no','En+pl','En+pt','En+ro','En+ru','En+sl','En+sr','En+tr','En+zh','En+zh+ja','Eo','Es','Et','Eto','Eu','Ee','Ext','Fa','Ff','Fi','Fil','Fj','Fo','Fr','Fr-be','Fr/en','Fr+ar','Fr+de','Fr+en','Fr+en+de','Fr+en+es','Fr+en+es+de','Fr+en+es+ja','Fr+en+it','Fr+en+nl','Fr+en+no','Fr+es','Fr+grc','Fr+he','Fr+nl','Fr+nl+de','Fr+nl+en','Fr+nl+en+de','Fr1835','Frm','Fro','Frp','Fud','Fur','Fy','Ga','Gag','Gcf','Gcf-mq','Gd','Gez','Gil','Gl','Gn','Got','Grc','Grc+en','Gsw','Gsw-ch','Gsw-fr','Gu','Gv','Ha','Hak','Haw','He','He+en','Hi','Hif','Hr','Hsb','Ht','Hu','Hu+en','Hu+fr','Hy','Hy+en','Hy+ru+en','Hyw','Hz','Ia','Id','Ie','Ig','Ii','Ik','Ilo','Io','Is','It','Iu','Ja','Ja-latn','Jv','Ka','Kaa','Kab','Kaw','Kbd','Kea','Kg','Ki','Kk','Kk-arab','Kk-cyrl','Kk-latn','Kl','Km','Kmr','Kn','Ko','Ks','Ksh','Ku','Kv','Kw','Ky','Kzg','La','La+en','La+fr','Lad','Lb','Lb+fr+de','Lb+fr+de+en','Lfn','Li','Lij','Lld','Lmo','Ln','Lo','Lob','Lou','Lt','Ltc','Lua','Luo','Lv','Lzh','Mey','Mfe','Mg','Mga','Mh','Mhr','Lang:mi','Mk','Mk-cyrl','Mk-latn','Ml','Mn','Mn-cyrl','Mn-latn','Mn-mong','Mnc','Mo','Moh','Lang:mr','Mqm','Mrq','Ms','Mt','Mug','Mul','Mus','Mvf','Mwl','My','Myv','Na','Nah','Nan','Nap','Naq','Lang:nb','Nd','Nds','Nds-nl','Ne','New','Niu','Nl','Nl-be','Nl+en','Nl+fr','Nl+fr+de','Nl+fr+en','Nl+fr+en+de','Nn','No','Lang:non','Nr','Nrf','Nrf-je','Nso','Nv','Ny','Oc','Och','Okn','Om','Or','Os','Osp','Ota','Otk','Pa','Pal','Pam','Pap','Pau','Pcd','Pdc','Pi','Lang:pid/Documentation','Pis','Pl','Pms','Pnt','Prk','Prs','Ps','Pt','Pt-br','Qu','Rap','Rar','Rm','Rmy','Ro','Ro+en+fr','Ru','Ru-latn','Rue','Run','Rup','Rw','Ryu','Sa','Sc','Scn','Sco','Sd','Se','Sg','Sga','Sgs','Sh','Shy','Si','Sjo','Sk','Sl','Sli','Slr','Sm','Smi','Sn','Snk','So','St','Sq','Sr','Sr-Cyrl','Sr-Latn','Ssf','Su','Sv','Sw','Syc','Syr','Szl','Ta','Te','Tet','Tg','Th','Ti','Tk','Tl','Tmr','Tn','To','Tok','Tpi','Tr','Tr+en','Ts','Tsg','Tt','Tts','Tvl','Tw','Ty','Tyv','Tzl','Udm','Ug','Uhn','Uk','Ur','Uz','Lang:ve','Vec','Vep','Vi','Vls','Vo','Vro','Wa','War','Wls','Wo','Woe','Wuu','Xh','Xmm','Xsl','Yak','Yi','Yo','Yoi','Yue','Za','Zea','Zgh','Zh','Zh-cn','Zh-hans','Zh-hant','Zh-hk','Zh-latn-pinyin','Zh-mo','Zh-sg','Zh-tw','Zu','Zza'; SELECT page_title FROM linktarget LEFT JOIN templatelinks ON lt_id = tl_target_id LEFT JOIN page ON tl_from = page_id WHERE lt_namespace = 10 -- Template: AND lt_title IN @template AND tl_from_namespace = 0 -- Main: ;
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...