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

SQL

​x
 
/*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
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...