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.

Checking query status...