Untitled query #8625

SQL

WITH NonFreeImages AS
  (SELECT DISTINCT page_title AS title
   FROM page AS p
   JOIN categorylinks cl ON p.page_id = cl.cl_from
   WHERE cl.cl_to = 'Բոլոր_ոչ_ազատ_պատկերներ'),
  Movies AS 
    (SELECT DISTINCT page_id as movie_id
   FROM page AS p
   JOIN categorylinks cl ON p.page_id = cl.cl_from
   WHERE cl.cl_to = 'Ֆիլմեր_այբբենական_կարգով'
     AND p.page_namespace = 0)
WITH MoviesWithNonFreeImages (SELECT DISTINCT page_id as movie_with_non_free_image_id
FROM page
JOIN Movies as m ON page_id = movie_id
JOIN imagelinks ON page_id = il_from
WHERE page_is_redirect = 0
  AND page_namespace = 0
                              AND il_to IN (SELECT title FROM NonFreeImages))
                              
SELECT page_title
FROM page
JOIN Movies on movie_id = page_title
WHERE page_id NOT IN (SELECT movie_with_non_free_image_id FROM MoviesWithNonFreeImages)
SQL

Checking query status...
