SQL
AخA
USE arwiki_p;
SELECT
CONCAT('[[',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 = 'يتيمة')
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.