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 'Calciatori\_%' OR cl_to LIKE 'Attori\_%' OR cl_to LIKE 'Politici\_%' OR cl_to LIKE 'Cestisti\_%' OR cl_to LIKE 'Scrittori\_%' OR cl_to LIKE 'Allenatori\_%' OR cl_to LIKE 'Pittori\_%' OR cl_to LIKE 'Cantanti\_%' OR cl_to LIKE 'Registi\_%' OR cl_to LIKE 'Compositori\_%' OR cl_to LIKE 'Militari\_%' OR cl_to LIKE 'Giornalisti\_%' OR cl_to LIKE 'Poeti\_%' OR cl_to LIKE 'Sceneggiatori\_%' OR cl_to LIKE 'Nobili\_%' OR cl_to LIKE 'Giocatori\_%' OR cl_to LIKE 'Generali\_%' OR cl_to LIKE 'Ciclisti\_%' OR cl_to LIKE 'Storici\_%' OR cl_to LIKE 'Imprenditori\_%' OR cl_to LIKE 'Musicisti\_%' OR cl_to LIKE 'Vescovi\_%' OR cl_to LIKE 'Tennisti\_%' OR cl_to LIKE 'Dirigenti\_%' OR cl_to LIKE 'Architetti\_%' OR cl_to LIKE 'Filosofi\_%' OR cl_to LIKE 'Cantautori\_%' OR cl_to LIKE 'Cardinali\_%' OR cl_to LIKE 'Scultori\_%' OR cl_to LIKE 'Insegnanti\_%' OR cl_to LIKE 'Arcivescovi\_%' OR cl_to LIKE 'Hockeisti\_%' OR cl_to LIKE 'Medici\_%' OR cl_to LIKE 'Nuotatori\_%' OR cl_to LIKE 'Avvocati\_%' OR cl_to LIKE 'Pallavolisti\_%' OR cl_to LIKE 'Sovrani\_%' OR cl_to LIKE 'Schermidori\_%' OR cl_to LIKE 'Accademici\_%' OR cl_to LIKE 'Ingegneri\_%' OR cl_to LIKE 'Produttori\_cinematografici\_%' OR cl_to LIKE 'Produttori\_discografici\_%' OR cl_to LIKE 'Doppiatori\_%' OR cl_to LIKE 'Drammaturghi\_%' OR cl_to LIKE 'Matematici\_%' OR cl_to LIKE 'Rugbisti\_%' OR cl_to LIKE 'Religiosi\_%' OR cl_to LIKE 'Chitarristi\_%' OR cl_to LIKE 'Velocisti\_%' OR cl_to LIKE 'Presbiteri\_%' OR cl_to LIKE 'Astronomi\_%' OR cl_to LIKE 'Fumettisti\_%' OR cl_to LIKE 'Sciatori\_%' OR cl_to LIKE 'Giuristi\_%' OR cl_to LIKE 'Diplomatici\_%' OR cl_to LIKE 'Teologi\_%' OR cl_to LIKE 'Saggisti\_%' OR cl_to LIKE 'Pugili\_%' OR cl_to LIKE 'Ginnasti\_%' OR cl_to LIKE 'Conduttori\_televisivi\_%' OR cl_to LIKE 'Pianisti\_%' OR cl_to LIKE 'Fisici\_%' OR cl_to LIKE 'Direttori\_d\'orchestra\_%' OR cl_to LIKE 'Artisti\_%' OR cl_to LIKE 'Danzatori\_%' OR cl_to LIKE 'Piloti\_%' OR cl_to LIKE 'Partigiani\_%' OR cl_to LIKE 'Mezzofondisti\_%' OR cl_to LIKE 'Attivisti\_%' OR cl_to LIKE 'Traduttori\_%' OR cl_to LIKE 'Economisti\_%' OR cl_to LIKE 'Fotografi\_%' OR cl_to LIKE 'Botanici\_%' OR cl_to LIKE 'Canottieri\_%' OR cl_to LIKE 'Patrioti\_%' OR cl_to LIKE 'Pallanuotisti\_%' OR cl_to LIKE 'Pistard\_%' OR cl_to LIKE 'Incisori\_%' OR cl_to LIKE 'Wrestler\_%' OR cl_to LIKE 'Lottatori\_%' OR cl_to LIKE 'Santi\_%' OR cl_to LIKE 'Condottieri\_%' OR cl_to LIKE 'Aviatori\_%' OR cl_to LIKE 'Esploratori\_%' OR cl_to LIKE 'Scacchisti\_%' OR cl_to LIKE 'Rapper\_%' OR cl_to LIKE 'Critici\_%' OR cl_to LIKE 'Chimici\_%' OR cl_to LIKE 'Fondisti\_%') AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to LIKE '%immaginari') AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 AND tl_title IN ('Bio'));
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...