Fork of
Cross-wiki project tagging
by Edgars2007
This query is marked as a draft
This query has been published
by FShbib.
SQL
AخA
use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
join page p on p.page_id=l.ll_from
where p.page_namespace=0 and p.page_title in (select pla.page_title
from categorylinks cla
join page pla on cla.cl_from=pla.page_id
where pla.page_namespace=1 and cla.cl_type="page" and
cla.cl_to="WikiProject_Film_articles")
and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="ar")
and l.ll_lang="ar"
group by l.ll_from
limit 500;
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.