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 := 20122958;
set @num2 := 20122958;
execute com using @num1, @num2;
set @num1 := 20122959;
set @num2 := 20122959;
execute com using @num1, @num2;
set @num1 := 20123024;
set @num2 := 20123024;
execute com using @num1, @num2;
set @num1 := 20123105;
set @num2 := 20123105;
execute com using @num1, @num2;
set @num1 := 20123121;
set @num2 := 20123121;
execute com using @num1, @num2;
set @num1 := 20123471;
set @num2 := 20123471;
execute com using @num1, @num2;
set @num1 := 20123629;
set @num2 := 20123629;
execute com using @num1, @num2;
set @num1 := 20123694;
set @num2 := 20123694;
execute com using @num1, @num2;
set @num1 := 20123843;
set @num2 := 20123843;
execute com using @num1, @num2;
set @num1 := 20124131;
set @num2 := 20124131;
execute com using @num1, @num2;
set @num1 := 20124241;
set @num2 := 20124241;
execute com using @num1, @num2;
set @num1 := 20124245;
set @num2 := 20124245;
execute com using @num1, @num2;
set @num1 := 20124498;
set @num2 := 20124498;
execute com using @num1, @num2;
set @num1 := 20125175;
set @num2 := 20125175;
execute com using @num1, @num2;
set @num1 := 20125380;
set @num2 := 20125380;
execute com using @num1, @num2;
set @num1 := 20125697;
set @num2 := 20125697;
execute com using @num1, @num2;
set @num1 := 20125773;
set @num2 := 20125773;
execute com using @num1, @num2;
set @num1 := 20126005;
set @num2 := 20126005;
execute com using @num1, @num2;
set @num1 := 20126369;
set @num2 := 20126369;
execute com using @num1, @num2;
set @num1 := 20126431;
set @num2 := 20126431;
execute com using @num1, @num2;
set @num1 := 20126484;
set @num2 := 20126484;
execute com using @num1, @num2;
set @num1 := 20126528;
set @num2 := 20126528;
execute com using @num1, @num2;
set @num1 := 20126737;
set @num2 := 20126737;
execute com using @num1, @num2;
set @num1 := 20126911;
set @num2 := 20126911;
execute com using @num1, @num2;
set @num1 := 20127118;
set @num2 := 20127118;
execute com using @num1, @num2;
set @num1 := 20127191;
set @num2 := 20127191;
execute com using @num1, @num2;
set @num1 := 20127232;
set @num2 := 20127232;
execute com using @num1, @num2;
set @num1 := 20127249;
set @num2 := 20127249;
execute com using @num1, @num2;
set @num1 := 20127283;
set @num2 := 20127283;
execute com using @num1, @num2;
set @num1 := 20127398;
set @num2 := 20127398;
execute com using @num1, @num2;
set @num1 := 20127412;
set @num2 := 20127412;
execute com using @num1, @num2;
set @num1 := 20127441;
set @num2 := 20127441;
execute com using @num1, @num2;
set @num1 := 20127598;
set @num2 := 20127598;
execute com using @num1, @num2;
set @num1 := 20127650;
set @num2 := 20127650;
execute com using @num1, @num2;
set @num1 := 20127750;
set @num2 := 20127750;
execute com using @num1, @num2;
set @num1 := 20127961;
set @num2 := 20127961;
execute com using @num1, @num2;
set @num1 := 20128084;
set @num2 := 20128084;
execute com using @num1, @num2;
set @num1 := 20128094;
set @num2 := 20128094;
execute com using @num1, @num2;
set @num1 := 20128105;
set @num2 := 20128105;
execute com using @num1, @num2;
set @num1 := 20128239;
set @num2 := 20128239;
execute com using @num1, @num2;
set @num1 := 20128244;
set @num2 := 20128244;
execute com using @num1, @num2;
set @num1 := 20128343;
set @num2 := 20128343;
execute com using @num1, @num2;
set @num1 := 20128366;
set @num2 := 20128366;
execute com using @num1, @num2;
set @num1 := 20128413;
set @num2 := 20128413;
execute com using @num1, @num2;
set @num1 := 20128533;
set @num2 := 20128533;
execute com using @num1, @num2;
set @num1 := 20128577;
set @num2 := 20128577;
execute com using @num1, @num2;
set @num1 := 20128927;
set @num2 := 20128927;
execute com using @num1, @num2;
set @num1 := 20129067;
set @num2 := 20129067;
execute com using @num1, @num2;
set @num1 := 20129244;
set @num2 := 20129244;
execute com using @num1, @num2;
set @num1 := 20129447;
set @num2 := 20129447;
execute com using @num1, @num2;
set @num1 := 20129581;
set @num2 := 20129581;
execute com using @num1, @num2;
set @num1 := 20129660;
set @num2 := 20129660;
execute com using @num1, @num2;
set @num1 := 20129736;
set @num2 := 20129736;
execute com using @num1, @num2;
set @num1 := 20130010;
set @num2 := 20130010;
execute com using @num1, @num2;
set @num1 := 20130028;
set @num2 := 20130028;
execute com using @num1, @num2;
set @num1 := 20130084;
set @num2 := 20130084;
execute com using @num1, @num2;
set @num1 := 20130106;
set @num2 := 20130106;
execute com using @num1, @num2;
set @num1 := 20130134;
set @num2 := 20130134;
execute com using @num1, @num2;
set @num1 := 20130474;
set @num2 := 20130474;
execute com using @num1, @num2;
set @num1 := 20130592;
set @num2 := 20130592;
execute com using @num1, @num2;
set @num1 := 20130701;
set @num2 := 20130701;
execute com using @num1, @num2;
set @num1 := 20130730;
set @num2 := 20130730;
execute com using @num1, @num2;
set @num1 := 20130863;
set @num2 := 20130863;
execute com using @num1, @num2;
set @num1 := 20130904;
set @num2 := 20130904;
execute com using @num1, @num2;
set @num1 := 20130936;
set @num2 := 20130936;
execute com using @num1, @num2;
set @num1 := 20131029;
set @num2 := 20131029;
execute com using @num1, @num2;
set @num1 := 20131074;
set @num2 := 20131074;
execute com using @num1, @num2;
set @num1 := 20131156;
set @num2 := 20131156;
execute com using @num1, @num2;
set @num1 := 20131183;
set @num2 := 20131183;
execute com using @num1, @num2;
set @num1 := 20131287;
set @num2 := 20131287;
execute com using @num1, @num2;
set @num1 := 20131339;
set @num2 := 20131339;
execute com using @num1, @num2;
set @num1 := 20131359;
set @num2 := 20131359;
execute com using @num1, @num2;
set @num1 := 20131797;
set @num2 := 20131797;
execute com using @num1, @num2;
set @num1 := 20132021;
set @num2 := 20132021;
execute com using @num1, @num2;
set @num1 := 20132085;
set @num2 := 20132085;
execute com using @num1, @num2;
set @num1 := 20132320;
set @num2 := 20132320;
execute com using @num1, @num2;
set @num1 := 20132324;
set @num2 := 20132324;
execute com using @num1, @num2;
set @num1 := 20132343;
set @num2 := 20132343;
execute com using @num1, @num2;
set @num1 := 20132360;
set @num2 := 20132360;
execute com using @num1, @num2;
set @num1 := 20132366;
set @num2 := 20132366;
execute com using @num1, @num2;
set @num1 := 20132736;
set @num2 := 20132736;
execute com using @num1, @num2;
set @num1 := 20132755;
set @num2 := 20132755;
execute com using @num1, @num2;
set @num1 := 20132775;
set @num2 := 20132775;
execute com using @num1, @num2;
set @num1 := 20132844;
set @num2 := 20132844;
execute com using @num1, @num2;
set @num1 := 20133022;
set @num2 := 20133022;
execute com using @num1, @num2;
set @num1 := 20133633;
set @num2 := 20133633;
execute com using @num1, @num2;
set @num1 := 20133646;
set @num2 := 20133646;
execute com using @num1, @num2;
set @num1 := 20133719;
set @num2 := 20133719;
execute com using @num1, @num2;
set @num1 := 20133751;
set @num2 := 20133751;
execute com using @num1, @num2;
set @num1 := 20133845;
set @num2 := 20133845;
execute com using @num1, @num2;
set @num1 := 20134063;
set @num2 := 20134063;
execute com using @num1, @num2;
set @num1 := 20134108;
set @num2 := 20134108;
execute com using @num1, @num2;
set @num1 := 20134204;
set @num2 := 20134204;
execute com using @num1, @num2;
set @num1 := 20134553;
set @num2 := 20134553;
execute com using @num1, @num2;
set @num1 := 20134604;
set @num2 := 20134604;
execute com using @num1, @num2;
set @num1 := 20134651;
set @num2 := 20134651;
execute com using @num1, @num2;
set @num1 := 20134780;
set @num2 := 20134780;
execute com using @num1, @num2;
set @num1 := 20134849;
set @num2 := 20134849;
execute com using @num1, @num2;
set @num1 := 20134869;
set @num2 := 20134869;
execute com using @num1, @num2;
set @num1 := 20135063;
set @num2 := 20135063;
execute com using @num1, @num2;
set @num1 := 20135290;
set @num2 := 20135290;
execute com using @num1, @num2;
set @num1 := 20135364;
set @num2 := 20135364;
execute com using @num1, @num2;
set @num1 := 20135407;
set @num2 := 20135407;
execute com using @num1, @num2;
set @num1 := 20135606;
set @num2 := 20135606;
execute com using @num1, @num2;
set @num1 := 20135647;
set @num2 := 20135647;
execute com using @num1, @num2;
set @num1 := 20135652;
set @num2 := 20135652;
execute com using @num1, @num2;
set @num1 := 20135783;
set @num2 := 20135783;
execute com using @num1, @num2;
set @num1 := 20135894;
set @num2 := 20135894;
execute com using @num1, @num2;
set @num1 := 20135924;
set @num2 := 20135924;
execute com using @num1, @num2;
set @num1 := 20136044;
set @num2 := 20136044;
execute com using @num1, @num2;
set @num1 := 20136093;
set @num2 := 20136093;
execute com using @num1, @num2;
set @num1 := 20136429;
set @num2 := 20136429;
execute com using @num1, @num2;
set @num1 := 20136606;
set @num2 := 20136606;
execute com using @num1, @num2;
set @num1 := 20136741;
set @num2 := 20136741;
execute com using @num1, @num2;
set @num1 := 20136857;
set @num2 := 20136857;
execute com using @num1, @num2;
set @num1 := 20136962;
set @num2 := 20136962;
execute com using @num1, @num2;
set @num1 := 20137020;
set @num2 := 20137020;
execute com using @num1, @num2;
set @num1 := 20137071;
set @num2 := 20137071;
execute com using @num1, @num2;
set @num1 := 20137111;
set @num2 := 20137111;
execute com using @num1, @num2;
set @num1 := 20137189;
set @num2 := 20137189;
execute com using @num1, @num2;
set @num1 := 20137261;
set @num2 := 20137261;
execute com using @num1, @num2;
set @num1 := 20137386;
set @num2 := 20137386;
execute com using @num1, @num2;
set @num1 := 20137411;
set @num2 := 20137411;
execute com using @num1, @num2;
set @num1 := 20137426;
set @num2 := 20137426;
execute com using @num1, @num2;
set @num1 := 20137448;
set @num2 := 20137448;
execute com using @num1, @num2;
set @num1 := 20137455;
set @num2 := 20137455;
execute com using @num1, @num2;
set @num1 := 20137686;
set @num2 := 20137686;
execute com using @num1, @num2;
set @num1 := 20137935;
set @num2 := 20137935;
execute com using @num1, @num2;
set @num1 := 20138434;
set @num2 := 20138434;
execute com using @num1, @num2;
set @num1 := 20138455;
set @num2 := 20138455;
execute com using @num1, @num2;
set @num1 := 20138456;
set @num2 := 20138456;
execute com using @num1, @num2;
set @num1 := 20138516;
set @num2 := 20138516;
execute com using @num1, @num2;
set @num1 := 20139008;
set @num2 := 20139008;
execute com using @num1, @num2;
set @num1 := 20139015;
set @num2 := 20139015;
execute com using @num1, @num2;
set @num1 := 20139269;
set @num2 := 20139269;
execute com using @num1, @num2;
set @num1 := 20139308;
set @num2 := 20139308;
execute com using @num1, @num2;
set @num1 := 20139405;
set @num2 := 20139405;
execute com using @num1, @num2;
set @num1 := 20139469;
set @num2 := 20139469;
execute com using @num1, @num2;
set @num1 := 20139610;
set @num2 := 20139610;
execute com using @num1, @num2;
set @num1 := 20139942;
set @num2 := 20139942;
execute com using @num1, @num2;
set @num1 := 20140085;
set @num2 := 20140085;
execute com using @num1, @num2;
set @num1 := 20140234;
set @num2 := 20140234;
execute com using @num1, @num2;
set @num1 := 20140308;
set @num2 := 20140308;
execute com using @num1, @num2;
set @num1 := 20140386;
set @num2 := 20140386;
execute com using @num1, @num2;
set @num1 := 20140565;
set @num2 := 20140565;
execute com using @num1, @num2;
set @num1 := 20140610;
set @num2 := 20140610;
execute com using @num1, @num2;
set @num1 := 20140617;
set @num2 := 20140617;
execute com using @num1, @num2;
set @num1 := 20140827;
set @num2 := 20140827;
execute com using @num1, @num2;
set @num1 := 20140983;
set @num2 := 20140983;
execute com using @num1, @num2;
set @num1 := 20141382;
set @num2 := 20141382;
execute com using @num1, @num2;
set @num1 := 20141434;
set @num2 := 20141434;
execute com using @num1, @num2;
set @num1 := 20141901;
set @num2 := 20141901;
execute com using @num1, @num2;
set @num1 := 20142251;
set @num2 := 20142251;
execute com using @num1, @num2;
set @num1 := 20142268;
set @num2 := 20142268;
execute com using @num1, @num2;
set @num1 := 20142302;
set @num2 := 20142302;
execute com using @num1, @num2;
set @num1 := 20142808;
set @num2 := 20142808;
execute com using @num1, @num2;
set @num1 := 20142998;
set @num2 := 20142998;
execute com using @num1, @num2;
set @num1 := 20143079;
set @num2 := 20143079;
execute com using @num1, @num2;
set @num1 := 20143139;
set @num2 := 20143139;
execute com using @num1, @num2;
set @num1 := 20143215;
set @num2 := 20143215;
execute com using @num1, @num2;
set @num1 := 20143261;
set @num2 := 20143261;
execute com using @num1, @num2;
set @num1 := 20143837;
set @num2 := 20143837;
execute com using @num1, @num2;
set @num1 := 20143853;
set @num2 := 20143853;
execute com using @num1, @num2;
set @num1 := 20144001;
set @num2 := 20144001;
execute com using @num1, @num2;
set @num1 := 20144470;
set @num2 := 20144470;
execute com using @num1, @num2;
set @num1 := 20144653;
set @num2 := 20144653;
execute com using @num1, @num2;
set @num1 := 20144824;
set @num2 := 20144824;
execute com using @num1, @num2;
set @num1 := 20144848;
set @num2 := 20144848;
execute com using @num1, @num2;
set @num1 := 20144937;
set @num2 := 20144937;
execute com using @num1, @num2;
set @num1 := 20145143;
set @num2 := 20145143;
execute com using @num1, @num2;
set @num1 := 20145229;
set @num2 := 20145229;
execute com using @num1, @num2;
set @num1 := 20145309;
set @num2 := 20145309;
execute com using @num1, @num2;
set @num1 := 20145389;
set @num2 := 20145389;
execute com using @num1, @num2;
set @num1 := 20145519;
set @num2 := 20145519;
execute com using @num1, @num2;
set @num1 := 20145540;
set @num2 := 20145540;
execute com using @num1, @num2;
set @num1 := 20145877;
set @num2 := 20145877;
execute com using @num1, @num2;
set @num1 := 20146097;
set @num2 := 20146097;
execute com using @num1, @num2;
set @num1 := 20146279;
set @num2 := 20146279;
execute com using @num1, @num2;
set @num1 := 20146495;
set @num2 := 20146495;
execute com using @num1, @num2;
set @num1 := 20147033;
set @num2 := 20147033;
execute com using @num1, @num2;
set @num1 := 20147085;
set @num2 := 20147085;
execute com using @num1, @num2;
set @num1 := 20147369;
set @num2 := 20147369;
execute com using @num1, @num2;
set @num1 := 20147605;
set @num2 := 20147605;
execute com using @num1, @num2;
set @num1 := 20147670;
set @num2 := 20147670;
execute com using @num1, @num2;
set @num1 := 20147807;
set @num2 := 20147807;
execute com using @num1, @num2;
set @num1 := 20147819;
set @num2 := 20147819;
execute com using @num1, @num2;
set @num1 := 20148129;
set @num2 := 20148129;
execute com using @num1, @num2;
set @num1 := 20148159;
set @num2 := 20148159;
execute com using @num1, @num2;
set @num1 := 20148223;
set @num2 := 20148223;
execute com using @num1, @num2;
set @num1 := 20148343;
set @num2 := 20148343;
execute com using @num1, @num2;
set @num1 := 20148354;
set @num2 := 20148354;
execute com using @num1, @num2;
set @num1 := 20148394;
set @num2 := 20148394;
execute com using @num1, @num2;
set @num1 := 20148645;
set @num2 := 20148645;
execute com using @num1, @num2;
set @num1 := 20148765;
set @num2 := 20148765;
execute com using @num1, @num2;
set @num1 := 20149025;
set @num2 := 20149025;
execute com using @num1, @num2;
set @num1 := 20149216;
set @num2 := 20149216;
execute com using @num1, @num2;
set @num1 := 20149570;
set @num2 := 20149570;
execute com using @num1, @num2;
set @num1 := 20149955;
set @num2 := 20149955;
execute com using @num1, @num2;
set @num1 := 20149963;
set @num2 := 20149963;
execute com using @num1, @num2;
set @num1 := 20150559;
set @num2 := 20150559;
execute com using @num1, @num2;
set @num1 := 20150804;
set @num2 := 20150804;
execute com using @num1, @num2;
set @num1 := 20150837;
set @num2 := 20150837;
execute com using @num1, @num2;
set @num1 := 20151064;
set @num2 := 20151064;
execute com using @num1, @num2;
set @num1 := 20151137;
set @num2 := 20151137;
execute com using @num1, @num2;
set @num1 := 20151177;
set @num2 := 20151177;
execute com using @num1, @num2;
set @num1 := 20151223;
set @num2 := 20151223;
execute com using @num1, @num2;
set @num1 := 20151232;
set @num2 := 20151232;
execute com using @num1, @num2;
set @num1 := 20151283;
set @num2 := 20151283;
execute com using @num1, @num2;
set @num1 := 20151305;
set @num2 := 20151305;
execute com using @num1, @num2;
set @num1 := 20151327;
set @num2 := 20151327;
execute com using @num1, @num2;
set @num1 := 20151479;
set @num2 := 20151479;
execute com using @num1, @num2;
set @num1 := 20151574;
set @num2 := 20151574;
execute com using @num1, @num2;
set @num1 := 20151972;
set @num2 := 20151972;
execute com using @num1, @num2;
set @num1 := 20152133;
set @num2 := 20152133;
execute com using @num1, @num2;
set @num1 := 20152304;
set @num2 := 20152304;
execute com using @num1, @num2;
set @num1 := 20152323;
set @num2 := 20152323;
execute com using @num1, @num2;
set @num1 := 20152384;
set @num2 := 20152384;
execute com using @num1, @num2;
set @num1 := 20152655;
set @num2 := 20152655;
execute com using @num1, @num2;
set @num1 := 20152781;
set @num2 := 20152781;
execute com using @num1, @num2;
set @num1 := 20152797;
set @num2 := 20152797;
execute com using @num1, @num2;
set @num1 := 20152883;
set @num2 := 20152883;
execute com using @num1, @num2;
set @num1 := 20152885;
set @num2 := 20152885;
execute com using @num1, @num2;
set @num1 := 20152896;
set @num2 := 20152896;
execute com using @num1, @num2;
set @num1 := 20153306;
set @num2 := 20153306;
execute com using @num1, @num2;
set @num1 := 20153333;
set @num2 := 20153333;
execute com using @num1, @num2;
set @num1 := 20153419;
set @num2 := 20153419;
execute com using @num1, @num2;
set @num1 := 20153445;
set @num2 := 20153445;
execute com using @num1, @num2;
set @num1 := 20153592;
set @num2 := 20153592;
execute com using @num1, @num2;
set @num1 := 20153676;
set @num2 := 20153676;
execute com using @num1, @num2;
set @num1 := 20153719;
set @num2 := 20153719;
execute com using @num1, @num2;
set @num1 := 20154002;
set @num2 := 20154002;
execute com using @num1, @num2;
set @num1 := 20154187;
set @num2 := 20154187;
execute com using @num1, @num2;
set @num1 := 20154329;
set @num2 := 20154329;
execute com using @num1, @num2;
set @num1 := 20154370;
set @num2 := 20154370;
execute com using @num1, @num2;
set @num1 := 20154477;
set @num2 := 20154477;
execute com using @num1, @num2;
set @num1 := 20154513;
set @num2 := 20154513;
execute com using @num1, @num2;
set @num1 := 20154675;
set @num2 := 20154675;
execute com using @num1, @num2;
set @num1 := 20154717;
set @num2 := 20154717;
execute com using @num1, @num2;
set @num1 := 20154829;
set @num2 := 20154829;
execute com using @num1, @num2;
set @num1 := 20154881;
set @num2 := 20154881;
execute com using @num1, @num2;
set @num1 := 20155064;
set @num2 := 20155064;
execute com using @num1, @num2;
set @num1 := 20155099;
set @num2 := 20155099;
execute com using @num1, @num2;
set @num1 := 20155236;
set @num2 := 20155236;
execute com using @num1, @num2;
set @num1 := 20155404;
set @num2 := 20155404;
execute com using @num1, @num2;
set @num1 := 20155472;
set @num2 := 20155472;
execute com using @num1, @num2;
set @num1 := 20155503;
set @num2 := 20155503;
execute com using @num1, @num2;
set @num1 := 20155507;
set @num2 := 20155507;
execute com using @num1, @num2;
set @num1 := 20155525;
set @num2 := 20155525;
execute com using @num1, @num2;
set @num1 := 20155587;
set @num2 := 20155587;
execute com using @num1, @num2;
set @num1 := 20155650;
set @num2 := 20155650;
execute com using @num1, @num2;
set @num1 := 20155864;
set @num2 := 20155864;
execute com using @num1, @num2;
set @num1 := 20155994;
set @num2 := 20155994;
execute com using @num1, @num2;
set @num1 := 20156307;
set @num2 := 20156307;
execute com using @num1, @num2;
set @num1 := 20156639;
set @num2 := 20156639;
execute com using @num1, @num2;
set @num1 := 20156651;
set @num2 := 20156651;
execute com using @num1, @num2;
set @num1 := 20156752;
set @num2 := 20156752;
execute com using @num1, @num2;
set @num1 := 20156782;
set @num2 := 20156782;
execute com using @num1, @num2;
set @num1 := 20157124;
set @num2 := 20157124;
execute com using @num1, @num2;
set @num1 := 20157214;
set @num2 := 20157214;
execute com using @num1, @num2;
set @num1 := 20157253;
set @num2 := 20157253;
execute com using @num1, @num2;
set @num1 := 20157297;
set @num2 := 20157297;
execute com using @num1, @num2;
set @num1 := 20157632;
set @num2 := 20157632;
execute com using @num1, @num2;
set @num1 := 20157653;
set @num2 := 20157653;
execute com using @num1, @num2;
set @num1 := 20157891;
set @num2 := 20157891;
execute com using @num1, @num2;
set @num1 := 20158062;
set @num2 := 20158062;
execute com using @num1, @num2;
set @num1 := 20158091;
set @num2 := 20158091;
execute com using @num1, @num2;
set @num1 := 20158113;
set @num2 := 20158113;
execute com using @num1, @num2;
set @num1 := 20158170;
set @num2 := 20158170;
execute com using @num1, @num2;
set @num1 := 20158182;
set @num2 := 20158182;
execute com using @num1, @num2;
set @num1 := 20159413;
set @num2 := 20159413;
execute com using @num1, @num2;
set @num1 := 20159634;
set @num2 := 20159634;
execute com using @num1, @num2;
set @num1 := 20159883;
set @num2 := 20159883;
execute com using @num1, @num2;
set @num1 := 20159944;
set @num2 := 20159944;
execute com using @num1, @num2;
set @num1 := 20159996;
set @num2 := 20159996;
execute com using @num1, @num2;
set @num1 := 20160044;
set @num2 := 20160044;
execute com using @num1, @num2;
set @num1 := 20160136;
set @num2 := 20160136;
execute com using @num1, @num2;
set @num1 := 20160229;
set @num2 := 20160229;
execute com using @num1, @num2;
set @num1 := 20160277;
set @num2 := 20160277;
execute com using @num1, @num2;
set @num1 := 20160656;
set @num2 := 20160656;
execute com using @num1, @num2;
set @num1 := 20160920;
set @num2 := 20160920;
execute com using @num1, @num2;
set @num1 := 20161123;
set @num2 := 20161123;
execute com using @num1, @num2;
set @num1 := 20161245;
set @num2 := 20161245;
execute com using @num1, @num2;
set @num1 := 20161262;
set @num2 := 20161262;
execute com using @num1, @num2;
set @num1 := 20161306;
set @num2 := 20161306;
execute com using @num1, @num2;
set @num1 := 20161309;
set @num2 := 20161309;
execute com using @num1, @num2;
set @num1 := 20161356;
set @num2 := 20161356;
execute com using @num1, @num2;
set @num1 := 20161359;
set @num2 := 20161359;
execute com using @num1, @num2;
set @num1 := 20161402;
set @num2 := 20161402;
execute com using @num1, @num2;
set @num1 := 20161431;
set @num2 := 20161431;
execute com using @num1, @num2;
set @num1 := 20161502;
set @num2 := 20161502;
execute com using @num1, @num2;
set @num1 := 20161673;
set @num2 := 20161673;
execute com using @num1, @num2;
set @num1 := 20161678;
set @num2 := 20161678;
execute com using @num1, @num2;
set @num1 := 20161750;
set @num2 := 20161750;
execute com using @num1, @num2;
set @num1 := 20161931;
set @num2 := 20161931;
execute com using @num1, @num2;
set @num1 := 20162076;
set @num2 := 20162076;
execute com using @num1, @num2;
set @num1 := 20162160;
set @num2 := 20162160;
execute com using @num1, @num2;
set @num1 := 20162204;
set @num2 := 20162204;
execute com using @num1, @num2;
set @num1 := 20162307;
set @num2 := 20162307;
execute com using @num1, @num2;
set @num1 := 20162394;
set @num2 := 20162394;
execute com using @num1, @num2;
set @num1 := 20162567;
set @num2 := 20162567;
execute com using @num1, @num2;
set @num1 := 20162612;
set @num2 := 20162612;
execute com using @num1, @num2;
set @num1 := 20162892;
set @num2 := 20162892;
execute com using @num1, @num2;
set @num1 := 20162896;
set @num2 := 20162896;
execute com using @num1, @num2;
set @num1 := 20162960;
set @num2 := 20162960;
execute com using @num1, @num2;
set @num1 := 20162977;
set @num2 := 20162977;
execute com using @num1, @num2;
set @num1 := 20163012;
set @num2 := 20163012;
execute com using @num1, @num2;
set @num1 := 20163046;
set @num2 := 20163046;
execute com using @num1, @num2;
set @num1 := 20163057;
set @num2 := 20163057;
execute com using @num1, @num2;
set @num1 := 20163109;
set @num2 := 20163109;
execute com using @num1, @num2;
set @num1 := 20163127;
set @num2 := 20163127;
execute com using @num1, @num2;
set @num1 := 20163193;
set @num2 := 20163193;
execute com using @num1, @num2;
set @num1 := 20163371;
set @num2 := 20163371;
execute com using @num1, @num2;
set @num1 := 20163456;
set @num2 := 20163456;
execute com using @num1, @num2;
set @num1 := 20163528;
set @num2 := 20163528;
execute com using @num1, @num2;
set @num1 := 20163571;
set @num2 := 20163571;
execute com using @num1, @num2;
set @num1 := 20163607;
set @num2 := 20163607;
execute com using @num1, @num2;
set @num1 := 20163679;
set @num2 := 20163679;
execute com using @num1, @num2;
set @num1 := 20163777;
set @num2 := 20163777;
execute com using @num1, @num2;
set @num1 := 20163955;
set @num2 := 20163955;
execute com using @num1, @num2;
set @num1 := 20164092;
set @num2 := 20164092;
execute com using @num1, @num2;
set @num1 := 20164147;
set @num2 := 20164147;
execute com using @num1, @num2;
set @num1 := 20164244;
set @num2 := 20164244;
execute com using @num1, @num2;
set @num1 := 20164389;
set @num2 := 20164389;
execute com using @num1, @num2;
set @num1 := 20164409;
set @num2 := 20164409;
execute com using @num1, @num2;
set @num1 := 20164422;
set @num2 := 20164422;
execute com using @num1, @num2;
set @num1 := 20164469;
set @num2 := 20164469;
execute com using @num1, @num2;
set @num1 := 20165028;
set @num2 := 20165028;
execute com using @num1, @num2;
set @num1 := 20165124;
set @num2 := 20165124;
execute com using @num1, @num2;
set @num1 := 20165333;
set @num2 := 20165333;
execute com using @num1, @num2;
set @num1 := 20165433;
set @num2 := 20165433;
execute com using @num1, @num2;
set @num1 := 20165488;
set @num2 := 20165488;
execute com using @num1, @num2;
set @num1 := 20165583;
set @num2 := 20165583;
execute com using @num1, @num2;
set @num1 := 20166095;
set @num2 := 20166095;
execute com using @num1, @num2;
set @num1 := 20166228;
set @num2 := 20166228;
execute com using @num1, @num2;
set @num1 := 20166265;
set @num2 := 20166265;
execute com using @num1, @num2;
set @num1 := 20166364;
set @num2 := 20166364;
execute com using @num1, @num2;
set @num1 := 20166428;
set @num2 := 20166428;
execute com using @num1, @num2;
set @num1 := 20166459;
set @num2 := 20166459;
execute com using @num1, @num2;
set @num1 := 20166800;
set @num2 := 20166800;
execute com using @num1, @num2;
set @num1 := 20166962;
set @num2 := 20166962;
execute com using @num1, @num2;
set @num1 := 20166968;
set @num2 := 20166968;
execute com using @num1, @num2;
set @num1 := 20167002;
set @num2 := 20167002;
execute com using @num1, @num2;
set @num1 := 20167159;
set @num2 := 20167159;
execute com using @num1, @num2;
set @num1 := 20167373;
set @num2 := 20167373;
execute com using @num1, @num2;
set @num1 := 20167455;
set @num2 := 20167455;
execute com using @num1, @num2;
set @num1 := 20167496;
set @num2 := 20167496;
execute com using @num1, @num2;
set @num1 := 20167577;
set @num2 := 20167577;
execute com using @num1, @num2;
set @num1 := 20167640;
set @num2 := 20167640;
execute com using @num1, @num2;
set @num1 := 20167953;
set @num2 := 20167953;
execute com using @num1, @num2;
set @num1 := 20168100;
set @num2 := 20168100;
execute com using @num1, @num2;
set @num1 := 20168106;
set @num2 := 20168106;
execute com using @num1, @num2;
set @num1 := 20168345;
set @num2 := 20168345;
execute com using @num1, @num2;
set @num1 := 20168394;
set @num2 := 20168394;
execute com using @num1, @num2;
set @num1 := 20168648;
set @num2 := 20168648;
execute com using @num1, @num2;
set @num1 := 20168973;
set @num2 := 20168973;
execute com using @num1, @num2;
set @num1 := 20169094;
set @num2 := 20169094;
execute com using @num1, @num2;
set @num1 := 20169182;
set @num2 := 20169182;
execute com using @num1, @num2;
set @num1 := 20169234;
set @num2 := 20169234;
execute com using @num1, @num2;
set @num1 := 20169277;
set @num2 := 20169277;
execute com using @num1, @num2;
set @num1 := 20169559;
set @num2 := 20169559;
execute com using @num1, @num2;
set @num1 := 20169582;
set @num2 := 20169582;
execute com using @num1, @num2;
set @num1 := 20169624;
set @num2 := 20169624;
execute com using @num1, @num2;
set @num1 := 20169643;
set @num2 := 20169643;
execute com using @num1, @num2;
set @num1 := 20169723;
set @num2 := 20169723;
execute com using @num1, @num2;
set @num1 := 20169760;
set @num2 := 20169760;
execute com using @num1, @num2;
set @num1 := 20169779;
set @num2 := 20169779;
execute com using @num1, @num2;
set @num1 := 20170191;
set @num2 := 20170191;
execute com using @num1, @num2;
set @num1 := 20170212;
set @num2 := 20170212;
execute com using @num1, @num2;
set @num1 := 20170245;
set @num2 := 20170245;
execute com using @num1, @num2;
set @num1 := 20170581;
set @num2 := 20170581;
execute com using @num1, @num2;
set @num1 := 20170720;
set @num2 := 20170720;
execute com using @num1, @num2;
set @num1 := 20170910;
set @num2 := 20170910;
execute com using @num1, @num2;
set @num1 := 20170948;
set @num2 := 20170948;
execute com using @num1, @num2;
set @num1 := 20171044;
set @num2 := 20171044;
execute com using @num1, @num2;
set @num1 := 20171158;
set @num2 := 20171158;
execute com using @num1, @num2;
set @num1 := 20171264;
set @num2 := 20171264;
execute com using @num1, @num2;
set @num1 := 20171390;
set @num2 := 20171390;
execute com using @num1, @num2;
set @num1 := 20171511;
set @num2 := 20171511;
execute com using @num1, @num2;
set @num1 := 20171637;
set @num2 := 20171637;
execute com using @num1, @num2;
set @num1 := 20171659;
set @num2 := 20171659;
execute com using @num1, @num2;
set @num1 := 20171698;
set @num2 := 20171698;
execute com using @num1, @num2;
set @num1 := 20172054;
set @num2 := 20172054;
execute com using @num1, @num2;
set @num1 := 20172600;
set @num2 := 20172600;
execute com using @num1, @num2;
set @num1 := 20172640;
set @num2 := 20172640;
execute com using @num1, @num2;
set @num1 := 20172667;
set @num2 := 20172667;
execute com using @num1, @num2;
set @num1 := 20172795;
set @num2 := 20172795;
execute com using @num1, @num2;
set @num1 := 20173285;
set @num2 := 20173285;
execute com using @num1, @num2;
set @num1 := 20173319;
set @num2 := 20173319;
execute com using @num1, @num2;
set @num1 := 20173329;
set @num2 := 20173329;
execute com using @num1, @num2;
set @num1 := 20173584;
set @num2 := 20173584;
execute com using @num1, @num2;
set @num1 := 20173666;
set @num2 := 20173666;
execute com using @num1, @num2;
set @num1 := 20174050;
set @num2 := 20174050;
execute com using @num1, @num2;
set @num1 := 20174204;
set @num2 := 20174204;
execute com using @num1, @num2;
set @num1 := 20174411;
set @num2 := 20174411;
execute com using @num1, @num2;
set @num1 := 20174713;
set @num2 := 20174713;
execute com using @num1, @num2;
set @num1 := 20174888;
set @num2 := 20174888;
execute com using @num1, @num2;
set @num1 := 20174953;
set @num2 := 20174953;
execute com using @num1, @num2;
set @num1 := 20175348;
set @num2 := 20175348;
execute com using @num1, @num2;
set @num1 := 20175595;
set @num2 := 20175595;
execute com using @num1, @num2;
set @num1 := 20175733;
set @num2 := 20175733;
execute com using @num1, @num2;
set @num1 := 20175765;
set @num2 := 20175765;
execute com using @num1, @num2;
set @num1 := 20175785;
set @num2 := 20175785;
execute com using @num1, @num2;
set @num1 := 20175878;
set @num2 := 20175878;
execute com using @num1, @num2;
set @num1 := 20175983;
set @num2 := 20175983;
execute com using @num1, @num2;
set @num1 := 20176114;
set @num2 := 20176114;
execute com using @num1, @num2;
set @num1 := 20176247;
set @num2 := 20176247;
execute com using @num1, @num2;
set @num1 := 20176287;
set @num2 := 20176287;
execute com using @num1, @num2;
set @num1 := 20176522;
set @num2 := 20176522;
execute com using @num1, @num2;
set @num1 := 20176850;
set @num2 := 20176850;
execute com using @num1, @num2;
set @num1 := 20177010;
set @num2 := 20177010;
execute com using @num1, @num2;
set @num1 := 20177296;
set @num2 := 20177296;
execute com using @num1, @num2;
set @num1 := 20177353;
set @num2 := 20177353;
execute com using @num1, @num2;
set @num1 := 20177407;
set @num2 := 20177407;
execute com using @num1, @num2;
set @num1 := 20177464;
set @num2 := 20177464;
execute com using @num1, @num2;
set @num1 := 20177483;
set @num2 := 20177483;
execute com using @num1, @num2;
set @num1 := 20177556;
set @num2 := 20177556;
execute com using @num1, @num2;
set @num1 := 20177575;
set @num2 := 20177575;
execute com using @num1, @num2;
set @num1 := 20177637;
set @num2 := 20177637;
execute com using @num1, @num2;
set @num1 := 20177656;
set @num2 := 20177656;
execute com using @num1, @num2;
set @num1 := 20177697;
set @num2 := 20177697;
execute com using @num1, @num2;
set @num1 := 20177714;
set @num2 := 20177714;
execute com using @num1, @num2;
set @num1 := 20177753;
set @num2 := 20177753;
execute com using @num1, @num2;
set @num1 := 20177759;
set @num2 := 20177759;
execute com using @num1, @num2;
set @num1 := 20177763;
set @num2 := 20177763;
execute com using @num1, @num2;
set @num1 := 20177834;
set @num2 := 20177834;
execute com using @num1, @num2;
set @num1 := 20177960;
set @num2 := 20177960;
execute com using @num1, @num2;
set @num1 := 20178037;
set @num2 := 20178037;
execute com using @num1, @num2;
set @num1 := 20178262;
set @num2 := 20178262;
execute com using @num1, @num2;
set @num1 := 20178516;
set @num2 := 20178516;
execute com using @num1, @num2;
set @num1 := 20178657;
set @num2 := 20178657;
execute com using @num1, @num2;
set @num1 := 20178681;
set @num2 := 20178681;
execute com using @num1, @num2;
set @num1 := 20178712;
set @num2 := 20178712;
execute com using @num1, @num2;
set @num1 := 20178760;
set @num2 := 20178760;
execute com using @num1, @num2;
set @num1 := 20178788;
set @num2 := 20178788;
execute com using @num1, @num2;
set @num1 := 20178848;
set @num2 := 20178848;
execute com using @num1, @num2;
set @num1 := 20178849;
set @num2 := 20178849;
execute com using @num1, @num2;
set @num1 := 20178881;
set @num2 := 20178881;
execute com using @num1, @num2;
set @num1 := 20178911;
set @num2 := 20178911;
execute com using @num1, @num2;
set @num1 := 20179006;
set @num2 := 20179006;
execute com using @num1, @num2;
set @num1 := 20179017;
set @num2 := 20179017;
execute com using @num1, @num2;
set @num1 := 20179183;
set @num2 := 20179183;
execute com using @num1, @num2;
set @num1 := 20179343;
set @num2 := 20179343;
execute com using @num1, @num2;
set @num1 := 20179370;
set @num2 := 20179370;
execute com using @num1, @num2;
set @num1 := 20179415;
set @num2 := 20179415;
execute com using @num1, @num2;
set @num1 := 20179443;
set @num2 := 20179443;
execute com using @num1, @num2;
set @num1 := 20179479;
set @num2 := 20179479;
execute com using @num1, @num2;
set @num1 := 20179720;
set @num2 := 20179720;
execute com using @num1, @num2;
set @num1 := 20179758;
set @num2 := 20179758;
execute com using @num1, @num2;
set @num1 := 20179980;
set @num2 := 20179980;
execute com using @num1, @num2;
set @num1 := 20180016;
set @num2 := 20180016;
execute com using @num1, @num2;
set @num1 := 20180085;
set @num2 := 20180085;
execute com using @num1, @num2;
set @num1 := 20180465;
set @num2 := 20180465;
execute com using @num1, @num2;
set @num1 := 20180848;
set @num2 := 20180848;
execute com using @num1, @num2;
set @num1 := 20180998;
set @num2 := 20180998;
execute com using @num1, @num2;
set @num1 := 20181203;
set @num2 := 20181203;
execute com using @num1, @num2;
set @num1 := 20181213;
set @num2 := 20181213;
execute com using @num1, @num2;
set @num1 := 20181491;
set @num2 := 20181491;
execute com using @num1, @num2;
set @num1 := 20181562;
set @num2 := 20181562;
execute com using @num1, @num2;
set @num1 := 20181648;
set @num2 := 20181648;
execute com using @num1, @num2;
set @num1 := 20181689;
set @num2 := 20181689;
execute com using @num1, @num2;
set @num1 := 20181812;
set @num2 := 20181812;
execute com using @num1, @num2;
set @num1 := 20181860;
set @num2 := 20181860;
execute com using @num1, @num2;
set @num1 := 20181941;
set @num2 := 20181941;
execute com using @num1, @num2;
set @num1 := 20182034;
set @num2 := 20182034;
execute com using @num1, @num2;
set @num1 := 20182065;
set @num2 := 20182065;
execute com using @num1, @num2;
set @num1 := 20182868;
set @num2 := 20182868;
execute com using @num1, @num2;
set @num1 := 20183511;
set @num2 := 20183511;
execute com using @num1, @num2;
set @num1 := 20183641;
set @num2 := 20183641;
execute com using @num1, @num2;
set @num1 := 20183979;
set @num2 := 20183979;
execute com using @num1, @num2;
set @num1 := 20184005;
set @num2 := 20184005;
execute com using @num1, @num2;
set @num1 := 20184184;
set @num2 := 20184184;
execute com using @num1, @num2;
set @num1 := 20184221;
set @num2 := 20184221;
execute com using @num1, @num2;
set @num1 := 20184272;
set @num2 := 20184272;
execute com using @num1, @num2;
set @num1 := 20184349;
set @num2 := 20184349;
execute com using @num1, @num2;
set @num1 := 20184469;
set @num2 := 20184469;
execute com using @num1, @num2;
set @num1 := 20184557;
set @num2 := 20184557;
execute com using @num1, @num2;
set @num1 := 20184891;
set @num2 := 20184891;
execute com using @num1, @num2;
set @num1 := 20185322;
set @num2 := 20185322;
execute com using @num1, @num2;
set @num1 := 20185453;
set @num2 := 20185453;
execute com using @num1, @num2;
set @num1 := 20185582;
set @num2 := 20185582;
execute com using @num1, @num2;
set @num1 := 20185698;
set @num2 := 20185698;
execute com using @num1, @num2;
set @num1 := 20185854;
set @num2 := 20185854;
execute com using @num1, @num2;
set @num1 := 20186070;
set @num2 := 20186070;
execute com using @num1, @num2;
set @num1 := 20186145;
set @num2 := 20186145;
execute com using @num1, @num2;
set @num1 := 20186321;
set @num2 := 20186321;
execute com using @num1, @num2;
set @num1 := 20186335;
set @num2 := 20186335;
execute com using @num1, @num2;
set @num1 := 20186341;
set @num2 := 20186341;
execute com using @num1, @num2;
set @num1 := 20186672;
set @num2 := 20186672;
execute com using @num1, @num2;
set @num1 := 20186912;
set @num2 := 20186912;
execute com using @num1, @num2;
set @num1 := 20186915;
set @num2 := 20186915;
execute com using @num1, @num2;
set @num1 := 20187022;
set @num2 := 20187022;
execute com using @num1, @num2;
set @num1 := 20187039;
set @num2 := 20187039;
execute com using @num1, @num2;
set @num1 := 20187189;
set @num2 := 20187189;
execute com using @num1, @num2;
set @num1 := 20187254;
set @num2 := 20187254;
execute com using @num1, @num2;
set @num1 := 20187469;
set @num2 := 20187469;
execute com using @num1, @num2;
set @num1 := 20187582;
set @num2 := 20187582;
execute com using @num1, @num2;
set @num1 := 20188060;
set @num2 := 20188060;
execute com using @num1, @num2;
set @num1 := 20188146;
set @num2 := 20188146;
execute com using @num1, @num2;
set @num1 := 20188272;
set @num2 := 20188272;
execute com using @num1, @num2;
set @num1 := 20188434;
set @num2 := 20188434;
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.