To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 168288
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168288'
The Shares Amount is 0
The cusip is G44690116
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G44690116'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G44690116'
Number of Rows :288
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96499691'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96345091'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96491905'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96510116'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96511267'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96785603'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96870432'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96882605'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96943480'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97053791'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97076453'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97180551'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97190601'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97270505'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97306166'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97414880'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97518020'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97807124'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97807268'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97812160'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97836718'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97857145'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97906253'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97914683'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98118178'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98239045'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98239457'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '96765011'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97025002'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97060531'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97183270'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97283510'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97386471'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97442970'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97707300'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97707507'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97728795'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97769245'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97798660'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97802632'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97807672'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97812766'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97830880'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97837065'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97853464'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97861750'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97868201'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97874523'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97891744'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97913827'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97920009'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97920872'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97927604'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97930964'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97932064'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97933019'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97939183'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97939461'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97940835'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97945036'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97952646'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97953500'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97958353'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97960110'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97990449'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97991772'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97996550'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '97997767'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98009468'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98045438'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98051296'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98051897'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98064040'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98069473'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98083566'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98087255'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98104095'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98107826'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98373243'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99719257'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '98755623'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100480746'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99562433'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100069033'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99103235'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99273058'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100078399'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99493804'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99525330'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100100962'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100362764'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100661812'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100655963'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99256716'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99386552'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100077045'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99477092'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100117990'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100119773'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100092312'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100115862'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99684017'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100069252'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100069418'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100111736'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100126252'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100160227'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100642356'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100528128'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100115966'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100116121'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100120054'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100128187'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99920003'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100618860'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100619400'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100621555'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100272219'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100291359'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100624312'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100626668'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100627050'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100629142'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100341346'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100628976'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100346943'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100630949'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100632510'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100634211'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100392602'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100637773'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100638472'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100638705'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100637299'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100635939'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100639619'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100640578'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100639805'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100413912'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100419613'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100429362'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100449642'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100644875'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100645224'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100467655'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100646629'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100474492'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100647616'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100486884'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100494036'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100522330'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100650977'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100653142'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100653649'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100615249'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100654318'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100654754'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100568415'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '99526065'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100098382'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100624209'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100360480'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100422871'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100641689'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100613618'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100167271'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101103106'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103055599'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101708285'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103231009'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102139579'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102316601'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102438942'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102194989'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101211788'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101776668'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101573418'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101744325'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101709853'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102184521'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102226319'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102378223'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102416629'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102624708'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102988107'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102686583'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102994910'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102757908'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102765897'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102783917'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102798835'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102811694'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102823191'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102854933'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102875317'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102919644'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102942911'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103049124'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103060029'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103088939'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102619542'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102684054'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102754852'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103071629'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '101307803'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '102150149'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '100905588'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '103862649'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104051247'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104073785'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104795899'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104305402'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104338963'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104804577'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104444666'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105468832'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105410400'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104811567'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104809490'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '104277297'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105524309'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105008500'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105488759'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105476112'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105494955'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105522677'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105215411'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105232901'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105260924'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105295061'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105523831'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105307510'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105324881'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105513673'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105513124'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105514435'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105518913'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105482345'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105627947'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105629546'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105630361'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105757623'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '105925237'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '106249268'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '106366084'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '106450219'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107213950'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107250388'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '106867082'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107222133'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107225746'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '108107163'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107844911'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107459540'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107619545'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '108105318'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '108109708'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107822921'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '107927892'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '108674612'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '109834923'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '110738024'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '110012974'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '110757366'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '110263070'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '109115159'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '109676585'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '110762930'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '111812272'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '111594219'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '113359999'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '112058752'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '111361238'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '111925541'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '113252518'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '113328243'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '115383784'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '114526546'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '114882173'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '114398938'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '114578102'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '116027933'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '116021327'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '116487094'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '117374597'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '116736709'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '117367568'
update archive13F set
compid = '168288',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828817'
where entryId = '116746960'
End Function
The Script is complete, exiting....