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 := 18740; set @num2 := 18740; execute com using @num1, @num2; set @num1 := 173615; set @num2 := 173615; execute com using @num1, @num2; set @num1 := 208105; set @num2 := 208105; execute com using @num1, @num2; set @num1 := 277991; set @num2 := 277991; execute com using @num1, @num2; set @num1 := 894279; set @num2 := 894279; execute com using @num1, @num2; set @num1 := 922983; set @num2 := 922983; execute com using @num1, @num2; set @num1 := 949012; set @num2 := 949012; execute com using @num1, @num2; set @num1 := 958136; set @num2 := 958136; execute com using @num1, @num2; set @num1 := 1016247; set @num2 := 1016247; execute com using @num1, @num2; set @num1 := 1264561; set @num2 := 1264561; execute com using @num1, @num2; set @num1 := 1274067; set @num2 := 1274067; execute com using @num1, @num2; set @num1 := 1349209; set @num2 := 1349209; execute com using @num1, @num2; set @num1 := 1349225; set @num2 := 1349225; execute com using @num1, @num2; set @num1 := 1492438; set @num2 := 1492438; execute com using @num1, @num2; set @num1 := 1579988; set @num2 := 1579988; execute com using @num1, @num2; set @num1 := 1664920; set @num2 := 1664920; execute com using @num1, @num2; set @num1 := 1701224; set @num2 := 1701224; execute com using @num1, @num2; set @num1 := 1703386; set @num2 := 1703386; execute com using @num1, @num2; set @num1 := 1727194; set @num2 := 1727194; execute com using @num1, @num2; set @num1 := 1737496; set @num2 := 1737496; execute com using @num1, @num2; set @num1 := 1741490; set @num2 := 1741490; execute com using @num1, @num2; set @num1 := 1897875; set @num2 := 1897875; execute com using @num1, @num2; set @num1 := 1897921; set @num2 := 1897921; execute com using @num1, @num2; set @num1 := 1929385; set @num2 := 1929385; execute com using @num1, @num2; set @num1 := 2226608; set @num2 := 2226608; execute com using @num1, @num2; set @num1 := 2450450; set @num2 := 2450450; execute com using @num1, @num2; set @num1 := 2519608; set @num2 := 2519608; execute com using @num1, @num2; set @num1 := 2549096; set @num2 := 2549096; execute com using @num1, @num2; set @num1 := 2575459; set @num2 := 2575459; execute com using @num1, @num2; set @num1 := 2599854; set @num2 := 2599854; execute com using @num1, @num2; set @num1 := 2833960; set @num2 := 2833960; execute com using @num1, @num2; set @num1 := 2836350; set @num2 := 2836350; execute com using @num1, @num2; set @num1 := 3013521; set @num2 := 3013521; execute com using @num1, @num2; set @num1 := 3163686; set @num2 := 3163686; execute com using @num1, @num2; set @num1 := 3479343; set @num2 := 3479343; execute com using @num1, @num2; set @num1 := 3531074; set @num2 := 3531074; execute com using @num1, @num2; set @num1 := 12860845; set @num2 := 12860845; execute com using @num1, @num2; set @num1 := 18457271; set @num2 := 18457271; execute com using @num1, @num2; set @num1 := 21492894; set @num2 := 21492894; execute com using @num1, @num2; set @num1 := 32959431; set @num2 := 32959431; execute com using @num1, @num2; set @num1 := 73717042; set @num2 := 73717042; execute com using @num1, @num2; set @num1 := 73777642; set @num2 := 73777642; 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...