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_namespace = 0
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$";

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