Untitled query #73529

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 := 2475;
set @num2 := 2475;
execute com using @num1, @num2;
set @num1 := 5783;
set @num2 := 5783;
execute com using @num1, @num2;
SQL

Checking query status...
