Untitled query #11976

SQL

USE commonswiki_p; 



SELECT img_name, 
       img_width, 
       img_height, 
       img_size 
FROM   image 
WHERE  img_size > 2000000 
       AND img_actor not in (select actor_id from actor where actor_name = 'Beko')
       AND img_name IN (SELECT page_title 
                        FROM   page 
                        WHERE 
               page_id IN (SELECT cl_from 
                           FROM   categorylinks 
                           WHERE  cl_to = 
                          'Images_from_Wiki_Loves_Monuments_2019_in_Armenia')) 
       AND img_name IN (SELECT page_title 
                        FROM   page 
                        WHERE 
               page_id IN (SELECT cl_from 
                           FROM   categorylinks 
                           WHERE  cl_to = 'Cultural_heritage_monuments_in_Armenia_with_known_IDs'))
SQL

Checking query status...
