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

SQL

AخA
 
select c6.cl_to, count(*)
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
group by c6.cl_to
having c6.cl_to like "Academic_disciplines" or c6.cl_to like "Business" or c6.cl_to like "Communication" or c6.cl_to like "Concepts" 
    or c6.cl_to like "Culture" or c6.cl_to like "Economy" or c6.cl_to like "Education" or c6.cl_to like "Energy" 
    or c6.cl_to like "Engineering" or c6.cl_to like "Entertainment" or c6.cl_to like "Entities" or c6.cl_to like "Ethics" 
    or c6.cl_to like "Food_and_drink" or c6.cl_to like "Geography" or c6.cl_to like "Government" or c6.cl_to like "Health" 
    or c6.cl_to like "History" or c6.cl_to like "Human_behavior" or c6.cl_to like "Humanities" or c6.cl_to like "Information" 
    or c6.cl_to like "Internet" or c6.cl_to like "Knowledge" or c6.cl_to like "Language" or c6.cl_to like "Law" or c6.cl_to like "Life" 
    or c6.cl_to like "Mass_media" or c6.cl_to like "Mathematics" or c6.cl_to like "Military" or c6.cl_to like "Nature" 
    or c6.cl_to like "People" or c6.cl_to like "Philosophy" or c6.cl_to like "Politics" or c6.cl_to like "Religion" 
    or c6.cl_to like "Science" or c6.cl_to like "Society" or c6.cl_to like "Sports" or c6.cl_to like "Technology" or c6.cl_to like "Time" 
    or c6.cl_to like "Universe" 
order by c6.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...