Fork of
unreviewed Visual arts articles
by Vexations
This query is marked as a draft
This query has been published
by Vexations.
SQL
x
SELECT DISTINCT article.page_title
#SELECT DISTINCT article.page_title AS PT, CONCAT("https://en.wikipedia.org/wiki/", article.page_title) AS link
FROM page article
JOIN page talkpage ON article.page_title = talkpage.page_title
JOIN templatelinks ON talkpage.page_id=templatelinks.tl_from
LEFT JOIN categorylinks ON article.page_id = cl_from
WHERE cl_from IS NULL
AND article.page_namespace=0
AND talkpage.page_namespace= 1
AND templatelinks.tl_title IN ('WikiProject_Arts',
'WikiProject_Graphic_design'
'WikiProject_Public_Art',
'WikiProject_Visual_Art',
'WikiProject_Visual_arts',
'WikiProject_Visual_Arts',
'WikiProject_Women_artists',
'WikiProject_Sculpture',
'WikiProject_Textile_Arts',
'Wikiproject_Craft'
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.