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 := 15231;
set @num2 := 15231;
execute com using @num1, @num2;
set @num1 := 15245;
set @num2 := 15245;
execute com using @num1, @num2;
set @num1 := 15250;
set @num2 := 15250;
execute com using @num1, @num2;
set @num1 := 15251;
set @num2 := 15251;
execute com using @num1, @num2;
set @num1 := 15252;
set @num2 := 15252;
execute com using @num1, @num2;
set @num1 := 15256;
set @num2 := 15256;
execute com using @num1, @num2;
set @num1 := 15270;
set @num2 := 15270;
execute com using @num1, @num2;
set @num1 := 15271;
set @num2 := 15271;
execute com using @num1, @num2;
set @num1 := 15274;
set @num2 := 15274;
execute com using @num1, @num2;
set @num1 := 15275;
set @num2 := 15275;
execute com using @num1, @num2;
set @num1 := 15284;
set @num2 := 15284;
execute com using @num1, @num2;
set @num1 := 15287;
set @num2 := 15287;
execute com using @num1, @num2;
set @num1 := 15289;
set @num2 := 15289;
execute com using @num1, @num2;
set @num1 := 15294;
set @num2 := 15294;
execute com using @num1, @num2;
set @num1 := 15295;
set @num2 := 15295;
execute com using @num1, @num2;
set @num1 := 15304;
set @num2 := 15304;
execute com using @num1, @num2;
set @num1 := 15305;
set @num2 := 15305;
execute com using @num1, @num2;
set @num1 := 15308;
set @num2 := 15308;
execute com using @num1, @num2;
set @num1 := 15309;
set @num2 := 15309;
execute com using @num1, @num2;
set @num1 := 15316;
set @num2 := 15316;
execute com using @num1, @num2;
set @num1 := 15317;
set @num2 := 15317;
execute com using @num1, @num2;
set @num1 := 15318;
set @num2 := 15318;
execute com using @num1, @num2;
set @num1 := 15319;
set @num2 := 15319;
execute com using @num1, @num2;
set @num1 := 15321;
set @num2 := 15321;
execute com using @num1, @num2;
set @num1 := 15328;
set @num2 := 15328;
execute com using @num1, @num2;
set @num1 := 15335;
set @num2 := 15335;
execute com using @num1, @num2;
set @num1 := 15336;
set @num2 := 15336;
execute com using @num1, @num2;
set @num1 := 15341;
set @num2 := 15341;
execute com using @num1, @num2;
set @num1 := 15346;
set @num2 := 15346;
execute com using @num1, @num2;
set @num1 := 15347;
set @num2 := 15347;
execute com using @num1, @num2;
set @num1 := 15354;
set @num2 := 15354;
execute com using @num1, @num2;
set @num1 := 15355;
set @num2 := 15355;
execute com using @num1, @num2;
set @num1 := 15358;
set @num2 := 15358;
execute com using @num1, @num2;
set @num1 := 15361;
set @num2 := 15361;
execute com using @num1, @num2;
set @num1 := 15368;
set @num2 := 15368;
execute com using @num1, @num2;
set @num1 := 15369;
set @num2 := 15369;
execute com using @num1, @num2;
set @num1 := 15374;
set @num2 := 15374;
execute com using @num1, @num2;
set @num1 := 15387;
set @num2 := 15387;
execute com using @num1, @num2;
set @num1 := 15388;
set @num2 := 15388;
execute com using @num1, @num2;
set @num1 := 15395;
set @num2 := 15395;
execute com using @num1, @num2;
set @num1 := 15401;
set @num2 := 15401;
execute com using @num1, @num2;
set @num1 := 15403;
set @num2 := 15403;
execute com using @num1, @num2;
set @num1 := 15406;
set @num2 := 15406;
execute com using @num1, @num2;
set @num1 := 15408;
set @num2 := 15408;
execute com using @num1, @num2;
set @num1 := 15412;
set @num2 := 15412;
execute com using @num1, @num2;
set @num1 := 15414;
set @num2 := 15414;
execute com using @num1, @num2;
set @num1 := 15416;
set @num2 := 15416;
execute com using @num1, @num2;
set @num1 := 15417;
set @num2 := 15417;
execute com using @num1, @num2;
set @num1 := 15422;
set @num2 := 15422;
execute com using @num1, @num2;
set @num1 := 15428;
set @num2 := 15428;
execute com using @num1, @num2;
set @num1 := 15430;
set @num2 := 15430;
execute com using @num1, @num2;
set @num1 := 15435;
set @num2 := 15435;
execute com using @num1, @num2;
set @num1 := 15443;
set @num2 := 15443;
execute com using @num1, @num2;
set @num1 := 15445;
set @num2 := 15445;
execute com using @num1, @num2;
set @num1 := 15447;
set @num2 := 15447;
execute com using @num1, @num2;
set @num1 := 15454;
set @num2 := 15454;
execute com using @num1, @num2;
set @num1 := 15459;
set @num2 := 15459;
execute com using @num1, @num2;
set @num1 := 15466;
set @num2 := 15466;
execute com using @num1, @num2;
set @num1 := 15468;
set @num2 := 15468;
execute com using @num1, @num2;
set @num1 := 15471;
set @num2 := 15471;
execute com using @num1, @num2;
set @num1 := 15474;
set @num2 := 15474;
execute com using @num1, @num2;
set @num1 := 15476;
set @num2 := 15476;
execute com using @num1, @num2;
set @num1 := 15477;
set @num2 := 15477;
execute com using @num1, @num2;
set @num1 := 15478;
set @num2 := 15478;
execute com using @num1, @num2;
set @num1 := 15487;
set @num2 := 15487;
execute com using @num1, @num2;
set @num1 := 15490;
set @num2 := 15490;
execute com using @num1, @num2;
set @num1 := 15491;
set @num2 := 15491;
execute com using @num1, @num2;
set @num1 := 15492;
set @num2 := 15492;
execute com using @num1, @num2;
set @num1 := 15501;
set @num2 := 15501;
execute com using @num1, @num2;
set @num1 := 15505;
set @num2 := 15505;
execute com using @num1, @num2;
set @num1 := 15506;
set @num2 := 15506;
execute com using @num1, @num2;
set @num1 := 15511;
set @num2 := 15511;
execute com using @num1, @num2;
set @num1 := 15513;
set @num2 := 15513;
execute com using @num1, @num2;
set @num1 := 15514;
set @num2 := 15514;
execute com using @num1, @num2;
set @num1 := 15521;
set @num2 := 15521;
execute com using @num1, @num2;
set @num1 := 15524;
set @num2 := 15524;
execute com using @num1, @num2;
set @num1 := 15531;
set @num2 := 15531;
execute com using @num1, @num2;
set @num1 := 15532;
set @num2 := 15532;
execute com using @num1, @num2;
set @num1 := 15533;
set @num2 := 15533;
execute com using @num1, @num2;
set @num1 := 15570;
set @num2 := 15570;
execute com using @num1, @num2;
set @num1 := 15571;
set @num2 := 15571;
execute com using @num1, @num2;
set @num1 := 15573;
set @num2 := 15573;
execute com using @num1, @num2;
set @num1 := 15575;
set @num2 := 15575;
execute com using @num1, @num2;
set @num1 := 15576;
set @num2 := 15576;
execute com using @num1, @num2;
set @num1 := 15578;
set @num2 := 15578;
execute com using @num1, @num2;
set @num1 := 15587;
set @num2 := 15587;
execute com using @num1, @num2;
set @num1 := 15593;
set @num2 := 15593;
execute com using @num1, @num2;
set @num1 := 15600;
set @num2 := 15600;
execute com using @num1, @num2;
set @num1 := 15601;
set @num2 := 15601;
execute com using @num1, @num2;
set @num1 := 15604;
set @num2 := 15604;
execute com using @num1, @num2;
set @num1 := 15606;
set @num2 := 15606;
execute com using @num1, @num2;
set @num1 := 15608;
set @num2 := 15608;
execute com using @num1, @num2;
set @num1 := 15612;
set @num2 := 15612;
execute com using @num1, @num2;
set @num1 := 15613;
set @num2 := 15613;
execute com using @num1, @num2;
set @num1 := 15614;
set @num2 := 15614;
execute com using @num1, @num2;
set @num1 := 15616;
set @num2 := 15616;
execute com using @num1, @num2;
set @num1 := 15622;
set @num2 := 15622;
execute com using @num1, @num2;
set @num1 := 15624;
set @num2 := 15624;
execute com using @num1, @num2;
set @num1 := 15626;
set @num2 := 15626;
execute com using @num1, @num2;
set @num1 := 15627;
set @num2 := 15627;
execute com using @num1, @num2;
set @num1 := 15628;
set @num2 := 15628;
execute com using @num1, @num2;
set @num1 := 15630;
set @num2 := 15630;
execute com using @num1, @num2;
set @num1 := 15640;
set @num2 := 15640;
execute com using @num1, @num2;
set @num1 := 15641;
set @num2 := 15641;
execute com using @num1, @num2;
set @num1 := 15645;
set @num2 := 15645;
execute com using @num1, @num2;
set @num1 := 15654;
set @num2 := 15654;
execute com using @num1, @num2;
set @num1 := 15655;
set @num2 := 15655;
execute com using @num1, @num2;
set @num1 := 15656;
set @num2 := 15656;
execute com using @num1, @num2;
set @num1 := 15657;
set @num2 := 15657;
execute com using @num1, @num2;
set @num1 := 15658;
set @num2 := 15658;
execute com using @num1, @num2;
set @num1 := 15660;
set @num2 := 15660;
execute com using @num1, @num2;
set @num1 := 15661;
set @num2 := 15661;
execute com using @num1, @num2;
set @num1 := 15683;
set @num2 := 15683;
execute com using @num1, @num2;
set @num1 := 15693;
set @num2 := 15693;
execute com using @num1, @num2;
set @num1 := 15719;
set @num2 := 15719;
execute com using @num1, @num2;
set @num1 := 15721;
set @num2 := 15721;
execute com using @num1, @num2;
set @num1 := 15736;
set @num2 := 15736;
execute com using @num1, @num2;
set @num1 := 15739;
set @num2 := 15739;
execute com using @num1, @num2;
set @num1 := 15745;
set @num2 := 15745;
execute com using @num1, @num2;
set @num1 := 15766;
set @num2 := 15766;
execute com using @num1, @num2;
set @num1 := 15770;
set @num2 := 15770;
execute com using @num1, @num2;
set @num1 := 15772;
set @num2 := 15772;
execute com using @num1, @num2;
set @num1 := 15777;
set @num2 := 15777;
execute com using @num1, @num2;
set @num1 := 15780;
set @num2 := 15780;
execute com using @num1, @num2;
set @num1 := 15781;
set @num2 := 15781;
execute com using @num1, @num2;
set @num1 := 15782;
set @num2 := 15782;
execute com using @num1, @num2;
set @num1 := 15787;
set @num2 := 15787;
execute com using @num1, @num2;
set @num1 := 15788;
set @num2 := 15788;
execute com using @num1, @num2;
set @num1 := 15789;
set @num2 := 15789;
execute com using @num1, @num2;
set @num1 := 15790;
set @num2 := 15790;
execute com using @num1, @num2;
set @num1 := 15791;
set @num2 := 15791;
execute com using @num1, @num2;
set @num1 := 15792;
set @num2 := 15792;
execute com using @num1, @num2;
set @num1 := 15793;
set @num2 := 15793;
execute com using @num1, @num2;
set @num1 := 15794;
set @num2 := 15794;
execute com using @num1, @num2;
set @num1 := 15795;
set @num2 := 15795;
execute com using @num1, @num2;
set @num1 := 15796;
set @num2 := 15796;
execute com using @num1, @num2;
set @num1 := 15797;
set @num2 := 15797;
execute com using @num1, @num2;
set @num1 := 15798;
set @num2 := 15798;
execute com using @num1, @num2;
set @num1 := 15799;
set @num2 := 15799;
execute com using @num1, @num2;
set @num1 := 15800;
set @num2 := 15800;
execute com using @num1, @num2;
set @num1 := 15801;
set @num2 := 15801;
execute com using @num1, @num2;
set @num1 := 15802;
set @num2 := 15802;
execute com using @num1, @num2;
set @num1 := 15803;
set @num2 := 15803;
execute com using @num1, @num2;
set @num1 := 15804;
set @num2 := 15804;
execute com using @num1, @num2;
set @num1 := 15805;
set @num2 := 15805;
execute com using @num1, @num2;
set @num1 := 15806;
set @num2 := 15806;
execute com using @num1, @num2;
set @num1 := 15807;
set @num2 := 15807;
execute com using @num1, @num2;
set @num1 := 15809;
set @num2 := 15809;
execute com using @num1, @num2;
set @num1 := 15812;
set @num2 := 15812;
execute com using @num1, @num2;
set @num1 := 15813;
set @num2 := 15813;
execute com using @num1, @num2;
set @num1 := 15814;
set @num2 := 15814;
execute com using @num1, @num2;
set @num1 := 15815;
set @num2 := 15815;
execute com using @num1, @num2;
set @num1 := 15816;
set @num2 := 15816;
execute com using @num1, @num2;
set @num1 := 15817;
set @num2 := 15817;
execute com using @num1, @num2;
set @num1 := 15818;
set @num2 := 15818;
execute com using @num1, @num2;
set @num1 := 15819;
set @num2 := 15819;
execute com using @num1, @num2;
set @num1 := 15820;
set @num2 := 15820;
execute com using @num1, @num2;
set @num1 := 15821;
set @num2 := 15821;
execute com using @num1, @num2;
set @num1 := 15823;
set @num2 := 15823;
execute com using @num1, @num2;
set @num1 := 15824;
set @num2 := 15824;
execute com using @num1, @num2;
set @num1 := 15825;
set @num2 := 15825;
execute com using @num1, @num2;
set @num1 := 15826;
set @num2 := 15826;
execute com using @num1, @num2;
set @num1 := 15827;
set @num2 := 15827;
execute com using @num1, @num2;
set @num1 := 15830;
set @num2 := 15830;
execute com using @num1, @num2;
set @num1 := 15831;
set @num2 := 15831;
execute com using @num1, @num2;
set @num1 := 15834;
set @num2 := 15834;
execute com using @num1, @num2;
set @num1 := 15837;
set @num2 := 15837;
execute com using @num1, @num2;
set @num1 := 15838;
set @num2 := 15838;
execute com using @num1, @num2;
set @num1 := 15839;
set @num2 := 15839;
execute com using @num1, @num2;
set @num1 := 15842;
set @num2 := 15842;
execute com using @num1, @num2;
set @num1 := 15843;
set @num2 := 15843;
execute com using @num1, @num2;
set @num1 := 15844;
set @num2 := 15844;
execute com using @num1, @num2;
set @num1 := 15845;
set @num2 := 15845;
execute com using @num1, @num2;
set @num1 := 15846;
set @num2 := 15846;
execute com using @num1, @num2;
set @num1 := 15847;
set @num2 := 15847;
execute com using @num1, @num2;
set @num1 := 15848;
set @num2 := 15848;
execute com using @num1, @num2;
set @num1 := 15849;
set @num2 := 15849;
execute com using @num1, @num2;
set @num1 := 15852;
set @num2 := 15852;
execute com using @num1, @num2;
set @num1 := 15854;
set @num2 := 15854;
execute com using @num1, @num2;
set @num1 := 15855;
set @num2 := 15855;
execute com using @num1, @num2;
set @num1 := 15856;
set @num2 := 15856;
execute com using @num1, @num2;
set @num1 := 15857;
set @num2 := 15857;
execute com using @num1, @num2;
set @num1 := 15858;
set @num2 := 15858;
execute com using @num1, @num2;
set @num1 := 15861;
set @num2 := 15861;
execute com using @num1, @num2;
set @num1 := 15862;
set @num2 := 15862;
execute com using @num1, @num2;
set @num1 := 15863;
set @num2 := 15863;
execute com using @num1, @num2;
set @num1 := 15864;
set @num2 := 15864;
execute com using @num1, @num2;
set @num1 := 15865;
set @num2 := 15865;
execute com using @num1, @num2;
set @num1 := 15866;
set @num2 := 15866;
execute com using @num1, @num2;
set @num1 := 15870;
set @num2 := 15870;
execute com using @num1, @num2;
set @num1 := 15872;
set @num2 := 15872;
execute com using @num1, @num2;
set @num1 := 15873;
set @num2 := 15873;
execute com using @num1, @num2;
set @num1 := 15874;
set @num2 := 15874;
execute com using @num1, @num2;
set @num1 := 15878;
set @num2 := 15878;
execute com using @num1, @num2;
set @num1 := 15879;
set @num2 := 15879;
execute com using @num1, @num2;
set @num1 := 15881;
set @num2 := 15881;
execute com using @num1, @num2;
set @num1 := 15883;
set @num2 := 15883;
execute com using @num1, @num2;
set @num1 := 15885;
set @num2 := 15885;
execute com using @num1, @num2;
set @num1 := 15888;
set @num2 := 15888;
execute com using @num1, @num2;
set @num1 := 15889;
set @num2 := 15889;
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.