Fork of
Most linked portals on cswiki
by Blahma
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
x
USE frwiki_p;
SELECT *
#pl_title, COUNT(*) AS articles
FROM pagelinks , page
WHERE pl_from_namespace = 0
AND pl_namespace = 100
and page_namespace = 100
and page_title = pl_title
/*
and page_id not in (
select ll_from from langlinks
where ll_lang = "ar"
and ll_from = page_id
)*/
and pl_from in (
select d.ll_from from langlinks d
where d.ll_lang = "ar"
and d.ll_from = pl_from
)
#GROUP BY pl_title
#ORDER BY articles DESC, pl_title
limit 100
;
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.