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
Vexations
.
Toggle Highlighting
SQL
# paintings that are not Visual arts articles SELECT article.page_title FROM page AS article INNER JOIN page AS talk on article.page_title = talk.page_title # INNER JOIN templatelinks ON tl_from = talk.page_id INNER JOIN categorylinks ON cl_from = article.page_id WHERE cl_to IN ('1981_paintings', '1982_paintings', '1983_paintings', '1984_paintings', '1984_paintings', '1985_paintings', '1986_paintings', '1987_paintings', '1988_paintings', '1989_paintings', '1990_paintings') AND talk.page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'WikiProject_Visual_arts' AND tl_namespace = 10) AND article.page_namespace = 0 AND talk.page_namespace = 1 LIMIT 100;
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...