جميع التصنيفات التي بحاجة لتصانيف معادلة من الإنجليزية

SQL

use arwiki_p;
select concat("تصنيف:",p.page_title) as page_title, group_concat(el.ll_title SEPARATOR '***') as "cats"
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 = replace(replace(l1.ll_title, "Category:",""), " ", "_")
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
inner join page p3
on p3.page_title = replace(replace(el.ll_title, "تصنيف:",""), " ", "_")
where p.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 p.page_id not in (select cl_from from categorylinks where cl_to = p3.page_title)
and p3.page_id not in (select cl_from from categorylinks  where cl_to = 'تصنيفات_مخفية')
and p3.page_id not in (select cl_from from categorylinks  where cl_to = 'تحويلات_تصنيفات_ويكيبيديا')
and p3.page_title not like "صفحات_توضيح%"
and p.page_namespace =14
and p.page_id not in (select cl_from from categorylinks  where cl_to = 'صفحات_لا_تقبل_التصنيف_المعادل')
and enwiki_p.page.page_namespace = 14
and enwiki_p.page.page_is_redirect = 0
and enwiki_p.page.page_touched < SUBDATE(NOW(),1)
and p2.page_is_redirect = 0
and p2.page_namespace = 14
and p3.page_namespace = 14
and p3.page_is_redirect = 0
and l1.ll_lang like "en"
and el.ll_lang like "ar"
and p.page_id not in (select cl_from from categorylinks  where cl_to = 'تصنيفات_مخفية')
group by p.page_title;
SQL

Checking query status...
