Untitled query #78227

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+es,Ca+eu+en+es+gl,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,Ee,Egl,Ekk,El,El+en,El+fr,En,En+ar,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,En-gb,En-us,Eo,Es,Et,Eto,Eu,Ext,Fa,Ff,Fi,Fil,Fj,Fo,Fr,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,Fr-be,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,Lang:mi,Lang:mr,Lang:nb,Lang:non,Lang:ve,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,Mk,Mk-cyrl,Mk-latn,Ml,Mn,Mn-cyrl,Mn-latn,Mn-mong,Mnc,Mo,Moh,Mqm,Mrq,Ms,Mt,Mug,Mul,Mus,Mvf,Mwl,My,Myv,Na,Nah,Nan,Nap,Naq,Nd,Nds,Nds-nl,Ne,New,Niu,Nl,Nl+en,Nl+fr,Nl+fr+de,Nl+fr+en,Nl+fr+en+de,Nl-be,Nn,No,Nr,Nrf,Nrf-je,Nso,Nv,Ny,Oc,Och,Okn,Om,Or,Os,Osp,Ota,Otk,Pa,Pal,Pam,Pap,Pau,Pcd,Pdc,Pi,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,Simple,Sjo,Sk,Sl,Sli,Slr,Sm,Smi,Sn,Snk,So,Sq,Sr,Sr-Cyrl,Sr-Latn,Ssf,St,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,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;
SQL

Checking query status...
