تصانيف معادلة

SQL

use arwiki_p;
select p.page_title
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
where p.page_is_redirect = 0
and p.page_namespace = 14
and enwiki_p.page.page_namespace = 14
and enwiki_p.page.page_is_redirect = 0
and p.page_id not in (select cl_from from categorylinks  where cl_to = 'صفحات_لا_تقبل_التصنيف_المعادل')
and l1.ll_lang like "en"
group by p.page_title;
SQL

Checking query status...
