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

SQL

use arwiki_p;
select concat (SUBSTRING_INDEX(`page_title`, '_', 2)) AS "بداية التصنيف",
(select DISTINCT  cl2.cl_to from categorylinks cl
inner join categorylinks cl2
on cl.cl_from = cl2.cl_from
where cl.cl_to LIKE CONCAT('%', concat (SUBSTRING_INDEX(`page_title`, '_', 2))  ,'%')
and cl2.cl_to like "%بذرة%"
group by cl2.cl_to
order by count(cl2.cl_to) desc
 limit 10)
,count(*)
from page
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 100;
SQL

Checking query status...
