SQL
AخA
use wikidatawiki_p;
SELECT pl_title, count(*)
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and pl_title not in (select concat('P',term_entity_id)
from wb_terms where term_language='ar' and term_type = "label"
and term_entity_type="property")
GROUP BY pl_title
ORDER BY count(*) DESC
limit 10;
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.