Most redundant categories in orphan articles

SQL

use arwiki_p;
select  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 = (select concat ("بوابة ",page_title,"/","مقالات_متعلقة") from page
                 inner join categorylinks cll on cll.cl_from = page_id where
                 page_is_redirect = 0 and page_namespace = 100
				 and cll.cl_to = "قائمة_البوابات" and cl.cl_to = cll.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...
