Untitled query #70504

SQL

select c3.cl_to, count(*)
from categorylinks c3
join (select p3.page_id
      from page p3
      join (select c2.cl_to
           from categorylinks c2
           join (select p2.page_id
                from page p2
                join (select c1.cl_to
                      from categorylinks c1
                      join (select p1.page_id
                            from page p1
                            join (select cl_to
                                  from categorylinks
                                  where cl_from = 12) t1 on p1.page_title = t1.cl_to
                            where p1.page_namespace = 14
                            order by p1.page_title
                            /*limit 1*/) t2 on c1.cl_from = t2.page_id
                      order by c1.cl_to
                      /*limit 1*/) t3 on p2.page_title = t3.cl_to
                where p2.page_namespace = 14
                order by p2.page_title) t4 on c2.cl_from = t4.page_id
           order by c2.cl_to #desc
           /*limit 1*/) t5 on p3.page_title = t5.cl_to
      where p3.page_namespace = 14
      order by p3.page_title) t6 on c3.cl_from = t6.page_id
group by c3.cl_to
order by c3.cl_to
SQL

Checking query status...
