Find Bad Langlinks

This query is marked as a draft This query has been published by Livnetata.
SQL

(SELECT DISTINCT 'lezwiki' as source, page_id, page_title, ll_lang, ll_title FROM lezwiki_p.langlinks LEFT JOIN lezwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'lnwiki' as source, page_id, page_title, ll_lang, ll_title FROM lnwiki_p.langlinks LEFT JOIN lnwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'pflwiki' as source, page_id, page_title, ll_lang, ll_title FROM pflwiki_p.langlinks LEFT JOIN pflwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'krcwiki' as source, page_id, page_title, ll_lang, ll_title FROM krcwiki_p.langlinks LEFT JOIN krcwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'hawwiki' as source, page_id, page_title, ll_lang, ll_title FROM hawwiki_p.langlinks LEFT JOIN hawwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'pdcwiki' as source, page_id, page_title, ll_lang, ll_title FROM pdcwiki_p.langlinks LEFT JOIN pdcwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'xalwiki' as source, page_id, page_title, ll_lang, ll_title FROM xalwiki_p.langlinks LEFT JOIN xalwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'rwwiki' as source, page_id, page_title, ll_lang, ll_title FROM rwwiki_p.langlinks LEFT JOIN rwwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'myvwiki' as source, page_id, page_title, ll_lang, ll_title FROM myvwiki_p.langlinks LEFT JOIN myvwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'novwiki' as source, page_id, page_title, ll_lang, ll_title FROM novwiki_p.langlinks LEFT JOIN novwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'towiki' as source, page_id, page_title, ll_lang, ll_title FROM towiki_p.langlinks LEFT JOIN towiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'klwiki' as source, page_id, page_title, ll_lang, ll_title FROM klwiki_p.langlinks LEFT JOIN klwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'arcwiki' as source, page_id, page_title, ll_lang, ll_title FROM arcwiki_p.langlinks LEFT JOIN arcwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'cdowiki' as source, page_id, page_title, ll_lang, ll_title FROM cdowiki_p.langlinks LEFT JOIN cdowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'kaawiki' as source, page_id, page_title, ll_lang, ll_title FROM kaawiki_p.langlinks LEFT JOIN kaawiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'bjnwiki' as source, page_id, page_title, ll_lang, ll_title FROM bjnwiki_p.langlinks LEFT JOIN bjnwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'lowiki' as source, page_id, page_title, ll_lang, ll_title FROM lowiki_p.langlinks LEFT JOIN lowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'kbdwiki' as source, page_id, page_title, ll_lang, ll_title FROM kbdwiki_p.langlinks LEFT JOIN kbdwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'papwiki' as source, page_id, page_title, ll_lang, ll_title FROM papwiki_p.langlinks LEFT JOIN papwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'hawiki' as source, page_id, page_title, ll_lang, ll_title FROM hawiki_p.langlinks LEFT JOIN hawiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'avwiki' as source, page_id, page_title, ll_lang, ll_title FROM avwiki_p.langlinks LEFT JOIN avwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tywiki' as source, page_id, page_title, ll_lang, ll_title FROM tywiki_p.langlinks LEFT JOIN tywiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tpiwiki' as source, page_id, page_title, ll_lang, ll_title FROM tpiwiki_p.langlinks LEFT JOIN tpiwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'bxrwiki' as source, page_id, page_title, ll_lang, ll_title FROM bxrwiki_p.langlinks LEFT JOIN bxrwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'nawiki' as source, page_id, page_title, ll_lang, ll_title FROM nawiki_p.langlinks LEFT JOIN nawiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'mdfwiki' as source, page_id, page_title, ll_lang, ll_title FROM mdfwiki_p.langlinks LEFT JOIN mdfwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'lbewiki' as source, page_id, page_title, ll_lang, ll_title FROM lbewiki_p.langlinks LEFT JOIN lbewiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'jbowiki' as source, page_id, page_title, ll_lang, ll_title FROM jbowiki_p.langlinks LEFT JOIN jbowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'wowiki' as source, page_id, page_title, ll_lang, ll_title FROM wowiki_p.langlinks LEFT JOIN wowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'roa-rupwiki' as source, page_id, page_title, ll_lang, ll_title FROM roa_rupwiki_p.langlinks LEFT JOIN roa_rupwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'srnwiki' as source, page_id, page_title, ll_lang, ll_title FROM srnwiki_p.langlinks LEFT JOIN srnwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'igwiki' as source, page_id, page_title, ll_lang, ll_title FROM igwiki_p.langlinks LEFT JOIN igwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tetwiki' as source, page_id, page_title, ll_lang, ll_title FROM tetwiki_p.langlinks LEFT JOIN tetwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'nsowiki' as source, page_id, page_title, ll_lang, ll_title FROM nsowiki_p.langlinks LEFT JOIN nsowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'kgwiki' as source, page_id, page_title, ll_lang, ll_title FROM kgwiki_p.langlinks LEFT JOIN kgwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tyvwiki' as source, page_id, page_title, ll_lang, ll_title FROM tyvwiki_p.langlinks LEFT JOIN tyvwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'abwiki' as source, page_id, page_title, ll_lang, ll_title FROM abwiki_p.langlinks LEFT JOIN abwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'ltgwiki' as source, page_id, page_title, ll_lang, ll_title FROM ltgwiki_p.langlinks LEFT JOIN ltgwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'sdwiki' as source, page_id, page_title, ll_lang, ll_title FROM sdwiki_p.langlinks LEFT JOIN sdwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'zuwiki' as source, page_id, page_title, ll_lang, ll_title FROM zuwiki_p.langlinks LEFT JOIN zuwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'zawiki' as source, page_id, page_title, ll_lang, ll_title FROM zawiki_p.langlinks LEFT JOIN zawiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'omwiki' as source, page_id, page_title, ll_lang, ll_title FROM omwiki_p.langlinks LEFT JOIN omwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'chywiki' as source, page_id, page_title, ll_lang, ll_title FROM chywiki_p.langlinks LEFT JOIN chywiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'twwiki' as source, page_id, page_title, ll_lang, ll_title FROM twwiki_p.langlinks LEFT JOIN twwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'rmywiki' as source, page_id, page_title, ll_lang, ll_title FROM rmywiki_p.langlinks LEFT JOIN rmywiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'cuwiki' as source, page_id, page_title, ll_lang, ll_title FROM cuwiki_p.langlinks LEFT JOIN cuwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'maiwiki' as source, page_id, page_title, ll_lang, ll_title FROM maiwiki_p.langlinks LEFT JOIN maiwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'chrwiki' as source, page_id, page_title, ll_lang, ll_title FROM chrwiki_p.langlinks LEFT JOIN chrwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tnwiki' as source, page_id, page_title, ll_lang, ll_title FROM tnwiki_p.langlinks LEFT JOIN tnwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'gotwiki' as source, page_id, page_title, ll_lang, ll_title FROM gotwiki_p.langlinks LEFT JOIN gotwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'biwiki' as source, page_id, page_title, ll_lang, ll_title FROM biwiki_p.langlinks LEFT JOIN biwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'pihwiki' as source, page_id, page_title, ll_lang, ll_title FROM pihwiki_p.langlinks LEFT JOIN pihwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'rnwiki' as source, page_id, page_title, ll_lang, ll_title FROM rnwiki_p.langlinks LEFT JOIN rnwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'smwiki' as source, page_id, page_title, ll_lang, ll_title FROM smwiki_p.langlinks LEFT JOIN smwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'bmwiki' as source, page_id, page_title, ll_lang, ll_title FROM bmwiki_p.langlinks LEFT JOIN bmwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'sswiki' as source, page_id, page_title, ll_lang, ll_title FROM sswiki_p.langlinks LEFT JOIN sswiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'mowiki' as source, page_id, page_title, ll_lang, ll_title FROM mowiki_p.langlinks LEFT JOIN mowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'iuwiki' as source, page_id, page_title, ll_lang, ll_title FROM iuwiki_p.langlinks LEFT JOIN iuwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'xhwiki' as source, page_id, page_title, ll_lang, ll_title FROM xhwiki_p.langlinks LEFT JOIN xhwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'kiwiki' as source, page_id, page_title, ll_lang, ll_title FROM kiwiki_p.langlinks LEFT JOIN kiwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'pntwiki' as source, page_id, page_title, ll_lang, ll_title FROM pntwiki_p.langlinks LEFT JOIN pntwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'lgwiki' as source, page_id, page_title, ll_lang, ll_title FROM lgwiki_p.langlinks LEFT JOIN lgwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tswiki' as source, page_id, page_title, ll_lang, ll_title FROM tswiki_p.langlinks LEFT JOIN tswiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'eewiki' as source, page_id, page_title, ll_lang, ll_title FROM eewiki_p.langlinks LEFT JOIN eewiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'akwiki' as source, page_id, page_title, ll_lang, ll_title FROM akwiki_p.langlinks LEFT JOIN akwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tiwiki' as source, page_id, page_title, ll_lang, ll_title FROM tiwiki_p.langlinks LEFT JOIN tiwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'fjwiki' as source, page_id, page_title, ll_lang, ll_title FROM fjwiki_p.langlinks LEFT JOIN fjwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'kswiki' as source, page_id, page_title, ll_lang, ll_title FROM kswiki_p.langlinks LEFT JOIN kswiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'sgwiki' as source, page_id, page_title, ll_lang, ll_title FROM sgwiki_p.langlinks LEFT JOIN sgwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'ffwiki' as source, page_id, page_title, ll_lang, ll_title FROM ffwiki_p.langlinks LEFT JOIN ffwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'nywiki' as source, page_id, page_title, ll_lang, ll_title FROM nywiki_p.langlinks LEFT JOIN nywiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'stwiki' as source, page_id, page_title, ll_lang, ll_title FROM stwiki_p.langlinks LEFT JOIN stwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'vewiki' as source, page_id, page_title, ll_lang, ll_title FROM vewiki_p.langlinks LEFT JOIN vewiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'crwiki' as source, page_id, page_title, ll_lang, ll_title FROM crwiki_p.langlinks LEFT JOIN crwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'dzwiki' as source, page_id, page_title, ll_lang, ll_title FROM dzwiki_p.langlinks LEFT JOIN dzwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'ikwiki' as source, page_id, page_title, ll_lang, ll_title FROM ikwiki_p.langlinks LEFT JOIN ikwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'tumwiki' as source, page_id, page_title, ll_lang, ll_title FROM tumwiki_p.langlinks LEFT JOIN tumwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'chwiki' as source, page_id, page_title, ll_lang, ll_title FROM chwiki_p.langlinks LEFT JOIN chwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'ngwiki' as source, page_id, page_title, ll_lang, ll_title FROM ngwiki_p.langlinks LEFT JOIN ngwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'iiwiki' as source, page_id, page_title, ll_lang, ll_title FROM iiwiki_p.langlinks LEFT JOIN iiwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'chowiki' as source, page_id, page_title, ll_lang, ll_title FROM chowiki_p.langlinks LEFT JOIN chowiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'mhwiki' as source, page_id, page_title, ll_lang, ll_title FROM mhwiki_p.langlinks LEFT JOIN mhwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'aawiki' as source, page_id, page_title, ll_lang, ll_title FROM aawiki_p.langlinks LEFT JOIN aawiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'kjwiki' as source, page_id, page_title, ll_lang, ll_title FROM kjwiki_p.langlinks LEFT JOIN kjwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'howiki' as source, page_id, page_title, ll_lang, ll_title FROM howiki_p.langlinks LEFT JOIN howiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'muswiki' as source, page_id, page_title, ll_lang, ll_title FROM muswiki_p.langlinks LEFT JOIN muswiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'krwiki' as source, page_id, page_title, ll_lang, ll_title FROM krwiki_p.langlinks LEFT JOIN krwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	UNION ALL
(SELECT DISTINCT 'hzwiki' as source, page_id, page_title, ll_lang, ll_title FROM hzwiki_p.langlinks LEFT JOIN hzwiki_p.page
	ON page_id = ll_from 
	WHERE page_namespace = 0
	AND (ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw"))
	;
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.
SQL

Checking query status...
