use arwiki_p;

use arwiki_p;

select DISTINCT  cl2.cl_to, count(cl2.cl_to), cl.cl_to from categorylinks cl

inner join categorylinks cl2

on cl.cl_from = cl2.cl_from

where cl.cl_to 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, cl.cl_to

order by count(cl2.cl_to) desc

limit 1000;