Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
The Polish
.
Toggle Highlighting
SQL
SELECT CONCAT('[[',plwiki_p.page.page_title,']]') AS pl#, CONCAT('[[:es:',eswiki_p.page.page_title,'|',eswiki_p.page.page_title,']]') AS es FROM eswiki_p.page JOIN plwiki_p.page ON eswiki_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 eswiki_p.page.page_namespace = 0 AND eswiki_p.page.page_is_redirect = 0 AND ll_title IS NULL AND pp_value IS NULL AND plwiki_p.page.page_title NOT IN ( 'Payas','Taylor_Brown','Alberich','Antea','Ayam','Blanca_Rodríguez','Bong','Bursaki','Chicago_Stadium','Children','Cue_sheet', 'Emil_Werner','Estefanía_Ramírez','Eva_González','Fort_Ransom','Freefall','Grandeza_mexicana','Graves','Guillermo_Coppola', 'Happy_Returns','Heretique','Hermann_Fischer','Historie','How_I_Could_Just_Kill_a_Man','Humanity','Hydropolis', 'Héctor_Rodríguez','I_Walked_with_a_Zombie','Irene_García','Isle_of_Palms','Iso_Rivolta','It%s_You','John_Bird','John_Carr', 'John_Pedersen','Jonathan_Phillips','Kent_Andersson','Leeds_Carnegie','Long_Way_Home','Milburga','Mr._DJ','Namorik', 'Off_the_Hook','Paolo_Volponi','Paweł_Urban','Piggybacking','Platoon','Promesa','Qana','Rabia_Lamalsa','Rafael_Mota', 'Rediscovered','Ricardo_Gil','Sakra','Sarah_Connolly','Shaheen','Stupnik','Take_It_Like_a_Man','Thomas_Davis','Top_Kids', 'Tybee_Island','Video_marketing','What%s_It_All_About','Wotje' ) 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 eswiki_p.page_props AS disambig2 WHERE disambig2.pp_propname LIKE 'disambiguation' AND disambig2.pp_page = eswiki_p.page.page_id) GROUP BY eswiki_p.page.page_title, plwiki_p.page.page_title;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...