This query is marked as a draft This query has been published by ԱշոտՏՆՂ.

SQL

x
 
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))
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...