Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mess
.
Toggle Highlighting
SQL
SELECT page_title FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_id NOT IN (SELECT DISTINCT cl_from FROM categorylinks, pagelinks WHERE cl_to = pl_title AND pl_namespace = 14 AND pl_from = 4195411) AND page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to LIKE 'Nati\_%' OR cl_to LIKE 'Accademici\_%' OR cl_to LIKE 'Aforisti\_%' OR cl_to LIKE 'Agenti\_segreti\_%' OR cl_to LIKE 'Agronomi\_%' OR cl_to LIKE 'Alchimisti\_%' OR cl_to LIKE 'Allenatori\_%' OR cl_to LIKE 'Allevatori\_%' OR cl_to LIKE 'Alpinisti\_%' OR cl_to LIKE 'Altisti\_%' OR cl_to LIKE 'Ambasciatori\_%' OR cl_to LIKE 'Ambientalisti\_%' OR cl_to LIKE 'Ammiragli\_%' OR cl_to LIKE 'Anarchici\_%' OR cl_to LIKE 'Anatomisti\_%' OR cl_to LIKE 'Animatori\_%' OR cl_to LIKE 'Annunciatori\_televisivi\_%' OR cl_to LIKE 'Antifascisti\_%' OR cl_to LIKE 'Antiquari\_%' OR cl_to LIKE 'Antropologi\_%' OR cl_to LIKE 'Apneisti\_%' OR cl_to LIKE 'Arabisti\_%' OR cl_to LIKE 'Aracnologi\_%' OR cl_to LIKE 'Araldisti\_%' OR cl_to LIKE 'Arbitri\_%' OR cl_to LIKE 'Archeologi\_%' OR cl_to LIKE 'Architetti\_%' OR cl_to LIKE 'Archivisti\_%' OR cl_to LIKE 'Arcieri\_%' OR cl_to LIKE 'Arcivescovi\_%' OR cl_to LIKE 'Armatori\_%' OR cl_to LIKE 'Armonicisti\_%' OR cl_to LIKE 'Arpisti\_%' OR cl_to LIKE 'Arrampicatori\_%' OR cl_to LIKE 'Arrangiatori\_%' OR cl_to LIKE 'Artigiani\_%' OR cl_to LIKE 'Artisti\_%' OR cl_to LIKE 'Assassini\_%' OR cl_to LIKE 'Assiriologi\_%' OR cl_to LIKE 'Assistenti\_arbitrali\_di\_calcio\_%' OR cl_to LIKE 'Astisti\_%' OR cl_to LIKE 'Astrofisici\_%' OR cl_to LIKE 'Astrologi\_%' OR cl_to LIKE 'Astronauti\_%' OR cl_to LIKE 'Astronomi\_%' OR cl_to LIKE 'Atleti\_%' OR cl_to LIKE 'Attivisti\_%' OR cl_to LIKE 'Attori\_%' OR cl_to LIKE 'Aviatori\_%' OR cl_to LIKE 'Avventurieri\_%' OR cl_to LIKE 'Avvocati\_%' OR cl_to LIKE 'Banchieri\_%' OR cl_to LIKE 'Baritoni\_%' OR cl_to LIKE 'Base\_jumper\_%' OR cl_to LIKE 'Bassi\_%' OR cl_to LIKE 'Bassi-baritoni\_%' OR cl_to LIKE 'Bassisti\_%' OR cl_to LIKE 'Batteriologi\_%' OR cl_to LIKE 'Batteristi\_%' OR cl_to LIKE 'Beatboxer\_%' OR cl_to LIKE 'Beati\_%' OR cl_to LIKE 'Beatmaker\_%' OR cl_to LIKE 'Biatleti\_%' OR cl_to LIKE 'Bibliografi\_%' OR cl_to LIKE 'Bibliotecari\_%' OR cl_to LIKE 'Biblisti\_%' OR cl_to LIKE 'Biochimici\_%' OR cl_to LIKE 'Biofisici\_%' OR cl_to LIKE 'Biografi\_%' OR cl_to LIKE 'Biologi\_%' OR cl_to LIKE 'Blogger\_%' OR cl_to LIKE 'Bobbisti\_%' OR cl_to LIKE 'Boccisti\_%' OR cl_to LIKE 'Botanici\_%' OR cl_to LIKE 'Briganti\_%' OR cl_to LIKE 'Cabarettisti\_%' OR cl_to LIKE 'Cacciatori\_di\_taglie\_%' OR cl_to LIKE 'Calciatori\_%' OR cl_to LIKE 'Calligrafi\_%' OR cl_to LIKE 'Canoisti\_%' OR cl_to LIKE 'Canottieri\_%' OR cl_to LIKE 'Cantanti\_%' OR cl_to LIKE 'Cantanti\_lirici\_%' OR cl_to LIKE 'Cantastorie\_%' OR cl_to LIKE 'Cantautori\_%' OR cl_to LIKE 'Cantori\_%' OR cl_to LIKE 'Cardinali\_%' OR cl_to LIKE 'Cardiochirurghi\_%' OR cl_to LIKE 'Cardiologi\_%' OR cl_to LIKE 'Carpentieri\_%' OR cl_to LIKE 'Carrozzieri\_%' OR cl_to LIKE 'Cartografi\_%' OR cl_to LIKE 'Castrati\_%' OR cl_to LIKE 'Cavalieri\_%' OR cl_to LIKE 'Cembalari\_%' OR cl_to LIKE 'Centurioni\_%' OR cl_to LIKE 'Ceramisti\_%' OR cl_to LIKE 'Cestisti\_%' OR cl_to LIKE 'Character\_designer\_%' OR cl_to LIKE 'Chimici\_%' OR cl_to LIKE 'Chirurghi\_%' OR cl_to LIKE 'Chitarristi\_%' OR cl_to LIKE 'Ciclisti\_%' OR cl_to LIKE 'Ciclocrossisti\_%' OR cl_to LIKE 'Circensi\_%' OR cl_to LIKE 'Clarinettisti\_%' OR cl_to LIKE 'Clavicembalisti\_%' OR cl_to LIKE 'Climatologi\_%' OR cl_to LIKE 'Collaboratori\_di\_giustizia\_%' OR cl_to LIKE 'Collezionisti\_d\'arte\_%' OR cl_to LIKE 'Combinatisti\_nordici\_%' OR cl_to LIKE 'Comici\_%' OR cl_to LIKE 'Compositori\_%' OR cl_to LIKE 'Condottieri\_%' OR cl_to LIKE 'Conduttori\_radiofonici\_%' OR cl_to LIKE 'Conduttori\_televisivi\_%' OR cl_to LIKE 'Contrabbassisti\_%' OR cl_to LIKE 'Contralti\_%' OR cl_to LIKE 'Contraltisti\_%' OR cl_to LIKE 'Controtenori\_%' OR cl_to LIKE 'Copiloti\_di\_rally\_%' OR cl_to LIKE 'Coreografi\_%' OR cl_to LIKE 'Cornisti\_%' OR cl_to LIKE 'Corsari\_%' OR cl_to LIKE 'Cosmografi\_%' OR cl_to LIKE 'Cosmologi\_%' OR cl_to LIKE 'Cosmonauti\_%' OR cl_to LIKE 'Costituzionalisti\_%' OR cl_to LIKE 'Costumisti\_%' OR cl_to LIKE 'Crickettisti\_%' OR cl_to LIKE 'Criminali\_%' OR cl_to LIKE 'Criminologi\_%' OR cl_to LIKE 'Cristallografi\_%' OR cl_to LIKE 'Critici\_%' OR cl_to LIKE 'Crittografi\_%' OR cl_to LIKE 'Culturisti\_%' OR cl_to LIKE 'Cuochi\_%' OR cl_to LIKE 'Curatori\_editoriali\_%' OR cl_to LIKE 'Damisti\_%' OR cl_to LIKE 'Danzatori\_%' OR cl_to LIKE 'Danzatori\_su\_ghiaccio\_%' OR cl_to LIKE 'Decoratori\_%' OR cl_to LIKE 'Dermatologi\_%' OR cl_to LIKE 'Designer\_%' OR cl_to LIKE 'Dialoghisti\_%' OR cl_to LIKE 'Diplomatici\_%' OR cl_to LIKE 'Diplomatisti\_%' OR cl_to LIKE 'Direttori\_%' OR cl_to LIKE 'Dirigenti\_%' OR cl_to LIKE 'Dirigibilisti\_%' OR cl_to LIKE 'Disc\_jockey\_%' OR cl_to LIKE 'Discoboli\_%' OR cl_to LIKE 'Disegnatori\_%' OR cl_to LIKE 'Divulgatori\_scientifici\_%' OR cl_to LIKE 'Dogi\_%' OR cl_to LIKE 'Doppiatori\_%' OR cl_to LIKE 'Drammaturghi\_%' OR cl_to LIKE 'Driver\_ippici\_%' OR cl_to LIKE 'Ebanisti\_%' OR cl_to LIKE 'Ebraisti\_%' OR cl_to LIKE 'Ecologi\_%' OR cl_to LIKE 'Economisti\_%' OR cl_to LIKE 'Editori\_%' OR cl_to LIKE 'Editori\_musicali\_%' OR cl_to LIKE 'Educatori\_%' OR cl_to LIKE 'Effettisti\_%' OR cl_to LIKE 'Egittologi\_%' OR cl_to LIKE 'Ematologi\_%' OR cl_to LIKE 'Enciclopedisti\_%' OR cl_to LIKE 'Enigmisti\_%' OR cl_to LIKE 'Enologi\_%' OR cl_to LIKE 'Entomologi\_%' OR cl_to LIKE 'Epigrafisti\_%' OR cl_to LIKE 'Erpetologi\_%' OR cl_to LIKE 'Esarchi\_%' OR cl_to LIKE 'Esoteristi\_%' OR cl_to LIKE 'Esperantisti\_%' OR cl_to LIKE 'Esploratori\_%' OR cl_to LIKE 'Etnografi\_%' OR cl_to LIKE 'Etnologi\_%' OR cl_to LIKE 'Etnomusicologi\_%' OR cl_to LIKE 'Etologi\_%' OR cl_to LIKE 'Etruscologi\_%' OR cl_to LIKE 'Faccendieri\_%' OR cl_to LIKE 'Fagottisti\_%' OR cl_to LIKE 'Falsari\_%' OR cl_to LIKE 'Fantini\_%' OR cl_to LIKE 'Farmacisti\_%' OR cl_to LIKE 'Farmacologi\_%' OR cl_to LIKE 'Filantropi\_%' OR cl_to LIKE 'Filatelisti\_%' OR cl_to LIKE 'Filologi\_%' OR cl_to LIKE 'Filosofi\_%' OR cl_to LIKE 'First\_lady\_%' OR cl_to LIKE 'Fisarmonicisti\_%' OR cl_to LIKE 'Fisici\_%' OR cl_to LIKE 'Fisiologi\_%' OR cl_to LIKE 'Fisioterapisti\_%' OR cl_to LIKE 'Flautisti\_%' OR cl_to LIKE 'Fondisti\_%' OR cl_to LIKE 'Fotografi\_%' OR cl_to LIKE 'Fotoreporter\_%' OR cl_to LIKE 'Francescani\_%' OR cl_to LIKE 'Fumettisti\_%' OR cl_to LIKE 'Funzionari\_%' OR cl_to LIKE 'Galleristi\_%' OR cl_to LIKE 'Gambisti\_%' OR cl_to LIKE 'Gastronomi\_%' OR cl_to LIKE 'Genealogisti\_%' OR cl_to LIKE 'Generali\_%' OR cl_to LIKE 'Genetisti\_%' OR cl_to LIKE 'Geodeti\_%' OR cl_to LIKE 'Geografi\_%' OR cl_to LIKE 'Geologi\_%' OR cl_to LIKE 'Germanisti\_%' OR cl_to LIKE 'Gesuiti\_%' OR cl_to LIKE 'Ghirondisti\_%' OR cl_to LIKE 'Giavellottisti\_%' OR cl_to LIKE 'Ginecologi\_%' OR cl_to LIKE 'Ginnasti\_%' OR cl_to LIKE 'Giocatori\_%' OR cl_to LIKE 'Giocolieri\_%' OR cl_to LIKE 'Gioiellieri\_%' OR cl_to LIKE 'Giornalisti\_%' OR cl_to LIKE 'Giudici\_%' OR cl_to LIKE 'Giuristi\_%' OR cl_to LIKE 'Glottologi\_%' OR cl_to LIKE 'Glottoteti\_%' OR cl_to LIKE 'Goisti\_%' OR cl_to LIKE 'Golfisti\_%' OR cl_to LIKE 'Graffiti\_writer\_%' OR cl_to LIKE 'Grafici\_%' OR cl_to LIKE 'Grammatici\_%' OR cl_to LIKE 'Grecisti\_%' OR cl_to LIKE 'Guerriglieri\_%' OR cl_to LIKE 'Hacker\_%' OR cl_to LIKE 'Hockeisti\_%' OR cl_to LIKE 'Idrologi\_%' OR cl_to LIKE 'Igienisti\_%' OR cl_to LIKE 'Illusionisti\_%' OR cl_to LIKE 'Illustratori\_%' OR cl_to LIKE 'Imam\_%' OR cl_to LIKE 'Imitatori\_%' OR cl_to LIKE 'Immunologi\_%' OR cl_to LIKE 'Imperatori\_%' OR cl_to LIKE 'Imprenditori\_%' OR cl_to LIKE 'Impresari\_teatrali\_%' OR cl_to LIKE 'Incisori\_%' OR cl_to LIKE 'Indologi\_%' OR cl_to LIKE 'Infermieri\_%' OR cl_to LIKE 'Informatici\_%' OR cl_to LIKE 'Ingegneri\_%' OR cl_to LIKE 'Insegnanti\_%' OR cl_to LIKE 'Intagliatori\_%' OR cl_to LIKE 'Intarsiatori\_%' OR cl_to LIKE 'Inventori\_%' OR cl_to LIKE 'Investigatori\_%' OR cl_to LIKE 'Iranisti\_%' OR cl_to LIKE 'Islamisti\_%' OR cl_to LIKE 'Ittiologi\_%' OR cl_to LIKE 'Judoka\_%' OR cl_to LIKE 'Karateka\_%' OR cl_to LIKE 'Kickboxer\_%' OR cl_to LIKE 'Latinisti\_%' OR cl_to LIKE 'Lessicografi\_%' OR cl_to LIKE 'Letterati\_%' OR cl_to LIKE 'Librettisti\_%' OR cl_to LIKE 'Limnologi\_%' OR cl_to LIKE 'Linguisti\_%' OR cl_to LIKE 'Litografi\_%' OR cl_to LIKE 'Liutai\_%' OR cl_to LIKE 'Liutisti\_%' OR cl_to LIKE 'Logici\_%' OR cl_to LIKE 'Lottatori\_%' OR cl_to LIKE 'Lunghisti\_%' OR cl_to LIKE 'Maestri\_%' OR cl_to LIKE 'Mafiosi\_%' OR cl_to LIKE 'Magistrati\_%' OR cl_to LIKE 'Maratoneti\_%' OR cl_to LIKE 'Marciatori\_%' OR cl_to LIKE 'Marinai\_%' OR cl_to LIKE 'Marittimi\_%' OR cl_to LIKE 'Martellisti\_%' OR cl_to LIKE 'Matematici\_%' OR cl_to LIKE 'Mecenati\_%' OR cl_to LIKE 'Medaglisti\_%' OR cl_to LIKE 'Medici\_%' OR cl_to LIKE 'Medievisti\_%' OR cl_to LIKE 'Mercanti\_%' OR cl_to LIKE 'Mercenari\_%' OR cl_to LIKE 'Meteorologi\_%' OR cl_to LIKE 'Metricisti\_%' OR cl_to LIKE 'Mezzofondisti\_%' OR cl_to LIKE 'Mezzosoprani\_%' OR cl_to LIKE 'Micologi\_%' OR cl_to LIKE 'Microbiologi\_%' OR cl_to LIKE 'Militari\_%' OR cl_to LIKE 'Mimi\_%' OR cl_to LIKE 'Minatori\_%' OR cl_to LIKE 'Mineralogisti\_%' OR cl_to LIKE 'Miniatori\_%' OR cl_to LIKE 'Missionari\_%' OR cl_to LIKE 'Mistici\_%' OR cl_to LIKE 'Mitografi\_%' OR cl_to LIKE 'Modelli\_%' OR cl_to LIKE 'Monaci\_%' OR cl_to LIKE 'Montatori\_%' OR cl_to LIKE 'Mountain\_biker\_%' OR cl_to LIKE 'Multiplisti\_%' OR cl_to LIKE 'Museologi\_%' OR cl_to LIKE 'Musicisti\_%' OR cl_to LIKE 'Musicologi\_%' OR cl_to LIKE 'Naturalisti\_%' OR cl_to LIKE 'Navigatori\_%' OR cl_to LIKE 'Neurologi\_%' OR cl_to LIKE 'Neuroscienziati\_%' OR cl_to LIKE 'Nobili\_%' OR cl_to LIKE 'Notai\_%' OR cl_to LIKE 'Numismatici\_%' OR cl_to LIKE 'Nuotatori\_%' OR cl_to LIKE 'Oboisti\_%' OR cl_to LIKE 'Oceanografi\_%' OR cl_to LIKE 'Oculisti\_%' OR cl_to LIKE 'Odontoiatri\_%' OR cl_to LIKE 'Oncologi\_%' OR cl_to LIKE 'Operai\_%' OR cl_to LIKE 'Opinionisti\_%' OR cl_to LIKE 'Orafi\_%' OR cl_to LIKE 'Organari\_%' OR cl_to LIKE 'Organisti\_%' OR cl_to LIKE 'Orientalisti\_%' OR cl_to LIKE 'Orientisti\_%' OR cl_to LIKE 'Ornitologi\_%' OR cl_to LIKE 'Orologiai\_%' OR cl_to LIKE 'Ostacolisti\_%' OR cl_to LIKE 'Ottici\_%' OR cl_to LIKE 'Paleografi\_%' OR cl_to LIKE 'Paleontologi\_%' OR cl_to LIKE 'Pallamanisti\_%' OR cl_to LIKE 'Pallanuotisti\_%' OR cl_to LIKE 'Pallavolisti\_%' OR cl_to LIKE 'Pallonisti\_%' OR cl_to LIKE 'Papi\_%' OR cl_to LIKE 'Papirologi\_%' OR cl_to LIKE 'Paracadutisti\_%' OR cl_to LIKE 'Paraciclisti\_%' OR cl_to LIKE 'Parapsicologi\_%' OR cl_to LIKE 'Parolieri\_%' OR cl_to LIKE 'Partigiani\_%' OR cl_to LIKE 'Pastori\_protestanti\_%' OR cl_to LIKE 'Patologi\_%' OR cl_to LIKE 'Patriarchi\_cattolici\_%' OR cl_to LIKE 'Patrioti\_%' OR cl_to LIKE 'Pattinatori\_%' OR cl_to LIKE 'Pedagogisti\_%' OR cl_to LIKE 'Pediatri\_%' OR cl_to LIKE 'Pentatleti\_%' OR cl_to LIKE 'Percussionisti\_%' OR cl_to LIKE 'Performance\_artist\_%' OR cl_to LIKE 'Personaggi\_televisivi\_%' OR cl_to LIKE 'Personalità\_religiose\_%' OR cl_to LIKE 'Pesisti\_%' OR cl_to LIKE 'Pianisti\_%' OR cl_to LIKE 'Piloti\_%' OR cl_to LIKE 'Pionieri\_%' OR cl_to LIKE 'Pirati\_%' OR cl_to LIKE 'Pistard\_%' OR cl_to LIKE 'Pittori\_%' OR cl_to LIKE 'Poeti\_%' OR cl_to LIKE 'Polistrumentisti\_%' OR cl_to LIKE 'Politici\_%' OR cl_to LIKE 'Politologi\_%' OR cl_to LIKE 'Poliziotti\_%' OR cl_to LIKE 'Powerlifter\_%' OR cl_to LIKE 'Predicatori\_%' OR cl_to LIKE 'Prefetti\_%' OR cl_to LIKE 'Preparatori\_atletici\_%' OR cl_to LIKE 'Presbiteri\_%' OR cl_to LIKE 'Principi\_%' OR cl_to LIKE 'Procuratori\_sportivi\_%' OR cl_to LIKE 'Produttori\_cinematografici\_%' OR cl_to LIKE 'Produttori\_discografici\_%' OR cl_to LIKE 'Produttori\_teatrali\_%' OR cl_to LIKE 'Produttori\_televisivi\_%' OR cl_to LIKE 'Profeti\_%' OR cl_to LIKE 'Profumieri\_%' OR cl_to LIKE 'Progettisti\_%' OR cl_to LIKE 'Pseudoscienziati\_%' OR cl_to LIKE 'Psichiatri\_%' OR cl_to LIKE 'Psicoanalisti\_%' OR cl_to LIKE 'Psicologi\_%' OR cl_to LIKE 'Psicoterapeuti\_%' OR cl_to LIKE 'Pubblicitari\_%' OR cl_to LIKE 'Pugili\_%' OR cl_to LIKE 'Rabbini\_%' OR cl_to LIKE 'Radiologi\_%' OR cl_to LIKE 'Rapper\_%' OR cl_to LIKE 'Registi\_%' OR cl_to LIKE 'Religiosi\_%' OR cl_to LIKE 'Restauratori\_%' OR cl_to LIKE 'Retori\_%' OR cl_to LIKE 'Rettori\_%' OR cl_to LIKE 'Rivoluzionari\_%' OR cl_to LIKE 'Rugbisti\_%' OR cl_to LIKE 'Sacerdoti\_%' OR cl_to LIKE 'Saggisti\_%' OR cl_to LIKE 'Saltatori\_con\_gli\_sci\_%' OR cl_to LIKE 'Santi\_%' OR cl_to LIKE 'Sassofonisti\_%' OR cl_to LIKE 'Scacchisti\_%' OR cl_to LIKE 'Sceneggiatori\_%' OR cl_to LIKE 'Scenografi\_%' OR cl_to LIKE 'Schermidori\_%' OR cl_to LIKE 'Sci\_orientisti\_%' OR cl_to LIKE 'Scialpinisti\_%' OR cl_to LIKE 'Sciatori\_%' OR cl_to LIKE 'Scienziati\_%' OR cl_to LIKE 'Scrittori\_%' OR cl_to LIKE 'Scultori\_%' OR cl_to LIKE 'Semiologi\_%' OR cl_to LIKE 'Senatori\_%' OR cl_to LIKE 'Sensitivi\_%' OR cl_to LIKE 'Sessuologi\_%' OR cl_to LIKE 'Siepisti\_%' OR cl_to LIKE 'Sincronetti\_%' OR cl_to LIKE 'Sindacalisti\_%' OR cl_to LIKE 'Sismologi\_%' OR cl_to LIKE 'Skater\_%' OR cl_to LIKE 'Skeletonisti\_%' OR cl_to LIKE 'Slavisti\_%' OR cl_to LIKE 'Slittinisti\_%' OR cl_to LIKE 'Snowboarder\_%' OR cl_to LIKE 'Sociologi\_%' OR cl_to LIKE 'Sollevatori\_%' OR cl_to LIKE 'Sondaggisti\_%' OR cl_to LIKE 'Soprani\_%' OR cl_to LIKE 'Sopranisti\_%' OR cl_to LIKE 'Sovrani\_%' OR cl_to LIKE 'Speedcuber\_%' OR cl_to LIKE 'Speleologi\_%' OR cl_to LIKE 'Sportivi\_%' OR cl_to LIKE 'Statistici\_%' OR cl_to LIKE 'Stilisti\_%' OR cl_to LIKE 'Storici\_%' OR cl_to LIKE 'Stuccatori\_%' OR cl_to LIKE 'Stuntman\_%' OR cl_to LIKE 'Sultani\_%' OR cl_to LIKE 'Suonatori\_%' OR cl_to LIKE 'Surfisti\_%' OR cl_to LIKE 'Taekwondoka\_%' OR cl_to LIKE 'Tastieristi\_%' OR cl_to LIKE 'Tecnici\_del\_suono\_%' OR cl_to LIKE 'Telecronisti\_%' OR cl_to LIKE 'Tennistavolisti\_%' OR cl_to LIKE 'Tennisti\_%' OR cl_to LIKE 'Tenori\_%' OR cl_to LIKE 'Teologi\_%' OR cl_to LIKE 'Teorici\_%' OR cl_to LIKE 'Teosofi\_%' OR cl_to LIKE 'Terroristi\_%' OR cl_to LIKE 'Thaiboxer\_%' OR cl_to LIKE 'Tipografi\_%' OR cl_to LIKE 'Tiratori\_%' OR cl_to LIKE 'Topografi\_%' OR cl_to LIKE 'Toreri\_%' OR cl_to LIKE 'Traduttori\_%' OR cl_to LIKE 'Trasformisti\_%' OR cl_to LIKE 'Triatleti\_%' OR cl_to LIKE 'Triplisti\_%' OR cl_to LIKE 'Trombettisti\_%' OR cl_to LIKE 'Trombonisti\_%' OR cl_to LIKE 'Trovatori\_%' OR cl_to LIKE 'Truccatori\_%' OR cl_to LIKE 'Truffatori\_%' OR cl_to LIKE 'Tuffatori\_%' OR cl_to LIKE 'Ultramaratoneti\_%' OR cl_to LIKE 'Umanisti\_%' OR cl_to LIKE 'Umoristi\_%' OR cl_to LIKE 'Urbanisti\_%' OR cl_to LIKE 'Velisti\_%' OR cl_to LIKE 'Velocisti\_%' OR cl_to LIKE 'Vescovi\_%' OR cl_to LIKE 'Veterinari\_%' OR cl_to LIKE 'Vetrai\_%' OR cl_to LIKE 'Viaggiatori\_%' OR cl_to LIKE 'Vibrafonisti\_%' OR cl_to LIKE 'Vignettisti\_%' OR cl_to LIKE 'Violinisti\_%' OR cl_to LIKE 'Violisti\_%' OR cl_to LIKE 'Violoncellisti\_%' OR cl_to LIKE 'Virologi\_%' OR cl_to LIKE 'Vulcanologi\_%' OR cl_to LIKE 'Wrestler\_%' OR cl_to LIKE 'Youtuber\_%' OR cl_to LIKE 'Zoologi\_%') AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to LIKE '%immaginari%' OR cl_to LIKE '%mitologici%' OR cl_to LIKE 'Liste%' OR cl_to LIKE 'Concistori%' OR cl_to LIKE 'Gruppi\_musicali%' OR cl_to LIKE 'Linee\_di\_successione%' OR cl_to LIKE 'Cavalieri\_di\_%' OR cl_to LIKE 'Cavalieri\_del%' OR cl_to LIKE 'Modelli\_di\_%' OR cl_to = 'Scienziati_pazzi' OR cl_to = 'Medici_(famiglia)' OR cl_to = 'Sacerdoti_romani' OR cl_to = 'Traduttori_automatici' OR cl_to = 'Pseudonimi_collettivi' OR cl_to = 'Principi_giuridici' OR cl_to LIKE 'Generali_Ladies_Linz%' OR cl_to LIKE 'Generali_Open%' ) AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 AND tl_title IN ('Bio')) AND page_title LIKE '[^_]_[^_]';
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
.
Checking query status...