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
RoJan94
.
Toggle Highlighting
SQL
prepare com from 'select case when c7.cl_to is not null then ? end as page_id, c7.cl_to, count(*) from categorylinks c7 join (select p7.page_id from page p7 join (select c6.cl_to from categorylinks c6 join (select p6.page_id from page p6 join (select c5.cl_to from categorylinks c5 join (select p5.page_id from page p5 join (select c4.cl_to from categorylinks c4 join (select p4.page_id from page p4 join (select c3.cl_to from categorylinks c3 join (select p3.page_id from page p3 join (select c2.cl_to from categorylinks c2 join (select p2.page_id from page p2 join (select c1.cl_to from categorylinks c1 join (select p1.page_id from page p1 join (select cl_to from categorylinks where cl_from = ?) t1 on p1.page_title = t1.cl_to where p1.page_namespace = 14) t2 on c1.cl_from = t2.page_id) t3 on p2.page_title = t3.cl_to where p2.page_namespace = 14) t4 on c2.cl_from = t4.page_id) t5 on p3.page_title = t5.cl_to where p3.page_namespace = 14) t6 on c3.cl_from = t6.page_id) t7 on p4.page_title = t7.cl_to where p4.page_namespace = 14) t8 on c4.cl_from = t8.page_id) t9 on p5.page_title = t9.cl_to where p5.page_namespace = 14) t10 on c5.cl_from = t10.page_id) t11 on p6.page_title = t11.cl_to where p6.page_namespace = 14) t12 on c6.cl_from = t12.page_id) t13 on p7.page_title = t13.cl_to where p7.page_namespace = 14) t14 on c7.cl_from = t14.page_id group by c7.cl_to having c7.cl_to like "Academic_disciplines" or c7.cl_to like "Business" or c7.cl_to like "Communication" or c7.cl_to like "Concepts" or c7.cl_to like "Culture" or c7.cl_to like "Economy" or c7.cl_to like "Education" or c7.cl_to like "Energy" or c7.cl_to like "Engineering" or c7.cl_to like "Entertainment" or c7.cl_to like "Entities" or c7.cl_to like "Ethics" or c7.cl_to like "Food_and_drink" or c7.cl_to like "Geography" or c7.cl_to like "Government" or c7.cl_to like "Health" or c7.cl_to like "History" or c7.cl_to like "Human_behavior" or c7.cl_to like "Humanities" or c7.cl_to like "Information" or c7.cl_to like "Internet" or c7.cl_to like "Knowledge" or c7.cl_to like "Language" or c7.cl_to like "Law" or c7.cl_to like "Life" or c7.cl_to like "Mass_media" or c7.cl_to like "Mathematics" or c7.cl_to like "Military" or c7.cl_to like "Nature" or c7.cl_to like "People" or c7.cl_to like "Philosophy" or c7.cl_to like "Politics" or c7.cl_to like "Religion" or c7.cl_to like "Science" or c7.cl_to like "Society" or c7.cl_to like "Sports" or c7.cl_to like "Technology" or c7.cl_to like "Time" or c7.cl_to like "Universe" order by c7.cl_to'; set @num1 := 62104443; set @num2 := 62104443; execute com using @num1, @num2; set @num1 := 62104445; set @num2 := 62104445; execute com using @num1, @num2; set @num1 := 62104448; set @num2 := 62104448; execute com using @num1, @num2; set @num1 := 62104451; set @num2 := 62104451; execute com using @num1, @num2; set @num1 := 62104456; set @num2 := 62104456; execute com using @num1, @num2; set @num1 := 62104459; set @num2 := 62104459; execute com using @num1, @num2; set @num1 := 62104466; set @num2 := 62104466; execute com using @num1, @num2; set @num1 := 62104469; set @num2 := 62104469; execute com using @num1, @num2; set @num1 := 62104470; set @num2 := 62104470; execute com using @num1, @num2; set @num1 := 62104476; set @num2 := 62104476; execute com using @num1, @num2; set @num1 := 62104480; set @num2 := 62104480; execute com using @num1, @num2; set @num1 := 62104487; set @num2 := 62104487; execute com using @num1, @num2; set @num1 := 62104493; set @num2 := 62104493; execute com using @num1, @num2; set @num1 := 62104504; set @num2 := 62104504; execute com using @num1, @num2; set @num1 := 62104510; set @num2 := 62104510; execute com using @num1, @num2; set @num1 := 62104513; set @num2 := 62104513; execute com using @num1, @num2; set @num1 := 62104519; set @num2 := 62104519; execute com using @num1, @num2; set @num1 := 62104523; set @num2 := 62104523; execute com using @num1, @num2; set @num1 := 62104525; set @num2 := 62104525; execute com using @num1, @num2; set @num1 := 62104527; set @num2 := 62104527; execute com using @num1, @num2; set @num1 := 62104529; set @num2 := 62104529; execute com using @num1, @num2; set @num1 := 62104530; set @num2 := 62104530; execute com using @num1, @num2; set @num1 := 62104532; set @num2 := 62104532; execute com using @num1, @num2; set @num1 := 62104533; set @num2 := 62104533; execute com using @num1, @num2; set @num1 := 62104543; set @num2 := 62104543; execute com using @num1, @num2; set @num1 := 62104549; set @num2 := 62104549; execute com using @num1, @num2; set @num1 := 62104552; set @num2 := 62104552; execute com using @num1, @num2; set @num1 := 62104559; set @num2 := 62104559; execute com using @num1, @num2; set @num1 := 62104566; set @num2 := 62104566; execute com using @num1, @num2; set @num1 := 62104570; set @num2 := 62104570; execute com using @num1, @num2; set @num1 := 62104572; set @num2 := 62104572; execute com using @num1, @num2; set @num1 := 62104578; set @num2 := 62104578; execute com using @num1, @num2; set @num1 := 62104579; set @num2 := 62104579; execute com using @num1, @num2; set @num1 := 62104584; set @num2 := 62104584; execute com using @num1, @num2; set @num1 := 62104586; set @num2 := 62104586; execute com using @num1, @num2; set @num1 := 62104587; set @num2 := 62104587; execute com using @num1, @num2; set @num1 := 62104588; set @num2 := 62104588; execute com using @num1, @num2; set @num1 := 62104589; set @num2 := 62104589; execute com using @num1, @num2; set @num1 := 62104591; set @num2 := 62104591; execute com using @num1, @num2; set @num1 := 62104596; set @num2 := 62104596; execute com using @num1, @num2; set @num1 := 62104606; set @num2 := 62104606; execute com using @num1, @num2; set @num1 := 62104611; set @num2 := 62104611; execute com using @num1, @num2; set @num1 := 62104613; set @num2 := 62104613; execute com using @num1, @num2; set @num1 := 62104614; set @num2 := 62104614; execute com using @num1, @num2; set @num1 := 62104619; set @num2 := 62104619; execute com using @num1, @num2; set @num1 := 62104629; set @num2 := 62104629; execute com using @num1, @num2; set @num1 := 62104642; set @num2 := 62104642; execute com using @num1, @num2; set @num1 := 62104645; set @num2 := 62104645; execute com using @num1, @num2; set @num1 := 62104652; set @num2 := 62104652; execute com using @num1, @num2; set @num1 := 62104653; set @num2 := 62104653; execute com using @num1, @num2; set @num1 := 62104654; set @num2 := 62104654; execute com using @num1, @num2; set @num1 := 62104655; set @num2 := 62104655; execute com using @num1, @num2; set @num1 := 62104658; set @num2 := 62104658; execute com using @num1, @num2; set @num1 := 62104659; set @num2 := 62104659; execute com using @num1, @num2; set @num1 := 62104660; set @num2 := 62104660; execute com using @num1, @num2; set @num1 := 62104663; set @num2 := 62104663; execute com using @num1, @num2; set @num1 := 62104664; set @num2 := 62104664; execute com using @num1, @num2; set @num1 := 62104667; set @num2 := 62104667; execute com using @num1, @num2; set @num1 := 62104669; set @num2 := 62104669; execute com using @num1, @num2; set @num1 := 62104674; set @num2 := 62104674; execute com using @num1, @num2; set @num1 := 62104676; set @num2 := 62104676; execute com using @num1, @num2; set @num1 := 62104682; set @num2 := 62104682; execute com using @num1, @num2; set @num1 := 62104690; set @num2 := 62104690; execute com using @num1, @num2; set @num1 := 62104692; set @num2 := 62104692; execute com using @num1, @num2; set @num1 := 62104695; set @num2 := 62104695; execute com using @num1, @num2; set @num1 := 62104697; set @num2 := 62104697; execute com using @num1, @num2; set @num1 := 62104703; set @num2 := 62104703; execute com using @num1, @num2; set @num1 := 62104707; set @num2 := 62104707; execute com using @num1, @num2; set @num1 := 62104712; set @num2 := 62104712; execute com using @num1, @num2; set @num1 := 62104716; set @num2 := 62104716; execute com using @num1, @num2; set @num1 := 62104717; set @num2 := 62104717; execute com using @num1, @num2; set @num1 := 62104723; set @num2 := 62104723; execute com using @num1, @num2; set @num1 := 62104724; set @num2 := 62104724; execute com using @num1, @num2; set @num1 := 62104725; set @num2 := 62104725; execute com using @num1, @num2; set @num1 := 62104730; set @num2 := 62104730; execute com using @num1, @num2; set @num1 := 62104731; set @num2 := 62104731; execute com using @num1, @num2; set @num1 := 62104737; set @num2 := 62104737; execute com using @num1, @num2; set @num1 := 62104744; set @num2 := 62104744; execute com using @num1, @num2; set @num1 := 62104751; set @num2 := 62104751; execute com using @num1, @num2; set @num1 := 62104752; set @num2 := 62104752; execute com using @num1, @num2; set @num1 := 62104762; set @num2 := 62104762; execute com using @num1, @num2; set @num1 := 62104770; set @num2 := 62104770; execute com using @num1, @num2; set @num1 := 62104774; set @num2 := 62104774; execute com using @num1, @num2; set @num1 := 62104784; set @num2 := 62104784; execute com using @num1, @num2; set @num1 := 62104786; set @num2 := 62104786; execute com using @num1, @num2; set @num1 := 62104795; set @num2 := 62104795; execute com using @num1, @num2; set @num1 := 62104806; set @num2 := 62104806; execute com using @num1, @num2; set @num1 := 62104810; set @num2 := 62104810; execute com using @num1, @num2; set @num1 := 62104813; set @num2 := 62104813; execute com using @num1, @num2; set @num1 := 62104816; set @num2 := 62104816; execute com using @num1, @num2; set @num1 := 62104817; set @num2 := 62104817; execute com using @num1, @num2; set @num1 := 62104818; set @num2 := 62104818; execute com using @num1, @num2; set @num1 := 62104819; set @num2 := 62104819; execute com using @num1, @num2; set @num1 := 62104825; set @num2 := 62104825; execute com using @num1, @num2; set @num1 := 62104826; set @num2 := 62104826; execute com using @num1, @num2; set @num1 := 62104827; set @num2 := 62104827; execute com using @num1, @num2; set @num1 := 62104829; set @num2 := 62104829; execute com using @num1, @num2; set @num1 := 62104830; set @num2 := 62104830; execute com using @num1, @num2; set @num1 := 62104831; set @num2 := 62104831; execute com using @num1, @num2; set @num1 := 62104832; set @num2 := 62104832; execute com using @num1, @num2; set @num1 := 62104833; set @num2 := 62104833; execute com using @num1, @num2; set @num1 := 62104835; set @num2 := 62104835; execute com using @num1, @num2; set @num1 := 62104836; set @num2 := 62104836; execute com using @num1, @num2; set @num1 := 62104840; set @num2 := 62104840; execute com using @num1, @num2; set @num1 := 62104841; set @num2 := 62104841; execute com using @num1, @num2; set @num1 := 62104843; set @num2 := 62104843; execute com using @num1, @num2; set @num1 := 62104845; set @num2 := 62104845; execute com using @num1, @num2; set @num1 := 62104852; set @num2 := 62104852; execute com using @num1, @num2; set @num1 := 62104854; set @num2 := 62104854; execute com using @num1, @num2; set @num1 := 62104855; set @num2 := 62104855; execute com using @num1, @num2; set @num1 := 62104865; set @num2 := 62104865; execute com using @num1, @num2; set @num1 := 62104870; set @num2 := 62104870; execute com using @num1, @num2; set @num1 := 62104872; set @num2 := 62104872; execute com using @num1, @num2; set @num1 := 62104873; set @num2 := 62104873; execute com using @num1, @num2; set @num1 := 62104875; set @num2 := 62104875; execute com using @num1, @num2; set @num1 := 62104877; set @num2 := 62104877; execute com using @num1, @num2; set @num1 := 62104880; set @num2 := 62104880; execute com using @num1, @num2; set @num1 := 62104882; set @num2 := 62104882; execute com using @num1, @num2; set @num1 := 62104885; set @num2 := 62104885; execute com using @num1, @num2; set @num1 := 62104887; set @num2 := 62104887; execute com using @num1, @num2; set @num1 := 62104890; set @num2 := 62104890; execute com using @num1, @num2; set @num1 := 62104891; set @num2 := 62104891; execute com using @num1, @num2; set @num1 := 62104892; set @num2 := 62104892; execute com using @num1, @num2; set @num1 := 62104894; set @num2 := 62104894; execute com using @num1, @num2; set @num1 := 62104895; set @num2 := 62104895; execute com using @num1, @num2; set @num1 := 62104899; set @num2 := 62104899; execute com using @num1, @num2; set @num1 := 62104900; set @num2 := 62104900; execute com using @num1, @num2; set @num1 := 62104901; set @num2 := 62104901; execute com using @num1, @num2; set @num1 := 62104903; set @num2 := 62104903; execute com using @num1, @num2; set @num1 := 62104907; set @num2 := 62104907; execute com using @num1, @num2; set @num1 := 62104910; set @num2 := 62104910; execute com using @num1, @num2; set @num1 := 62104913; set @num2 := 62104913; execute com using @num1, @num2; set @num1 := 62104914; set @num2 := 62104914; execute com using @num1, @num2; set @num1 := 62104915; set @num2 := 62104915; execute com using @num1, @num2; set @num1 := 62104916; set @num2 := 62104916; execute com using @num1, @num2; set @num1 := 62104917; set @num2 := 62104917; execute com using @num1, @num2; set @num1 := 62104918; set @num2 := 62104918; execute com using @num1, @num2; set @num1 := 62104919; set @num2 := 62104919; execute com using @num1, @num2; set @num1 := 62104924; set @num2 := 62104924; execute com using @num1, @num2; set @num1 := 62104925; set @num2 := 62104925; execute com using @num1, @num2; set @num1 := 62104927; set @num2 := 62104927; execute com using @num1, @num2; set @num1 := 62104928; set @num2 := 62104928; execute com using @num1, @num2; set @num1 := 62104929; set @num2 := 62104929; execute com using @num1, @num2; set @num1 := 62104931; set @num2 := 62104931; execute com using @num1, @num2; set @num1 := 62104934; set @num2 := 62104934; execute com using @num1, @num2; set @num1 := 62104936; set @num2 := 62104936; execute com using @num1, @num2; set @num1 := 62104948; set @num2 := 62104948; execute com using @num1, @num2; set @num1 := 62104950; set @num2 := 62104950; execute com using @num1, @num2; set @num1 := 62104955; set @num2 := 62104955; execute com using @num1, @num2; set @num1 := 62104957; set @num2 := 62104957; execute com using @num1, @num2; set @num1 := 62104960; set @num2 := 62104960; execute com using @num1, @num2; set @num1 := 62104963; set @num2 := 62104963; execute com using @num1, @num2; set @num1 := 62104972; set @num2 := 62104972; execute com using @num1, @num2; set @num1 := 62104974; set @num2 := 62104974; execute com using @num1, @num2; set @num1 := 62104977; set @num2 := 62104977; execute com using @num1, @num2; set @num1 := 62104978; set @num2 := 62104978; execute com using @num1, @num2; set @num1 := 62104983; set @num2 := 62104983; execute com using @num1, @num2; set @num1 := 62104987; set @num2 := 62104987; execute com using @num1, @num2; set @num1 := 62104989; set @num2 := 62104989; execute com using @num1, @num2; set @num1 := 62104999; set @num2 := 62104999; execute com using @num1, @num2; set @num1 := 62105005; set @num2 := 62105005; execute com using @num1, @num2; set @num1 := 62105006; set @num2 := 62105006; execute com using @num1, @num2; set @num1 := 62105008; set @num2 := 62105008; execute com using @num1, @num2; set @num1 := 62105017; set @num2 := 62105017; execute com using @num1, @num2;
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...