Find Bad Langlinks

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

SELECT 'enwiki' as source, page_id, page_title, ll_lang, ll_title FROM enwiki_p.langlinks LEFT JOIN enwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'svwiki' as source, page_id, page_title, ll_lang, ll_title FROM svwiki_p.langlinks LEFT JOIN svwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nlwiki' as source, page_id, page_title, ll_lang, ll_title FROM nlwiki_p.langlinks LEFT JOIN nlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'dewiki' as source, page_id, page_title, ll_lang, ll_title FROM dewiki_p.langlinks LEFT JOIN dewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'frwiki' as source, page_id, page_title, ll_lang, ll_title FROM frwiki_p.langlinks LEFT JOIN frwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'warwiki' as source, page_id, page_title, ll_lang, ll_title FROM warwiki_p.langlinks LEFT JOIN warwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cebwiki' as source, page_id, page_title, ll_lang, ll_title FROM cebwiki_p.langlinks LEFT JOIN cebwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ruwiki' as source, page_id, page_title, ll_lang, ll_title FROM ruwiki_p.langlinks LEFT JOIN ruwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'itwiki' as source, page_id, page_title, ll_lang, ll_title FROM itwiki_p.langlinks LEFT JOIN itwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'eswiki' as source, page_id, page_title, ll_lang, ll_title FROM eswiki_p.langlinks LEFT JOIN eswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'viwiki' as source, page_id, page_title, ll_lang, ll_title FROM viwiki_p.langlinks LEFT JOIN viwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'plwiki' as source, page_id, page_title, ll_lang, ll_title FROM plwiki_p.langlinks LEFT JOIN plwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'jawiki' as source, page_id, page_title, ll_lang, ll_title FROM jawiki_p.langlinks LEFT JOIN jawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ptwiki' as source, page_id, page_title, ll_lang, ll_title FROM ptwiki_p.langlinks LEFT JOIN ptwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'zhwiki' as source, page_id, page_title, ll_lang, ll_title FROM zhwiki_p.langlinks LEFT JOIN zhwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ukwiki' as source, page_id, page_title, ll_lang, ll_title FROM ukwiki_p.langlinks LEFT JOIN ukwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cawiki' as source, page_id, page_title, ll_lang, ll_title FROM cawiki_p.langlinks LEFT JOIN cawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'fawiki' as source, page_id, page_title, ll_lang, ll_title FROM fawiki_p.langlinks LEFT JOIN fawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nowiki' as source, page_id, page_title, ll_lang, ll_title FROM nowiki_p.langlinks LEFT JOIN nowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'fiwiki' as source, page_id, page_title, ll_lang, ll_title FROM fiwiki_p.langlinks LEFT JOIN fiwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'idwiki' as source, page_id, page_title, ll_lang, ll_title FROM idwiki_p.langlinks LEFT JOIN idwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'arwiki' as source, page_id, page_title, ll_lang, ll_title FROM arwiki_p.langlinks LEFT JOIN arwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'srwiki' as source, page_id, page_title, ll_lang, ll_title FROM srwiki_p.langlinks LEFT JOIN srwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cswiki' as source, page_id, page_title, ll_lang, ll_title FROM cswiki_p.langlinks LEFT JOIN cswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kowiki' as source, page_id, page_title, ll_lang, ll_title FROM kowiki_p.langlinks LEFT JOIN kowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'shwiki' as source, page_id, page_title, ll_lang, ll_title FROM shwiki_p.langlinks LEFT JOIN shwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'huwiki' as source, page_id, page_title, ll_lang, ll_title FROM huwiki_p.langlinks LEFT JOIN huwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mswiki' as source, page_id, page_title, ll_lang, ll_title FROM mswiki_p.langlinks LEFT JOIN mswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'rowiki' as source, page_id, page_title, ll_lang, ll_title FROM rowiki_p.langlinks LEFT JOIN rowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'trwiki' as source, page_id, page_title, ll_lang, ll_title FROM trwiki_p.langlinks LEFT JOIN trwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'minwiki' as source, page_id, page_title, ll_lang, ll_title FROM minwiki_p.langlinks LEFT JOIN minwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kkwiki' as source, page_id, page_title, ll_lang, ll_title FROM kkwiki_p.langlinks LEFT JOIN kkwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'eowiki' as source, page_id, page_title, ll_lang, ll_title FROM eowiki_p.langlinks LEFT JOIN eowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'euwiki' as source, page_id, page_title, ll_lang, ll_title FROM euwiki_p.langlinks LEFT JOIN euwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'skwiki' as source, page_id, page_title, ll_lang, ll_title FROM skwiki_p.langlinks LEFT JOIN skwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'dawiki' as source, page_id, page_title, ll_lang, ll_title FROM dawiki_p.langlinks LEFT JOIN dawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bgwiki' as source, page_id, page_title, ll_lang, ll_title FROM bgwiki_p.langlinks LEFT JOIN bgwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ltwiki' as source, page_id, page_title, ll_lang, ll_title FROM ltwiki_p.langlinks LEFT JOIN ltwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hewiki' as source, page_id, page_title, ll_lang, ll_title FROM hewiki_p.langlinks LEFT JOIN hewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hrwiki' as source, page_id, page_title, ll_lang, ll_title FROM hrwiki_p.langlinks LEFT JOIN hrwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'slwiki' as source, page_id, page_title, ll_lang, ll_title FROM slwiki_p.langlinks LEFT JOIN slwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hywiki' as source, page_id, page_title, ll_lang, ll_title FROM hywiki_p.langlinks LEFT JOIN hywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'etwiki' as source, page_id, page_title, ll_lang, ll_title FROM etwiki_p.langlinks LEFT JOIN etwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'uzwiki' as source, page_id, page_title, ll_lang, ll_title FROM uzwiki_p.langlinks LEFT JOIN uzwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'vowiki' as source, page_id, page_title, ll_lang, ll_title FROM vowiki_p.langlinks LEFT JOIN vowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'glwiki' as source, page_id, page_title, ll_lang, ll_title FROM glwiki_p.langlinks LEFT JOIN glwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'simplewiki' as source, page_id, page_title, ll_lang, ll_title FROM simplewiki_p.langlinks LEFT JOIN simplewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nnwiki' as source, page_id, page_title, ll_lang, ll_title FROM nnwiki_p.langlinks LEFT JOIN nnwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hiwiki' as source, page_id, page_title, ll_lang, ll_title FROM hiwiki_p.langlinks LEFT JOIN hiwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'elwiki' as source, page_id, page_title, ll_lang, ll_title FROM elwiki_p.langlinks LEFT JOIN elwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'lawiki' as source, page_id, page_title, ll_lang, ll_title FROM lawiki_p.langlinks LEFT JOIN lawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'azwiki' as source, page_id, page_title, ll_lang, ll_title FROM azwiki_p.langlinks LEFT JOIN azwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'thwiki' as source, page_id, page_title, ll_lang, ll_title FROM thwiki_p.langlinks LEFT JOIN thwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ocwiki' as source, page_id, page_title, ll_lang, ll_title FROM ocwiki_p.langlinks LEFT JOIN ocwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kawiki' as source, page_id, page_title, ll_lang, ll_title FROM kawiki_p.langlinks LEFT JOIN kawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mkwiki' as source, page_id, page_title, ll_lang, ll_title FROM mkwiki_p.langlinks LEFT JOIN mkwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bewiki' as source, page_id, page_title, ll_lang, ll_title FROM bewiki_p.langlinks LEFT JOIN bewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cewiki' as source, page_id, page_title, ll_lang, ll_title FROM cewiki_p.langlinks LEFT JOIN cewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'newwiki' as source, page_id, page_title, ll_lang, ll_title FROM newwiki_p.langlinks LEFT JOIN newwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'tawiki' as source, page_id, page_title, ll_lang, ll_title FROM tawiki_p.langlinks LEFT JOIN tawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ttwiki' as source, page_id, page_title, ll_lang, ll_title FROM ttwiki_p.langlinks LEFT JOIN ttwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'urwiki' as source, page_id, page_title, ll_lang, ll_title FROM urwiki_p.langlinks LEFT JOIN urwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pmswiki' as source, page_id, page_title, ll_lang, ll_title FROM pmswiki_p.langlinks LEFT JOIN pmswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'tlwiki' as source, page_id, page_title, ll_lang, ll_title FROM tlwiki_p.langlinks LEFT JOIN tlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cywiki' as source, page_id, page_title, ll_lang, ll_title FROM cywiki_p.langlinks LEFT JOIN cywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'tewiki' as source, page_id, page_title, ll_lang, ll_title FROM tewiki_p.langlinks LEFT JOIN tewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'lvwiki' as source, page_id, page_title, ll_lang, ll_title FROM lvwiki_p.langlinks LEFT JOIN lvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bswiki' as source, page_id, page_title, ll_lang, ll_title FROM bswiki_p.langlinks LEFT JOIN bswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'be-x-oldwiki' as source, page_id, page_title, ll_lang, ll_title FROM be_x_oldwiki_p.langlinks LEFT JOIN be_x_oldwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mgwiki' as source, page_id, page_title, ll_lang, ll_title FROM mgwiki_p.langlinks LEFT JOIN mgwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'htwiki' as source, page_id, page_title, ll_lang, ll_title FROM htwiki_p.langlinks LEFT JOIN htwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'brwiki' as source, page_id, page_title, ll_lang, ll_title FROM brwiki_p.langlinks LEFT JOIN brwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'sqwiki' as source, page_id, page_title, ll_lang, ll_title FROM sqwiki_p.langlinks LEFT JOIN sqwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'jvwiki' as source, page_id, page_title, ll_lang, ll_title FROM jvwiki_p.langlinks LEFT JOIN jvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'lbwiki' as source, page_id, page_title, ll_lang, ll_title FROM lbwiki_p.langlinks LEFT JOIN lbwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mrwiki' as source, page_id, page_title, ll_lang, ll_title FROM mrwiki_p.langlinks LEFT JOIN mrwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'iswiki' as source, page_id, page_title, ll_lang, ll_title FROM iswiki_p.langlinks LEFT JOIN iswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mlwiki' as source, page_id, page_title, ll_lang, ll_title FROM mlwiki_p.langlinks LEFT JOIN mlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'zh-yuewiki' as source, page_id, page_title, ll_lang, ll_title FROM zh_yuewiki_p.langlinks LEFT JOIN zh_yuewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'afwiki' as source, page_id, page_title, ll_lang, ll_title FROM afwiki_p.langlinks LEFT JOIN afwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bnwiki' as source, page_id, page_title, ll_lang, ll_title FROM bnwiki_p.langlinks LEFT JOIN bnwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bawiki' as source, page_id, page_title, ll_lang, ll_title FROM bawiki_p.langlinks LEFT JOIN bawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pnbwiki' as source, page_id, page_title, ll_lang, ll_title FROM pnbwiki_p.langlinks LEFT JOIN pnbwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'gawiki' as source, page_id, page_title, ll_lang, ll_title FROM gawiki_p.langlinks LEFT JOIN gawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mywiki' as source, page_id, page_title, ll_lang, ll_title FROM mywiki_p.langlinks LEFT JOIN mywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'lmowiki' as source, page_id, page_title, ll_lang, ll_title FROM lmowiki_p.langlinks LEFT JOIN lmowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'fywiki' as source, page_id, page_title, ll_lang, ll_title FROM fywiki_p.langlinks LEFT JOIN fywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'yowiki' as source, page_id, page_title, ll_lang, ll_title FROM yowiki_p.langlinks LEFT JOIN yowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'tgwiki' as source, page_id, page_title, ll_lang, ll_title FROM tgwiki_p.langlinks LEFT JOIN tgwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'anwiki' as source, page_id, page_title, ll_lang, ll_title FROM anwiki_p.langlinks LEFT JOIN anwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cvwiki' as source, page_id, page_title, ll_lang, ll_title FROM cvwiki_p.langlinks LEFT JOIN cvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'scowiki' as source, page_id, page_title, ll_lang, ll_title FROM scowiki_p.langlinks LEFT JOIN scowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'swwiki' as source, page_id, page_title, ll_lang, ll_title FROM swwiki_p.langlinks LEFT JOIN swwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kywiki' as source, page_id, page_title, ll_lang, ll_title FROM kywiki_p.langlinks LEFT JOIN kywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'newiki' as source, page_id, page_title, ll_lang, ll_title FROM newiki_p.langlinks LEFT JOIN newiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'iowiki' as source, page_id, page_title, ll_lang, ll_title FROM iowiki_p.langlinks LEFT JOIN iowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'guwiki' as source, page_id, page_title, ll_lang, ll_title FROM guwiki_p.langlinks LEFT JOIN guwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bpywiki' as source, page_id, page_title, ll_lang, ll_title FROM bpywiki_p.langlinks LEFT JOIN bpywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'scnwiki' as source, page_id, page_title, ll_lang, ll_title FROM scnwiki_p.langlinks LEFT JOIN scnwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ndswiki' as source, page_id, page_title, ll_lang, ll_title FROM ndswiki_p.langlinks LEFT JOIN ndswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kuwiki' as source, page_id, page_title, ll_lang, ll_title FROM kuwiki_p.langlinks LEFT JOIN kuwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'astwiki' as source, page_id, page_title, ll_lang, ll_title FROM astwiki_p.langlinks LEFT JOIN astwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'quwiki' as source, page_id, page_title, ll_lang, ll_title FROM quwiki_p.langlinks LEFT JOIN quwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'gdwiki' as source, page_id, page_title, ll_lang, ll_title FROM gdwiki_p.langlinks LEFT JOIN gdwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'alswiki' as source, page_id, page_title, ll_lang, ll_title FROM alswiki_p.langlinks LEFT JOIN alswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'suwiki' as source, page_id, page_title, ll_lang, ll_title FROM suwiki_p.langlinks LEFT JOIN suwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'knwiki' as source, page_id, page_title, ll_lang, ll_title FROM knwiki_p.langlinks LEFT JOIN knwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pawiki' as source, page_id, page_title, ll_lang, ll_title FROM pawiki_p.langlinks LEFT JOIN pawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'amwiki' as source, page_id, page_title, ll_lang, ll_title FROM amwiki_p.langlinks LEFT JOIN amwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ckbwiki' as source, page_id, page_title, ll_lang, ll_title FROM ckbwiki_p.langlinks LEFT JOIN ckbwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'iawiki' as source, page_id, page_title, ll_lang, ll_title FROM iawiki_p.langlinks LEFT JOIN iawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'napwiki' as source, page_id, page_title, ll_lang, ll_title FROM napwiki_p.langlinks LEFT JOIN napwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bugwiki' as source, page_id, page_title, ll_lang, ll_title FROM bugwiki_p.langlinks LEFT JOIN bugwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mnwiki' as source, page_id, page_title, ll_lang, ll_title FROM mnwiki_p.langlinks LEFT JOIN mnwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bat-smgwiki' as source, page_id, page_title, ll_lang, ll_title FROM bat_smgwiki_p.langlinks LEFT JOIN bat_smgwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'wawiki' as source, page_id, page_title, ll_lang, ll_title FROM wawiki_p.langlinks LEFT JOIN wawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'arzwiki' as source, page_id, page_title, ll_lang, ll_title FROM arzwiki_p.langlinks LEFT JOIN arzwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'map-bmswiki' as source, page_id, page_title, ll_lang, ll_title FROM map_bmswiki_p.langlinks LEFT JOIN map_bmswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'siwiki' as source, page_id, page_title, ll_lang, ll_title FROM siwiki_p.langlinks LEFT JOIN siwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mznwiki' as source, page_id, page_title, ll_lang, ll_title FROM mznwiki_p.langlinks LEFT JOIN mznwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'zh-min-nanwiki' as source, page_id, page_title, ll_lang, ll_title FROM zh_min_nanwiki_p.langlinks LEFT JOIN zh_min_nanwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'yiwiki' as source, page_id, page_title, ll_lang, ll_title FROM yiwiki_p.langlinks LEFT JOIN yiwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'fowiki' as source, page_id, page_title, ll_lang, ll_title FROM fowiki_p.langlinks LEFT JOIN fowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'sahwiki' as source, page_id, page_title, ll_lang, ll_title FROM sahwiki_p.langlinks LEFT JOIN sahwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'barwiki' as source, page_id, page_title, ll_lang, ll_title FROM barwiki_p.langlinks LEFT JOIN barwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'vecwiki' as source, page_id, page_title, ll_lang, ll_title FROM vecwiki_p.langlinks LEFT JOIN vecwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'sawiki' as source, page_id, page_title, ll_lang, ll_title FROM sawiki_p.langlinks LEFT JOIN sawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nahwiki' as source, page_id, page_title, ll_lang, ll_title FROM nahwiki_p.langlinks LEFT JOIN nahwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'oswiki' as source, page_id, page_title, ll_lang, ll_title FROM oswiki_p.langlinks LEFT JOIN oswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'roa-tarawiki' as source, page_id, page_title, ll_lang, ll_title FROM roa_tarawiki_p.langlinks LEFT JOIN roa_tarawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hsbwiki' as source, page_id, page_title, ll_lang, ll_title FROM hsbwiki_p.langlinks LEFT JOIN hsbwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'orwiki' as source, page_id, page_title, ll_lang, ll_title FROM orwiki_p.langlinks LEFT JOIN orwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'liwiki' as source, page_id, page_title, ll_lang, ll_title FROM liwiki_p.langlinks LEFT JOIN liwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pamwiki' as source, page_id, page_title, ll_lang, ll_title FROM pamwiki_p.langlinks LEFT JOIN pamwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'sewiki' as source, page_id, page_title, ll_lang, ll_title FROM sewiki_p.langlinks LEFT JOIN sewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mrjwiki' as source, page_id, page_title, ll_lang, ll_title FROM mrjwiki_p.langlinks LEFT JOIN mrjwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ilowiki' as source, page_id, page_title, ll_lang, ll_title FROM ilowiki_p.langlinks LEFT JOIN ilowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'miwiki' as source, page_id, page_title, ll_lang, ll_title FROM miwiki_p.langlinks LEFT JOIN miwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cowiki' as source, page_id, page_title, ll_lang, ll_title FROM cowiki_p.langlinks LEFT JOIN cowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hifwiki' as source, page_id, page_title, ll_lang, ll_title FROM hifwiki_p.langlinks LEFT JOIN hifwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bclwiki' as source, page_id, page_title, ll_lang, ll_title FROM bclwiki_p.langlinks LEFT JOIN bclwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mhrwiki' as source, page_id, page_title, ll_lang, ll_title FROM mhrwiki_p.langlinks LEFT JOIN mhrwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ganwiki' as source, page_id, page_title, ll_lang, ll_title FROM ganwiki_p.langlinks LEFT JOIN ganwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'frrwiki' as source, page_id, page_title, ll_lang, ll_title FROM frrwiki_p.langlinks LEFT JOIN frrwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bowiki' as source, page_id, page_title, ll_lang, ll_title FROM bowiki_p.langlinks LEFT JOIN bowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ruewiki' as source, page_id, page_title, ll_lang, ll_title FROM ruewiki_p.langlinks LEFT JOIN ruewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'glkwiki' as source, page_id, page_title, ll_lang, ll_title FROM glkwiki_p.langlinks LEFT JOIN glkwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'bhwiki' as source, page_id, page_title, ll_lang, ll_title FROM bhwiki_p.langlinks LEFT JOIN bhwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nds-nlwiki' as source, page_id, page_title, ll_lang, ll_title FROM nds_nlwiki_p.langlinks LEFT JOIN nds_nlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'fiu-vrowiki' as source, page_id, page_title, ll_lang, ll_title FROM fiu_vrowiki_p.langlinks LEFT JOIN fiu_vrowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pswiki' as source, page_id, page_title, ll_lang, ll_title FROM pswiki_p.langlinks LEFT JOIN pswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'vlswiki' as source, page_id, page_title, ll_lang, ll_title FROM vlswiki_p.langlinks LEFT JOIN vlswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'tkwiki' as source, page_id, page_title, ll_lang, ll_title FROM tkwiki_p.langlinks LEFT JOIN tkwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pagwiki' as source, page_id, page_title, ll_lang, ll_title FROM pagwiki_p.langlinks LEFT JOIN pagwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'diqwiki' as source, page_id, page_title, ll_lang, ll_title FROM diqwiki_p.langlinks LEFT JOIN diqwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'xmfwiki' as source, page_id, page_title, ll_lang, ll_title FROM xmfwiki_p.langlinks LEFT JOIN xmfwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'gvwiki' as source, page_id, page_title, ll_lang, ll_title FROM gvwiki_p.langlinks LEFT JOIN gvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kmwiki' as source, page_id, page_title, ll_lang, ll_title FROM kmwiki_p.langlinks LEFT JOIN kmwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'scwiki' as source, page_id, page_title, ll_lang, ll_title FROM scwiki_p.langlinks LEFT JOIN scwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'csbwiki' as source, page_id, page_title, ll_lang, ll_title FROM csbwiki_p.langlinks LEFT JOIN csbwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'hakwiki' as source, page_id, page_title, ll_lang, ll_title FROM hakwiki_p.langlinks LEFT JOIN hakwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kvwiki' as source, page_id, page_title, ll_lang, ll_title FROM kvwiki_p.langlinks LEFT JOIN kvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'zeawiki' as source, page_id, page_title, ll_lang, ll_title FROM zeawiki_p.langlinks LEFT JOIN zeawiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'crhwiki' as source, page_id, page_title, ll_lang, ll_title FROM crhwiki_p.langlinks LEFT JOIN crhwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'vepwiki' as source, page_id, page_title, ll_lang, ll_title FROM vepwiki_p.langlinks LEFT JOIN vepwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'zh-classicalwiki' as source, page_id, page_title, ll_lang, ll_title FROM zh_classicalwiki_p.langlinks LEFT JOIN zh_classicalwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'aywiki' as source, page_id, page_title, ll_lang, ll_title FROM aywiki_p.langlinks LEFT JOIN aywiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'sowiki' as source, page_id, page_title, ll_lang, ll_title FROM sowiki_p.langlinks LEFT JOIN sowiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'dvwiki' as source, page_id, page_title, ll_lang, ll_title FROM dvwiki_p.langlinks LEFT JOIN dvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nrmwiki' as source, page_id, page_title, ll_lang, ll_title FROM nrmwiki_p.langlinks LEFT JOIN nrmwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kwwiki' as source, page_id, page_title, ll_lang, ll_title FROM kwwiki_p.langlinks LEFT JOIN kwwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'rmwiki' as source, page_id, page_title, ll_lang, ll_title FROM rmwiki_p.langlinks LEFT JOIN rmwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'udmwiki' as source, page_id, page_title, ll_lang, ll_title FROM udmwiki_p.langlinks LEFT JOIN udmwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'wuuwiki' as source, page_id, page_title, ll_lang, ll_title FROM wuuwiki_p.langlinks LEFT JOIN wuuwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'emlwiki' as source, page_id, page_title, ll_lang, ll_title FROM emlwiki_p.langlinks LEFT JOIN emlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'koiwiki' as source, page_id, page_title, ll_lang, ll_title FROM koiwiki_p.langlinks LEFT JOIN koiwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ugwiki' as source, page_id, page_title, ll_lang, ll_title FROM ugwiki_p.langlinks LEFT JOIN ugwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'stqwiki' as source, page_id, page_title, ll_lang, ll_title FROM stqwiki_p.langlinks LEFT JOIN stqwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'ladwiki' as source, page_id, page_title, ll_lang, ll_title FROM ladwiki_p.langlinks LEFT JOIN ladwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'lijwiki' as source, page_id, page_title, ll_lang, ll_title FROM lijwiki_p.langlinks LEFT JOIN lijwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'furwiki' as source, page_id, page_title, ll_lang, ll_title FROM furwiki_p.langlinks LEFT JOIN furwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'szlwiki' as source, page_id, page_title, ll_lang, ll_title FROM szlwiki_p.langlinks LEFT JOIN szlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mtwiki' as source, page_id, page_title, ll_lang, ll_title FROM mtwiki_p.langlinks LEFT JOIN mtwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'aswiki' as source, page_id, page_title, ll_lang, ll_title FROM aswiki_p.langlinks LEFT JOIN aswiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'cbk-zamwiki' as source, page_id, page_title, ll_lang, ll_title FROM cbk_zamwiki_p.langlinks LEFT JOIN cbk_zamwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'gnwiki' as source, page_id, page_title, ll_lang, ll_title FROM gnwiki_p.langlinks LEFT JOIN gnwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'pcdwiki' as source, page_id, page_title, ll_lang, ll_title FROM pcdwiki_p.langlinks LEFT JOIN pcdwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'piwiki' as source, page_id, page_title, ll_lang, ll_title FROM piwiki_p.langlinks LEFT JOIN piwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'gagwiki' as source, page_id, page_title, ll_lang, ll_title FROM gagwiki_p.langlinks LEFT JOIN gagwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kshwiki' as source, page_id, page_title, ll_lang, ll_title FROM kshwiki_p.langlinks LEFT JOIN kshwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'angwiki' as source, page_id, page_title, ll_lang, ll_title FROM angwiki_p.langlinks LEFT JOIN angwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'iewiki' as source, page_id, page_title, ll_lang, ll_title FROM iewiki_p.langlinks LEFT JOIN iewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'acewiki' as source, page_id, page_title, ll_lang, ll_title FROM acewiki_p.langlinks LEFT JOIN acewiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'extwiki' as source, page_id, page_title, ll_lang, ll_title FROM extwiki_p.langlinks LEFT JOIN extwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'nvwiki' as source, page_id, page_title, ll_lang, ll_title FROM nvwiki_p.langlinks LEFT JOIN nvwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'frpwiki' as source, page_id, page_title, ll_lang, ll_title FROM frpwiki_p.langlinks LEFT JOIN frpwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'dsbwiki' as source, page_id, page_title, ll_lang, ll_title FROM dsbwiki_p.langlinks LEFT JOIN dsbwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'kabwiki' as source, page_id, page_title, ll_lang, ll_title FROM kabwiki_p.langlinks LEFT JOIN kabwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'mwlwiki' as source, page_id, page_title, ll_lang, ll_title FROM mwlwiki_p.langlinks LEFT JOIN mwlwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT 'snwiki' as source, page_id, page_title, ll_lang, ll_title FROM snwiki_p.langlinks LEFT JOIN snwiki_p.page
	ON page_id = ll_from 
	WHERE ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 ll_lang = "tokipona" OR ll_lang = "yue" OR ll_lang = "zh-cn" OR ll_lang = "zh-tw")
	UNION ALL
(SELECT '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 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...
