Untitled query #70487

SQL

/*select *
from categorylinks
where cl_from = 780754*/

select *
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
                 order by p1.page_title
                 limit 1) t2 on c1.cl_from = t2.page_id
           order by c1.cl_to
           limit 1) t3 on p2.page_title = t3.cl_to
     where p2.page_namespace = 14
     order by p2.page_title) t4 on c2.cl_from = t4.page_id
order by c2.cl_to
SQL

Checking query status...
