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
Jarekt
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT page_title, rd_title FROM page LEFT JOIN redirect ON rd_from = page_id WHERE page_namespace = 0 AND page_title IN ( "Q29864259", "Q62113967", "Q62113983", "Q18687918", "Q59095019", "Q21614455", "Q30094050", "Q61744446", "Q19820344", "Q18683102", "Q27010608", "Q27011369", "Q20268343", "Q58029882", "Q192673", "Q21152204", "Q3335976", "Q19681688", "Q20004137", "Q20538386", "Q50076353", "Q19826803", "Q3289878", "Q27951282", "Q76290647", "Q3889261", "Q66023553", "Q16620779", "Q9672205", "Q28070951", "Q60761862", "Q60749349", "Q60474750", "Q60054833", "Q47035544", "Q3907536", "Q28678950", "Q27924999", "Q21712108", "Q26828714", "Q27039232", "Q17036232", "Q27011802", "Q27981829", "Q20185645", "Q1163504", "Q66254516", "Q19883077", "Q28798275", "Q19825938", "Q16583336", "Q16620523", "Q6057325", "Q61679236", "Q21618968", "Q21618967", "Q47686466", "Q51580826", "Q20191862", "Q44090240", "Q44089316", "Q44042305", "Q44089175", "Q26250180", "Q734834", "Q734834", "Q3618182", "Q20202607", "Q20093134", "Q18572961", "Q24707644", "Q21741429", "Q28728595", "Q27012621", "Q58427154", "Q27982205", "Q19943601", "Q44564378", "Q18685981", "Q20751784", "Q65519367", "Q59513873", "Q47012471", "Q60477359", "Q4193277", "Q17343045", "Q21000727", "Q5996597", "Q21601138", "Q21617147", "Q27011909", "Q58213106", "Q23933276", "Q3071934", "Q41515823", "Q18177355", "Q23936118", "Q17791693", "Q398973", "Q28094889", "Q28809121", "Q21615079", "Q60779042", "Q18586874", "Q18580521", "Q16168303", "Q5932556", "Q3937771", "Q65097377", "Q18638499", "Q29654906", "Q21715176", "Q65097916", "Q3842577", "Q27698538", "Q20188714", "Q2620732", "Q20173218", "Q28810811", "Q20020196", "Q25853080", "Q3815496", "Q26708287", "Q591762", "Q591762", "Q591762", "Q9391480", "Q21614466", "Q27121502", "Q16038743", "Q3999120", "Q3999120", "Q4062968", "Q28798023", "Q20275886", "Q20173238", "Q1140358", "Q28060195", "Q62415248", "Q18609334", "Q30097812", "Q66310124", "Q67959115", "Q23936253", "Q66310307", "Q11946947", "Q55171752", "Q2653851", "Q62605026", "Q27011675" "Q27011693", "Q19008597", "Q27012819", "Q27012685", "Q27012957", "Q27012764", "Q66385031", "Q47707095", "Q20812815", "Q17275710", "Q930477", "Q24064167", "Q1778000", "Q65457776", "Q19820269", "Q18643531", "Q6116827", "Q18573062", "Q20184222", "Q21614531", "Q20355317", "Q19911699", "Q49392725", "Q21161958", "Q2664039", "Q18599021", "Q20175135", "Q47289399", "Q20441658", "Q20178259", "Q39363023", "Q956541", "Q47303379", "Q28042922", "Q17519479", "Q23948893", "Q27989634", "Q17324378", "Q19883586", "Q20862064", "Q20176807", "Q27981484", "Q18688145", "Q64667560", "Q20188404", "Q20188412", "Q20186159", "Q20186059", "Q6583495", "Q17346914", "Q57776927", "Q16976941", )
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...
