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 := 17086352; set @num2 := 17086352; execute com using @num1, @num2; set @num1 := 17086602; set @num2 := 17086602; execute com using @num1, @num2; set @num1 := 17086666; set @num2 := 17086666; execute com using @num1, @num2; set @num1 := 17087685; set @num2 := 17087685; execute com using @num1, @num2; set @num1 := 17088693; set @num2 := 17088693; execute com using @num1, @num2; set @num1 := 17088705; set @num2 := 17088705; execute com using @num1, @num2; set @num1 := 17088831; set @num2 := 17088831; execute com using @num1, @num2; set @num1 := 17088855; set @num2 := 17088855; execute com using @num1, @num2; set @num1 := 17088960; set @num2 := 17088960; execute com using @num1, @num2; set @num1 := 17089103; set @num2 := 17089103; execute com using @num1, @num2; set @num1 := 17089472; set @num2 := 17089472; execute com using @num1, @num2; set @num1 := 17089501; set @num2 := 17089501; execute com using @num1, @num2; set @num1 := 17089516; set @num2 := 17089516; execute com using @num1, @num2; set @num1 := 17090038; set @num2 := 17090038; execute com using @num1, @num2; set @num1 := 17090158; set @num2 := 17090158; execute com using @num1, @num2; set @num1 := 17090217; set @num2 := 17090217; execute com using @num1, @num2; set @num1 := 17090356; set @num2 := 17090356; execute com using @num1, @num2; set @num1 := 17090711; set @num2 := 17090711; execute com using @num1, @num2; set @num1 := 17090780; set @num2 := 17090780; execute com using @num1, @num2; set @num1 := 17090953; set @num2 := 17090953; execute com using @num1, @num2; set @num1 := 17090987; set @num2 := 17090987; execute com using @num1, @num2; set @num1 := 17090993; set @num2 := 17090993; execute com using @num1, @num2; set @num1 := 17091314; set @num2 := 17091314; execute com using @num1, @num2; set @num1 := 17091381; set @num2 := 17091381; execute com using @num1, @num2; set @num1 := 17091424; set @num2 := 17091424; execute com using @num1, @num2; set @num1 := 17091617; set @num2 := 17091617; execute com using @num1, @num2; set @num1 := 17091675; set @num2 := 17091675; execute com using @num1, @num2; set @num1 := 17092118; set @num2 := 17092118; execute com using @num1, @num2; set @num1 := 17092376; set @num2 := 17092376; execute com using @num1, @num2; set @num1 := 17092396; set @num2 := 17092396; execute com using @num1, @num2; set @num1 := 17092415; set @num2 := 17092415; execute com using @num1, @num2; set @num1 := 17092445; set @num2 := 17092445; execute com using @num1, @num2; set @num1 := 17092585; set @num2 := 17092585; execute com using @num1, @num2; set @num1 := 17092891; set @num2 := 17092891; execute com using @num1, @num2; set @num1 := 17092993; set @num2 := 17092993; execute com using @num1, @num2; set @num1 := 17093100; set @num2 := 17093100; execute com using @num1, @num2; set @num1 := 17093119; set @num2 := 17093119; execute com using @num1, @num2; set @num1 := 17093263; set @num2 := 17093263; execute com using @num1, @num2; set @num1 := 17093279; set @num2 := 17093279; execute com using @num1, @num2; set @num1 := 17093286; set @num2 := 17093286; execute com using @num1, @num2; set @num1 := 17093454; set @num2 := 17093454; execute com using @num1, @num2; set @num1 := 17093490; set @num2 := 17093490; execute com using @num1, @num2; set @num1 := 17093494; set @num2 := 17093494; execute com using @num1, @num2; set @num1 := 17093549; set @num2 := 17093549; execute com using @num1, @num2; set @num1 := 17093921; set @num2 := 17093921; execute com using @num1, @num2; set @num1 := 17093959; set @num2 := 17093959; execute com using @num1, @num2; set @num1 := 17094194; set @num2 := 17094194; execute com using @num1, @num2; set @num1 := 17094232; set @num2 := 17094232; execute com using @num1, @num2; set @num1 := 17094862; set @num2 := 17094862; execute com using @num1, @num2; set @num1 := 17095000; set @num2 := 17095000; execute com using @num1, @num2; set @num1 := 17095045; set @num2 := 17095045; execute com using @num1, @num2; set @num1 := 17095557; set @num2 := 17095557; execute com using @num1, @num2; set @num1 := 17095735; set @num2 := 17095735; execute com using @num1, @num2; set @num1 := 17095740; set @num2 := 17095740; execute com using @num1, @num2; set @num1 := 17095933; set @num2 := 17095933; execute com using @num1, @num2; set @num1 := 17096085; set @num2 := 17096085; execute com using @num1, @num2; set @num1 := 17096183; set @num2 := 17096183; execute com using @num1, @num2; set @num1 := 17096374; set @num2 := 17096374; execute com using @num1, @num2; set @num1 := 17096437; set @num2 := 17096437; execute com using @num1, @num2; set @num1 := 17096806; set @num2 := 17096806; execute com using @num1, @num2; set @num1 := 17096874; set @num2 := 17096874; execute com using @num1, @num2; set @num1 := 17096905; set @num2 := 17096905; execute com using @num1, @num2; set @num1 := 17096910; set @num2 := 17096910; execute com using @num1, @num2; set @num1 := 17097277; set @num2 := 17097277; execute com using @num1, @num2; set @num1 := 17097303; set @num2 := 17097303; execute com using @num1, @num2; set @num1 := 17097528; set @num2 := 17097528; execute com using @num1, @num2; set @num1 := 17097555; set @num2 := 17097555; execute com using @num1, @num2; set @num1 := 17097662; set @num2 := 17097662; execute com using @num1, @num2; set @num1 := 17097666; set @num2 := 17097666; execute com using @num1, @num2; set @num1 := 17097726; set @num2 := 17097726; execute com using @num1, @num2; set @num1 := 17098220; set @num2 := 17098220; execute com using @num1, @num2; set @num1 := 17098327; set @num2 := 17098327; execute com using @num1, @num2; set @num1 := 17098452; set @num2 := 17098452; execute com using @num1, @num2; set @num1 := 17098738; set @num2 := 17098738; execute com using @num1, @num2; set @num1 := 17099208; set @num2 := 17099208; execute com using @num1, @num2; set @num1 := 17099271; set @num2 := 17099271; execute com using @num1, @num2; set @num1 := 17099311; set @num2 := 17099311; execute com using @num1, @num2; set @num1 := 17099327; set @num2 := 17099327; execute com using @num1, @num2; set @num1 := 17099404; set @num2 := 17099404; execute com using @num1, @num2; set @num1 := 17099417; set @num2 := 17099417; execute com using @num1, @num2; set @num1 := 17099445; set @num2 := 17099445; execute com using @num1, @num2; set @num1 := 17099516; set @num2 := 17099516; execute com using @num1, @num2; set @num1 := 17099579; set @num2 := 17099579; execute com using @num1, @num2; set @num1 := 17099647; set @num2 := 17099647; execute com using @num1, @num2; set @num1 := 17099663; set @num2 := 17099663; execute com using @num1, @num2; set @num1 := 17099689; set @num2 := 17099689; execute com using @num1, @num2; set @num1 := 17099795; set @num2 := 17099795; execute com using @num1, @num2; set @num1 := 17099977; set @num2 := 17099977; execute com using @num1, @num2; set @num1 := 17100042; set @num2 := 17100042; execute com using @num1, @num2; set @num1 := 17100103; set @num2 := 17100103; execute com using @num1, @num2; set @num1 := 17100238; set @num2 := 17100238; execute com using @num1, @num2; set @num1 := 17100336; set @num2 := 17100336; execute com using @num1, @num2; set @num1 := 17100379; set @num2 := 17100379; execute com using @num1, @num2; set @num1 := 17100455; set @num2 := 17100455; execute com using @num1, @num2; set @num1 := 17100549; set @num2 := 17100549; execute com using @num1, @num2; set @num1 := 17100556; set @num2 := 17100556; execute com using @num1, @num2; set @num1 := 17101358; set @num2 := 17101358; execute com using @num1, @num2; set @num1 := 17101398; set @num2 := 17101398; execute com using @num1, @num2; set @num1 := 17101400; set @num2 := 17101400; 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...