Potential unmarked paintings-by-artist categories on Commons

SQL

use commonswiki_p;
SELECT page.page_title
FROM page
WHERE page.page_namespace = 14
AND page.page_title LIKE 'Paintings\_by\_%'
AND page.page_title NOT LIKE 'Paintings\_by\_%\_by\_%'
AND page.page_title NOT LIKE '%\_in\_%'
AND page.page_title NOT LIKE '%useum%'
AND page.page_title NOT LIKE '%with_fur'
AND page.page_title NOT LIKE '%atelier'
AND page.page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to = "Paintings_by_artist")
AND page.page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to = "Category_redirects")
AND page.page_id NOT IN (
  SELECT innercat.cl_from
  FROM categorylinks outercat
  INNER JOIN page catpage ON catpage.page_id = outercat.cl_from
  INNER JOIN categorylinks innercat ON innercat.cl_to = catpage.page_title
  WHERE outercat.cl_to = "Paintings_by_artist_by_country_of_origin"
  AND catpage.page_namespace = 14
)
SQL

Checking query status...
