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.