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

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...