SQL
AخA
USE arwiki_p;
SELECT
page_namespace,
page_title
FROM page
LEFT JOIN pagelinks
ON pl_title = page_title
AND pl_namespace = page_namespace
WHERE pl_namespace IS NULL
AND page.page_namespace =0 AND page.page_is_redirect = 0
and page.page_id not in (select tl_from from templatelinks where tl_title = 'يتيمة')
LIMIT 1000;
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.