Untitled query #70768

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

prepare com
from 'select case when c7.cl_to is not null then ? end as page_id, c7.cl_to, count(*)
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 = ?) 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
group by c7.cl_to
having c7.cl_to like "Academic_disciplines" or c7.cl_to like "Business" or c7.cl_to like "Communication" or c7.cl_to like "Concepts" 
	or c7.cl_to like "Culture" or c7.cl_to like "Economy" or c7.cl_to like "Education" or c7.cl_to like "Energy" 
    or c7.cl_to like "Engineering" or c7.cl_to like "Entertainment" or c7.cl_to like "Entities" or c7.cl_to like "Ethics" 
    or c7.cl_to like "Food_and_drink" or c7.cl_to like "Geography" or c7.cl_to like "Government" or c7.cl_to like "Health" 
    or c7.cl_to like "History" or c7.cl_to like "Human_behavior" or c7.cl_to like "Humanities" or c7.cl_to like "Information" 
    or c7.cl_to like "Internet" or c7.cl_to like "Knowledge" or c7.cl_to like "Language" or c7.cl_to like "Law" or c7.cl_to like "Life" 
    or c7.cl_to like "Mass_media" or c7.cl_to like "Mathematics" or c7.cl_to like "Military" or c7.cl_to like "Nature" 
    or c7.cl_to like "People" or c7.cl_to like "Philosophy" or c7.cl_to like "Politics" or c7.cl_to like "Religion" 
    or c7.cl_to like "Science" or c7.cl_to like "Society" or c7.cl_to like "Sports" or c7.cl_to like "Technology" or c7.cl_to like "Time" 
    or c7.cl_to like "Universe" 
order by c7.cl_to';
set @num1 := 1946;
set @num2 := 1946;
execute com using @num1, @num2;
set @num1 := 1948;
set @num2 := 1948;
execute com using @num1, @num2;
set @num1 := 1950;
set @num2 := 1950;
execute com using @num1, @num2;
set @num1 := 1957;
set @num2 := 1957;
execute com using @num1, @num2;
set @num1 := 1965;
set @num2 := 1965;
execute com using @num1, @num2;
set @num1 := 1966;
set @num2 := 1966;
execute com using @num1, @num2;
set @num1 := 1967;
set @num2 := 1967;
execute com using @num1, @num2;
set @num1 := 1968;
set @num2 := 1968;
execute com using @num1, @num2;
set @num1 := 1969;
set @num2 := 1969;
execute com using @num1, @num2;
set @num1 := 1970;
set @num2 := 1970;
execute com using @num1, @num2;
set @num1 := 1971;
set @num2 := 1971;
execute com using @num1, @num2;
set @num1 := 1973;
set @num2 := 1973;
execute com using @num1, @num2;
set @num1 := 1974;
set @num2 := 1974;
execute com using @num1, @num2;
set @num1 := 1975;
set @num2 := 1975;
execute com using @num1, @num2;
set @num1 := 1979;
set @num2 := 1979;
execute com using @num1, @num2;
set @num1 := 1985;
set @num2 := 1985;
execute com using @num1, @num2;
set @num1 := 1988;
set @num2 := 1988;
execute com using @num1, @num2;
set @num1 := 1990;
set @num2 := 1990;
execute com using @num1, @num2;
set @num1 := 1998;
set @num2 := 1998;
execute com using @num1, @num2;
set @num1 := 2006;
set @num2 := 2006;
execute com using @num1, @num2;
set @num1 := 2007;
set @num2 := 2007;
execute com using @num1, @num2;
set @num1 := 2009;
set @num2 := 2009;
execute com using @num1, @num2;
set @num1 := 2011;
set @num2 := 2011;
execute com using @num1, @num2;
set @num1 := 2015;
set @num2 := 2015;
execute com using @num1, @num2;
set @num1 := 2017;
set @num2 := 2017;
execute com using @num1, @num2;
set @num1 := 2019;
set @num2 := 2019;
execute com using @num1, @num2;
set @num1 := 2021;
set @num2 := 2021;
execute com using @num1, @num2;
set @num1 := 2023;
set @num2 := 2023;
execute com using @num1, @num2;
set @num1 := 2027;
set @num2 := 2027;
execute com using @num1, @num2;
set @num1 := 2029;
set @num2 := 2029;
execute com using @num1, @num2;
set @num1 := 2030;
set @num2 := 2030;
execute com using @num1, @num2;
set @num1 := 2032;
set @num2 := 2032;
execute com using @num1, @num2;
set @num1 := 2041;
set @num2 := 2041;
execute com using @num1, @num2;
set @num1 := 2047;
set @num2 := 2047;
execute com using @num1, @num2;
set @num1 := 2053;
set @num2 := 2053;
execute com using @num1, @num2;
set @num1 := 2063;
set @num2 := 2063;
execute com using @num1, @num2;
set @num1 := 2065;
set @num2 := 2065;
execute com using @num1, @num2;
set @num1 := 2067;
set @num2 := 2067;
execute com using @num1, @num2;
set @num1 := 2070;
set @num2 := 2070;
execute com using @num1, @num2;
set @num1 := 2075;
set @num2 := 2075;
execute com using @num1, @num2;
set @num1 := 2076;
set @num2 := 2076;
execute com using @num1, @num2;
set @num1 := 2077;
set @num2 := 2077;
execute com using @num1, @num2;
set @num1 := 2082;
set @num2 := 2082;
execute com using @num1, @num2;
set @num1 := 2083;
set @num2 := 2083;
execute com using @num1, @num2;
set @num1 := 2084;
set @num2 := 2084;
execute com using @num1, @num2;
set @num1 := 2085;
set @num2 := 2085;
execute com using @num1, @num2;
set @num1 := 2087;
set @num2 := 2087;
execute com using @num1, @num2;
set @num1 := 2088;
set @num2 := 2088;
execute com using @num1, @num2;
set @num1 := 2089;
set @num2 := 2089;
execute com using @num1, @num2;
set @num1 := 2093;
set @num2 := 2093;
execute com using @num1, @num2;
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 Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
