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 := 16383;
set @num2 := 16383;
execute com using @num1, @num2;
set @num1 := 16384;
set @num2 := 16384;
execute com using @num1, @num2;
set @num1 := 16395;
set @num2 := 16395;
execute com using @num1, @num2;
set @num1 := 16399;
set @num2 := 16399;
execute com using @num1, @num2;
set @num1 := 16403;
set @num2 := 16403;
execute com using @num1, @num2;
set @num1 := 16412;
set @num2 := 16412;
execute com using @num1, @num2;
set @num1 := 16415;
set @num2 := 16415;
execute com using @num1, @num2;
set @num1 := 16419;
set @num2 := 16419;
execute com using @num1, @num2;
set @num1 := 16421;
set @num2 := 16421;
execute com using @num1, @num2;
set @num1 := 16422;
set @num2 := 16422;
execute com using @num1, @num2;
set @num1 := 16427;
set @num2 := 16427;
execute com using @num1, @num2;
set @num1 := 16429;
set @num2 := 16429;
execute com using @num1, @num2;
set @num1 := 16433;
set @num2 := 16433;
execute com using @num1, @num2;
set @num1 := 16440;
set @num2 := 16440;
execute com using @num1, @num2;
set @num1 := 16441;
set @num2 := 16441;
execute com using @num1, @num2;
set @num1 := 16442;
set @num2 := 16442;
execute com using @num1, @num2;
set @num1 := 16449;
set @num2 := 16449;
execute com using @num1, @num2;
set @num1 := 16452;
set @num2 := 16452;
execute com using @num1, @num2;
set @num1 := 16455;
set @num2 := 16455;
execute com using @num1, @num2;
set @num1 := 16457;
set @num2 := 16457;
execute com using @num1, @num2;
set @num1 := 16460;
set @num2 := 16460;
execute com using @num1, @num2;
set @num1 := 16462;
set @num2 := 16462;
execute com using @num1, @num2;
set @num1 := 16466;
set @num2 := 16466;
execute com using @num1, @num2;
set @num1 := 16467;
set @num2 := 16467;
execute com using @num1, @num2;
set @num1 := 16472;
set @num2 := 16472;
execute com using @num1, @num2;
set @num1 := 16476;
set @num2 := 16476;
execute com using @num1, @num2;
set @num1 := 16479;
set @num2 := 16479;
execute com using @num1, @num2;
set @num1 := 16480;
set @num2 := 16480;
execute com using @num1, @num2;
set @num1 := 16486;
set @num2 := 16486;
execute com using @num1, @num2;
set @num1 := 16488;
set @num2 := 16488;
execute com using @num1, @num2;
set @num1 := 16489;
set @num2 := 16489;
execute com using @num1, @num2;
set @num1 := 16493;
set @num2 := 16493;
execute com using @num1, @num2;
set @num1 := 16494;
set @num2 := 16494;
execute com using @num1, @num2;
set @num1 := 16496;
set @num2 := 16496;
execute com using @num1, @num2;
set @num1 := 16504;
set @num2 := 16504;
execute com using @num1, @num2;
set @num1 := 16505;
set @num2 := 16505;
execute com using @num1, @num2;
set @num1 := 16506;
set @num2 := 16506;
execute com using @num1, @num2;
set @num1 := 16507;
set @num2 := 16507;
execute com using @num1, @num2;
set @num1 := 16509;
set @num2 := 16509;
execute com using @num1, @num2;
set @num1 := 16514;
set @num2 := 16514;
execute com using @num1, @num2;
set @num1 := 16516;
set @num2 := 16516;
execute com using @num1, @num2;
set @num1 := 16517;
set @num2 := 16517;
execute com using @num1, @num2;
set @num1 := 16518;
set @num2 := 16518;
execute com using @num1, @num2;
set @num1 := 16521;
set @num2 := 16521;
execute com using @num1, @num2;
set @num1 := 16535;
set @num2 := 16535;
execute com using @num1, @num2;
set @num1 := 16542;
set @num2 := 16542;
execute com using @num1, @num2;
set @num1 := 16543;
set @num2 := 16543;
execute com using @num1, @num2;
set @num1 := 16544;
set @num2 := 16544;
execute com using @num1, @num2;
set @num1 := 16545;
set @num2 := 16545;
execute com using @num1, @num2;
set @num1 := 16546;
set @num2 := 16546;
execute com using @num1, @num2;
set @num1 := 16547;
set @num2 := 16547;
execute com using @num1, @num2;
set @num1 := 16550;
set @num2 := 16550;
execute com using @num1, @num2;
set @num1 := 16551;
set @num2 := 16551;
execute com using @num1, @num2;
set @num1 := 16553;
set @num2 := 16553;
execute com using @num1, @num2;
set @num1 := 16555;
set @num2 := 16555;
execute com using @num1, @num2;
set @num1 := 16556;
set @num2 := 16556;
execute com using @num1, @num2;
set @num1 := 16558;
set @num2 := 16558;
execute com using @num1, @num2;
set @num1 := 16559;
set @num2 := 16559;
execute com using @num1, @num2;
set @num1 := 16567;
set @num2 := 16567;
execute com using @num1, @num2;
set @num1 := 16569;
set @num2 := 16569;
execute com using @num1, @num2;
set @num1 := 16570;
set @num2 := 16570;
execute com using @num1, @num2;
set @num1 := 16572;
set @num2 := 16572;
execute com using @num1, @num2;
set @num1 := 16573;
set @num2 := 16573;
execute com using @num1, @num2;
set @num1 := 16578;
set @num2 := 16578;
execute com using @num1, @num2;
set @num1 := 16579;
set @num2 := 16579;
execute com using @num1, @num2;
set @num1 := 16581;
set @num2 := 16581;
execute com using @num1, @num2;
set @num1 := 16585;
set @num2 := 16585;
execute com using @num1, @num2;
set @num1 := 16588;
set @num2 := 16588;
execute com using @num1, @num2;
set @num1 := 16590;
set @num2 := 16590;
execute com using @num1, @num2;
set @num1 := 16603;
set @num2 := 16603;
execute com using @num1, @num2;
set @num1 := 16608;
set @num2 := 16608;
execute com using @num1, @num2;
set @num1 := 16615;
set @num2 := 16615;
execute com using @num1, @num2;
set @num1 := 16616;
set @num2 := 16616;
execute com using @num1, @num2;
set @num1 := 16619;
set @num2 := 16619;
execute com using @num1, @num2;
set @num1 := 16623;
set @num2 := 16623;
execute com using @num1, @num2;
set @num1 := 16625;
set @num2 := 16625;
execute com using @num1, @num2;
set @num1 := 16629;
set @num2 := 16629;
execute com using @num1, @num2;
set @num1 := 16634;
set @num2 := 16634;
execute com using @num1, @num2;
set @num1 := 16635;
set @num2 := 16635;
execute com using @num1, @num2;
set @num1 := 16641;
set @num2 := 16641;
execute com using @num1, @num2;
set @num1 := 16642;
set @num2 := 16642;
execute com using @num1, @num2;
set @num1 := 16643;
set @num2 := 16643;
execute com using @num1, @num2;
set @num1 := 16644;
set @num2 := 16644;
execute com using @num1, @num2;
set @num1 := 16647;
set @num2 := 16647;
execute com using @num1, @num2;
set @num1 := 16649;
set @num2 := 16649;
execute com using @num1, @num2;
set @num1 := 16654;
set @num2 := 16654;
execute com using @num1, @num2;
set @num1 := 16674;
set @num2 := 16674;
execute com using @num1, @num2;
set @num1 := 16675;
set @num2 := 16675;
execute com using @num1, @num2;
set @num1 := 16678;
set @num2 := 16678;
execute com using @num1, @num2;
set @num1 := 16688;
set @num2 := 16688;
execute com using @num1, @num2;
set @num1 := 16692;
set @num2 := 16692;
execute com using @num1, @num2;
set @num1 := 16693;
set @num2 := 16693;
execute com using @num1, @num2;
set @num1 := 16696;
set @num2 := 16696;
execute com using @num1, @num2;
set @num1 := 16698;
set @num2 := 16698;
execute com using @num1, @num2;
set @num1 := 16705;
set @num2 := 16705;
execute com using @num1, @num2;
set @num1 := 16707;
set @num2 := 16707;
execute com using @num1, @num2;
set @num1 := 16716;
set @num2 := 16716;
execute com using @num1, @num2;
set @num1 := 16717;
set @num2 := 16717;
execute com using @num1, @num2;
set @num1 := 16724;
set @num2 := 16724;
execute com using @num1, @num2;
set @num1 := 16726;
set @num2 := 16726;
execute com using @num1, @num2;
set @num1 := 16733;
set @num2 := 16733;
execute com using @num1, @num2;
set @num1 := 16736;
set @num2 := 16736;
execute com using @num1, @num2;
set @num1 := 16743;
set @num2 := 16743;
execute com using @num1, @num2;
set @num1 := 16744;
set @num2 := 16744;
execute com using @num1, @num2;
set @num1 := 16746;
set @num2 := 16746;
execute com using @num1, @num2;
set @num1 := 16748;
set @num2 := 16748;
execute com using @num1, @num2;
set @num1 := 16749;
set @num2 := 16749;
execute com using @num1, @num2;
set @num1 := 16756;
set @num2 := 16756;
execute com using @num1, @num2;
set @num1 := 16757;
set @num2 := 16757;
execute com using @num1, @num2;
set @num1 := 16759;
set @num2 := 16759;
execute com using @num1, @num2;
set @num1 := 16760;
set @num2 := 16760;
execute com using @num1, @num2;
set @num1 := 16766;
set @num2 := 16766;
execute com using @num1, @num2;
set @num1 := 16767;
set @num2 := 16767;
execute com using @num1, @num2;
set @num1 := 16768;
set @num2 := 16768;
execute com using @num1, @num2;
set @num1 := 16769;
set @num2 := 16769;
execute com using @num1, @num2;
set @num1 := 16771;
set @num2 := 16771;
execute com using @num1, @num2;
set @num1 := 16772;
set @num2 := 16772;
execute com using @num1, @num2;
set @num1 := 16773;
set @num2 := 16773;
execute com using @num1, @num2;
set @num1 := 16774;
set @num2 := 16774;
execute com using @num1, @num2;
set @num1 := 16775;
set @num2 := 16775;
execute com using @num1, @num2;
set @num1 := 16776;
set @num2 := 16776;
execute com using @num1, @num2;
set @num1 := 16777;
set @num2 := 16777;
execute com using @num1, @num2;
set @num1 := 16779;
set @num2 := 16779;
execute com using @num1, @num2;
set @num1 := 16782;
set @num2 := 16782;
execute com using @num1, @num2;
set @num1 := 16788;
set @num2 := 16788;
execute com using @num1, @num2;
set @num1 := 16790;
set @num2 := 16790;
execute com using @num1, @num2;
set @num1 := 16796;
set @num2 := 16796;
execute com using @num1, @num2;
set @num1 := 16797;
set @num2 := 16797;
execute com using @num1, @num2;
set @num1 := 16800;
set @num2 := 16800;
execute com using @num1, @num2;
set @num1 := 16801;
set @num2 := 16801;
execute com using @num1, @num2;
set @num1 := 16802;
set @num2 := 16802;
execute com using @num1, @num2;
set @num1 := 16803;
set @num2 := 16803;
execute com using @num1, @num2;
set @num1 := 16804;
set @num2 := 16804;
execute com using @num1, @num2;
set @num1 := 16807;
set @num2 := 16807;
execute com using @num1, @num2;
set @num1 := 16808;
set @num2 := 16808;
execute com using @num1, @num2;
set @num1 := 16810;
set @num2 := 16810;
execute com using @num1, @num2;
set @num1 := 16812;
set @num2 := 16812;
execute com using @num1, @num2;
set @num1 := 16815;
set @num2 := 16815;
execute com using @num1, @num2;
set @num1 := 16818;
set @num2 := 16818;
execute com using @num1, @num2;
set @num1 := 16820;
set @num2 := 16820;
execute com using @num1, @num2;
set @num1 := 16821;
set @num2 := 16821;
execute com using @num1, @num2;
set @num1 := 16822;
set @num2 := 16822;
execute com using @num1, @num2;
set @num1 := 16826;
set @num2 := 16826;
execute com using @num1, @num2;
set @num1 := 16827;
set @num2 := 16827;
execute com using @num1, @num2;
set @num1 := 16830;
set @num2 := 16830;
execute com using @num1, @num2;
set @num1 := 16838;
set @num2 := 16838;
execute com using @num1, @num2;
set @num1 := 16843;
set @num2 := 16843;
execute com using @num1, @num2;
set @num1 := 16844;
set @num2 := 16844;
execute com using @num1, @num2;
set @num1 := 16846;
set @num2 := 16846;
execute com using @num1, @num2;
set @num1 := 16850;
set @num2 := 16850;
execute com using @num1, @num2;
set @num1 := 16851;
set @num2 := 16851;
execute com using @num1, @num2;
set @num1 := 16853;
set @num2 := 16853;
execute com using @num1, @num2;
set @num1 := 16854;
set @num2 := 16854;
execute com using @num1, @num2;
set @num1 := 16855;
set @num2 := 16855;
execute com using @num1, @num2;
set @num1 := 16857;
set @num2 := 16857;
execute com using @num1, @num2;
set @num1 := 16858;
set @num2 := 16858;
execute com using @num1, @num2;
set @num1 := 16860;
set @num2 := 16860;
execute com using @num1, @num2;
set @num1 := 16861;
set @num2 := 16861;
execute com using @num1, @num2;
set @num1 := 16862;
set @num2 := 16862;
execute com using @num1, @num2;
set @num1 := 16864;
set @num2 := 16864;
execute com using @num1, @num2;
set @num1 := 16869;
set @num2 := 16869;
execute com using @num1, @num2;
set @num1 := 16873;
set @num2 := 16873;
execute com using @num1, @num2;
set @num1 := 16880;
set @num2 := 16880;
execute com using @num1, @num2;
set @num1 := 16881;
set @num2 := 16881;
execute com using @num1, @num2;
set @num1 := 16882;
set @num2 := 16882;
execute com using @num1, @num2;
set @num1 := 16883;
set @num2 := 16883;
execute com using @num1, @num2;
set @num1 := 16890;
set @num2 := 16890;
execute com using @num1, @num2;
set @num1 := 16892;
set @num2 := 16892;
execute com using @num1, @num2;
set @num1 := 16893;
set @num2 := 16893;
execute com using @num1, @num2;
set @num1 := 16894;
set @num2 := 16894;
execute com using @num1, @num2;
set @num1 := 16897;
set @num2 := 16897;
execute com using @num1, @num2;
set @num1 := 16899;
set @num2 := 16899;
execute com using @num1, @num2;
set @num1 := 16903;
set @num2 := 16903;
execute com using @num1, @num2;
set @num1 := 16905;
set @num2 := 16905;
execute com using @num1, @num2;
set @num1 := 16912;
set @num2 := 16912;
execute com using @num1, @num2;
set @num1 := 16914;
set @num2 := 16914;
execute com using @num1, @num2;
set @num1 := 16919;
set @num2 := 16919;
execute com using @num1, @num2;
set @num1 := 16926;
set @num2 := 16926;
execute com using @num1, @num2;
set @num1 := 16930;
set @num2 := 16930;
execute com using @num1, @num2;
set @num1 := 16938;
set @num2 := 16938;
execute com using @num1, @num2;
set @num1 := 16942;
set @num2 := 16942;
execute com using @num1, @num2;
set @num1 := 16947;
set @num2 := 16947;
execute com using @num1, @num2;
set @num1 := 16948;
set @num2 := 16948;
execute com using @num1, @num2;
set @num1 := 16954;
set @num2 := 16954;
execute com using @num1, @num2;
set @num1 := 16959;
set @num2 := 16959;
execute com using @num1, @num2;
set @num1 := 16960;
set @num2 := 16960;
execute com using @num1, @num2;
set @num1 := 16966;
set @num2 := 16966;
execute com using @num1, @num2;
set @num1 := 16971;
set @num2 := 16971;
execute com using @num1, @num2;
set @num1 := 16973;
set @num2 := 16973;
execute com using @num1, @num2;
set @num1 := 16985;
set @num2 := 16985;
execute com using @num1, @num2;
set @num1 := 16986;
set @num2 := 16986;
execute com using @num1, @num2;
set @num1 := 16988;
set @num2 := 16988;
execute com using @num1, @num2;
set @num1 := 16991;
set @num2 := 16991;
execute com using @num1, @num2;
set @num1 := 16992;
set @num2 := 16992;
execute com using @num1, @num2;
set @num1 := 16995;
set @num2 := 16995;
execute com using @num1, @num2;
set @num1 := 17006;
set @num2 := 17006;
execute com using @num1, @num2;
set @num1 := 17011;
set @num2 := 17011;
execute com using @num1, @num2;
set @num1 := 17012;
set @num2 := 17012;
execute com using @num1, @num2;
set @num1 := 17013;
set @num2 := 17013;
execute com using @num1, @num2;
set @num1 := 17022;
set @num2 := 17022;
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.