SQL
AخA
USE arwiki_p;
SELECT
CONCAT('# [[',p.page_title,']] - ') as "المقالة",
COUNT(pl.pl_from)
FROM page p
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
INNER JOIN page p2 ON p2.page_id = pl.pl_from
AND pl.pl_from_namespace = 0 #AND p2.page_is_redirect=0
AND p.page_id NOT IN (SELECT tl_from FROM templatelinks where tl_title = 'يتيمة')
AND p.page_id IN (SELECT cl_from FROM categorylinks where cl_to = 'بوابة_علوم/مقالات_متعلقة')
GROUP BY p.page_title
having COUNT(pl.pl_from)<3
ORDER BY COUNT(pl.pl_from) DESC
#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.