تصنيفات إلى بوابات

SQL

use arwiki_p;
select concat (SUBSTRING_INDEX(`page_title`, '_', 2)) AS "بداية التصنيف" , count(*), stub
from page, (select DISTINCT  cl2.cl_to from categorylinks cl
inner join categorylinks cl2
on cl.cl_from = cl2.cl_from
where cl.cl_to like "تأسيسات_سنة%"
and cl2.cl_to like "%بذرة%"
group by cl2.cl_to
order by count(cl2.cl_to) desc
limit 10) as stub
where page_namespace = 14
and page_is_redirect = 0
and concat('',SUBSTRING_INDEX(`page_title`, '_', 1) * 1) <> SUBSTRING_INDEX(`page_title`, '_', 1)
group by SUBSTRING_INDEX(`page_title`, '_', 2)
order by count(*) desc
limit 5000;
SQL

Checking query status...
