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 = 'Բոլոր_ոչ_ազատ_պատկերներ'
     AND p.page_namespace = 7),
  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)
SELECT DISTINCT page_title
FROM page, il_to
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 NOT IN (SELECT title FROM NonFreeImages)
LIMIT 100
SQL

Checking query status...
