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

SQL

use arwiki_p;
select ll_title, page_title, count(cl_from)/*, (select count(*) from enwiki_p.categorylinks 
                            inner join enwiki_p.page
                            on enwiki_p.page.page_title = ll_title
                            where enwiki_p.categorylinks.cl_from = enwiki_p.page.page_id
                            and enwiki_p.page.page_is_redirect = 0
                            and enwiki_p.page.page_namespace = 0)*/
from page
inner join langlinks l1
on l1.ll_from = 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 page_is_redirect = 0
and page_namespace = 0
and l1.ll_lang like "en"
group by page_title
limit 10;
SQL

Checking query status...
