SELECT CONCAT('[[',plwiki_p.page.page_title,']]') AS pl, CONCAT('[[:en:',enwiki_p.page.page_title,'|',enwiki_p.page.page_title,']]') AS en

FROM enwiki_p.page

JOIN plwiki_p.page

ON enwiki_p.page.page_title = plwiki_p.page.page_title

LEFT JOIN plwiki_p.langlinks

ON ll_from = plwiki_p.page.page_id

LEFT JOIN (SELECT * FROM plwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props

ON pp_page = plwiki_p.page.page_id

LEFT JOIN plwiki_p.templatelinks

ON tl_from = plwiki_p.page.page_id

WHERE plwiki_p.page.page_namespace = 0

AND plwiki_p.page.page_is_redirect = 0

AND enwiki_p.page.page_namespace = 0

AND enwiki_p.page.page_is_redirect = 0

AND ll_title IS NULL

AND pp_value IS NULL

AND plwiki_p.page.page_title NOT IN (

'Abel_Martínez','Ailill','Albert_Johnson','Aleksandr_Kostin','Alfonso_González','Alfred_Heinrich','Allan_Scott','Andrew_Green',

'Antigona','Arbela','Arleston','Historie','Horizontalism','Hydropolis','Ave','Ballarini','Basket','Biopreparat','Callum_Morris',

'Captain','Carl_Crawford','Charles_Barnes','Chicago_Stadium','Colin_Morris','Cyril_Cameron','Cássio_Oliveira','D35','Daniel_Zimmermann',

'Debir','Existence','Młynkowiec','Nie_zatrzymasz_mnie','Polonia_Świdnica','Styria','Stöckli','Thomas_Rowley','Thomas_Warner',

'Torbjörn_Johansson','Trevor_French','Tuya','Uath','Ulu_Wang_Jin','White_Heat','Wildflower','Wilhelm_Meyer','Workplace','Zahid_Khan',

'Bolama','Sing_Your_Song','Something_Personal','Spencer_Oliver','The_New_Tradition','Peter_Gibson','Pierre_Perret','Planchet','Promesa',

'Qana','Quién','Rachel_Thompson','Rafał_Sarnecki','Raging_Bull','Rahima','Real_Hero','Roberto_Acosta','Roger_Maxwell','Sancho_Martin',

'Savana','Seven_Lucky_Gods','The_Authority','Ulu','Wang_Jin','Þorsteinn_Þorsteinsson','Hurricane_Dean','Gerald_Meyer','David_Crabb',

'Danny_Hughes','Jeffrey_Harrison','John_Calvin','John_Thomas_Moore','Kyle_Russell','Paul_Keenan','Laurence_Jones','Luis_Sandoval',

'Dustin_Watten','Helena_Costa','Jacopo_Massari','Karolina_Goliat','Tom_Strohbach','Lauriane_Truchetet','Terence_Fisher',

'Mareike_Hindriksen','Renáta_Sándor','Rebecca_Pavan','Louise_Lamphere','Martijn_Colson','Martin_Kraus','Megan_Cyr','Melissa_Vargas',

'Michael_Wilde','Michelina_of_Pesaro','Nick_Capra','Nicolas_Rossard','Oliver_Venno','Patrick_Schmidt','ASJ_Soyaux','Muhammad_Salih',

'Mike_Clelland','Long_Mountain','Eduardo_Estrada','Esteban_Sánchez','Geira','Gerhardt','Happy_Returns','Hiraeth','Ibrahim_Ahmad',

'In_Awe','Isana','Jacob_Ross','Johnny_Guitar','Kameleon_2','Kapik','Khuru','Kinderszenen','Lal','Land_of_Gold','Les_Femmes','Lubich',

'Lunatique','Lur','Maqsood_Ahmed','Mr._DJ','Parsley','Payas','Taylor_Brown','Robert_Clarke',"Mother's_Pride", 'Guram_Mchedlidze',

'Peep_Show_(album)','Retrorocket','Werner_Lehmann','Idrissa_Traoré','I_Walked_with_a_Zombie','Brandon_Peterson','Roma_(album)','Scampolo',

'Spasm','Sirota','Shamsher_Singh','Warta Zawiercie','A_Vision_of_Judgment','Adam_Baruch','Adam_Russo','Aksel_Andersen','Alain_Berger',

'Alberich','Aleksandar_Nedeljković','Aleksandar_Rakić','Alex_Welsh','Alfred_Klein','Aloke_Dasgupta','Andries_Schutte','Anmol','B-67',

'Babanka','Blanca_Rodríguez','Bong','Carlos_Thomas','Carry_Fire','Chilca','DS_3','DS_4','DS_5','Deepak_Punia','Dona_Branca',

'Edmund_Lewandowski','El_Poblenou','Electrocution','Elole','Elżbieta_Branicka','Emil_Werner','Eric_Hilton','Erik_Olsson',

'Estefanía_Ramírez','Eva_González','Forsaking_All_Others','Guillermo_Coppola','Gurmeet_Kaur','Hataki','Heinz_Schmidt','Hewish',

'Hore','How_I_Could_Just_Kill_a_Man','István_Lévai','James_Washington','John_Short','Jordan_Jones','Justin_Holland','Kambo','Karl_Blau',

'Kehar_Singh','Kim_Seung-jun','Konrad_Baumgarten','Krishan_Kumar','Krzanowski','Lysianassa','Magneto','Manisha','Minuca','MyPhone',

'Nemanja_Pavlović','Nicholas_Lane','Omar_Arellano','Paolo_Volponi','Paweł_Urban','Philip_Roberts','Platoon','Pretest','Prudy',

'Puccinia_coronata','Rajneesh','Rapaport','Rhombus','Richard_Mohr','Robach','Sacrum','Sarah_Connolly','Skarstein','Stuart_White','Stupnik',

'Sumit_Kumar','Tarif','Tim_Müller','Tony_Bull','Trapezoid','Veronica_Carlson','Warta_Zawiercie','Hip_Hop_TV','Hore'

)

AND NOT EXISTS

(SELECT * FROM plwiki_p.page_props AS disambig1

WHERE disambig1.pp_propname LIKE 'disambiguation'

AND disambig1.pp_page = plwiki_p.page.page_id)

AND NOT EXISTS

(SELECT * FROM enwiki_p.page_props AS disambig2

WHERE disambig2.pp_propname LIKE 'disambiguation'

AND disambig2.pp_page = enwiki_p.page.page_id)

GROUP BY enwiki_p.page.page_title, plwiki_p.page.page_title;