Most redundant categories in orphan articles

Fork of Most redundant categories in orphan articles by ASammour

This query is marked as a draft This query has been published by ASammour.

SQL

use arwiki_p;
select  GROUP_CONCAT(cl2.cl_to) , count(cl2.cl_to) from categorylinks cl
inner join categorylinks cl2
on cl.cl_from = cl2.cl_from
where cl.cl_to in select concat (page_title,"/","مقالات_متعلقة") from page
                 inner join categorylinks on cl_from = page_id where
                 page_is_redirect = 0 and page_namespace = 100
				 and cl_to = "قائمة_البوابات")
and cl2.cl_to not like "%مقالات%"
and cl2.cl_to not like "%بذرة%"
and cl2.cl_to not like "%ويكي_بيانات%"
and cl2.cl_to not like "%/%"
and cl2.cl_to not like "%بوابة%"
and cl2.cl_to not like "%صفحات%"
group by cl2.cl_to
order by count(cl2.cl_to) desc
limit 100;

SQL

Checking query status...