Untitled query #44159

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

select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 63316879
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 63136490
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 25237
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 382507
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 39206
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 41790724
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 22677497
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 978044
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 24336516
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 9265773
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 4071945
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 10542070
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 1104535
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 24255
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 43358530
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 492128
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 2277678
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 481447
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 29816
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 1289409
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 673381
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 14711914
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 607572
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 24698
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 40829
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 9988187
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 292376
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 4785476
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 59252
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 19574
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 289862
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 11299
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 1294685
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 1092923
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 176681
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 32277996
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 55178
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 235534
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 214268
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 53905865
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 38714
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 23443846
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 28022
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 8474655
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 2037726
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 2306978
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 935621
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 1375104
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 389615
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 242260
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 222912
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 77173
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 38656714
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 425279
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 2530301
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 11110672
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 63204759
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 33898
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 10834
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)
                               )
;
select cl1.cl_to 
from categorylinks as cl1 
where cl_from = 578307
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...
