Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Airklizz
.
Toggle Highlighting
SQL
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 = 721002 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 = 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 = 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 = 56822861 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 = 63550143 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 = 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 = 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 = 2323738 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 = 66936 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 = 980548 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 = 52001590 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 = 167409 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 = 63265538 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 = 1345842 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 = 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 = 631190 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 = 1605759 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 = 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 = 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 = 489387 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 = 52132287 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 = 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 = 917917 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 = 159727 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 = 75253 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 = 253413 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 = 1806 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 = 59720 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 = 300594 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 = 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 = 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 = 61272 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 = 48029919 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 = 187851 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 = 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 = 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 = 5271646 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 = 174871 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 = 7928372 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 = 40007698 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 = 2084 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 = 45286 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 = 1428362 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 = 47200458 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 = 2643914 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 = 21572345 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 = 44302 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 = 320852 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 = 1922114 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 = 55389995 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 = 6811 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 = 1622547 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 = 28298532 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 = 76176 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 = 12651353 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 = 48613465 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 = 94380 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 = 37235 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
.
Checking query status...