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 = "بوابة_الولايات_المتحدة/مقالات_متعلقة"
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...