Untitled query #70487

SQL

/*select *
from categorylinks
where cl_from = 780754

c3.cl_to, count(*)
group by c3.cl_to*/

select c8.cl_to
from categorylinks c8
join (select p8.page_id
      from page p8
      join (select c7.cl_to
            from categorylinks c7
            join (select p7.page_id
                  from page p7
                  join (select c6.cl_to
                        from categorylinks c6
                        join (select p6.page_id
                              from page p6
                              join (select c5.cl_to
                                    from categorylinks c5
                                    join (select p5.page_id
                                          from page p5
                                          join (select c4.cl_to
                                                from categorylinks c4
                                                join (select p4.page_id
                                                      from page p4
                                                      join (select c3.cl_to
                                                            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) t2 on c1.cl_from = t2.page_id) t3 on p2.page_title = t3.cl_to
                                                                            where p2.page_namespace = 14) t4 on c2.cl_from = t4.page_id) t5 on p3.page_title = t5.cl_to
                                                                  where p3.page_namespace = 14) t6 on c3.cl_from = t6.page_id) t7 on p4.page_title = t7.cl_to
                                                      where p4.page_namespace = 14) t8 on c4.cl_from = t8.page_id) t9 on p5.page_title = t9.cl_to
                                          where p5.page_namespace = 14) t10 on c5.cl_from = t10.page_id) t11 on p6.page_title = t11.cl_to
                              where p6.page_namespace = 14) t12 on c6.cl_from = t12.page_id) t13 on p7.page_title = t13.cl_to
                  where p7.page_namespace = 14) t14 on c7.cl_from = t14.page_id) t15 on p8.page_title = t15.cl_to
      where p8.page_namespace = 14) t16 on c8.cl_from = t16.page_id
SQL

Checking query status...
