Hewiki radio - Quarry

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

SQL

select * from hewiki_p.categorylinks as c3
  where c3.cl_from = 78194
  and exists
       (select * from page as p4
        where c3.cl_to = p4.page_title
        and p4.page_namespace = 14
        and exists
        (select * from categorylinks as c4
         where c4.cl_from = p4.page_id
               and c4.cl_to = @t))

​x
 
select * from hewiki_p.categorylinks as c3  where c3.cl_from = 78194  and exists       (select * from page as p4        where c3.cl_to = p4.page_title        and p4.page_namespace = 14        and exists        (select * from categorylinks as c4         where c4.cl_from = p4.page_id               and c4.cl_to = @t))​

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.

Checking query status...