Get parents of parents of parents

SQL

select cl1.cl_to 
from categorylinks as cl1 
inner join (select page_id 
            from page 
            where page_title in (select cl1.cl_to 
                                from categorylinks as cl1 
                                inner join (select page_id 
                                            from page 
                                            where page_title in (select cl1.cl_to 
                                                                 from categorylinks as cl1 
                                                                 inner join (select page_id 
                                                                             from page 
                                                                             where page_title = "Berlin"
                                                                             and page_namespace = 14 limit 1) as p
                                                                 on cl1.cl_from = p.page_id
                                                                 and not "Hidden_categories" in (select cl2.cl_to 
                                                                                                 from categorylinks as cl2
                                                                                                 where cl_from = (select page_id 
                                                                                                                  from page 
                                                                                                                  where page_title = cl1.cl_to
                                                                                                                  and page_namespace = 14 
                                                                                                                  limit 1)
                                                                                                )
                                                                )
                                            and page_namespace = 14
                                           ) as p
                                           on cl1.cl_from = p.page_id
                                and not "Hidden_categories" in (select cl2.cl_to 
                                                                from categorylinks as cl2
                                                                where cl_from = (select page_id 
                                                                                 from page 
                                                                                 where page_title = cl1.cl_to
                                                                                 and page_namespace = 14 
                                                                                 limit 1)
                                                               )
                                )
            and page_namespace = 14
           ) as p
           on cl1.cl_from = p.page_id
and not "Hidden_categories" in (select cl2.cl_to 
                                from categorylinks as cl2
                                where cl_from = (select page_id 
                                                 from page 
                                                 where page_title = cl1.cl_to
                                                 and page_namespace = 14 
                                                 limit 1)
                               )
;
SQL

Checking query status...
