wikidata: redirects to pre-defined list of items

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

USE wikidatawiki_p;

SELECT rd_title FROM redirect JOIN page ON redirect.rd_page=page.page_id WHERE page_title IN ('Q30112525','Q30102806','Q29550474','Q28924606','Q25932265','Q25973060','Q26958013','Q26962475','Q26216299','Q26216133','Q26209045','Q26197334','Q26186406','Q26185075','Q26111323','Q26085005','Q26085004','Q26085006','Q26085001','Q26085003','Q26085002','Q26073236','Q26064960','Q26036654','Q28934789','Q28017461','Q28503417','Q28091444','Q28478622','Q28493588','Q28495794','Q28495792','Q28495796','Q28495797','Q28501320','Q28503637','Q28503662','Q28517679','Q28669975','Q28702951','Q28723704','Q28740120','Q28746182','Q28746329','Q28833151','Q28842996','Q28846017','Q28846510','Q28846539','Q28878259','Q28924108','Q28956354','Q28925804','Q28949367','Q28949628','Q30108502','Q29982546','Q30107501','Q30107462','Q30104308','Q24902333','Q24896975','Q24893108','Q24883552','Q23827039','Q23770612','Q23769277','Q23769275','Q23826640','Q23826647','Q23826644','Q23826645','Q23826650','Q23826648','Q23826649','Q23826654','Q23826659','Q23826662','Q23826755','Q24048415','Q23827041','Q23826636','Q23826632','Q23826631','Q23826619','Q23683319','Q28736877','Q28736554','Q28858973','Q28840515','Q29248245','Q29470860','Q29467441','Q29535183','Q29885076','Q29898797','Q28160128','Q29566858','Q29561396','Q30102632','Q30100104','Q29469141','Q30106716','Q28924401','Q28875150','Q28950278','Q29022250','Q29042775','Q29045015','Q28092498','Q28058175','Q28054858','Q27987140','Q27963819','Q26156670','Q26156671','Q26156676','Q26156680','Q26197210','Q26206326','Q26156678','Q26156673','Q26156672','Q26156675','Q26156674','Q26156669','Q26245174','Q27047329','Q27047498','Q26939146','Q26935572','Q26939067','Q26834326','Q26770686','Q26464659','Q26459464','Q28449578','Q28449042','Q27959719','Q30106150','Q30106271','Q30102960','Q30084349','Q28226379','Q27067835','Q27067836','Q25252378','Q25252379','Q25252380','Q22669701','Q26278247','Q25374302','Q24839161','Q24850954','Q24859240','Q24860115','Q24865175','Q25485164','Q25402381','Q25402752','Q25404026','Q25406570','Q25409504','Q25409524','Q25409963','Q25410798','Q25413851','Q25433073','Q25434338','Q25437590','Q25442238','Q25513740','Q25514401','Q25542811','Q25544045','Q25545421','Q30105804','Q30105801','Q30105706','Q30105453','Q30105446','Q30105080','Q25401633','Q23661991','Q23661993','Q23758175','Q23806540','Q23809839','Q23831097','Q23831250','Q23831249','Q23894005','Q23900978','Q23905672','Q23908652','Q23920169','Q23924554','Q23924617','Q23924625','Q23924634','Q23924633','Q23925008','Q28003968','Q29577528','Q21083866','Q21260490','Q21601118','Q21597601','Q21597598','Q21696596','Q21704548','Q21973908','Q20020696','Q20067883','Q20095653','Q20098758','Q20111985','Q20111973','Q20180337','Q20413375','Q20465100','Q20474842','Q20516883','Q20544936','Q20573793','Q20577670','Q20579155','Q20604410','Q20605049','Q20613041','Q20627094','Q22125804','Q20651812','Q20652394','Q20727391','Q20757796','Q20965587','Q20904971','Q20895157','Q20866522','Q20856227','Q20827483','Q20827338','Q20827215','Q20827082','Q20826884','Q20820213','Q12216790','Q12776759','Q12056470','Q12119888','Q12180978','Q12184516','Q12185681','Q12187225','Q12192065','Q12193600','Q12320253','Q12942823','Q12452631','Q30076273','Q30045300','Q30045298','Q18002442','Q18052656','Q18451755','Q18451924','Q18526137','Q18526136','Q18815610','Q18829158','Q18833498','Q18834848','Q18840887','Q18874336','Q18878412','Q18878708','Q18907714','Q18916268','Q19216806','Q19215329','Q19278984','Q19890806','Q19650161','Q19655203','Q19683879','Q12111575','Q4227981','Q11630939','Q17059647','Q17484616','Q17779104','Q17944436','Q17997033','Q17997288','Q17997588','Q17998862','Q12870842','Q16378353','Q13052878','Q16380849','Q16415328','Q16415336','Q16415540','Q1881972','Q13727986','Q13383762','Q13198511','Q13186244','Q25678917','Q25677670','Q25641941','Q25639783','Q25639780','Q25639779','Q25639778','Q25639777','Q25639776','Q25639775','Q25639774','Q25639773','Q25639772','Q25639770','Q25639768','Q25639626','Q25639624','Q25639623','Q25639622','Q25639621','Q25639620','Q25639619','Q28125536','Q26156681','Q26156682','Q29992330','Q30092339','Q30091487','Q30091898','Q30092768','Q30092793','Q30093074','Q30093266','Q30093269','Q16376970','Q16364031','Q13037711','Q16351122','Q13057812','Q16345398','Q12873557','Q16330735','Q12884357','Q16328255','Q13002059','Q16317098','Q16314362','Q16163376','Q27972268','Q13161242','Q15722430','Q12992918','Q15691947','Q14203940','Q28771876','Q28681715','Q27862667','Q27430471','Q16163930','Q12983621','Q16311826','Q13010762','Q16316016','Q16415578','Q12835360','Q16415698','Q16419950','Q16480468','Q12776864','Q16517629','Q28443717','Q30091738','Q19760261','Q30091323','Q26678708','Q26678709','Q26678712','Q26689918','Q26861352','Q27237636','Q27324254','Q27334770','Q27334771','Q27341826','Q27342868','Q27331491','Q27338921','Q27468515','Q27500669','Q27506491','Q27506535','Q27506542','Q27511045','Q27517583','Q27534967','Q28221997','Q28322117','Q28920915','Q28922290','Q28957697','Q28966265','Q28973742','Q28976490','Q29001929','Q29001930','Q30088276','Q26172822','Q22678691','Q22168535','Q22342987','Q22661626','Q22662491','Q21979426','Q22662815','Q22973207','Q24436366','Q24439167','Q24546088','Q24574721','Q24576389','Q24698237','Q24708227','Q24708288','Q24727835','Q24799824','Q24799976','Q24894126','Q24892849','Q24890894','Q24890684','Q24887703','Q24887496','Q24886896','Q24884693','Q24884302','Q24883517','Q24883283','Q24883029','Q24882652','Q24877473','Q24877447','Q24877353','Q24877309','Q24877307','Q24867728','Q24866071','Q24866036','Q24865590','Q24864756','Q24864745','Q24864723','Q24863124','Q24860364','Q24860356','Q24860354','Q24860285','Q24860186','Q24859609','Q24832945','Q24832930','Q24832870','Q24816011','Q24815929','Q24895304','Q24895381','Q24895502','Q24895816','Q24895841','Q24895860','Q24895888','Q24896014','Q24902297','Q24885799','Q24885891','Q24886234','Q24896131','Q24900806','Q24900893','Q24901471','Q24902022','Q24902035','Q24902095','Q12622545','Q12827779','Q12834946','Q10563509','Q11963209','Q11975238','Q11997700','Q20176989','Q18359780','Q9174563','Q5165524','Q10363001','Q6109097','Q432640','Q30089358','Q24895734','Q30089296','Q30089063','Q30088292','Q30088275','Q30088271','Q30087452','Q13167145','Q13165139','Q13158458','Q13100555','Q13090981','Q13090978','Q13090275','Q13090135','Q13085263','Q13085183','Q13085171','Q13085112','Q13081998','Q13081989','Q13081392','Q13081205','Q13055183','Q13052130','Q13028560','Q13025778','Q13016042','Q14088889','Q14653781','Q12851502','Q12905375','Q19738254','Q19754473','Q19754466','Q19754461','Q19754447','Q19754444','Q19754432','Q19754428','Q19840332','Q19863069','Q19900777','Q19928839','Q19955910','Q19969045','Q12409171','Q12320639','Q12318597','Q12308607','Q12229626','Q12234941','Q12244477','Q12255550','Q7480752','Q3708658','Q3708630','Q3563977','Q10419706','Q10461246','Q12664966','Q9921147','Q24000110','Q24089337','Q24174847','Q24175460','Q24190095','Q17074136','Q16688660','Q16662744','Q16701229','Q16711711','Q18359668','Q16946934','Q12985405','Q16311613','Q12982761','Q16309864','Q16300855','Q16184193','Q16167003','Q12604486','Q16161202','Q13020045','Q16138311','Q12751723','Q16087208','Q12747352','Q16083178','Q16070362','Q19356980','Q19392393','Q19393679','Q19718745','Q19719971','Q19729712','Q19739749','Q19848966','Q19858840','Q19858794','Q5564722','Q25224993','Q25319872','Q24987588','Q25149606');
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...
