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

)