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, rev_timestamp FROM page, revision WHERE page_id = rev_page AND rev_parent_id = 0 AND 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\_%') 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 = 'Principi_del_diritto_internazionale' OR cl_to = 'Principi_della_termodinamica' OR cl_to = 'Principi_attivi' OR cl_to = 'Esploratori_della_Regia_Marina' OR cl_to = 'Cavalieri_templari' OR cl_to = 'Modelli_strutturali' OR cl_to = 'Modelli_macroeconomici' OR cl_to = 'Modelli_teorici_della_pubblicitĂ ' 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')) ORDER BY rev_timestamp DESC;
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...