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)
SELECT DISTINCT page_title, il_to
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 NOT IN (SELECT title FROM NonFreeImages)
LIMIT 10
SQL

Checking query status...
