SQL
AخA
use arwiki_p;
select p.page_title, count(enwiki_p.categorylinks.cl_from)
from page p
inner join langlinks l1
on l1.ll_from = p.page_id
inner join enwiki_p.page
on enwiki_p.page.page_title = l1.ll_title
inner join enwiki_p.categorylinks
on enwiki_p.categorylinks.cl_from = enwiki_p.page.page_id
inner join enwiki_p.page p2
on p2.page_title = enwiki_p.categorylinks.cl_to
inner join enwiki_p.langlinks el
on p2.page_id = el.ll_from
where p.page_is_redirect = 0
and p.page_namespace = 0
and enwiki_p.page.page_namespace = 0
and enwiki_p.page.page_is_redirect = 0
and p2.page_id not in (select enwiki_p.categorylinks.cl_from from enwiki_p.categorylinks where enwiki_p.categorylinks.cl_to = 'Hidden_categories')
and p2.page_is_redirect = 0
and p2.page_namespace = 14
and l1.ll_lang like "en"
and el.ll_lang like "ar"
group by p.page_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.