Categories in enwiki could be created in arwiki

Fork of Categories in enwiki could be created in arwiki by FShbib

This query is marked as a draft This query has been published by FShbib.

SQL

select concat("* [[:en:Category:",page_title,"]]"), count(cl_from)
from page
inner join categorylinks
on cl_to = page_title
where page_id not in (select cl_from from categorylinks where cl_to = "Hidden_categories")
and cl_from in (select ll_from from langlinks where ll_from = cl_from and ll_lang = "ar")
and page_id not in (select ll_from from langlinks where ll_from = page_id and ll_lang = "ar")
and page_title like "%films%"
and page_namespace = 14
and page_is_redirect = 0
group by page_title
having count(cl_from)>10
limit 50;

SQL

Checking query status...