SQL
AخA
use arwiki_p;
select page_title, count(tl_title)
from page
inner join templatelinks
on tl_from = page_id
where page_namespace = 1
and page_is_redirect = 0
and tl_from_namespace = page_namespace
and tl_namespace = 10
and tl_title like "مشروع_ويكي_%"
group by page_title
order by count(tl_title) 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.