تخصيص البذور حسب المقالات المشابهة حسب التصنيف

SQL

use arwiki_p;
select concat("#[[", p1.page_title,"]]--->", 
       group_concat(DISTINCT concat("<div class = \"stub-value ",cl4.cl_to,"\">", cl4.cl_to, "</div>") SEPARATOR ' '),"</br>")
from page p1

inner join categorylinks cl1
on cl1.cl_from = p1.page_id

inner join categorylinks cl2
on p1.page_id = cl2.cl_from

inner join categorylinks cl3
on cl3.cl_to = cl2.cl_to

inner join categorylinks cl4
on cl4.cl_from = cl3.cl_from

where cl1.cl_to = "مقالات_بذور_عامة"
and (select page_id from page where page_title = cl2.cl_to and page_namespace = 14 and page_is_redirect = 0)
	not in 
    (select cl_from from categorylinks where cl_to = "تصنيفات_مخفية")
and cl4.cl_to like "بذرة_%"
and cl4.cl_to in (select page_title from page where page_namespace = 10 and page_title = cl4.cl_to)
group by p1.page_title
limit 500;

SQL

Checking query status...