Long pages (hywiki)

SQL

USE hywiki_p; 

SELECT page_title 
                          FROM   page 
                                 JOIN revision 
                                   ON rev_page = page_id 
                          WHERE  page_namespace = 0 
                                 AND page_is_redirect = 0
                                 AND rev_parent_id = 0
                          AND rev_timestamp > 20200000000000
                          AND page_id not in (SELECT page_id 
FROM   categorylinks 
       JOIN page 
         ON page_id = cl_from 
WHERE  cl_to = 'Վիքիպեդիա:Թարգմանված_հոդվածներ' 
       AND page_title IN (SELECT page_title 
                          FROM   page 
                                 JOIN revision 
                                   ON rev_page = page_id 
                          WHERE  page_namespace = 0 
                                 AND page_is_redirect = 0
                                 AND rev_parent_id = 0
                          AND rev_timestamp > 20200000000000))
SQL

Checking query status...
