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