SQL
AخA
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 := 15890;
set @num2 := 15890;
execute com using @num1, @num2;
set @num1 := 15892;
set @num2 := 15892;
execute com using @num1, @num2;
set @num1 := 15893;
set @num2 := 15893;
execute com using @num1, @num2;
set @num1 := 15898;
set @num2 := 15898;
execute com using @num1, @num2;
set @num1 := 15904;
set @num2 := 15904;
execute com using @num1, @num2;
set @num1 := 15907;
set @num2 := 15907;
execute com using @num1, @num2;
set @num1 := 15908;
set @num2 := 15908;
execute com using @num1, @num2;
set @num1 := 15911;
set @num2 := 15911;
execute com using @num1, @num2;
set @num1 := 15912;
set @num2 := 15912;
execute com using @num1, @num2;
set @num1 := 15915;
set @num2 := 15915;
execute com using @num1, @num2;
set @num1 := 15916;
set @num2 := 15916;
execute com using @num1, @num2;
set @num1 := 15918;
set @num2 := 15918;
execute com using @num1, @num2;
set @num1 := 15919;
set @num2 := 15919;
execute com using @num1, @num2;
set @num1 := 15920;
set @num2 := 15920;
execute com using @num1, @num2;
set @num1 := 15922;
set @num2 := 15922;
execute com using @num1, @num2;
set @num1 := 15923;
set @num2 := 15923;
execute com using @num1, @num2;
set @num1 := 15924;
set @num2 := 15924;
execute com using @num1, @num2;
set @num1 := 15925;
set @num2 := 15925;
execute com using @num1, @num2;
set @num1 := 15927;
set @num2 := 15927;
execute com using @num1, @num2;
set @num1 := 15928;
set @num2 := 15928;
execute com using @num1, @num2;
set @num1 := 15930;
set @num2 := 15930;
execute com using @num1, @num2;
set @num1 := 15935;
set @num2 := 15935;
execute com using @num1, @num2;
set @num1 := 15936;
set @num2 := 15936;
execute com using @num1, @num2;
set @num1 := 15937;
set @num2 := 15937;
execute com using @num1, @num2;
set @num1 := 15940;
set @num2 := 15940;
execute com using @num1, @num2;
set @num1 := 15941;
set @num2 := 15941;
execute com using @num1, @num2;
set @num1 := 15942;
set @num2 := 15942;
execute com using @num1, @num2;
set @num1 := 15943;
set @num2 := 15943;
execute com using @num1, @num2;
set @num1 := 15944;
set @num2 := 15944;
execute com using @num1, @num2;
set @num1 := 15947;
set @num2 := 15947;
execute com using @num1, @num2;
set @num1 := 15948;
set @num2 := 15948;
execute com using @num1, @num2;
set @num1 := 15949;
set @num2 := 15949;
execute com using @num1, @num2;
set @num1 := 15950;
set @num2 := 15950;
execute com using @num1, @num2;
set @num1 := 15954;
set @num2 := 15954;
execute com using @num1, @num2;
set @num1 := 15960;
set @num2 := 15960;
execute com using @num1, @num2;
set @num1 := 15963;
set @num2 := 15963;
execute com using @num1, @num2;
set @num1 := 15965;
set @num2 := 15965;
execute com using @num1, @num2;
set @num1 := 15967;
set @num2 := 15967;
execute com using @num1, @num2;
set @num1 := 15968;
set @num2 := 15968;
execute com using @num1, @num2;
set @num1 := 15971;
set @num2 := 15971;
execute com using @num1, @num2;
set @num1 := 15974;
set @num2 := 15974;
execute com using @num1, @num2;
set @num1 := 15975;
set @num2 := 15975;
execute com using @num1, @num2;
set @num1 := 15976;
set @num2 := 15976;
execute com using @num1, @num2;
set @num1 := 15978;
set @num2 := 15978;
execute com using @num1, @num2;
set @num1 := 15980;
set @num2 := 15980;
execute com using @num1, @num2;
set @num1 := 15982;
set @num2 := 15982;
execute com using @num1, @num2;
set @num1 := 15986;
set @num2 := 15986;
execute com using @num1, @num2;
set @num1 := 15987;
set @num2 := 15987;
execute com using @num1, @num2;
set @num1 := 15988;
set @num2 := 15988;
execute com using @num1, @num2;
set @num1 := 15990;
set @num2 := 15990;
execute com using @num1, @num2;
set @num1 := 15992;
set @num2 := 15992;
execute com using @num1, @num2;
set @num1 := 15993;
set @num2 := 15993;
execute com using @num1, @num2;
set @num1 := 15996;
set @num2 := 15996;
execute com using @num1, @num2;
set @num1 := 16005;
set @num2 := 16005;
execute com using @num1, @num2;
set @num1 := 16010;
set @num2 := 16010;
execute com using @num1, @num2;
set @num1 := 16011;
set @num2 := 16011;
execute com using @num1, @num2;
set @num1 := 16016;
set @num2 := 16016;
execute com using @num1, @num2;
set @num1 := 16017;
set @num2 := 16017;
execute com using @num1, @num2;
set @num1 := 16018;
set @num2 := 16018;
execute com using @num1, @num2;
set @num1 := 16020;
set @num2 := 16020;
execute com using @num1, @num2;
set @num1 := 16021;
set @num2 := 16021;
execute com using @num1, @num2;
set @num1 := 16022;
set @num2 := 16022;
execute com using @num1, @num2;
set @num1 := 16023;
set @num2 := 16023;
execute com using @num1, @num2;
set @num1 := 16024;
set @num2 := 16024;
execute com using @num1, @num2;
set @num1 := 16025;
set @num2 := 16025;
execute com using @num1, @num2;
set @num1 := 16027;
set @num2 := 16027;
execute com using @num1, @num2;
set @num1 := 16028;
set @num2 := 16028;
execute com using @num1, @num2;
set @num1 := 16032;
set @num2 := 16032;
execute com using @num1, @num2;
set @num1 := 16036;
set @num2 := 16036;
execute com using @num1, @num2;
set @num1 := 16037;
set @num2 := 16037;
execute com using @num1, @num2;
set @num1 := 16040;
set @num2 := 16040;
execute com using @num1, @num2;
set @num1 := 16043;
set @num2 := 16043;
execute com using @num1, @num2;
set @num1 := 16044;
set @num2 := 16044;
execute com using @num1, @num2;
set @num1 := 16045;
set @num2 := 16045;
execute com using @num1, @num2;
set @num1 := 16046;
set @num2 := 16046;
execute com using @num1, @num2;
set @num1 := 16053;
set @num2 := 16053;
execute com using @num1, @num2;
set @num1 := 16069;
set @num2 := 16069;
execute com using @num1, @num2;
set @num1 := 16074;
set @num2 := 16074;
execute com using @num1, @num2;
set @num1 := 16075;
set @num2 := 16075;
execute com using @num1, @num2;
set @num1 := 16076;
set @num2 := 16076;
execute com using @num1, @num2;
set @num1 := 16078;
set @num2 := 16078;
execute com using @num1, @num2;
set @num1 := 16079;
set @num2 := 16079;
execute com using @num1, @num2;
set @num1 := 16082;
set @num2 := 16082;
execute com using @num1, @num2;
set @num1 := 16083;
set @num2 := 16083;
execute com using @num1, @num2;
set @num1 := 16088;
set @num2 := 16088;
execute com using @num1, @num2;
set @num1 := 16089;
set @num2 := 16089;
execute com using @num1, @num2;
set @num1 := 16090;
set @num2 := 16090;
execute com using @num1, @num2;
set @num1 := 16091;
set @num2 := 16091;
execute com using @num1, @num2;
set @num1 := 16092;
set @num2 := 16092;
execute com using @num1, @num2;
set @num1 := 16094;
set @num2 := 16094;
execute com using @num1, @num2;
set @num1 := 16095;
set @num2 := 16095;
execute com using @num1, @num2;
set @num1 := 16099;
set @num2 := 16099;
execute com using @num1, @num2;
set @num1 := 16103;
set @num2 := 16103;
execute com using @num1, @num2;
set @num1 := 16110;
set @num2 := 16110;
execute com using @num1, @num2;
set @num1 := 16111;
set @num2 := 16111;
execute com using @num1, @num2;
set @num1 := 16112;
set @num2 := 16112;
execute com using @num1, @num2;
set @num1 := 16115;
set @num2 := 16115;
execute com using @num1, @num2;
set @num1 := 16117;
set @num2 := 16117;
execute com using @num1, @num2;
set @num1 := 16118;
set @num2 := 16118;
execute com using @num1, @num2;
set @num1 := 16120;
set @num2 := 16120;
execute com using @num1, @num2;
set @num1 := 16121;
set @num2 := 16121;
execute com using @num1, @num2;
set @num1 := 16123;
set @num2 := 16123;
execute com using @num1, @num2;
set @num1 := 16125;
set @num2 := 16125;
execute com using @num1, @num2;
set @num1 := 16129;
set @num2 := 16129;
execute com using @num1, @num2;
set @num1 := 16130;
set @num2 := 16130;
execute com using @num1, @num2;
set @num1 := 16132;
set @num2 := 16132;
execute com using @num1, @num2;
set @num1 := 16134;
set @num2 := 16134;
execute com using @num1, @num2;
set @num1 := 16135;
set @num2 := 16135;
execute com using @num1, @num2;
set @num1 := 16139;
set @num2 := 16139;
execute com using @num1, @num2;
set @num1 := 16141;
set @num2 := 16141;
execute com using @num1, @num2;
set @num1 := 16142;
set @num2 := 16142;
execute com using @num1, @num2;
set @num1 := 16143;
set @num2 := 16143;
execute com using @num1, @num2;
set @num1 := 16147;
set @num2 := 16147;
execute com using @num1, @num2;
set @num1 := 16148;
set @num2 := 16148;
execute com using @num1, @num2;
set @num1 := 16153;
set @num2 := 16153;
execute com using @num1, @num2;
set @num1 := 16156;
set @num2 := 16156;
execute com using @num1, @num2;
set @num1 := 16161;
set @num2 := 16161;
execute com using @num1, @num2;
set @num1 := 16162;
set @num2 := 16162;
execute com using @num1, @num2;
set @num1 := 16163;
set @num2 := 16163;
execute com using @num1, @num2;
set @num1 := 16164;
set @num2 := 16164;
execute com using @num1, @num2;
set @num1 := 16167;
set @num2 := 16167;
execute com using @num1, @num2;
set @num1 := 16168;
set @num2 := 16168;
execute com using @num1, @num2;
set @num1 := 16175;
set @num2 := 16175;
execute com using @num1, @num2;
set @num1 := 16179;
set @num2 := 16179;
execute com using @num1, @num2;
set @num1 := 16181;
set @num2 := 16181;
execute com using @num1, @num2;
set @num1 := 16186;
set @num2 := 16186;
execute com using @num1, @num2;
set @num1 := 16187;
set @num2 := 16187;
execute com using @num1, @num2;
set @num1 := 16188;
set @num2 := 16188;
execute com using @num1, @num2;
set @num1 := 16191;
set @num2 := 16191;
execute com using @num1, @num2;
set @num1 := 16192;
set @num2 := 16192;
execute com using @num1, @num2;
set @num1 := 16193;
set @num2 := 16193;
execute com using @num1, @num2;
set @num1 := 16200;
set @num2 := 16200;
execute com using @num1, @num2;
set @num1 := 16202;
set @num2 := 16202;
execute com using @num1, @num2;
set @num1 := 16203;
set @num2 := 16203;
execute com using @num1, @num2;
set @num1 := 16205;
set @num2 := 16205;
execute com using @num1, @num2;
set @num1 := 16206;
set @num2 := 16206;
execute com using @num1, @num2;
set @num1 := 16207;
set @num2 := 16207;
execute com using @num1, @num2;
set @num1 := 16208;
set @num2 := 16208;
execute com using @num1, @num2;
set @num1 := 16209;
set @num2 := 16209;
execute com using @num1, @num2;
set @num1 := 16211;
set @num2 := 16211;
execute com using @num1, @num2;
set @num1 := 16215;
set @num2 := 16215;
execute com using @num1, @num2;
set @num1 := 16217;
set @num2 := 16217;
execute com using @num1, @num2;
set @num1 := 16218;
set @num2 := 16218;
execute com using @num1, @num2;
set @num1 := 16219;
set @num2 := 16219;
execute com using @num1, @num2;
set @num1 := 16224;
set @num2 := 16224;
execute com using @num1, @num2;
set @num1 := 16226;
set @num2 := 16226;
execute com using @num1, @num2;
set @num1 := 16228;
set @num2 := 16228;
execute com using @num1, @num2;
set @num1 := 16232;
set @num2 := 16232;
execute com using @num1, @num2;
set @num1 := 16238;
set @num2 := 16238;
execute com using @num1, @num2;
set @num1 := 16240;
set @num2 := 16240;
execute com using @num1, @num2;
set @num1 := 16241;
set @num2 := 16241;
execute com using @num1, @num2;
set @num1 := 16243;
set @num2 := 16243;
execute com using @num1, @num2;
set @num1 := 16245;
set @num2 := 16245;
execute com using @num1, @num2;
set @num1 := 16252;
set @num2 := 16252;
execute com using @num1, @num2;
set @num1 := 16253;
set @num2 := 16253;
execute com using @num1, @num2;
set @num1 := 16254;
set @num2 := 16254;
execute com using @num1, @num2;
set @num1 := 16261;
set @num2 := 16261;
execute com using @num1, @num2;
set @num1 := 16266;
set @num2 := 16266;
execute com using @num1, @num2;
set @num1 := 16267;
set @num2 := 16267;
execute com using @num1, @num2;
set @num1 := 16268;
set @num2 := 16268;
execute com using @num1, @num2;
set @num1 := 16273;
set @num2 := 16273;
execute com using @num1, @num2;
set @num1 := 16275;
set @num2 := 16275;
execute com using @num1, @num2;
set @num1 := 16277;
set @num2 := 16277;
execute com using @num1, @num2;
set @num1 := 16278;
set @num2 := 16278;
execute com using @num1, @num2;
set @num1 := 16279;
set @num2 := 16279;
execute com using @num1, @num2;
set @num1 := 16283;
set @num2 := 16283;
execute com using @num1, @num2;
set @num1 := 16288;
set @num2 := 16288;
execute com using @num1, @num2;
set @num1 := 16289;
set @num2 := 16289;
execute com using @num1, @num2;
set @num1 := 16294;
set @num2 := 16294;
execute com using @num1, @num2;
set @num1 := 16295;
set @num2 := 16295;
execute com using @num1, @num2;
set @num1 := 16300;
set @num2 := 16300;
execute com using @num1, @num2;
set @num1 := 16307;
set @num2 := 16307;
execute com using @num1, @num2;
set @num1 := 16310;
set @num2 := 16310;
execute com using @num1, @num2;
set @num1 := 16312;
set @num2 := 16312;
execute com using @num1, @num2;
set @num1 := 16315;
set @num2 := 16315;
execute com using @num1, @num2;
set @num1 := 16316;
set @num2 := 16316;
execute com using @num1, @num2;
set @num1 := 16317;
set @num2 := 16317;
execute com using @num1, @num2;
set @num1 := 16319;
set @num2 := 16319;
execute com using @num1, @num2;
set @num1 := 16321;
set @num2 := 16321;
execute com using @num1, @num2;
set @num1 := 16324;
set @num2 := 16324;
execute com using @num1, @num2;
set @num1 := 16326;
set @num2 := 16326;
execute com using @num1, @num2;
set @num1 := 16327;
set @num2 := 16327;
execute com using @num1, @num2;
set @num1 := 16328;
set @num2 := 16328;
execute com using @num1, @num2;
set @num1 := 16329;
set @num2 := 16329;
execute com using @num1, @num2;
set @num1 := 16333;
set @num2 := 16333;
execute com using @num1, @num2;
set @num1 := 16336;
set @num2 := 16336;
execute com using @num1, @num2;
set @num1 := 16339;
set @num2 := 16339;
execute com using @num1, @num2;
set @num1 := 16340;
set @num2 := 16340;
execute com using @num1, @num2;
set @num1 := 16341;
set @num2 := 16341;
execute com using @num1, @num2;
set @num1 := 16345;
set @num2 := 16345;
execute com using @num1, @num2;
set @num1 := 16356;
set @num2 := 16356;
execute com using @num1, @num2;
set @num1 := 16360;
set @num2 := 16360;
execute com using @num1, @num2;
set @num1 := 16367;
set @num2 := 16367;
execute com using @num1, @num2;
set @num1 := 16369;
set @num2 := 16369;
execute com using @num1, @num2;
set @num1 := 16372;
set @num2 := 16372;
execute com using @num1, @num2;
set @num1 := 16374;
set @num2 := 16374;
execute com using @num1, @num2;
set @num1 := 16378;
set @num2 := 16378;
execute com using @num1, @num2;
set @num1 := 16379;
set @num2 := 16379;
execute com using @num1, @num2;
set @num1 := 16380;
set @num2 := 16380;
execute com using @num1, @num2;
set @num1 := 16382;
set @num2 := 16382;
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.
All SQL code is licensed under CC0 License.