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: : 130547
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130547'
The Shares Amount is 14240000
The cusip is 29271Q103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '29271Q103'
Number of Rows :60
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '9.13'
where entryId = '14328997'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '9.13'
where entryId = '15994009'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '22.95'
where entryId = '16103998'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '25.28'
where entryId = '16110521'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '18.26'
where entryId = '18548884'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '284.9'
where entryId = '42082163'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '9.31'
where entryId = '129879233'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '6.82'
where entryId = '131709068'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '936.6'
where entryId = '130508846'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '9.83'
where entryId = '130930171'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '131375058'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '108.42'
where entryId = '131912335'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0.2'
where entryId = '132316048'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '103.88'
where entryId = '130813205'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '7.02'
where entryId = '131974974'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '131354364'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '10.28'
where entryId = '132349631'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '126.9'
where entryId = '131801890'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '24.84'
where entryId = '131174796'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '130470880'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '12.99'
where entryId = '130240624'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '8.99'
where entryId = '131860573'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '7.83'
where entryId = '132201212'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '70.33'
where entryId = '132203896'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '40.08'
where entryId = '131871922'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '11.23'
where entryId = '130679242'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '132580580'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '8.65'
where entryId = '132069336'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '23.03'
where entryId = '130920206'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '298.38'
where entryId = '131075215'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '324.51'
where entryId = '130935165'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '23.01'
where entryId = '131857172'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '34.55'
where entryId = '131018619'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '48.75'
where entryId = '130463072'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0.05'
where entryId = '130795594'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '7.92'
where entryId = '131167253'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '132548139'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '8.48'
where entryId = '130464297'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0.72'
where entryId = '132085013'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '12.1'
where entryId = '132299172'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '46.18'
where entryId = '131093197'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '254.05'
where entryId = '130459108'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '25.5'
where entryId = '132116514'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '1.4'
where entryId = '131271042'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '1.46'
where entryId = '131994619'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '131362719'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '311.36'
where entryId = '131558580'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '29.14'
where entryId = '130248499'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '14.06'
where entryId = '131651093'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '10.7'
where entryId = '130055462'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '124.57'
where entryId = '131827706'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '66.97'
where entryId = '132106493'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '9.62'
where entryId = '131487676'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '130725951'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '21.44'
where entryId = '131409460'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '13.13'
where entryId = '130165630'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '0'
where entryId = '130439473'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '4.11'
where entryId = '132392731'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '9.3'
where entryId = '132404530'
update current13Fpositions set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971' ,
percentOut = '19.95'
where entryId = '132476531'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '29271Q103'
Number of Rows :226
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '65342926'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '66841897'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '63713689'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '68562107'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '70508899'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '75819707'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '77780642'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '79944863'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '81686875'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '83866356'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '86101951'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '87802948'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '90134332'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '92204342'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '94253415'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '96027977'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '98416873'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '100988904'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '103549324'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '103066302'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '105764015'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '108232490'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '108436603'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109626567'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109293970'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110339279'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109067665'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109338806'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110576802'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110083639'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109113334'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109901200'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '109206182'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110094420'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110243363'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110602724'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110679005'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110905124'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '110985276'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113431582'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112131786'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111906290'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111854930'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111587115'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112764859'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113358803'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111514322'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113392008'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111524331'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111866731'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '111923685'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112103266'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112187387'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112207364'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112273953'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112747834'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112696118'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113456055'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113016895'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113045921'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113304682'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113452474'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '112647693'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113608546'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114706250'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113753506'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116068445'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114880335'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113775054'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '113890116'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114286424'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114308743'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114396452'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114432048'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114762503'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114572274'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115334263'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115174407'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115219662'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114834349'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115286244'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115324577'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116026264'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115159694'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '114700174'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115142739'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '115453420'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116953361'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116319876'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116704178'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117822736'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117122149'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117156863'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116798987'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117441472'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117836442'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116760418'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116883672'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117658013'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116599593'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116924343'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116770872'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117847589'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117900644'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116495662'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117932639'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117802347'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '117035159'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '118101341'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '116670901'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '118256119'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '118618095'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120284687'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '118908499'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119918225'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120142928'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '118781695'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119261632'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121001694'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119645526'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119720582'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119924881'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121125482'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120042071'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121203250'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119901034'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120707453'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120641209'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119679579'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '119945184'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120328689'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120948739'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121297901'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120962801'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121519895'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '120912400'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121054049'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121473463'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121550335'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123876507'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122455088'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121838981'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121966046'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121789221'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '121486362'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122409535'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122635033'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122439569'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122656194'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123289665'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123655149'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122888931'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123607067'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122746766'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123532729'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122843610'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123561452'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123536588'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124001274'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '122971051'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '123809619'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124146593'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124496657'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124620894'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124378792'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124957471'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125841990'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124461599'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124954328'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125461696'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125047811'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125217184'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125376957'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124604508'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125051685'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '124577808'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125401251'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125793566'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125818576'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125858755'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125895766'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125938381'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '125989633'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126012478'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126125052'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126174302'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126852491'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126512102'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126953844'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '126340664'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127034732'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128175585'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127195616'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127120237'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127836673'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127859947'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127815470'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127456427'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128007412'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127784092'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129033811'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128287228'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128001795'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127574913'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127823452'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127845152'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128019654'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128940808'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129823874'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129750061'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128408414'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128277835'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128794018'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129318409'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129069108'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128774124'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129185881'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128890265'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '127676728'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129161574'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128833681'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129708361'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128437435'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129197656'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '128998338'
update archive13F set
compid = '130547',
sectorNum = '302006',
sectorDes = 'Diversified Investments',
issuerCik = '0001357971'
where entryId = '129812205'
End Function
The Script is complete, exiting....