Paintings by specific artists without creator templates

SQL

SELECT specificcat.page_title, COUNT(filepage)
FROM page specificcat
INNER JOIN categorylinks cl1 ON cl1.cl_from = specificcat.page_id
INNER JOIN categorylinks cl2 ON cl2.cl_to = specificcat.page_title
INNER JOIN page filepage ON filepage.page_id = cl2.cl_from
WHERE specificcat.page_namespace = 14
AND cl1.cl_to = "Paintings_by_artist"
AND filepage.page_namespace = 6
AND filepage.page_id NOT IN (
  SELECT templatelinks.tl_from FROM templatelinks
  INNER JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id
  WHERE linktarget.lt_title = "Creator"
  AND linktarget.lt_namespace = 10
)
GROUP BY specificcat.page_title
ORDER BY COUNT(filepage) DESC

SQL

Checking query status...