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
#SELECT page.page_title, categorylinks.cl_to SELECT DISTINCT page.page_title FROM page JOIN categorylinks ON page.page_id=categorylinks.cl_from JOIN revision ON rev_page = page_id JOIN pagetriage_page ON rev_page = ptrp_page_id WHERE rev_parent_id = 0 AND ptrp_reviewed = 0 AND page_namespace = 0 AND page_is_redirect = 0 AND categorylinks.cl_to REGEXP 'paintings|_in_art|curators|gallerists|sculptors|painters|women_artists|contemporary_artists|engravers|conceptual' #AND categorylinks.cl_to REGEXP '^[0-9]{2}(st|th)-century.*(artists|painters|sculptors)$' AND categorylinks.cl_to NOT IN ( 'National artistic gymnastics competitions', '2021 in artistic gymnastics', 'Pending_AfC_submissions_in_article_space', 'Recipients_of_the_Padma_Shri_in_arts')
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...