Query test 10 - Quarry

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

SELECT DISTINCT CONCAT('#[[', REPLACE(page_title,'_',' '), ']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title NOT IN ('Aaron_Brown','Aaron_Wolf','Abbey_Murphy','Abbey_Weitzeil','Abby_Roque','Abdi_Nageeye','Abdulrashid_Sadulayev','Abe_Wiersma','Abigail_Strate','Abner','Adam_Peaty','Ádám_Varga','Adelina_Zagidullina','Adeline_Gray','Adrián_Holešinský','Adriana_Cerezo','Adriana_Leon','Adrienne_Lyle','Agnes_Knochenhauer','Agnieszka_Kobus-Zawojska','Agnieszka_Skrzypulec','Agnis_Čavars','Agos_Alonso','Agustina_Albertario','Agustina_Gorzelany','Ahmed_El-Gendy','Ahmed_Hafnaoui','A''ja_Wilson','Akbar_Djuraev','Akira_Sone','Akito_Watabe','Akzhol_Makhmudov','Albert_Batyrgaziyev','Alberto_Fernández','Alberto_Ginés','Aldo_Montano','Aleia_Hobbs','Aleksander_Aamodt_Kilde','Aleksandr_Bolshunov','Aleksandr_Gallyamov','Aleksandr_Krasnykh','Aleksandr_Loginov','Aleksandr_Nikishin','Aleksandr_Samonov','Aleksandr_Terentyev','Aleksandr_Yelesin','Aleksandr_Zuyev','Aleksandra_Patskevich','Aleksandra_Trusova','Aleksey_Chervotkin','Alena_Saili','Alessandra_Perilli','Alessandro_Hämmerle','Alessandro_Miressi','Alex_Carpenter','Alex_Ferreira','Alex_Fiva','Alex_Hall','Alex_Hill','Alex_Rigsby-Cavallini','Alex_Schmid','Alex_Walsh','Alex_Yee','Alexa_Scimeca_Knierim','Alexander_Hendrickx','Alexander_Ogando','Alexander_Purnell','Alexander_Schüller','Alexander_Zverev','Alexandra_Burghardt','Alexandra_Lacrabère','Alexandre_Iddir','Alexandria_Loutitt','Alexandros_Papanastasiou','Ali_Aguilar','Ali_Davoudi','Aline_Rotter-Focken','Alisa_Tishchenko','Alix_Klineman','Alla_Shishkina','Allisha_Gray','Allison_Pineau','Allison_Schmitt','Ally_Carda','Allysha_Chapman','Allyson_Felix','Almida_de_Val','Álvaro_Fernández','Alys_Williams','Amalie_Dideriksen','Amanaki_Nicole','Amanda_Chidester','Amanda_Ilestedt','Amanda_Kessel','Amanda_Longan','Amandine_Buchard','Amandine_Leynaud','Amber_English','Aminiasi_Tuimaba','Amos_Mosaner','An_San','Ana_Beatriz_Correa','Ana_Carolina_da_Silva','Ana_Cristina_Souza','Ana_Marcela_Cunha','Ana_Maria_Brânză-Popescu','Anabel_Medina','Anaïs_Chevalier-Bouchet','Anastasija_Zolotic','Anastasiya_Bliznyuk','Anastasiya_Chetverikova','Anastasiya_Galashina','Anastasiya_Ilyankova','Anastasiya_Logunova','Anastasiya_Maksimova','Anastasiya_Mishina','Anastasiya_Pavlyuchenkova','Anastasiya_Smirnova','Anastasiya_Tatareva','Anders_Mol','Andre_De_Grasse','Andrea_Cassinelli','Andrea_Drews','Andrea_Proske','Andrew_Albicy','Andrew_Capobianco','Andrew_Charter','Andrew_Hoy','Andrew_Knewstubb','Andrew_Wilson','Andrey_Chibisov','Andrey_Rublyov','Andrija_Prlainović','Andy_Cruz','Angelina_Golikova','Angelina_Melnikova','Angelina_Shkatova','Angelos_Vlachopoulos','Angus_Groom','Anita_Blaze','Anita_Włodarczyk','Anna_Anvegård','Anna_Berreiter','Anna_Burnet','Anna_Espar','Anna_Gasser','Anna_Hasselborg','Anna_Hopkin','Anna_Kárász','Anna_Kiełbasińska','Anna_Kiesenhofer','Anna_Prakaten','Anna_Puławska','Anna_Sedoykina','Anna_Sen','Anna_Shcherbakova','Anna_Vyakhireva','Annabelle_McIntyre','Anne-Cécile_Ciofani','Anne-Marie_Rindom','Annemiek_van_Vleuten','Anni_Keisala','Ann-Renée_Desbiens','Anouk_Vetter','Anthony_Carter','Anthony_Gose','Anthony_Zambrano','Antoaneta_Boneva-Kostadinova','Antoine_Brizard','Antoine_Kina','Antoinette_de_Jong','Anton_Borodachov','Anton_Dahlberg','Anton_Slepyshev','Anton_Smolski','Antonella_Palmisano','Antonina_Skorobogatchenko','Antony','Anzhelika_Sidorova','Anzhelika_Terliuha','April_Ross','Apriyani_Rahayu','Aran_Zalewski','Aria_Fischer','Arianna_Fontana','Arianna_Valcepina','Ariarne_Titmus','Ariel_Atkins','Arlen_López','Arno_Kamminga','Áron_Szilágyi','Arseny_Gritsyuk','Artem_Dolgopyat','Arthur_De_Sloover','Arthur_Van_Doren','Artur_Aleksanyan','Artur_Dalaloyan','Artur_Kayumov','Artyom_Chernousov','Artyom_Minulin','Artyom_Volvich','Asaeli_Tuivuaka','Ashleigh_Johnson','Ashley_Caldwell','Ashley_Lawrence','Ashton_Bell','Aslan_Karatsev','Astrid_Guyart','Athing_Mu','Atte_Ohtamaa','Aubree_Munro','Augustin_Meurmans','Avalon_Wasteneys','Axel_Clerget','Axel_Jungk','Ayano_Sato','Aysuluu_Tynybekova','Ayumu_Hirano','Azizul_Awang','Bakhodir_Dzhalolov','Bálint_Kopasz','Bam_Adebayo','Bao_Shanju','Barbora_Krejčíková','Bart_Swings','Barthélémy_Chinenyeze','Bea_Ortiz','Beat_Feuz','Béatrice_Edwige','Beatriz_Ferreira','Belén_Succi','Belinda_Bencic','Bella_Sims','Ben_Coakwell','Ben_Maher','Ben_Whittaker','Benjamin_Karl','Benjamin_Savšek','Benjamin_Toniutti','Beth_Ross','Beth_Shriever','Bianca_Buitendag','Birk_Ruud','Blair_Tuke','Blake_Govers','Blake_Pieroni','Blandine_Dancette','Blayre_Turnbull','Blessing_Oborududu','Bobby_Finke','Bobby_Lammie','Bowe_Becker','Brad_Gushue','Bradly_Sinden','Brandon_Dickson','Brandon_Frazier','Branislav_Konrád','Branislav_Mitrović','Breanna_Stewart','Brendon_Rodney','Brenno','Brett_Gallant','Briana_Williams','Brianna_Decker','Brianna_Throssell','Brianne_Jenner','Brigid_Kosgei','Brittany_Bowe','Brittney_Griner','Brittney_Reese','Bronte_Campbell','Brooke_Donoghue','Brooke_Forde','Brooks_Curry','Bruce_Mouat','Bruno_Fuchs','Bruno_Guimarães','Bryan_Gil','Bryce_Deadmon','Bubba_Starling','Bubbla_Nickles','Buse_Naz_Çakıroğlu','Busenaz_Sürmeneli','Caeleb_Dressel','Caia_van_Maasakker','Caitlin_Ryan-Regal','Caleb_Shepherd','Calum_Jarvis','Cam_Stones','Camila_Brait','Camille_Grassineau','Campbell_Stewart','Candy_Bauer','Cao_Yuan','Carissa_Moore','Carla_Neisen','Carlo_Paalam','Carlos_Arévalo','Carlos_Soler','Carol_Gattaz','Caroline_Drouin','Caroline_Harvey','Caroline_Seger','Casey_Dawson','Cassie_Sharpe','Cat_Osterman','Cate_Campbell','Caterina_Banti','Cayla_Barnes','Cécilia_Berder','Cédric_Charlier','Cene_Prevc','Cha_Min-Gyu','Charles_Hamelin','Charline_Picon','Charlotte_Lembach','Charlotte_Worthington','Chase_Kalisz','Chelsea_Gray','Chelsea_Hodges','Chen_Aisen','Chen_Lijun','Chen_Long','Chen_Meng','Chen_Qingchen','Chen_Yufei','Chen_Yunxia','Chen_Yuxi','Chiaka_Ogbogu','Chinami_Yoshida','Chizuru_Arai','Chloé_Jacquet','Chloe_Kim','Chloé_Pelle','Chloé_Trespeuch','Chloé_Valentini','Choi_In-Jeong','Choi_Min-Jeong','Chris_Nilsen','Christian_Rasp','Christian_Sørum','Christine_de_Bruin','Christine_Mboma','Christine_Roper','Christine_Sinclair','Christodoulos_Kolomvos','Christoffer_Sundgren','Christoph_Hafer','Christopher_Grotheer','Christopher_Lillis','Christopher_Weber','Ciprian_Tudosă','Claire_Bové','Claire_Curzan','Claire_Thompson','Clara_Espar','Clarisse_Agbegnenou','Claudinho','Clément_Noël','Clément_Parisse','Cléopâtre_Darleux','Colby_Stevenson','Constantin_Schmid','Coralie_Bertrand','Coralie_Lassource','Corinne_Suter','Cosmin_Pascari','Courtney_Frerichs','Cui_Xiaotong');
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...
