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 := 20188705;
set @num2 := 20188705;
execute com using @num1, @num2;
set @num1 := 20188853;
set @num2 := 20188853;
execute com using @num1, @num2;
set @num1 := 20189085;
set @num2 := 20189085;
execute com using @num1, @num2;
set @num1 := 20189480;
set @num2 := 20189480;
execute com using @num1, @num2;
set @num1 := 20189521;
set @num2 := 20189521;
execute com using @num1, @num2;
set @num1 := 20190057;
set @num2 := 20190057;
execute com using @num1, @num2;
set @num1 := 20190111;
set @num2 := 20190111;
execute com using @num1, @num2;
set @num1 := 20190298;
set @num2 := 20190298;
execute com using @num1, @num2;
set @num1 := 20190371;
set @num2 := 20190371;
execute com using @num1, @num2;
set @num1 := 20190748;
set @num2 := 20190748;
execute com using @num1, @num2;
set @num1 := 20190831;
set @num2 := 20190831;
execute com using @num1, @num2;
set @num1 := 20191057;
set @num2 := 20191057;
execute com using @num1, @num2;
set @num1 := 20191173;
set @num2 := 20191173;
execute com using @num1, @num2;
set @num1 := 20191264;
set @num2 := 20191264;
execute com using @num1, @num2;
set @num1 := 20191386;
set @num2 := 20191386;
execute com using @num1, @num2;
set @num1 := 20191883;
set @num2 := 20191883;
execute com using @num1, @num2;
set @num1 := 20192155;
set @num2 := 20192155;
execute com using @num1, @num2;
set @num1 := 20192217;
set @num2 := 20192217;
execute com using @num1, @num2;
set @num1 := 20192294;
set @num2 := 20192294;
execute com using @num1, @num2;
set @num1 := 20192421;
set @num2 := 20192421;
execute com using @num1, @num2;
set @num1 := 20192551;
set @num2 := 20192551;
execute com using @num1, @num2;
set @num1 := 20192650;
set @num2 := 20192650;
execute com using @num1, @num2;
set @num1 := 20192825;
set @num2 := 20192825;
execute com using @num1, @num2;
set @num1 := 20193016;
set @num2 := 20193016;
execute com using @num1, @num2;
set @num1 := 20193129;
set @num2 := 20193129;
execute com using @num1, @num2;
set @num1 := 20193146;
set @num2 := 20193146;
execute com using @num1, @num2;
set @num1 := 20193190;
set @num2 := 20193190;
execute com using @num1, @num2;
set @num1 := 20193207;
set @num2 := 20193207;
execute com using @num1, @num2;
set @num1 := 20193248;
set @num2 := 20193248;
execute com using @num1, @num2;
set @num1 := 20193365;
set @num2 := 20193365;
execute com using @num1, @num2;
set @num1 := 20193426;
set @num2 := 20193426;
execute com using @num1, @num2;
set @num1 := 20193458;
set @num2 := 20193458;
execute com using @num1, @num2;
set @num1 := 20193516;
set @num2 := 20193516;
execute com using @num1, @num2;
set @num1 := 20193608;
set @num2 := 20193608;
execute com using @num1, @num2;
set @num1 := 20193654;
set @num2 := 20193654;
execute com using @num1, @num2;
set @num1 := 20193667;
set @num2 := 20193667;
execute com using @num1, @num2;
set @num1 := 20193668;
set @num2 := 20193668;
execute com using @num1, @num2;
set @num1 := 20193704;
set @num2 := 20193704;
execute com using @num1, @num2;
set @num1 := 20193855;
set @num2 := 20193855;
execute com using @num1, @num2;
set @num1 := 20193867;
set @num2 := 20193867;
execute com using @num1, @num2;
set @num1 := 20194097;
set @num2 := 20194097;
execute com using @num1, @num2;
set @num1 := 20194287;
set @num2 := 20194287;
execute com using @num1, @num2;
set @num1 := 20194310;
set @num2 := 20194310;
execute com using @num1, @num2;
set @num1 := 20194385;
set @num2 := 20194385;
execute com using @num1, @num2;
set @num1 := 20194537;
set @num2 := 20194537;
execute com using @num1, @num2;
set @num1 := 20194618;
set @num2 := 20194618;
execute com using @num1, @num2;
set @num1 := 20194621;
set @num2 := 20194621;
execute com using @num1, @num2;
set @num1 := 20194625;
set @num2 := 20194625;
execute com using @num1, @num2;
set @num1 := 20194631;
set @num2 := 20194631;
execute com using @num1, @num2;
set @num1 := 20194644;
set @num2 := 20194644;
execute com using @num1, @num2;
set @num1 := 20194659;
set @num2 := 20194659;
execute com using @num1, @num2;
set @num1 := 20194706;
set @num2 := 20194706;
execute com using @num1, @num2;
set @num1 := 20194723;
set @num2 := 20194723;
execute com using @num1, @num2;
set @num1 := 20194748;
set @num2 := 20194748;
execute com using @num1, @num2;
set @num1 := 20194772;
set @num2 := 20194772;
execute com using @num1, @num2;
set @num1 := 20194875;
set @num2 := 20194875;
execute com using @num1, @num2;
set @num1 := 20194897;
set @num2 := 20194897;
execute com using @num1, @num2;
set @num1 := 20194995;
set @num2 := 20194995;
execute com using @num1, @num2;
set @num1 := 20195328;
set @num2 := 20195328;
execute com using @num1, @num2;
set @num1 := 20195484;
set @num2 := 20195484;
execute com using @num1, @num2;
set @num1 := 20195495;
set @num2 := 20195495;
execute com using @num1, @num2;
set @num1 := 20195503;
set @num2 := 20195503;
execute com using @num1, @num2;
set @num1 := 20195522;
set @num2 := 20195522;
execute com using @num1, @num2;
set @num1 := 20195524;
set @num2 := 20195524;
execute com using @num1, @num2;
set @num1 := 20195606;
set @num2 := 20195606;
execute com using @num1, @num2;
set @num1 := 20195730;
set @num2 := 20195730;
execute com using @num1, @num2;
set @num1 := 20195912;
set @num2 := 20195912;
execute com using @num1, @num2;
set @num1 := 20195979;
set @num2 := 20195979;
execute com using @num1, @num2;
set @num1 := 20196015;
set @num2 := 20196015;
execute com using @num1, @num2;
set @num1 := 20196150;
set @num2 := 20196150;
execute com using @num1, @num2;
set @num1 := 20196796;
set @num2 := 20196796;
execute com using @num1, @num2;
set @num1 := 20196928;
set @num2 := 20196928;
execute com using @num1, @num2;
set @num1 := 20196963;
set @num2 := 20196963;
execute com using @num1, @num2;
set @num1 := 20197036;
set @num2 := 20197036;
execute com using @num1, @num2;
set @num1 := 20197204;
set @num2 := 20197204;
execute com using @num1, @num2;
set @num1 := 20197219;
set @num2 := 20197219;
execute com using @num1, @num2;
set @num1 := 20197514;
set @num2 := 20197514;
execute com using @num1, @num2;
set @num1 := 20197702;
set @num2 := 20197702;
execute com using @num1, @num2;
set @num1 := 20197943;
set @num2 := 20197943;
execute com using @num1, @num2;
set @num1 := 20198013;
set @num2 := 20198013;
execute com using @num1, @num2;
set @num1 := 20198103;
set @num2 := 20198103;
execute com using @num1, @num2;
set @num1 := 20198488;
set @num2 := 20198488;
execute com using @num1, @num2;
set @num1 := 20198675;
set @num2 := 20198675;
execute com using @num1, @num2;
set @num1 := 20198681;
set @num2 := 20198681;
execute com using @num1, @num2;
set @num1 := 20198736;
set @num2 := 20198736;
execute com using @num1, @num2;
set @num1 := 20198796;
set @num2 := 20198796;
execute com using @num1, @num2;
set @num1 := 20199157;
set @num2 := 20199157;
execute com using @num1, @num2;
set @num1 := 20199344;
set @num2 := 20199344;
execute com using @num1, @num2;
set @num1 := 20200209;
set @num2 := 20200209;
execute com using @num1, @num2;
set @num1 := 20200244;
set @num2 := 20200244;
execute com using @num1, @num2;
set @num1 := 20200414;
set @num2 := 20200414;
execute com using @num1, @num2;
set @num1 := 20200632;
set @num2 := 20200632;
execute com using @num1, @num2;
set @num1 := 20201082;
set @num2 := 20201082;
execute com using @num1, @num2;
set @num1 := 20201244;
set @num2 := 20201244;
execute com using @num1, @num2;
set @num1 := 20201245;
set @num2 := 20201245;
execute com using @num1, @num2;
set @num1 := 20201306;
set @num2 := 20201306;
execute com using @num1, @num2;
set @num1 := 20201538;
set @num2 := 20201538;
execute com using @num1, @num2;
set @num1 := 20201761;
set @num2 := 20201761;
execute com using @num1, @num2;
set @num1 := 20202056;
set @num2 := 20202056;
execute com using @num1, @num2;
set @num1 := 20202094;
set @num2 := 20202094;
execute com using @num1, @num2;
set @num1 := 20202146;
set @num2 := 20202146;
execute com using @num1, @num2;
set @num1 := 20202587;
set @num2 := 20202587;
execute com using @num1, @num2;
set @num1 := 20202652;
set @num2 := 20202652;
execute com using @num1, @num2;
set @num1 := 20202699;
set @num2 := 20202699;
execute com using @num1, @num2;
set @num1 := 20202844;
set @num2 := 20202844;
execute com using @num1, @num2;
set @num1 := 20202893;
set @num2 := 20202893;
execute com using @num1, @num2;
set @num1 := 20203340;
set @num2 := 20203340;
execute com using @num1, @num2;
set @num1 := 20203716;
set @num2 := 20203716;
execute com using @num1, @num2;
set @num1 := 20203822;
set @num2 := 20203822;
execute com using @num1, @num2;
set @num1 := 20203888;
set @num2 := 20203888;
execute com using @num1, @num2;
set @num1 := 20204310;
set @num2 := 20204310;
execute com using @num1, @num2;
set @num1 := 20204393;
set @num2 := 20204393;
execute com using @num1, @num2;
set @num1 := 20204408;
set @num2 := 20204408;
execute com using @num1, @num2;
set @num1 := 20204666;
set @num2 := 20204666;
execute com using @num1, @num2;
set @num1 := 20204735;
set @num2 := 20204735;
execute com using @num1, @num2;
set @num1 := 20204906;
set @num2 := 20204906;
execute com using @num1, @num2;
set @num1 := 20204993;
set @num2 := 20204993;
execute com using @num1, @num2;
set @num1 := 20205016;
set @num2 := 20205016;
execute com using @num1, @num2;
set @num1 := 20205113;
set @num2 := 20205113;
execute com using @num1, @num2;
set @num1 := 20205408;
set @num2 := 20205408;
execute com using @num1, @num2;
set @num1 := 20205419;
set @num2 := 20205419;
execute com using @num1, @num2;
set @num1 := 20205559;
set @num2 := 20205559;
execute com using @num1, @num2;
set @num1 := 20205816;
set @num2 := 20205816;
execute com using @num1, @num2;
set @num1 := 20206072;
set @num2 := 20206072;
execute com using @num1, @num2;
set @num1 := 20206150;
set @num2 := 20206150;
execute com using @num1, @num2;
set @num1 := 20206306;
set @num2 := 20206306;
execute com using @num1, @num2;
set @num1 := 20206330;
set @num2 := 20206330;
execute com using @num1, @num2;
set @num1 := 20206341;
set @num2 := 20206341;
execute com using @num1, @num2;
set @num1 := 20206449;
set @num2 := 20206449;
execute com using @num1, @num2;
set @num1 := 20206487;
set @num2 := 20206487;
execute com using @num1, @num2;
set @num1 := 20206526;
set @num2 := 20206526;
execute com using @num1, @num2;
set @num1 := 20206541;
set @num2 := 20206541;
execute com using @num1, @num2;
set @num1 := 20206643;
set @num2 := 20206643;
execute com using @num1, @num2;
set @num1 := 20206700;
set @num2 := 20206700;
execute com using @num1, @num2;
set @num1 := 20206864;
set @num2 := 20206864;
execute com using @num1, @num2;
set @num1 := 20206886;
set @num2 := 20206886;
execute com using @num1, @num2;
set @num1 := 20207001;
set @num2 := 20207001;
execute com using @num1, @num2;
set @num1 := 20207062;
set @num2 := 20207062;
execute com using @num1, @num2;
set @num1 := 20207138;
set @num2 := 20207138;
execute com using @num1, @num2;
set @num1 := 20207215;
set @num2 := 20207215;
execute com using @num1, @num2;
set @num1 := 20207251;
set @num2 := 20207251;
execute com using @num1, @num2;
set @num1 := 20207261;
set @num2 := 20207261;
execute com using @num1, @num2;
set @num1 := 20207383;
set @num2 := 20207383;
execute com using @num1, @num2;
set @num1 := 20207446;
set @num2 := 20207446;
execute com using @num1, @num2;
set @num1 := 20207450;
set @num2 := 20207450;
execute com using @num1, @num2;
set @num1 := 20207893;
set @num2 := 20207893;
execute com using @num1, @num2;
set @num1 := 20207976;
set @num2 := 20207976;
execute com using @num1, @num2;
set @num1 := 20207989;
set @num2 := 20207989;
execute com using @num1, @num2;
set @num1 := 20208046;
set @num2 := 20208046;
execute com using @num1, @num2;
set @num1 := 20208130;
set @num2 := 20208130;
execute com using @num1, @num2;
set @num1 := 20208317;
set @num2 := 20208317;
execute com using @num1, @num2;
set @num1 := 20208515;
set @num2 := 20208515;
execute com using @num1, @num2;
set @num1 := 20208536;
set @num2 := 20208536;
execute com using @num1, @num2;
set @num1 := 20208537;
set @num2 := 20208537;
execute com using @num1, @num2;
set @num1 := 20208919;
set @num2 := 20208919;
execute com using @num1, @num2;
set @num1 := 20208952;
set @num2 := 20208952;
execute com using @num1, @num2;
set @num1 := 20209033;
set @num2 := 20209033;
execute com using @num1, @num2;
set @num1 := 20209091;
set @num2 := 20209091;
execute com using @num1, @num2;
set @num1 := 20209270;
set @num2 := 20209270;
execute com using @num1, @num2;
set @num1 := 20209394;
set @num2 := 20209394;
execute com using @num1, @num2;
set @num1 := 20209438;
set @num2 := 20209438;
execute com using @num1, @num2;
set @num1 := 20209667;
set @num2 := 20209667;
execute com using @num1, @num2;
set @num1 := 20209860;
set @num2 := 20209860;
execute com using @num1, @num2;
set @num1 := 20209928;
set @num2 := 20209928;
execute com using @num1, @num2;
set @num1 := 20209988;
set @num2 := 20209988;
execute com using @num1, @num2;
set @num1 := 20210027;
set @num2 := 20210027;
execute com using @num1, @num2;
set @num1 := 20210035;
set @num2 := 20210035;
execute com using @num1, @num2;
set @num1 := 20210168;
set @num2 := 20210168;
execute com using @num1, @num2;
set @num1 := 20210371;
set @num2 := 20210371;
execute com using @num1, @num2;
set @num1 := 20210644;
set @num2 := 20210644;
execute com using @num1, @num2;
set @num1 := 20210813;
set @num2 := 20210813;
execute com using @num1, @num2;
set @num1 := 20211228;
set @num2 := 20211228;
execute com using @num1, @num2;
set @num1 := 20211347;
set @num2 := 20211347;
execute com using @num1, @num2;
set @num1 := 20211517;
set @num2 := 20211517;
execute com using @num1, @num2;
set @num1 := 20211596;
set @num2 := 20211596;
execute com using @num1, @num2;
set @num1 := 20211701;
set @num2 := 20211701;
execute com using @num1, @num2;
set @num1 := 20211733;
set @num2 := 20211733;
execute com using @num1, @num2;
set @num1 := 20211817;
set @num2 := 20211817;
execute com using @num1, @num2;
set @num1 := 20211854;
set @num2 := 20211854;
execute com using @num1, @num2;
set @num1 := 20211917;
set @num2 := 20211917;
execute com using @num1, @num2;
set @num1 := 20211999;
set @num2 := 20211999;
execute com using @num1, @num2;
set @num1 := 20212108;
set @num2 := 20212108;
execute com using @num1, @num2;
set @num1 := 20212166;
set @num2 := 20212166;
execute com using @num1, @num2;
set @num1 := 20212212;
set @num2 := 20212212;
execute com using @num1, @num2;
set @num1 := 20212249;
set @num2 := 20212249;
execute com using @num1, @num2;
set @num1 := 20212368;
set @num2 := 20212368;
execute com using @num1, @num2;
set @num1 := 20212433;
set @num2 := 20212433;
execute com using @num1, @num2;
set @num1 := 20212513;
set @num2 := 20212513;
execute com using @num1, @num2;
set @num1 := 20212802;
set @num2 := 20212802;
execute com using @num1, @num2;
set @num1 := 20212895;
set @num2 := 20212895;
execute com using @num1, @num2;
set @num1 := 20212959;
set @num2 := 20212959;
execute com using @num1, @num2;
set @num1 := 20213052;
set @num2 := 20213052;
execute com using @num1, @num2;
set @num1 := 20213262;
set @num2 := 20213262;
execute com using @num1, @num2;
set @num1 := 20213373;
set @num2 := 20213373;
execute com using @num1, @num2;
set @num1 := 20213432;
set @num2 := 20213432;
execute com using @num1, @num2;
set @num1 := 20213640;
set @num2 := 20213640;
execute com using @num1, @num2;
set @num1 := 20213704;
set @num2 := 20213704;
execute com using @num1, @num2;
set @num1 := 20213856;
set @num2 := 20213856;
execute com using @num1, @num2;
set @num1 := 20213946;
set @num2 := 20213946;
execute com using @num1, @num2;
set @num1 := 20214302;
set @num2 := 20214302;
execute com using @num1, @num2;
set @num1 := 20214319;
set @num2 := 20214319;
execute com using @num1, @num2;
set @num1 := 20214438;
set @num2 := 20214438;
execute com using @num1, @num2;
set @num1 := 20214627;
set @num2 := 20214627;
execute com using @num1, @num2;
set @num1 := 20214756;
set @num2 := 20214756;
execute com using @num1, @num2;
set @num1 := 20214776;
set @num2 := 20214776;
execute com using @num1, @num2;
set @num1 := 20214847;
set @num2 := 20214847;
execute com using @num1, @num2;
set @num1 := 20214998;
set @num2 := 20214998;
execute com using @num1, @num2;
set @num1 := 20215359;
set @num2 := 20215359;
execute com using @num1, @num2;
set @num1 := 20215396;
set @num2 := 20215396;
execute com using @num1, @num2;
set @num1 := 20215583;
set @num2 := 20215583;
execute com using @num1, @num2;
set @num1 := 20215722;
set @num2 := 20215722;
execute com using @num1, @num2;
set @num1 := 20215812;
set @num2 := 20215812;
execute com using @num1, @num2;
set @num1 := 20215983;
set @num2 := 20215983;
execute com using @num1, @num2;
set @num1 := 20216081;
set @num2 := 20216081;
execute com using @num1, @num2;
set @num1 := 20216290;
set @num2 := 20216290;
execute com using @num1, @num2;
set @num1 := 20216323;
set @num2 := 20216323;
execute com using @num1, @num2;
set @num1 := 20216350;
set @num2 := 20216350;
execute com using @num1, @num2;
set @num1 := 20216556;
set @num2 := 20216556;
execute com using @num1, @num2;
set @num1 := 20216645;
set @num2 := 20216645;
execute com using @num1, @num2;
set @num1 := 20216673;
set @num2 := 20216673;
execute com using @num1, @num2;
set @num1 := 20216687;
set @num2 := 20216687;
execute com using @num1, @num2;
set @num1 := 20216995;
set @num2 := 20216995;
execute com using @num1, @num2;
set @num1 := 20217150;
set @num2 := 20217150;
execute com using @num1, @num2;
set @num1 := 20217230;
set @num2 := 20217230;
execute com using @num1, @num2;
set @num1 := 20217322;
set @num2 := 20217322;
execute com using @num1, @num2;
set @num1 := 20217336;
set @num2 := 20217336;
execute com using @num1, @num2;
set @num1 := 20217375;
set @num2 := 20217375;
execute com using @num1, @num2;
set @num1 := 20217474;
set @num2 := 20217474;
execute com using @num1, @num2;
set @num1 := 20217541;
set @num2 := 20217541;
execute com using @num1, @num2;
set @num1 := 20217688;
set @num2 := 20217688;
execute com using @num1, @num2;
set @num1 := 20217777;
set @num2 := 20217777;
execute com using @num1, @num2;
set @num1 := 20217946;
set @num2 := 20217946;
execute com using @num1, @num2;
set @num1 := 20217959;
set @num2 := 20217959;
execute com using @num1, @num2;
set @num1 := 20217980;
set @num2 := 20217980;
execute com using @num1, @num2;
set @num1 := 20218072;
set @num2 := 20218072;
execute com using @num1, @num2;
set @num1 := 20218079;
set @num2 := 20218079;
execute com using @num1, @num2;
set @num1 := 20218261;
set @num2 := 20218261;
execute com using @num1, @num2;
set @num1 := 20218474;
set @num2 := 20218474;
execute com using @num1, @num2;
set @num1 := 20218968;
set @num2 := 20218968;
execute com using @num1, @num2;
set @num1 := 20219314;
set @num2 := 20219314;
execute com using @num1, @num2;
set @num1 := 20219356;
set @num2 := 20219356;
execute com using @num1, @num2;
set @num1 := 20219598;
set @num2 := 20219598;
execute com using @num1, @num2;
set @num1 := 20219936;
set @num2 := 20219936;
execute com using @num1, @num2;
set @num1 := 20219973;
set @num2 := 20219973;
execute com using @num1, @num2;
set @num1 := 20220097;
set @num2 := 20220097;
execute com using @num1, @num2;
set @num1 := 20220119;
set @num2 := 20220119;
execute com using @num1, @num2;
set @num1 := 20220154;
set @num2 := 20220154;
execute com using @num1, @num2;
set @num1 := 20220317;
set @num2 := 20220317;
execute com using @num1, @num2;
set @num1 := 20220514;
set @num2 := 20220514;
execute com using @num1, @num2;
set @num1 := 20220563;
set @num2 := 20220563;
execute com using @num1, @num2;
set @num1 := 20220702;
set @num2 := 20220702;
execute com using @num1, @num2;
set @num1 := 20220712;
set @num2 := 20220712;
execute com using @num1, @num2;
set @num1 := 20220732;
set @num2 := 20220732;
execute com using @num1, @num2;
set @num1 := 20220748;
set @num2 := 20220748;
execute com using @num1, @num2;
set @num1 := 20220978;
set @num2 := 20220978;
execute com using @num1, @num2;
set @num1 := 20221067;
set @num2 := 20221067;
execute com using @num1, @num2;
set @num1 := 20221136;
set @num2 := 20221136;
execute com using @num1, @num2;
set @num1 := 20221342;
set @num2 := 20221342;
execute com using @num1, @num2;
set @num1 := 20221557;
set @num2 := 20221557;
execute com using @num1, @num2;
set @num1 := 20221560;
set @num2 := 20221560;
execute com using @num1, @num2;
set @num1 := 20221596;
set @num2 := 20221596;
execute com using @num1, @num2;
set @num1 := 20221597;
set @num2 := 20221597;
execute com using @num1, @num2;
set @num1 := 20221658;
set @num2 := 20221658;
execute com using @num1, @num2;
set @num1 := 20221779;
set @num2 := 20221779;
execute com using @num1, @num2;
set @num1 := 20221814;
set @num2 := 20221814;
execute com using @num1, @num2;
set @num1 := 20221835;
set @num2 := 20221835;
execute com using @num1, @num2;
set @num1 := 20221974;
set @num2 := 20221974;
execute com using @num1, @num2;
set @num1 := 20222069;
set @num2 := 20222069;
execute com using @num1, @num2;
set @num1 := 20222160;
set @num2 := 20222160;
execute com using @num1, @num2;
set @num1 := 20222491;
set @num2 := 20222491;
execute com using @num1, @num2;
set @num1 := 20222574;
set @num2 := 20222574;
execute com using @num1, @num2;
set @num1 := 20222647;
set @num2 := 20222647;
execute com using @num1, @num2;
set @num1 := 20222702;
set @num2 := 20222702;
execute com using @num1, @num2;
set @num1 := 20222705;
set @num2 := 20222705;
execute com using @num1, @num2;
set @num1 := 20222828;
set @num2 := 20222828;
execute com using @num1, @num2;
set @num1 := 20222830;
set @num2 := 20222830;
execute com using @num1, @num2;
set @num1 := 20223048;
set @num2 := 20223048;
execute com using @num1, @num2;
set @num1 := 20223233;
set @num2 := 20223233;
execute com using @num1, @num2;
set @num1 := 20223340;
set @num2 := 20223340;
execute com using @num1, @num2;
set @num1 := 20223361;
set @num2 := 20223361;
execute com using @num1, @num2;
set @num1 := 20223485;
set @num2 := 20223485;
execute com using @num1, @num2;
set @num1 := 20223641;
set @num2 := 20223641;
execute com using @num1, @num2;
set @num1 := 20223735;
set @num2 := 20223735;
execute com using @num1, @num2;
set @num1 := 20224043;
set @num2 := 20224043;
execute com using @num1, @num2;
set @num1 := 20224059;
set @num2 := 20224059;
execute com using @num1, @num2;
set @num1 := 20224096;
set @num2 := 20224096;
execute com using @num1, @num2;
set @num1 := 20224209;
set @num2 := 20224209;
execute com using @num1, @num2;
set @num1 := 20224339;
set @num2 := 20224339;
execute com using @num1, @num2;
set @num1 := 20224363;
set @num2 := 20224363;
execute com using @num1, @num2;
set @num1 := 20224544;
set @num2 := 20224544;
execute com using @num1, @num2;
set @num1 := 20224549;
set @num2 := 20224549;
execute com using @num1, @num2;
set @num1 := 20224722;
set @num2 := 20224722;
execute com using @num1, @num2;
set @num1 := 20224734;
set @num2 := 20224734;
execute com using @num1, @num2;
set @num1 := 20224767;
set @num2 := 20224767;
execute com using @num1, @num2;
set @num1 := 20224843;
set @num2 := 20224843;
execute com using @num1, @num2;
set @num1 := 20224969;
set @num2 := 20224969;
execute com using @num1, @num2;
set @num1 := 20225362;
set @num2 := 20225362;
execute com using @num1, @num2;
set @num1 := 20225685;
set @num2 := 20225685;
execute com using @num1, @num2;
set @num1 := 20225763;
set @num2 := 20225763;
execute com using @num1, @num2;
set @num1 := 20225912;
set @num2 := 20225912;
execute com using @num1, @num2;
set @num1 := 20226177;
set @num2 := 20226177;
execute com using @num1, @num2;
set @num1 := 20226643;
set @num2 := 20226643;
execute com using @num1, @num2;
set @num1 := 20226846;
set @num2 := 20226846;
execute com using @num1, @num2;
set @num1 := 20226874;
set @num2 := 20226874;
execute com using @num1, @num2;
set @num1 := 20227238;
set @num2 := 20227238;
execute com using @num1, @num2;
set @num1 := 20227382;
set @num2 := 20227382;
execute com using @num1, @num2;
set @num1 := 20227835;
set @num2 := 20227835;
execute com using @num1, @num2;
set @num1 := 20228019;
set @num2 := 20228019;
execute com using @num1, @num2;
set @num1 := 20228092;
set @num2 := 20228092;
execute com using @num1, @num2;
set @num1 := 20228169;
set @num2 := 20228169;
execute com using @num1, @num2;
set @num1 := 20228224;
set @num2 := 20228224;
execute com using @num1, @num2;
set @num1 := 20228495;
set @num2 := 20228495;
execute com using @num1, @num2;
set @num1 := 20228513;
set @num2 := 20228513;
execute com using @num1, @num2;
set @num1 := 20228558;
set @num2 := 20228558;
execute com using @num1, @num2;
set @num1 := 20229043;
set @num2 := 20229043;
execute com using @num1, @num2;
set @num1 := 20229641;
set @num2 := 20229641;
execute com using @num1, @num2;
set @num1 := 20229883;
set @num2 := 20229883;
execute com using @num1, @num2;
set @num1 := 20230030;
set @num2 := 20230030;
execute com using @num1, @num2;
set @num1 := 20230130;
set @num2 := 20230130;
execute com using @num1, @num2;
set @num1 := 20230427;
set @num2 := 20230427;
execute com using @num1, @num2;
set @num1 := 20230612;
set @num2 := 20230612;
execute com using @num1, @num2;
set @num1 := 20230632;
set @num2 := 20230632;
execute com using @num1, @num2;
set @num1 := 20231471;
set @num2 := 20231471;
execute com using @num1, @num2;
set @num1 := 20231562;
set @num2 := 20231562;
execute com using @num1, @num2;
set @num1 := 20231594;
set @num2 := 20231594;
execute com using @num1, @num2;
set @num1 := 20231648;
set @num2 := 20231648;
execute com using @num1, @num2;
set @num1 := 20231686;
set @num2 := 20231686;
execute com using @num1, @num2;
set @num1 := 20231888;
set @num2 := 20231888;
execute com using @num1, @num2;
set @num1 := 20232392;
set @num2 := 20232392;
execute com using @num1, @num2;
set @num1 := 20232514;
set @num2 := 20232514;
execute com using @num1, @num2;
set @num1 := 20232612;
set @num2 := 20232612;
execute com using @num1, @num2;
set @num1 := 20232717;
set @num2 := 20232717;
execute com using @num1, @num2;
set @num1 := 20232839;
set @num2 := 20232839;
execute com using @num1, @num2;
set @num1 := 20232862;
set @num2 := 20232862;
execute com using @num1, @num2;
set @num1 := 20232978;
set @num2 := 20232978;
execute com using @num1, @num2;
set @num1 := 20233159;
set @num2 := 20233159;
execute com using @num1, @num2;
set @num1 := 20233171;
set @num2 := 20233171;
execute com using @num1, @num2;
set @num1 := 20233279;
set @num2 := 20233279;
execute com using @num1, @num2;
set @num1 := 20233356;
set @num2 := 20233356;
execute com using @num1, @num2;
set @num1 := 20233374;
set @num2 := 20233374;
execute com using @num1, @num2;
set @num1 := 20233516;
set @num2 := 20233516;
execute com using @num1, @num2;
set @num1 := 20233631;
set @num2 := 20233631;
execute com using @num1, @num2;
set @num1 := 20233712;
set @num2 := 20233712;
execute com using @num1, @num2;
set @num1 := 20233900;
set @num2 := 20233900;
execute com using @num1, @num2;
set @num1 := 20233977;
set @num2 := 20233977;
execute com using @num1, @num2;
set @num1 := 20234003;
set @num2 := 20234003;
execute com using @num1, @num2;
set @num1 := 20234048;
set @num2 := 20234048;
execute com using @num1, @num2;
set @num1 := 20234368;
set @num2 := 20234368;
execute com using @num1, @num2;
set @num1 := 20234558;
set @num2 := 20234558;
execute com using @num1, @num2;
set @num1 := 20234687;
set @num2 := 20234687;
execute com using @num1, @num2;
set @num1 := 20234882;
set @num2 := 20234882;
execute com using @num1, @num2;
set @num1 := 20234883;
set @num2 := 20234883;
execute com using @num1, @num2;
set @num1 := 20235057;
set @num2 := 20235057;
execute com using @num1, @num2;
set @num1 := 20235086;
set @num2 := 20235086;
execute com using @num1, @num2;
set @num1 := 20235471;
set @num2 := 20235471;
execute com using @num1, @num2;
set @num1 := 20235548;
set @num2 := 20235548;
execute com using @num1, @num2;
set @num1 := 20235670;
set @num2 := 20235670;
execute com using @num1, @num2;
set @num1 := 20235801;
set @num2 := 20235801;
execute com using @num1, @num2;
set @num1 := 20235836;
set @num2 := 20235836;
execute com using @num1, @num2;
set @num1 := 20235839;
set @num2 := 20235839;
execute com using @num1, @num2;
set @num1 := 20236320;
set @num2 := 20236320;
execute com using @num1, @num2;
set @num1 := 20236400;
set @num2 := 20236400;
execute com using @num1, @num2;
set @num1 := 20236413;
set @num2 := 20236413;
execute com using @num1, @num2;
set @num1 := 20236521;
set @num2 := 20236521;
execute com using @num1, @num2;
set @num1 := 20236525;
set @num2 := 20236525;
execute com using @num1, @num2;
set @num1 := 20236673;
set @num2 := 20236673;
execute com using @num1, @num2;
set @num1 := 20236835;
set @num2 := 20236835;
execute com using @num1, @num2;
set @num1 := 20236878;
set @num2 := 20236878;
execute com using @num1, @num2;
set @num1 := 20237248;
set @num2 := 20237248;
execute com using @num1, @num2;
set @num1 := 20237527;
set @num2 := 20237527;
execute com using @num1, @num2;
set @num1 := 20237533;
set @num2 := 20237533;
execute com using @num1, @num2;
set @num1 := 20237606;
set @num2 := 20237606;
execute com using @num1, @num2;
set @num1 := 20237667;
set @num2 := 20237667;
execute com using @num1, @num2;
set @num1 := 20237925;
set @num2 := 20237925;
execute com using @num1, @num2;
set @num1 := 20237991;
set @num2 := 20237991;
execute com using @num1, @num2;
set @num1 := 20238015;
set @num2 := 20238015;
execute com using @num1, @num2;
set @num1 := 20238049;
set @num2 := 20238049;
execute com using @num1, @num2;
set @num1 := 20238168;
set @num2 := 20238168;
execute com using @num1, @num2;
set @num1 := 20238994;
set @num2 := 20238994;
execute com using @num1, @num2;
set @num1 := 20239010;
set @num2 := 20239010;
execute com using @num1, @num2;
set @num1 := 20239277;
set @num2 := 20239277;
execute com using @num1, @num2;
set @num1 := 20239428;
set @num2 := 20239428;
execute com using @num1, @num2;
set @num1 := 20239638;
set @num2 := 20239638;
execute com using @num1, @num2;
set @num1 := 20239701;
set @num2 := 20239701;
execute com using @num1, @num2;
set @num1 := 20239791;
set @num2 := 20239791;
execute com using @num1, @num2;
set @num1 := 20239858;
set @num2 := 20239858;
execute com using @num1, @num2;
set @num1 := 20240172;
set @num2 := 20240172;
execute com using @num1, @num2;
set @num1 := 20240232;
set @num2 := 20240232;
execute com using @num1, @num2;
set @num1 := 20240263;
set @num2 := 20240263;
execute com using @num1, @num2;
set @num1 := 20240301;
set @num2 := 20240301;
execute com using @num1, @num2;
set @num1 := 20240419;
set @num2 := 20240419;
execute com using @num1, @num2;
set @num1 := 20240448;
set @num2 := 20240448;
execute com using @num1, @num2;
set @num1 := 20240506;
set @num2 := 20240506;
execute com using @num1, @num2;
set @num1 := 20240600;
set @num2 := 20240600;
execute com using @num1, @num2;
set @num1 := 20240666;
set @num2 := 20240666;
execute com using @num1, @num2;
set @num1 := 20240742;
set @num2 := 20240742;
execute com using @num1, @num2;
set @num1 := 20240809;
set @num2 := 20240809;
execute com using @num1, @num2;
set @num1 := 20240873;
set @num2 := 20240873;
execute com using @num1, @num2;
set @num1 := 20240948;
set @num2 := 20240948;
execute com using @num1, @num2;
set @num1 := 20241038;
set @num2 := 20241038;
execute com using @num1, @num2;
set @num1 := 20241172;
set @num2 := 20241172;
execute com using @num1, @num2;
set @num1 := 20241250;
set @num2 := 20241250;
execute com using @num1, @num2;
set @num1 := 20241566;
set @num2 := 20241566;
execute com using @num1, @num2;
set @num1 := 20241796;
set @num2 := 20241796;
execute com using @num1, @num2;
set @num1 := 20241835;
set @num2 := 20241835;
execute com using @num1, @num2;
set @num1 := 20241862;
set @num2 := 20241862;
execute com using @num1, @num2;
set @num1 := 20242418;
set @num2 := 20242418;
execute com using @num1, @num2;
set @num1 := 20242930;
set @num2 := 20242930;
execute com using @num1, @num2;
set @num1 := 20243097;
set @num2 := 20243097;
execute com using @num1, @num2;
set @num1 := 20243540;
set @num2 := 20243540;
execute com using @num1, @num2;
set @num1 := 20243582;
set @num2 := 20243582;
execute com using @num1, @num2;
set @num1 := 20244024;
set @num2 := 20244024;
execute com using @num1, @num2;
set @num1 := 20244215;
set @num2 := 20244215;
execute com using @num1, @num2;
set @num1 := 20244295;
set @num2 := 20244295;
execute com using @num1, @num2;
set @num1 := 20244459;
set @num2 := 20244459;
execute com using @num1, @num2;
set @num1 := 20244741;
set @num2 := 20244741;
execute com using @num1, @num2;
set @num1 := 20244796;
set @num2 := 20244796;
execute com using @num1, @num2;
set @num1 := 20244828;
set @num2 := 20244828;
execute com using @num1, @num2;
set @num1 := 20245122;
set @num2 := 20245122;
execute com using @num1, @num2;
set @num1 := 20245488;
set @num2 := 20245488;
execute com using @num1, @num2;
set @num1 := 20245517;
set @num2 := 20245517;
execute com using @num1, @num2;
set @num1 := 20245730;
set @num2 := 20245730;
execute com using @num1, @num2;
set @num1 := 20245747;
set @num2 := 20245747;
execute com using @num1, @num2;
set @num1 := 20246114;
set @num2 := 20246114;
execute com using @num1, @num2;
set @num1 := 20246201;
set @num2 := 20246201;
execute com using @num1, @num2;
set @num1 := 20246631;
set @num2 := 20246631;
execute com using @num1, @num2;
set @num1 := 20246739;
set @num2 := 20246739;
execute com using @num1, @num2;
set @num1 := 20247397;
set @num2 := 20247397;
execute com using @num1, @num2;
set @num1 := 20247604;
set @num2 := 20247604;
execute com using @num1, @num2;
set @num1 := 20247963;
set @num2 := 20247963;
execute com using @num1, @num2;
set @num1 := 20247980;
set @num2 := 20247980;
execute com using @num1, @num2;
set @num1 := 20248029;
set @num2 := 20248029;
execute com using @num1, @num2;
set @num1 := 20248283;
set @num2 := 20248283;
execute com using @num1, @num2;
set @num1 := 20248326;
set @num2 := 20248326;
execute com using @num1, @num2;
set @num1 := 20249125;
set @num2 := 20249125;
execute com using @num1, @num2;
set @num1 := 20249181;
set @num2 := 20249181;
execute com using @num1, @num2;
set @num1 := 20249250;
set @num2 := 20249250;
execute com using @num1, @num2;
set @num1 := 20249484;
set @num2 := 20249484;
execute com using @num1, @num2;
set @num1 := 20249750;
set @num2 := 20249750;
execute com using @num1, @num2;
set @num1 := 20250413;
set @num2 := 20250413;
execute com using @num1, @num2;
set @num1 := 20250809;
set @num2 := 20250809;
execute com using @num1, @num2;
set @num1 := 20250821;
set @num2 := 20250821;
execute com using @num1, @num2;
set @num1 := 20250921;
set @num2 := 20250921;
execute com using @num1, @num2;
set @num1 := 20250979;
set @num2 := 20250979;
execute com using @num1, @num2;
set @num1 := 20251224;
set @num2 := 20251224;
execute com using @num1, @num2;
set @num1 := 20251276;
set @num2 := 20251276;
execute com using @num1, @num2;
set @num1 := 20251370;
set @num2 := 20251370;
execute com using @num1, @num2;
set @num1 := 20251674;
set @num2 := 20251674;
execute com using @num1, @num2;
set @num1 := 20251793;
set @num2 := 20251793;
execute com using @num1, @num2;
set @num1 := 20251858;
set @num2 := 20251858;
execute com using @num1, @num2;
set @num1 := 20252479;
set @num2 := 20252479;
execute com using @num1, @num2;
set @num1 := 20252532;
set @num2 := 20252532;
execute com using @num1, @num2;
set @num1 := 20252949;
set @num2 := 20252949;
execute com using @num1, @num2;
set @num1 := 20253094;
set @num2 := 20253094;
execute com using @num1, @num2;
set @num1 := 20253775;
set @num2 := 20253775;
execute com using @num1, @num2;
set @num1 := 20253822;
set @num2 := 20253822;
execute com using @num1, @num2;
set @num1 := 20253983;
set @num2 := 20253983;
execute com using @num1, @num2;
set @num1 := 20254041;
set @num2 := 20254041;
execute com using @num1, @num2;
set @num1 := 20254162;
set @num2 := 20254162;
execute com using @num1, @num2;
set @num1 := 20254750;
set @num2 := 20254750;
execute com using @num1, @num2;
set @num1 := 20255258;
set @num2 := 20255258;
execute com using @num1, @num2;
set @num1 := 20255585;
set @num2 := 20255585;
execute com using @num1, @num2;
set @num1 := 20255656;
set @num2 := 20255656;
execute com using @num1, @num2;
set @num1 := 20255739;
set @num2 := 20255739;
execute com using @num1, @num2;
set @num1 := 20255982;
set @num2 := 20255982;
execute com using @num1, @num2;
set @num1 := 20256071;
set @num2 := 20256071;
execute com using @num1, @num2;
set @num1 := 20256360;
set @num2 := 20256360;
execute com using @num1, @num2;
set @num1 := 20256470;
set @num2 := 20256470;
execute com using @num1, @num2;
set @num1 := 20256802;
set @num2 := 20256802;
execute com using @num1, @num2;
set @num1 := 20256898;
set @num2 := 20256898;
execute com using @num1, @num2;
set @num1 := 20256917;
set @num2 := 20256917;
execute com using @num1, @num2;
set @num1 := 20257152;
set @num2 := 20257152;
execute com using @num1, @num2;
set @num1 := 20257206;
set @num2 := 20257206;
execute com using @num1, @num2;
set @num1 := 20257359;
set @num2 := 20257359;
execute com using @num1, @num2;
set @num1 := 20257628;
set @num2 := 20257628;
execute com using @num1, @num2;
set @num1 := 20257730;
set @num2 := 20257730;
execute com using @num1, @num2;
set @num1 := 20257908;
set @num2 := 20257908;
execute com using @num1, @num2;
set @num1 := 20257969;
set @num2 := 20257969;
execute com using @num1, @num2;
set @num1 := 20258013;
set @num2 := 20258013;
execute com using @num1, @num2;
set @num1 := 20258111;
set @num2 := 20258111;
execute com using @num1, @num2;
set @num1 := 20258216;
set @num2 := 20258216;
execute com using @num1, @num2;
set @num1 := 20258382;
set @num2 := 20258382;
execute com using @num1, @num2;
set @num1 := 20258429;
set @num2 := 20258429;
execute com using @num1, @num2;
set @num1 := 20258556;
set @num2 := 20258556;
execute com using @num1, @num2;
set @num1 := 20258698;
set @num2 := 20258698;
execute com using @num1, @num2;
set @num1 := 20258813;
set @num2 := 20258813;
execute com using @num1, @num2;
set @num1 := 20258861;
set @num2 := 20258861;
execute com using @num1, @num2;
set @num1 := 20259028;
set @num2 := 20259028;
execute com using @num1, @num2;
set @num1 := 20259190;
set @num2 := 20259190;
execute com using @num1, @num2;
set @num1 := 20259298;
set @num2 := 20259298;
execute com using @num1, @num2;
set @num1 := 20259327;
set @num2 := 20259327;
execute com using @num1, @num2;
set @num1 := 20259362;
set @num2 := 20259362;
execute com using @num1, @num2;
set @num1 := 20259492;
set @num2 := 20259492;
execute com using @num1, @num2;
set @num1 := 20259632;
set @num2 := 20259632;
execute com using @num1, @num2;
set @num1 := 20259705;
set @num2 := 20259705;
execute com using @num1, @num2;
set @num1 := 20259818;
set @num2 := 20259818;
execute com using @num1, @num2;
set @num1 := 20259977;
set @num2 := 20259977;
execute com using @num1, @num2;
set @num1 := 20260013;
set @num2 := 20260013;
execute com using @num1, @num2;
set @num1 := 20260016;
set @num2 := 20260016;
execute com using @num1, @num2;
set @num1 := 20260055;
set @num2 := 20260055;
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.