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 := 14458;
set @num2 := 14458;
execute com using @num1, @num2;
set @num1 := 14459;
set @num2 := 14459;
execute com using @num1, @num2;
set @num1 := 14466;
set @num2 := 14466;
execute com using @num1, @num2;
set @num1 := 14467;
set @num2 := 14467;
execute com using @num1, @num2;
set @num1 := 14468;
set @num2 := 14468;
execute com using @num1, @num2;
set @num1 := 14470;
set @num2 := 14470;
execute com using @num1, @num2;
set @num1 := 14531;
set @num2 := 14531;
execute com using @num1, @num2;
set @num1 := 14532;
set @num2 := 14532;
execute com using @num1, @num2;
set @num1 := 14533;
set @num2 := 14533;
execute com using @num1, @num2;
set @num1 := 14535;
set @num2 := 14535;
execute com using @num1, @num2;
set @num1 := 14539;
set @num2 := 14539;
execute com using @num1, @num2;
set @num1 := 14541;
set @num2 := 14541;
execute com using @num1, @num2;
set @num1 := 14543;
set @num2 := 14543;
execute com using @num1, @num2;
set @num1 := 14546;
set @num2 := 14546;
execute com using @num1, @num2;
set @num1 := 14551;
set @num2 := 14551;
execute com using @num1, @num2;
set @num1 := 14552;
set @num2 := 14552;
execute com using @num1, @num2;
set @num1 := 14559;
set @num2 := 14559;
execute com using @num1, @num2;
set @num1 := 14560;
set @num2 := 14560;
execute com using @num1, @num2;
set @num1 := 14561;
set @num2 := 14561;
execute com using @num1, @num2;
set @num1 := 14563;
set @num2 := 14563;
execute com using @num1, @num2;
set @num1 := 14567;
set @num2 := 14567;
execute com using @num1, @num2;
set @num1 := 14573;
set @num2 := 14573;
execute com using @num1, @num2;
set @num1 := 14579;
set @num2 := 14579;
execute com using @num1, @num2;
set @num1 := 14580;
set @num2 := 14580;
execute com using @num1, @num2;
set @num1 := 14581;
set @num2 := 14581;
execute com using @num1, @num2;
set @num1 := 14582;
set @num2 := 14582;
execute com using @num1, @num2;
set @num1 := 14587;
set @num2 := 14587;
execute com using @num1, @num2;
set @num1 := 14594;
set @num2 := 14594;
execute com using @num1, @num2;
set @num1 := 14597;
set @num2 := 14597;
execute com using @num1, @num2;
set @num1 := 14598;
set @num2 := 14598;
execute com using @num1, @num2;
set @num1 := 14599;
set @num2 := 14599;
execute com using @num1, @num2;
set @num1 := 14601;
set @num2 := 14601;
execute com using @num1, @num2;
set @num1 := 14602;
set @num2 := 14602;
execute com using @num1, @num2;
set @num1 := 14604;
set @num2 := 14604;
execute com using @num1, @num2;
set @num1 := 14605;
set @num2 := 14605;
execute com using @num1, @num2;
set @num1 := 14607;
set @num2 := 14607;
execute com using @num1, @num2;
set @num1 := 14617;
set @num2 := 14617;
execute com using @num1, @num2;
set @num1 := 14618;
set @num2 := 14618;
execute com using @num1, @num2;
set @num1 := 14624;
set @num2 := 14624;
execute com using @num1, @num2;
set @num1 := 14626;
set @num2 := 14626;
execute com using @num1, @num2;
set @num1 := 14627;
set @num2 := 14627;
execute com using @num1, @num2;
set @num1 := 14631;
set @num2 := 14631;
execute com using @num1, @num2;
set @num1 := 14644;
set @num2 := 14644;
execute com using @num1, @num2;
set @num1 := 14645;
set @num2 := 14645;
execute com using @num1, @num2;
set @num1 := 14647;
set @num2 := 14647;
execute com using @num1, @num2;
set @num1 := 14650;
set @num2 := 14650;
execute com using @num1, @num2;
set @num1 := 14652;
set @num2 := 14652;
execute com using @num1, @num2;
set @num1 := 14653;
set @num2 := 14653;
execute com using @num1, @num2;
set @num1 := 14667;
set @num2 := 14667;
execute com using @num1, @num2;
set @num1 := 14668;
set @num2 := 14668;
execute com using @num1, @num2;
set @num1 := 14676;
set @num2 := 14676;
execute com using @num1, @num2;
set @num1 := 14682;
set @num2 := 14682;
execute com using @num1, @num2;
set @num1 := 14687;
set @num2 := 14687;
execute com using @num1, @num2;
set @num1 := 14688;
set @num2 := 14688;
execute com using @num1, @num2;
set @num1 := 14690;
set @num2 := 14690;
execute com using @num1, @num2;
set @num1 := 14696;
set @num2 := 14696;
execute com using @num1, @num2;
set @num1 := 14700;
set @num2 := 14700;
execute com using @num1, @num2;
set @num1 := 14701;
set @num2 := 14701;
execute com using @num1, @num2;
set @num1 := 14702;
set @num2 := 14702;
execute com using @num1, @num2;
set @num1 := 14705;
set @num2 := 14705;
execute com using @num1, @num2;
set @num1 := 14706;
set @num2 := 14706;
execute com using @num1, @num2;
set @num1 := 14708;
set @num2 := 14708;
execute com using @num1, @num2;
set @num1 := 14709;
set @num2 := 14709;
execute com using @num1, @num2;
set @num1 := 14711;
set @num2 := 14711;
execute com using @num1, @num2;
set @num1 := 14712;
set @num2 := 14712;
execute com using @num1, @num2;
set @num1 := 14724;
set @num2 := 14724;
execute com using @num1, @num2;
set @num1 := 14726;
set @num2 := 14726;
execute com using @num1, @num2;
set @num1 := 14727;
set @num2 := 14727;
execute com using @num1, @num2;
set @num1 := 14729;
set @num2 := 14729;
execute com using @num1, @num2;
set @num1 := 14730;
set @num2 := 14730;
execute com using @num1, @num2;
set @num1 := 14732;
set @num2 := 14732;
execute com using @num1, @num2;
set @num1 := 14734;
set @num2 := 14734;
execute com using @num1, @num2;
set @num1 := 14745;
set @num2 := 14745;
execute com using @num1, @num2;
set @num1 := 14749;
set @num2 := 14749;
execute com using @num1, @num2;
set @num1 := 14750;
set @num2 := 14750;
execute com using @num1, @num2;
set @num1 := 14751;
set @num2 := 14751;
execute com using @num1, @num2;
set @num1 := 14752;
set @num2 := 14752;
execute com using @num1, @num2;
set @num1 := 14753;
set @num2 := 14753;
execute com using @num1, @num2;
set @num1 := 14761;
set @num2 := 14761;
execute com using @num1, @num2;
set @num1 := 14762;
set @num2 := 14762;
execute com using @num1, @num2;
set @num1 := 14763;
set @num2 := 14763;
execute com using @num1, @num2;
set @num1 := 14764;
set @num2 := 14764;
execute com using @num1, @num2;
set @num1 := 14773;
set @num2 := 14773;
execute com using @num1, @num2;
set @num1 := 14775;
set @num2 := 14775;
execute com using @num1, @num2;
set @num1 := 14779;
set @num2 := 14779;
execute com using @num1, @num2;
set @num1 := 14783;
set @num2 := 14783;
execute com using @num1, @num2;
set @num1 := 14787;
set @num2 := 14787;
execute com using @num1, @num2;
set @num1 := 14789;
set @num2 := 14789;
execute com using @num1, @num2;
set @num1 := 14790;
set @num2 := 14790;
execute com using @num1, @num2;
set @num1 := 14794;
set @num2 := 14794;
execute com using @num1, @num2;
set @num1 := 14800;
set @num2 := 14800;
execute com using @num1, @num2;
set @num1 := 14804;
set @num2 := 14804;
execute com using @num1, @num2;
set @num1 := 14810;
set @num2 := 14810;
execute com using @num1, @num2;
set @num1 := 14814;
set @num2 := 14814;
execute com using @num1, @num2;
set @num1 := 14836;
set @num2 := 14836;
execute com using @num1, @num2;
set @num1 := 14837;
set @num2 := 14837;
execute com using @num1, @num2;
set @num1 := 14838;
set @num2 := 14838;
execute com using @num1, @num2;
set @num1 := 14841;
set @num2 := 14841;
execute com using @num1, @num2;
set @num1 := 14843;
set @num2 := 14843;
execute com using @num1, @num2;
set @num1 := 14848;
set @num2 := 14848;
execute com using @num1, @num2;
set @num1 := 14849;
set @num2 := 14849;
execute com using @num1, @num2;
set @num1 := 14858;
set @num2 := 14858;
execute com using @num1, @num2;
set @num1 := 14871;
set @num2 := 14871;
execute com using @num1, @num2;
set @num1 := 14872;
set @num2 := 14872;
execute com using @num1, @num2;
set @num1 := 14875;
set @num2 := 14875;
execute com using @num1, @num2;
set @num1 := 14880;
set @num2 := 14880;
execute com using @num1, @num2;
set @num1 := 14881;
set @num2 := 14881;
execute com using @num1, @num2;
set @num1 := 14883;
set @num2 := 14883;
execute com using @num1, @num2;
set @num1 := 14889;
set @num2 := 14889;
execute com using @num1, @num2;
set @num1 := 14892;
set @num2 := 14892;
execute com using @num1, @num2;
set @num1 := 14894;
set @num2 := 14894;
execute com using @num1, @num2;
set @num1 := 14895;
set @num2 := 14895;
execute com using @num1, @num2;
set @num1 := 14896;
set @num2 := 14896;
execute com using @num1, @num2;
set @num1 := 14907;
set @num2 := 14907;
execute com using @num1, @num2;
set @num1 := 14910;
set @num2 := 14910;
execute com using @num1, @num2;
set @num1 := 14912;
set @num2 := 14912;
execute com using @num1, @num2;
set @num1 := 14914;
set @num2 := 14914;
execute com using @num1, @num2;
set @num1 := 14919;
set @num2 := 14919;
execute com using @num1, @num2;
set @num1 := 14921;
set @num2 := 14921;
execute com using @num1, @num2;
set @num1 := 14923;
set @num2 := 14923;
execute com using @num1, @num2;
set @num1 := 14926;
set @num2 := 14926;
execute com using @num1, @num2;
set @num1 := 14933;
set @num2 := 14933;
execute com using @num1, @num2;
set @num1 := 14934;
set @num2 := 14934;
execute com using @num1, @num2;
set @num1 := 14936;
set @num2 := 14936;
execute com using @num1, @num2;
set @num1 := 14937;
set @num2 := 14937;
execute com using @num1, @num2;
set @num1 := 14946;
set @num2 := 14946;
execute com using @num1, @num2;
set @num1 := 14951;
set @num2 := 14951;
execute com using @num1, @num2;
set @num1 := 14958;
set @num2 := 14958;
execute com using @num1, @num2;
set @num1 := 14961;
set @num2 := 14961;
execute com using @num1, @num2;
set @num1 := 14971;
set @num2 := 14971;
execute com using @num1, @num2;
set @num1 := 14972;
set @num2 := 14972;
execute com using @num1, @num2;
set @num1 := 14975;
set @num2 := 14975;
execute com using @num1, @num2;
set @num1 := 14980;
set @num2 := 14980;
execute com using @num1, @num2;
set @num1 := 14984;
set @num2 := 14984;
execute com using @num1, @num2;
set @num1 := 14985;
set @num2 := 14985;
execute com using @num1, @num2;
set @num1 := 14986;
set @num2 := 14986;
execute com using @num1, @num2;
set @num1 := 14987;
set @num2 := 14987;
execute com using @num1, @num2;
set @num1 := 14990;
set @num2 := 14990;
execute com using @num1, @num2;
set @num1 := 14996;
set @num2 := 14996;
execute com using @num1, @num2;
set @num1 := 15004;
set @num2 := 15004;
execute com using @num1, @num2;
set @num1 := 15012;
set @num2 := 15012;
execute com using @num1, @num2;
set @num1 := 15019;
set @num2 := 15019;
execute com using @num1, @num2;
set @num1 := 15022;
set @num2 := 15022;
execute com using @num1, @num2;
set @num1 := 15024;
set @num2 := 15024;
execute com using @num1, @num2;
set @num1 := 15027;
set @num2 := 15027;
execute com using @num1, @num2;
set @num1 := 15028;
set @num2 := 15028;
execute com using @num1, @num2;
set @num1 := 15030;
set @num2 := 15030;
execute com using @num1, @num2;
set @num1 := 15033;
set @num2 := 15033;
execute com using @num1, @num2;
set @num1 := 15036;
set @num2 := 15036;
execute com using @num1, @num2;
set @num1 := 15039;
set @num2 := 15039;
execute com using @num1, @num2;
set @num1 := 15040;
set @num2 := 15040;
execute com using @num1, @num2;
set @num1 := 15043;
set @num2 := 15043;
execute com using @num1, @num2;
set @num1 := 15044;
set @num2 := 15044;
execute com using @num1, @num2;
set @num1 := 15046;
set @num2 := 15046;
execute com using @num1, @num2;
set @num1 := 15048;
set @num2 := 15048;
execute com using @num1, @num2;
set @num1 := 15049;
set @num2 := 15049;
execute com using @num1, @num2;
set @num1 := 15051;
set @num2 := 15051;
execute com using @num1, @num2;
set @num1 := 15055;
set @num2 := 15055;
execute com using @num1, @num2;
set @num1 := 15059;
set @num2 := 15059;
execute com using @num1, @num2;
set @num1 := 15066;
set @num2 := 15066;
execute com using @num1, @num2;
set @num1 := 15068;
set @num2 := 15068;
execute com using @num1, @num2;
set @num1 := 15073;
set @num2 := 15073;
execute com using @num1, @num2;
set @num1 := 15076;
set @num2 := 15076;
execute com using @num1, @num2;
set @num1 := 15077;
set @num2 := 15077;
execute com using @num1, @num2;
set @num1 := 15080;
set @num2 := 15080;
execute com using @num1, @num2;
set @num1 := 15081;
set @num2 := 15081;
execute com using @num1, @num2;
set @num1 := 15085;
set @num2 := 15085;
execute com using @num1, @num2;
set @num1 := 15087;
set @num2 := 15087;
execute com using @num1, @num2;
set @num1 := 15088;
set @num2 := 15088;
execute com using @num1, @num2;
set @num1 := 15095;
set @num2 := 15095;
execute com using @num1, @num2;
set @num1 := 15097;
set @num2 := 15097;
execute com using @num1, @num2;
set @num1 := 15100;
set @num2 := 15100;
execute com using @num1, @num2;
set @num1 := 15102;
set @num2 := 15102;
execute com using @num1, @num2;
set @num1 := 15107;
set @num2 := 15107;
execute com using @num1, @num2;
set @num1 := 15112;
set @num2 := 15112;
execute com using @num1, @num2;
set @num1 := 15116;
set @num2 := 15116;
execute com using @num1, @num2;
set @num1 := 15123;
set @num2 := 15123;
execute com using @num1, @num2;
set @num1 := 15129;
set @num2 := 15129;
execute com using @num1, @num2;
set @num1 := 15134;
set @num2 := 15134;
execute com using @num1, @num2;
set @num1 := 15146;
set @num2 := 15146;
execute com using @num1, @num2;
set @num1 := 15147;
set @num2 := 15147;
execute com using @num1, @num2;
set @num1 := 15155;
set @num2 := 15155;
execute com using @num1, @num2;
set @num1 := 15166;
set @num2 := 15166;
execute com using @num1, @num2;
set @num1 := 15167;
set @num2 := 15167;
execute com using @num1, @num2;
set @num1 := 15169;
set @num2 := 15169;
execute com using @num1, @num2;
set @num1 := 15172;
set @num2 := 15172;
execute com using @num1, @num2;
set @num1 := 15175;
set @num2 := 15175;
execute com using @num1, @num2;
set @num1 := 15176;
set @num2 := 15176;
execute com using @num1, @num2;
set @num1 := 15179;
set @num2 := 15179;
execute com using @num1, @num2;
set @num1 := 15181;
set @num2 := 15181;
execute com using @num1, @num2;
set @num1 := 15191;
set @num2 := 15191;
execute com using @num1, @num2;
set @num1 := 15192;
set @num2 := 15192;
execute com using @num1, @num2;
set @num1 := 15201;
set @num2 := 15201;
execute com using @num1, @num2;
set @num1 := 15205;
set @num2 := 15205;
execute com using @num1, @num2;
set @num1 := 15208;
set @num2 := 15208;
execute com using @num1, @num2;
set @num1 := 15214;
set @num2 := 15214;
execute com using @num1, @num2;
set @num1 := 15215;
set @num2 := 15215;
execute com using @num1, @num2;
set @num1 := 15226;
set @num2 := 15226;
execute com using @num1, @num2;
set @num1 := 15227;
set @num2 := 15227;
execute com using @num1, @num2;
set @num1 := 15229;
set @num2 := 15229;
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.