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 = 63425067
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 = 22904974
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 = 2357285
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 = 1221396
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 = 30752589
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 = 18996908
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 = 31023778
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 = 63113361
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 = 33548254
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 = 5976008
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 = 18842308
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 = 208174
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 = 21978607
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 = 19386149
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 = 17865484
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 = 20653
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 = 59126
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 = 61709
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 = 215780
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 = 360547
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 = 52008960
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 = 61130541
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 = 1917971
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 = 14539
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 = 63464189
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 = 64516
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 = 16115172
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 = 31591547
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 = 436179
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 = 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 = 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 = 454886
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 = 18053217
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 = 670555
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 = 63052506
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 = 14498090
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 = 21926410
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 = 668442
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 = 17015795
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 = 87315
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 = 3524766
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 = 20819040
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 = 63439883
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 = 5796
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 = 5897742
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 = 62750956
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 = 34346577
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 = 510588
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 = 236918
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 = 26235206
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 = 55797013
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 = 33068119
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 = 61300695
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 = 28508507
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 = 59813559
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 = 182053
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 = 90451
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 = 14543
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 = 11022453
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 = 9096372
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 = 185166
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 = 1192600
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 = 48304081
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 = 23523100
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 = 324683
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 = 173129
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 = 7093932
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 = 63430722
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 = 28682
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 = 8135890
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 = 60915010
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 = 38687734
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 = 2889173
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 = 63319438
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 = 1212
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 = 29271794
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 = 44501
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 = 21221594
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 = 2501674
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 = 702945
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 = 786283
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 = 57061150
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 = 147999
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 = 40047992
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 = 46788290
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 = 59860703
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 = 5165
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 = 27378494
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 = 59352
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 = 54393556
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 = 72487
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...
