Get parents - Quarry

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

SQL

select cl1.cl_to 
from categorylinks as cl1 
inner join (select page_id 
            from page 
            where page_title = "Awards"
            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)
                               )
;

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...