Untitled query #82334

This query is marked as a draft This query has been published by A smart kitten.

featuring a stupidly long piece of regex

SQL

select *
from categorylinks
inner join page
on page_id = cl_from
where cl_to = "Redirects_connected_to_a_Wikidata_item"
and page_title regexp "Floccinaucinihilipilification|Normoxic|Conducted_interference|Local_battery|Faux_pas|Percy_Weasley|IMNSHO|Freeloading|Non-event|Triwizard_Tournament|Crank_(person)|Plaintiff_in_error|Epeen|IINM|Plutography|List_of_irregular_English_adjectives|Camberwell_Carrot|Interlacustrine|Flitterjigs|CMIIW|-ous|Dicksucker|Primage|Aolbonics|Dowdified|Claustrophilia|Iouea|Throwed|Runner-up|Sneck_posset|Acierage|-izzle|Wuzzup|NIFOC|Simplistic|OTOH|BBIAB|Coeval|AOLbonics|Soraismus|P-P|Wussup?|Wusup|Wasup|Watzup|Wutzup|What's_up_(phrase)|Wussup_(phrase)|Wuzzup_(phrase)|Inedible|Parlance|Codswallop|Sacrilicious|GBTW|Hoo-hah|The_middle_of_nowhere_(phrase)|Flippant|Clowder|Esquilax|Subfund|Gluggy|Party_pooper|Charlie_foxtrot|Cager|Brachyology|Sesquiennial|Livraison|Katzetnik|Kah-Tzets|IBTL|Oxbird|Consecutive|Tomfool|Lylab|Habile|Hitchment|Fairweather_friend|Profound|Pretentious|Oldster|Skeevy|Perforator|Lowly|Lylas|Ginormous|Obstreperous|Ambisexuality|Floristics|Miffed|MOTOS|Cleverness|Blatte|Knee-deep|OMGWTF|Outwith|BTDTGTTS|Glottometrics|Squid_(motorcycle)|Humungous|Inhospitable|Horse_hockey|Tawdry|Hack_job|Valvulitis|Subjacent|Buck_naked|Quaquaversal|Propheteering|Drink_run|Trollop|Perishing|Ancony|Userpass|Millie_(pejorative)|Pipe_down|Verruciform|Saunter|Archite|Integrous|Flagitious|Dollop|AFAIU|AIUI|ALOL|BTDT|Cluebie|CTTOI|CWOT|DKDC|FTFY|ITYM|IYDMMA|IYKWIM|IDTS|JFTR|KTHNX|LYLAB|LYSM|NFBSK|New_York_reload|Low_maintenance|IITYWYBAD|Cool_beans|Anteflexion|Nobble|ATFQ|Wazzock|Roll_rate|Well-mannered|Offload|Faying|Meticulous|Cattle_beast|Electuary|Botch_(engineering)|Locus_classicus|Use_one's_loaf|Polyglutamation|Several|Avocat|Drop_off|Jelly_roll_(slang)|Nimrod_(slang)|Wicket_(retail)|Au_fait|Hinky|Transplacental|Bad_egg|Ttbomk|Canoodling|Wats_up|Hygienically|Advisee|Endobiotic|Internecion|Buxom|Panelist|Dilettanti|Defective_on_arrival|Extoll|Biotransference|Stramash|Nebbish|Lambent|Multimediocrity|Greenhorn_(slang)|Smarmy|Gadgie|Specious|Moon_language|DIAF|ROFLOL|Micromorphological|Texas_heart_shot|Tortuous|Shipshape|Christian_figures_of_speech|List_of_aviation,_aerospace_and_aeronautical_terms|Osteoconduction|Osteoinduction|Tight_loop|Grasping_at_straws|Dojocho|Nympholept|Pony_(slang)|Tyvm|TYVM|Pliable|AFAICR|Defervescence|Folie_du_pourquoi|Defanging|T,FTFY|FU_(internet_slang)|Albeit|TTYS|Flaunching|Ancillary|Incorrect|Blumpkin|Eschew|Urbanologist|Snarly|UTFSE|List_of_SMS_abbreviations|TBQH|Tbqh|Bog_standard|Glossary_of_trauma_terms|For_the_win_(Internet_slang)|For_The_Win_(WoW)|Forlorn|Nincompoop|Man_of_parts|Your_mileage_may_vary|Yak_shaving|Wuffo|Abandonee|Pompous|Outer|Sizzling|Mailpack|Harried|Shambolic|Consternation|Subpar|Tldnr|Fulsome|Wheeler-dealer|Zomfg|Overdramatic|Telesthesia|Aback|Loath|Valetudinarian|Tzetnik|Bum_rushing|Excerpt|Snick_or_snee|Panatheism|Logophilia|List_of_chat_speak|Knouleche|Simple_minded|Wastage|Ebullient|ZOMG|Blamestorm|Sardoodledom|Insipid|Miscellaneous|Chilver|Glossary_of_Jewish_terms|Homomeric|Abat-vent|Aegicrane|Affetti|After-cast|Aguilla|Ajaraca|List_of_Canadian_Forces_terms_and_expressions|Mind_you|Wuddup|Zealousness|Distensibility|Clean-cut|Qualm|Enturbulation|2-4-6_block|Board_finger|Emersion|Pillock|Pomosexuality|Locating_engineer|Testy|Fraught|Crap_(word)|Predictand|Sis_boom_bah|Job's_comforter|Exhilaration|Parlous|Museophile|Donorcycle|Fatling|Apellous|Zumology|That's_the_way_the_cookie_crumbles|Moonrunes|Taking_the_matter_into_your_own_hands|Invidiousness|Manteaux|Zero_air|Nonplus|Aequalis|Ecesis|Deflavorizing_machine|Weir_Word|Tracy_Strauss|Sordidly|Sordidness|Resourcefulness|Triannual|Glossary_of_legal_terms_in_technology|Tendentious|Habitué|Zorz|Institutional_framework|Nitpicky|Hypodigm|High_probability_trade|Major_diameter|Clearance_hole|Lusciousness|Resistance_distance_(mechanics)|Bimestrial|Calved|Exclude|Hoochie|Scrump|Dignitary|Woollyback|Bathophobia|So-called|Tergiversate|Veg*n|Tergiversation|Holocyclic|Oh_dear|Hometowned|Brace_(grouping)|Allocrine|Detergency|Lateral_area|Jonesing|Comprise|Reworkability|Obijime|Skip_hoist|Skip_car|Key_to_the_midway|Gnawing|Minor_diameter|Nooner|White_zone|Yeasting|Accomplishment|Agog|Acarpous|Russian_Third_League|Lygophilia|Furthermore|Un_(prefix)|Omigod|Greenfinger|Microsclerodermin|CC_RAM|The_grass_is_always_greener_on_the_other_side|Interdictum|-scope|Miso-|Curvy|Ulterior|Phenone|Adiadokokinesis|-gram|Four_door_house|Omnitheism|Osseoaponeurotic|Jackleg|Moo_U|Implausibility|Pay_through_the_nose|RAF_Wick|Erotosexual|Juventini|Skin_forming_alloy|-mer|Smert|Also-ran|Cacosyntheton|Nyctohylophobia|Coastal_squeeze|Pateras|Hétéroclite|Heteroclite|Heteroclisis|Oma_(suffix)|Testee|Surmise|Bumbaclot|Jamoke|Disputatious|Erotolalia|Policy_wonk|Compatriot|Smidge|Bunk_(slang)|Polyword|Poxy|Barspin|Self-explanatory|Cystolithotripsy|Deer_in_the_headlights|Humorless|Take_a_picture,_it_will_last_longer|Shortcut_(word)|Disanalogy|Declivity|MAFIAA|Ham_it_up|Maneuverability|Show_the_flag|ULRR|Pimp_slap|Something_is_rotten_in_the_state_of_Denmark|Feel-good_factor|Umbrage|Out_of_character|Fire_in_anger|Fired_a_shot_in_anger|Casino_junket|Galeanthropy|Floozie|Quotidian|Intra_legem|Proprietress|Prehard|Canoodle|Winningest|Cajolement|Cajole|Occasional_table|Occasional_Table|Industrial_strength|Poster-boy|Pint_pot|Sneak_thief|Back_marker|Backwoodsmen|Ballyhooed|Ballyhooing|Eye_bath|OWTTE|Multi-hyphenate|Chinless_wonder|Pithiness|Pithy|Peg_(fishing)|Berkeley_Daily_Gazette|Geili|Plodder|Yowl|Wherewithal|Plumpness|Prattle|Prattler|Renounce|Retrogression|Short_shrift|Sesquipedalian|Sob_story|Hogwaller|Wurtzilite|Recessionista|See_the_forest_for_the_trees|Purview|Reassurance|Scapegrace|Scratch_pad|Retrogreen|Spitting_distance|Traipse|Vituperation|Waiting_game|Wage_earner|Iunno|HTH,_HAND|Glibness|Hebetude|Inductee|Kickshaw|Lady_bountiful|Lucubration|Milksop|Mixed_bag|Mudpack|Nerve_center|Obloquy|Off_chance|Fuddle|Frippery|Foretoken|Foretaste|Foreboding|Foofaraw|Hatchet_job|Folderol|Flyspeck|Feculence|Highfalutin|Fanfaronade|False_step|Falderal|Eyeful|Exuberance|Exquisite|Expediency|Exiguity|Evulsion|Entrant|Entirety|Elbowroom|Elegist|Edification|Burrstone|Aliunde|Duologue|Driblet|Down-and-out|Dotard|Dotage|Dope_fiend|Doings|Gardyloo|Gild_the_lily|Saucy|Criminy|Two-timing|Quarreling|Can_of_whoop_ass|Plyg|Condimental|Abditory|Pullulant|Pabulation|Superfluity|Gangling|Improvvisatore|Resourceful|Trousse|Descuidos|Descuido|Oliver_Wood_(Harry_Potter)|Plestor|Japanese_r|Get_the_hell_out_of_Dodge|Publicise|Astreated|Calendar_day|Altercation|Over_(word)|Global_weirding|Putz-head|Putzhead|Putz_head|Putz-Head|Grasp_at_straws|Pokiest|Crapulence|Femerell|Suprapersonal|Hypobole|Pococurante|Beurk|Scraggy_(word)|Hydranth|Trustafarian|Placate|Lackadaisical|Shemozzle|Personalised|Dastard|Word_hoard|Grand_total|Chirm|Foul_up|Biliment|Estuation|Amazement|Antipole|Balladmonger|Carfare|Congeries|Escape_hatch|Acrospire|Actions_speak_louder_than_words|Ablatitious|Could_not_care_less|Vamos_(Spanish_word)|Connects|Floordrobe|Acrocephalic|Eat_one's_heart_out|Up_the_ante|Conversationism|Beauteous|Telescience|Endectocide|Uppity|Asteismus|Able-bodied|Melocoton|Waggery|Weak_sister|Whiffet|Wench|Lollygag|Rear_admiral_(lower_half)|Fanwank|Percussive_maintenance|Equivalents_of_duke_in_other_European_languages|Multifarious|List_of_phrasal_verbs|Soffietta|Lyophobic|Monocule|My_country_right_or_wrong|-penia|Snickersnee|Agriology|Windbaggery|Vulpicide|Lepid|Give_a_man_a_fish_and_you_feed_him_for_a_day._Teach_a_man_to_fish_and_you_feed_him_for_a_lifetime|Vouchsafe|Stellagama_stellio|Chitchat|Infelicity|Lambaste|Street_clothes|Cankle|Obama-mania|Obama_mania|Sophister|Chuffed|Kith_and_kin|Gurge|Ptochocracy|Bandobast|Shroomer|Perhydrate|A_stone's_throw_away|Donative_(canon_law)|Jonny-come-lately|Aperçu|Sexual_majority|Hippopotomonstrosesquipedaliophobia|Cockwomble|Attentisme|Gavin_Jennings_(broadcaster)|William_Tell_pattern|Siphosome|Nectophore|Phylogroup|Flexuous|Odontostyle|Seat_of_honor|Villalba–Segovia_railway|Cross-step|BuckleScript|Trumpster_fire|Trumpster_diving|WebGPU_Shading_Language|Covidiot|Sisterhood_(feminism)|French_Air_Force|Hectarage|⋺|⋵|Consanguinamory|Neurogender|Template_Studio|Roohallah_Jomei|Mendel_Medal_(Villanova_University)|Glycoscience|Calcutta_Port_Commissioners'_Railway|Better_to_light_a_candle_than_curse_the_darkness|Regression_(statistics)|Whole_Hog_Theatre|YouTube_channel_(identifier)|YouTube_video_(identifier)|YouTube_playlist_(identifier)|YouTube_user_(identifier)|YouTube_handle_(identifier)|VISUAL_Centre_for_Contemporary_Art_(Carlow)|Art_O'Leary_(political_scientist)|Blair_Smith_(cinematographer)|Brett_Pelling|Brittany_Farms|Amethyst_Lakes|Narrow_Water_bridge|Siún_Ní_Raghallaigh|IFTA_Lifetime_Achievement_Award|R309_road_(Ireland)|R306_road_(Ireland)|R307_road_(Ireland)|R308_road_(Ireland)|R380_road_(Ireland)|R381_road_(Ireland)|R723_road_(Ireland)|R757_road_(Ireland)|R770_road_(Ireland)|ReScript|Giuseppe_Sacco_Albanese|Sottoscala|Scoutisme_Congolais|K-Pop_Super_Live|Believe_Square|Dublin_Fingal_East_(Dáil_Constituency)|Dublin_Fingal_West_(Dáil_Constituency)|Kim_Hyun-sook_(politician)|Edward_Brinton_Smith|Lancaster_Guardian|Kea_Scout|The_Flag_(film)|Sinners_(tv_movie)|Small_Engine_Repair_(2006_film)|On_Home_Ground|Fergus's_Wedding|OpenGL_ES_Shading_Language|Tarrac|Madeleine_Yuna_Voyles|Ballywalter_(film)|Auchengillan_Outdoor_Centre|Blair_Atholl_International_Jamborette|Belfast_Government_School_of_Art|Brú_na_Bóinne_National_Park|Carlingford_Lough_greenway|Mindaugas_Sruogius|Dave_Gorman:_Terms_and_Conditions_Apply|Ascogonium|NewsBrands_Ireland|Joe_Kent-Walters|OPT-NC|Andrea_Eckerbom|Expansion_pack_(videogames)|Natural_language_modelling|澤民|至德|Tianmu_Campus,_University_of_Taipei|Wikipedia:Translation_of_the_week|Wikipedia:Don't_be_a_jerk|Wikipedia:Template_index/Redirect_pages|Wikipedia:Interface_editors|Template:Starbox_end|Template:Essays_on_building_Wikipedia|Template:NASTRO_comment|Template:NASTRO_comment/doc|Template:NASTRO_comment/sandbox|Template:Redirect_template/testcases|Template:Soft_redirect_with_Wikidata_item/testcases/wikidataconnected|Template:Soft_redirect_with_Wikidata_item/testcases/wikidatanotconnected|Template_talk:Soft_redirect_with_Wikidata_item|Category:Place_names|Category:Polish_priests|Category:Cleveland_Indians|Category:American_priests|Category:Mexican_priests|Category:Finnish_priests|Category:Priests_by_nationality|Category:Slovenian_priests|Category:Italian_priests|Category:Fictional_professors|Category:Human-derived_fictional_species|Category:Australian_priests|Category:Canadian_priests|Category:English_priests|Category:German_priests|Category:Irish_priests|Category:Swedish_priests|Category:Dutch_priests|Category:Colombian_priests|Category:Czech_priests|Category:Belgian_priests|Category:Bulgarian_priests|Category:Norwegian_priests|Category:Welsh_priests|Category:Hungarian_priests|Category:Years_in_Ceylon|Category:Swiss_priests|Category:Icelandic_priests|Category:Bermudian_priests|Category:Guyanese_priests|Category:Kenyan_priests|Category:Tongan_priests|Category:Palestinian_priests|Category:Sports_broadcasters_by_nationality|Category:Priests_from_Northern_Ireland|Category:Los_Angeles_Angels_of_Anaheim_announcers|Category:California_Angels_announcers|Category:Danish_priests|Category:Los_Angeles_Angels_of_Anaheim_stadiums|Category:Cleveland_Indians_postseason|Category:California_Angels_stadiums|Category:Turkish_priests|Category:Chinese_priests|Category:Anaheim_Angels_announcers|Category:14th-century_Czech_people|Category:Pubs_in_County_Dublin|Category:19th_century_in_Sri_Lanka|Category:Culture_of_Sindh|Category:Abkhaz_people|Category:Establishments_in_Ceylon_by_year|Category:Pakistani_priests|Category:Decades_in_Ceylon|Category:20th_century_in_Ceylon|Category:Centuries_in_Ceylon|Category:Disestablishments_in_Ceylon_by_year|Category:Establishments_in_Ceylon_by_decade|Category:Disestablishments_in_Ceylon_by_decade|Category:Establishments_in_Ceylon_by_century|Category:Disestablishments_in_Ceylon_by_century|Category:Years_of_the_20th_century_in_Ceylon|Category:Lebanese_priests|Category:South_African_priests|Category:Slovak_priests|Category:Russian_priests|Category:Romanian_priests|Category:2nd-millennium_disestablishments_in_Ceylon|Category:20th_century_in_the_Federation_of_Rhodesia_and_Nyasaland|Category:Years_of_the_20th_century_in_the_Federation_of_Rhodesia_and_Nyasaland|Category:Anaheim_Angels_stadiums|Category:Sports_broadcasters|Category:Albanian_priests|Category:Belarusian_priests|Category:19th_century_in_New_Mexico|Category:New_Zealand_priests|Category:Maltese_priests|Category:Fictional_schoolchildren|Category:British_priests|Category:Western_philosophy"
limit 3;

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...