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 := 16524964; set @num2 := 16524964; execute com using @num1, @num2; set @num1 := 16525132; set @num2 := 16525132; execute com using @num1, @num2; set @num1 := 16525888; set @num2 := 16525888; execute com using @num1, @num2; set @num1 := 16526215; set @num2 := 16526215; execute com using @num1, @num2; set @num1 := 16526222; set @num2 := 16526222; execute com using @num1, @num2; set @num1 := 16526699; set @num2 := 16526699; execute com using @num1, @num2; set @num1 := 16526762; set @num2 := 16526762; execute com using @num1, @num2; set @num1 := 16527120; set @num2 := 16527120; execute com using @num1, @num2; set @num1 := 16527218; set @num2 := 16527218; execute com using @num1, @num2; set @num1 := 16527449; set @num2 := 16527449; execute com using @num1, @num2; set @num1 := 16527560; set @num2 := 16527560; execute com using @num1, @num2; set @num1 := 16527578; set @num2 := 16527578; execute com using @num1, @num2; set @num1 := 16527640; set @num2 := 16527640; execute com using @num1, @num2; set @num1 := 16527823; set @num2 := 16527823; execute com using @num1, @num2; set @num1 := 16527833; set @num2 := 16527833; execute com using @num1, @num2; set @num1 := 16527939; set @num2 := 16527939; execute com using @num1, @num2; set @num1 := 16527949; set @num2 := 16527949; execute com using @num1, @num2; set @num1 := 16528237; set @num2 := 16528237; execute com using @num1, @num2; set @num1 := 16528921; set @num2 := 16528921; execute com using @num1, @num2; set @num1 := 16528963; set @num2 := 16528963; execute com using @num1, @num2; set @num1 := 16528972; set @num2 := 16528972; execute com using @num1, @num2; set @num1 := 16529033; set @num2 := 16529033; execute com using @num1, @num2; set @num1 := 16529369; set @num2 := 16529369; execute com using @num1, @num2; set @num1 := 16529594; set @num2 := 16529594; execute com using @num1, @num2; set @num1 := 16529957; set @num2 := 16529957; execute com using @num1, @num2; set @num1 := 16530777; set @num2 := 16530777; execute com using @num1, @num2; set @num1 := 16531083; set @num2 := 16531083; execute com using @num1, @num2; set @num1 := 16531455; set @num2 := 16531455; execute com using @num1, @num2; set @num1 := 16532780; set @num2 := 16532780; execute com using @num1, @num2; set @num1 := 16533067; set @num2 := 16533067; execute com using @num1, @num2; set @num1 := 16533091; set @num2 := 16533091; execute com using @num1, @num2; set @num1 := 16533094; set @num2 := 16533094; execute com using @num1, @num2; set @num1 := 16533136; set @num2 := 16533136; execute com using @num1, @num2; set @num1 := 16533638; set @num2 := 16533638; execute com using @num1, @num2; set @num1 := 16533683; set @num2 := 16533683; execute com using @num1, @num2; set @num1 := 16533999; set @num2 := 16533999; execute com using @num1, @num2; set @num1 := 16534191; set @num2 := 16534191; execute com using @num1, @num2; set @num1 := 16534594; set @num2 := 16534594; execute com using @num1, @num2; set @num1 := 16535441; set @num2 := 16535441; execute com using @num1, @num2; set @num1 := 16535444; set @num2 := 16535444; execute com using @num1, @num2; set @num1 := 16536131; set @num2 := 16536131; execute com using @num1, @num2; set @num1 := 16536249; set @num2 := 16536249; execute com using @num1, @num2; set @num1 := 16536311; set @num2 := 16536311; execute com using @num1, @num2; set @num1 := 16536625; set @num2 := 16536625; execute com using @num1, @num2; set @num1 := 16536746; set @num2 := 16536746; execute com using @num1, @num2; set @num1 := 16537551; set @num2 := 16537551; execute com using @num1, @num2; set @num1 := 16537645; set @num2 := 16537645; execute com using @num1, @num2; set @num1 := 16537883; set @num2 := 16537883; execute com using @num1, @num2; set @num1 := 16537960; set @num2 := 16537960; execute com using @num1, @num2; set @num1 := 16538134; set @num2 := 16538134; execute com using @num1, @num2; set @num1 := 16538279; set @num2 := 16538279; execute com using @num1, @num2; set @num1 := 16539120; set @num2 := 16539120; execute com using @num1, @num2; set @num1 := 16539344; set @num2 := 16539344; execute com using @num1, @num2; set @num1 := 16539649; set @num2 := 16539649; execute com using @num1, @num2; set @num1 := 16540142; set @num2 := 16540142; execute com using @num1, @num2; set @num1 := 16540256; set @num2 := 16540256; execute com using @num1, @num2; set @num1 := 16540302; set @num2 := 16540302; execute com using @num1, @num2; set @num1 := 16540346; set @num2 := 16540346; execute com using @num1, @num2; set @num1 := 16540432; set @num2 := 16540432; execute com using @num1, @num2; set @num1 := 16540549; set @num2 := 16540549; execute com using @num1, @num2; set @num1 := 16540708; set @num2 := 16540708; execute com using @num1, @num2; set @num1 := 16540803; set @num2 := 16540803; execute com using @num1, @num2; set @num1 := 16541024; set @num2 := 16541024; execute com using @num1, @num2; set @num1 := 16541125; set @num2 := 16541125; execute com using @num1, @num2; set @num1 := 16541532; set @num2 := 16541532; execute com using @num1, @num2; set @num1 := 16541728; set @num2 := 16541728; execute com using @num1, @num2; set @num1 := 16541979; set @num2 := 16541979; execute com using @num1, @num2; set @num1 := 16542478; set @num2 := 16542478; execute com using @num1, @num2; set @num1 := 16543125; set @num2 := 16543125; execute com using @num1, @num2; set @num1 := 16543441; set @num2 := 16543441; execute com using @num1, @num2; set @num1 := 16543502; set @num2 := 16543502; execute com using @num1, @num2; set @num1 := 16543596; set @num2 := 16543596; execute com using @num1, @num2; set @num1 := 16543647; set @num2 := 16543647; execute com using @num1, @num2; set @num1 := 16543982; set @num2 := 16543982; execute com using @num1, @num2; set @num1 := 16544236; set @num2 := 16544236; execute com using @num1, @num2; set @num1 := 16544296; set @num2 := 16544296; execute com using @num1, @num2; set @num1 := 16544485; set @num2 := 16544485; execute com using @num1, @num2; set @num1 := 16545451; set @num2 := 16545451; execute com using @num1, @num2; set @num1 := 16545663; set @num2 := 16545663; execute com using @num1, @num2; set @num1 := 16545746; set @num2 := 16545746; execute com using @num1, @num2; set @num1 := 16545843; set @num2 := 16545843; execute com using @num1, @num2; set @num1 := 16546133; set @num2 := 16546133; execute com using @num1, @num2; set @num1 := 16546488; set @num2 := 16546488; execute com using @num1, @num2; set @num1 := 16547084; set @num2 := 16547084; execute com using @num1, @num2; set @num1 := 16547378; set @num2 := 16547378; execute com using @num1, @num2; set @num1 := 16547543; set @num2 := 16547543; execute com using @num1, @num2; set @num1 := 16547586; set @num2 := 16547586; execute com using @num1, @num2; set @num1 := 16547761; set @num2 := 16547761; execute com using @num1, @num2; set @num1 := 16547843; set @num2 := 16547843; execute com using @num1, @num2; set @num1 := 16548081; set @num2 := 16548081; execute com using @num1, @num2; set @num1 := 16548268; set @num2 := 16548268; execute com using @num1, @num2; set @num1 := 16548484; set @num2 := 16548484; execute com using @num1, @num2; set @num1 := 16548670; set @num2 := 16548670; execute com using @num1, @num2; set @num1 := 16549198; set @num2 := 16549198; execute com using @num1, @num2; set @num1 := 16549823; set @num2 := 16549823; execute com using @num1, @num2; set @num1 := 16550399; set @num2 := 16550399; execute com using @num1, @num2; set @num1 := 16550707; set @num2 := 16550707; execute com using @num1, @num2; set @num1 := 16550744; set @num2 := 16550744; execute com using @num1, @num2; set @num1 := 16550785; set @num2 := 16550785; execute com using @num1, @num2; set @num1 := 16550838; set @num2 := 16550838; execute com using @num1, @num2; set @num1 := 16551520; set @num2 := 16551520; execute com using @num1, @num2; set @num1 := 16551735; set @num2 := 16551735; execute com using @num1, @num2; set @num1 := 16552215; set @num2 := 16552215; execute com using @num1, @num2; set @num1 := 16552687; set @num2 := 16552687; execute com using @num1, @num2; set @num1 := 16553583; set @num2 := 16553583; execute com using @num1, @num2; set @num1 := 16553753; set @num2 := 16553753; execute com using @num1, @num2; set @num1 := 16553939; set @num2 := 16553939; execute com using @num1, @num2; set @num1 := 16554342; set @num2 := 16554342; execute com using @num1, @num2; set @num1 := 16554851; set @num2 := 16554851; execute com using @num1, @num2; set @num1 := 16554947; set @num2 := 16554947; execute com using @num1, @num2; set @num1 := 16555042; set @num2 := 16555042; execute com using @num1, @num2; set @num1 := 16555100; set @num2 := 16555100; execute com using @num1, @num2; set @num1 := 16555113; set @num2 := 16555113; execute com using @num1, @num2; set @num1 := 16555266; set @num2 := 16555266; execute com using @num1, @num2; set @num1 := 16555338; set @num2 := 16555338; execute com using @num1, @num2; set @num1 := 16555375; set @num2 := 16555375; execute com using @num1, @num2; set @num1 := 16555604; set @num2 := 16555604; execute com using @num1, @num2; set @num1 := 16555669; set @num2 := 16555669; execute com using @num1, @num2; set @num1 := 16555813; set @num2 := 16555813; execute com using @num1, @num2; set @num1 := 16556363; set @num2 := 16556363; execute com using @num1, @num2; set @num1 := 16556377; set @num2 := 16556377; execute com using @num1, @num2; set @num1 := 16556402; set @num2 := 16556402; execute com using @num1, @num2; set @num1 := 16556852; set @num2 := 16556852; execute com using @num1, @num2; set @num1 := 16557090; set @num2 := 16557090; execute com using @num1, @num2; set @num1 := 16557345; set @num2 := 16557345; execute com using @num1, @num2; set @num1 := 16557367; set @num2 := 16557367; execute com using @num1, @num2; set @num1 := 16557386; set @num2 := 16557386; execute com using @num1, @num2; set @num1 := 16557440; set @num2 := 16557440; execute com using @num1, @num2; set @num1 := 16557587; set @num2 := 16557587; execute com using @num1, @num2; set @num1 := 16557816; set @num2 := 16557816; execute com using @num1, @num2; set @num1 := 16558048; set @num2 := 16558048; execute com using @num1, @num2; set @num1 := 16558131; set @num2 := 16558131; execute com using @num1, @num2; set @num1 := 16558283; set @num2 := 16558283; execute com using @num1, @num2; set @num1 := 16558535; set @num2 := 16558535; execute com using @num1, @num2; set @num1 := 16558580; set @num2 := 16558580; execute com using @num1, @num2; set @num1 := 16558627; set @num2 := 16558627; execute com using @num1, @num2; set @num1 := 16558866; set @num2 := 16558866; execute com using @num1, @num2; set @num1 := 16559151; set @num2 := 16559151; execute com using @num1, @num2; set @num1 := 16559515; set @num2 := 16559515; execute com using @num1, @num2; set @num1 := 16559840; set @num2 := 16559840; execute com using @num1, @num2; set @num1 := 16559892; set @num2 := 16559892; execute com using @num1, @num2; set @num1 := 16560694; set @num2 := 16560694; execute com using @num1, @num2; set @num1 := 16560793; set @num2 := 16560793; execute com using @num1, @num2; set @num1 := 16561562; set @num2 := 16561562; execute com using @num1, @num2; set @num1 := 16561699; set @num2 := 16561699; execute com using @num1, @num2; set @num1 := 16561990; set @num2 := 16561990; execute com using @num1, @num2; set @num1 := 16562840; set @num2 := 16562840; execute com using @num1, @num2; set @num1 := 16562952; set @num2 := 16562952; execute com using @num1, @num2; set @num1 := 16563311; set @num2 := 16563311; execute com using @num1, @num2; set @num1 := 16563365; set @num2 := 16563365; execute com using @num1, @num2; set @num1 := 16563439; set @num2 := 16563439; execute com using @num1, @num2; set @num1 := 16563466; set @num2 := 16563466; execute com using @num1, @num2; set @num1 := 16563526; set @num2 := 16563526; execute com using @num1, @num2; set @num1 := 16563762; set @num2 := 16563762; execute com using @num1, @num2; set @num1 := 16563776; set @num2 := 16563776; execute com using @num1, @num2; set @num1 := 16563871; set @num2 := 16563871; execute com using @num1, @num2; set @num1 := 16564159; set @num2 := 16564159; execute com using @num1, @num2; set @num1 := 16564721; set @num2 := 16564721; execute com using @num1, @num2; set @num1 := 16564858; set @num2 := 16564858; execute com using @num1, @num2; set @num1 := 16564959; set @num2 := 16564959; execute com using @num1, @num2; set @num1 := 16565139; set @num2 := 16565139; execute com using @num1, @num2; set @num1 := 16565427; set @num2 := 16565427; execute com using @num1, @num2; set @num1 := 16565547; set @num2 := 16565547; execute com using @num1, @num2; set @num1 := 16565761; set @num2 := 16565761; execute com using @num1, @num2; set @num1 := 16565999; set @num2 := 16565999; execute com using @num1, @num2; set @num1 := 16566083; set @num2 := 16566083; execute com using @num1, @num2; set @num1 := 16566225; set @num2 := 16566225; execute com using @num1, @num2; set @num1 := 16566738; set @num2 := 16566738; execute com using @num1, @num2; set @num1 := 16566887; set @num2 := 16566887; execute com using @num1, @num2; set @num1 := 16567366; set @num2 := 16567366; execute com using @num1, @num2; set @num1 := 16567567; set @num2 := 16567567; execute com using @num1, @num2; set @num1 := 16567591; set @num2 := 16567591; execute com using @num1, @num2; set @num1 := 16567715; set @num2 := 16567715; execute com using @num1, @num2; set @num1 := 16567915; set @num2 := 16567915; execute com using @num1, @num2; set @num1 := 16568007; set @num2 := 16568007; execute com using @num1, @num2; set @num1 := 16568191; set @num2 := 16568191; execute com using @num1, @num2; set @num1 := 16568361; set @num2 := 16568361; execute com using @num1, @num2; set @num1 := 16568545; set @num2 := 16568545; execute com using @num1, @num2; set @num1 := 16568893; set @num2 := 16568893; execute com using @num1, @num2; set @num1 := 16569023; set @num2 := 16569023; execute com using @num1, @num2; set @num1 := 16569028; set @num2 := 16569028; execute com using @num1, @num2; set @num1 := 16569219; set @num2 := 16569219; execute com using @num1, @num2; set @num1 := 16569274; set @num2 := 16569274; execute com using @num1, @num2; set @num1 := 16569413; set @num2 := 16569413; execute com using @num1, @num2; set @num1 := 16569501; set @num2 := 16569501; execute com using @num1, @num2; set @num1 := 16569860; set @num2 := 16569860; execute com using @num1, @num2; set @num1 := 16569877; set @num2 := 16569877; execute com using @num1, @num2; set @num1 := 16570888; set @num2 := 16570888; execute com using @num1, @num2; set @num1 := 16571054; set @num2 := 16571054; execute com using @num1, @num2; set @num1 := 16571386; set @num2 := 16571386; execute com using @num1, @num2; set @num1 := 16571806; set @num2 := 16571806; execute com using @num1, @num2; set @num1 := 16571956; set @num2 := 16571956; execute com using @num1, @num2; set @num1 := 16572592; set @num2 := 16572592; execute com using @num1, @num2; set @num1 := 16573110; set @num2 := 16573110; execute com using @num1, @num2; set @num1 := 16573327; set @num2 := 16573327; execute com using @num1, @num2; set @num1 := 16573518; set @num2 := 16573518; execute com using @num1, @num2; set @num1 := 16573601; set @num2 := 16573601; execute com using @num1, @num2; set @num1 := 16573987; set @num2 := 16573987; execute com using @num1, @num2; set @num1 := 16574375; set @num2 := 16574375; execute com using @num1, @num2; set @num1 := 16574659; set @num2 := 16574659; execute com using @num1, @num2; set @num1 := 16574879; set @num2 := 16574879; execute com using @num1, @num2; set @num1 := 16574920; set @num2 := 16574920; execute com using @num1, @num2; set @num1 := 16575265; set @num2 := 16575265; execute com using @num1, @num2; set @num1 := 16575618; set @num2 := 16575618; execute com using @num1, @num2; set @num1 := 16576221; set @num2 := 16576221; execute com using @num1, @num2; set @num1 := 16576715; set @num2 := 16576715; execute com using @num1, @num2; set @num1 := 16576985; set @num2 := 16576985; execute com using @num1, @num2; set @num1 := 16577118; set @num2 := 16577118; execute com using @num1, @num2; set @num1 := 16577160; set @num2 := 16577160; execute com using @num1, @num2; set @num1 := 16577543; set @num2 := 16577543; execute com using @num1, @num2; set @num1 := 16577622; set @num2 := 16577622; execute com using @num1, @num2; set @num1 := 16577724; set @num2 := 16577724; execute com using @num1, @num2; set @num1 := 16578504; set @num2 := 16578504; execute com using @num1, @num2; set @num1 := 16578594; set @num2 := 16578594; execute com using @num1, @num2; set @num1 := 16578687; set @num2 := 16578687; execute com using @num1, @num2; set @num1 := 16578764; set @num2 := 16578764; execute com using @num1, @num2; set @num1 := 16578772; set @num2 := 16578772; execute com using @num1, @num2; set @num1 := 16579055; set @num2 := 16579055; execute com using @num1, @num2; set @num1 := 16579290; set @num2 := 16579290; execute com using @num1, @num2; set @num1 := 16579474; set @num2 := 16579474; execute com using @num1, @num2; set @num1 := 16579872; set @num2 := 16579872; execute com using @num1, @num2; set @num1 := 16580385; set @num2 := 16580385; execute com using @num1, @num2; set @num1 := 16580448; set @num2 := 16580448; execute com using @num1, @num2; set @num1 := 16580554; set @num2 := 16580554; execute com using @num1, @num2; set @num1 := 16580674; set @num2 := 16580674; execute com using @num1, @num2; set @num1 := 16580818; set @num2 := 16580818; execute com using @num1, @num2; set @num1 := 16581068; set @num2 := 16581068; execute com using @num1, @num2; set @num1 := 16581161; set @num2 := 16581161; execute com using @num1, @num2; set @num1 := 16581695; set @num2 := 16581695; 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...