Untitled query #67874

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

USE dewiki_p;
SELECT CONCAT('[[', REPLACE(p.page_title, '_', ' '), ']]') as Artikel, CONCAT('[[:Kategorie:', REPLACE(cl_to, '_', ' '), ']]') AS Kategorie
FROM page AS p
INNER JOIN categorylinks ON p.page_id = cl_from
INNER JOIN page AS catpage ON catpage.page_namespace = 14
  AND catpage.page_title = cl_to
INNER JOIN page_props ON pp_page = catpage.page_id AND pp_propname = 'hiddencat'
WHERE p.page_namespace = 0
 AND p.page_title in ('Garcia_House','Life_Is_Strange_(Computerspielreihe)','Todesfall_Gabby_Petito','Victim_in_Pain','Albert_Gomes','Interactive_Fiction_Database','University_of_the_Southern_Caribbean','TADS','Pirate_Records','Paul_Volz','United_Petrotrin_FC','Peelander-Z','Federation_Park','Ash_Return','We_Are_Zombies','Tsunematsu_Matsui','Simon_the_Sorcerer_II','Crash_and_Burn','John_Valentine_Wistar_Shaw','Legionaire’s_Disease_Band','Adventure_International','Trinidad_and_Tobago_Film_Festival','Trindad_and_Tobago_Film_Festival','Geschichte_von_Port_of_Spain','Xpeng_Voyager_X2','The_Viletones','Animation_Arts','Mindshadow','Michael_Mooleedhar','Christine_Kangaloo','Where_in_the_World_is_Carmen_Sandiego?','People’s_Partnership','Point-and-Click-Adventure','Old_People','Raven’s_Hollow','Return_to_Monkey_Island','No_for_an_Answer','Ecuadorianische_Küche','Gateway_(Computerspiel)','Rikk_Agnew','Somnio','Jodie_Faster','Soonago','Eastern_Main_Road','Kapitän_Platte','International_Soca_Monarch','Pain_Teens','Ras_Shorty_I','Post_Mortem_(Computerspiel)','From_the_Gates_of_Aksum','Order_of_the_Republic_of_Trinidad_and_Tobago','Carnival_Road_March','Solasta:_Crown_of_the_Magister','Sin_Secretos_con_Doris','The_Cult_of_the_Will','Costa-ricanische_Küche','Crapoulet_Records','Warrior_Kids','Cellebrite','Caribbean’s_Next_Top_Model','Sarapiquí','Jamaat_al_Muslimeen','Daniel_Schneiker','J.U.L.I.A.:_Among_the_Stars','Gamma_Force_in_Pit_of_a_Thousand_Screams','Deepfake-Pornografie','Drachen_von_Laas','Coktel_Vision','Pisco_Punch','Karl_Kritz','Marianne_River','Sauce_chien','Pokey_Mo','Bazodee','Westafrikanische_Küche','Choose_Your_Own_Adventure','Moruga','Beyond_a_Steel_Sky','Thaumistry:_In_Charm’s_Way','Agression','Wahl_zum_Repräsentantenhaus_in_Trinidad_und_Tobago_2020','All_Fours','Mike_Verdu','Saheena','Gender_Reveal_Party','Louis_Lee_Sing','Hamburger_Hill_(Band)','June’s_Journey','Herald_(Computerspiel)','Chilenische_Küche','12:08_Jenseits_von_Bukarest','Shannara','Too_Hot_to_Handle_(Fernsehsendung)','Dalgona_Coffee','Supreme_League_of_Patriots','Green_Swizzle','House_of_Angostura','Brian_Moriarty','Angelo_Bissessarsingh','Yaybahar','Santa_Cruz_(Trinidad_und_Tobago)','Postal_4:_No_Regerts','Frederick_Street','Really_Red','Syberia_(Computerspiel)','Karborn','Dark_Encounter','Freaks_–_Sie_sehen_aus_wie_wir','Ready_or_Not_–_Auf_die_Plätze,_fertig,_tot','Choka','Royal_Castle','Simon_the_Sorcerer_3D','Big_Boys','Jonathan_(Computerspiel)','Cosmo_Park','Chiswick_Records','Die_Stadt_der_Löwen','Adi_Bakel','Rio_Claro_(Trinidad_und_Tobago)','Jalebi','Firni','Mushawa','Articles_of_Faith','Otra_Salida','Crime_Time','Chilaquiles','Dreamfall:_The_Longest_Journey','Villa_Marittima','The_Fix','Rafael_Delgado_(Gouverneur)','Her_Majesty’s_SPIFFING','My_Time_At_Portia','British_West_Indies_Regiment','Mekanik_Destrüktiw_Komandöh','Caroni_Plain','Eddoes_Talkari','Jet_Black_(Musiker)','Mandy_(2018)','Enchanted_Scepters','Isa_Müller','Agent_86','The_Happytime_Murders','Anna_und_die_Apokalypse','Broken_Teeth','Heavy_Trip','Border_(2018)','Valley_of_Shadows','Elizabeth_Harvest','The_Gospel_According_to_the_Meninblack','Shine_Rice','Face_Noir','The_Endless','Tendencia','Get_the_Shot','Calypso_Rose','Maryland_Deathfest','Oropuche_River','Chepang','Cromwell_House','Carenage','Trincity','Cards_Against_Humanity','Kolumbianische_Küche','Citizens_Arrest','Through_the_Woods','Breakers','Ralph_Woodford','Panamaische_Küche','Carrera_Island','Blotnik_Brothers','Trash_Talk','Shin_Ramyun','Lords_of_Time','Tom_Kha_Kai','Red_House_(Port_of_Spain)','Sommerrolle','Noise_the_Show','Even_Worse','Vitality_Air','Hotel_Monterey_Osaka','Memento_Mori_2','Arthur_Cipriani','Paula_Mae_Weekes','Melbourne_House','Offenders','Brian_Lara_Cricket_Academy','1893:_A_World’s_Fair_Mystery','Ellerslie_Park','Overclocked','Chain_of_Strength','Emperor_Valley_Zoo','Edward_Beetham','Benjamin_Chee_Chee','Liste_von_Textadventures','Desert_Hot_Springs_Motel','76%_Uncertain','Spider_Crew','Crash_Test_Aglaé','Solitaire_(Film)','Parang_(Musikrichtung)','Lost_Horizon_2','Breadfruit_Oil-Down','Die_Säulen_der_Erde_(Computerspiel)','Tass_Times_in_Tonetown','Questions','Central_F.C.','Trinidad_Guardian','Miozän_(Band)','Spellcasting_301','I_Am_Revenge','Churchill_Roosevelt_Highway','Lungfish','Doh_Say_Dat','Hector_William_Munro','The_Darkside','Einsamkeit_und_Sex_und_Mitleid','False_Prophets','Superblue','Paradigm','Syberia_3','Cathedral_Oceans_II','Marginal_Man_(Band)','El_Nido_Airport','Road_to_India','Caigual','Green_Days_by_the_River','Luisa_Calderon','ABC_No_Rio','Lane_Mastodon_vs._the_Blubbermen','Sprangalang','Scrunter','Under_the_Shadow','Ooze','Marco-Polo-Tower','Urban_Waste','Die_feine_Gesellschaft','Hexuma','Barataria','Zork_Nemesis','The_Meatmen','Güiria','Couva','Salma_(1985)','Normality','Antonio_Barreto','Seduction_Cinema','Erin_Brown','Vitamin_X','Tacarigua','The_Raven:_Vermächtnis_eines_Meisterdiebs','Heart_Attack_(Band)','Gérard_Besson_(Historiker)','Lighthouse_Reef','Cronstadt_Island','Black_Stalin','Antidote_(Hardcore-Band)','Mercenaire','Raving_Iran','Mosaic_Publishing','Holy_Trinity_Cathedral_(Port_of_Spain)','My_Big_Night','Die_Arche_(Roman)','United_Mutation','Adrian_Cola_Rienzi','Arouca','Arouca_(Trinidad_und_Tobago)','The_Book_of_Unwritten_Tales_2','Ashdautas','Kona_(Computerspiel)','Bacolet','Tablet_(Süßware)','Jerry’s_Kids','Cocorite','Peter_Minshall','Jean-Jacques_Burnel','Fran_Bow','Queen’s_Park_Savannah','Hatebeak','The_Raven_(Album)','Stasis_(Computerspiel)','Pig_foot_souse','Trinidad_Express','Solomon_Hochoy','Caroni_Swamp','UBH','Uriah_Butler_Highway','Spazz','Brimstone_(Computerspiel)','Petrotrin','Lancelot_(Computerspiel)','King_Art','The_Fiend','William_Fullarton','Destra_Garcia','Ceville','The_Mob_(Hardcore-Band)','El_Tucuche','Champs_Fleurs','Ortoire_River','Memento_Mori_(Computerspiel)','Void_(Band)','East-West_Corridor','San_Juan_(Trinidad_und_Tobago)','Michel-Jean_Cazabon','El_Clan','Alternative_Software','Chuck_Norris_und_der_Kommunismus','The_Undead','15_Days','Martin_Ganteföhr','Juan_Francisco_Machado','Seven_Minutes_of_Nausea','Spellcasting_201','White_Flag_(Band)','Untouchables_(Band)','Subject_13','Little_Gasparee','Laventille','Quarterstaff','New_York_Thrash','Cathedral_of_the_Immaculate_Conception_(Port_of_Spain)','Hellowoon','A7_(Club)','A_Perfect_Day_(2015)','Fyzabad','Die_Kathedrale_(Computerspiel)','Valsayn','Uriah_Butler','Keith_Rowley_(Begriffsklärung)','Keith_Rowley','Wahl_zum_Repräsentantenhaus_in_Trinidad_und_Tobago_2015','Oöphoi','The_Pleasures_of_Electricity','Return_to_Zork','Deathgasm','Andrarakh','Homesick_(Computerspiel)','D.I.','Belmont_(Port_of_Spain)','Movimiento_por_la_Autodeterminación_e_Independencia_del_Archipiélago_Canario','Siparia_(Trinidad_und_Tobago)','Lord_of_the_G-Strings','Sancoche','Long_Caye','Men_&amp;_Chicken','Sir_Solomon_Hochoy_Highway','Frauenlager_der_Ninja','Siparia_(Region)','Black_and_White_(Album)','Django_Nudo_und_die_lüsternen_Mädchen_von_Porno_Hill','St._Joseph_(Trinidad_und_Tobago)','Johnny_Moped','Adrenalin_O.D.','Caroni_River','House_of_Tales','Essex_(Computerspiel)','Silvertop','Scapeghost','Martín_de_Salaverría','Spellcasting_101','Gaspar_Grande','Morvant','Arthur:_The_Quest_for_Excalibur','Svffer','Anthony_de_Verteuil','Banutzer:Grueslayer/Vorlagen/Band','Magnificent_Seven_(Port_of_Spain)','Caroni_(1975)_Limited','The_Stimulators_(Punkband)','Conejo_en_Salmorejo','Triple_X_Records','Cathedral_Oceans','Zork:_Der_Großinquisitor','Moho_Caye','Penal-Debe','No_More_Heroes_(Album)','Pepperpot','Fuck_Art,_Let’s_Dance!','Dragonsphere','Cranberry_Production','Michael_Anthony_(Autor)','The_Abused','Rock_&amp;_Wrestling','Myth_(Computerspiel)','Mindwheel','Knight_Orc','Carling_House','Eric_the_Unready','Journey_(Computerspiel,_1989)','Machel_Montano','Life_Is_Strange','The_Journey_Down','Chaguanas','Bocas_Islands','Raymond_Barbieri','Lost_&amp;_Found_Records','Curepe','Fort_George_(Trinidad)','José_María_Chacón','Golf_von_Paria','Meridian_Brothers','Shifting_City','Pastelles','The_90’s_Suck_&amp;_So_Do_You','Geera_Pork','Princes_Town_(Region)','Rattus_Norvegicus_(Album)','Cassareep','Fish!','Lure_of_the_Temptress','Amnesia_(Computerspiel,_1986)','Ingrid’s_Back','Laughing_Bird_Caye','Shogun_(Computerspiel)','Kerwin_Du_Bois','Pearlman_Mountain_Cabin','Trinidadische_Küche','St._Augustine_(Trinidad_und_Tobago)','Lee_Ving','Monos_(Insel)','Fort_San_Andres','In_Mysterious_Ways','Wizarbox','Pelau','STP_Not_LSD','Mayaro-Rio_Claro','Rainbird_Software','Corruption_(Computerspiel)','Mirrorsoft','Auf_Wiedersehen_Monty','Gnome_Ranger','Kettel_(Musiker)','St._George’s_Caye','Zork_Zero','Arango_House','Tunapuna','Huevos','Papo_&amp;_Yo','The_Golden_Section','Yesterday_Started_Tomorrow','Kuchela','Nikopol:_Die_Rückkehr_des_Unsterblichen','Couva-Tabaquite-Talparo','Jinxter','Monty_on_the_Run','Dynamite_Dan_2','Half_Moon_Caye','Ensemble_Micrologus','Antiseen','Chacachacare','Bunji_Garlin','John_Foxx/Diskografie','Carib_Brewery','Amerzone','Dynamite_Dan','Necros','Goff’s_Caye','Chaguaramas','Chaguaramas_(Trinidad_und_Tobago)','The_Garden_(Album)','Reprobates','Sangre_Grande_(Region)','Anti-Everything','Cayo_Espanto','Beyond_Zork','Diego_Martin_(Region)','Caye_Chapel','Confronto','San_Juan-Laventille','Blackadore_Caye','Slap_A_Ham_Records','Plundered_Hearts','Paradise_(Computerspiel)','Back_from_Samoa','Alter_Ego_(Computerspiel,_2010)','Stationfall','Tunapuna-Piarco','Hollywood_Hijinx','Northern_Range','Sheats-Goldstein_Residence','Fay-Ann_Lyons','Mauby','White_Birds_Productions','Cutthroats','Aloo_Pie','Seastalker','Future_Games','Punta_Rock','Buljol','Infidel','We_Bite_Records','Suspended','Kanka_(Musiker)','Pholourie','Sinking_Island','Wishbringer','Spellbreaker','Sorcerer_(Computerspiel)','Doubles','Enchanter','Tony_James','Bake_and_Shark','Dead_Reefs','Callaloo','Asa_Wright_Nature_Centre','Norte_Cartel','Inside_My_Brain','Roti_(Imbiss)','The_Cat_Lady','Yacøpsæ','Blanchisseuse','Peter_Moore_(Autor)','Gary_Buslik'
)
order by Kategorie asc;
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...
