Compid = 142755Number Of Rows Found :1<BR>$tempCalculation=0<BR>START :<BR>END :0.000001<BR><BR>Compid Found :142755 Tic Found :DEER<BR>FINALDEER | 142755<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =142755 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes'  AND reportDate >= '2024-03-31' <BR><BR>Number Of Rows Found :1must have stayed the same<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies0<BR>oldDecreaseHoldingTotalValue0<BR>oldDecreaseHoldingTotalShares0<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 1<BR>unchangedHoldingTotalValue 0<BR>unchangedHoldingTotalShares 130<BR><BR><BR>totalSharesHeld130<BR>totalSharesValue1<BR>totalPostionChange0<BR>totalValueChange0<BR>totalHolders1<BR>COMPID142755<BR>TICDEER<BR>CIK0001388855<BR>SHSOUT33593<BR>NAMEDeer Consumer Products Inc<BR>SECTOR102001<BR>CUSIP24379J200<BR>PRICE0.000001<BR>virgina 0<BR><BR>virgina2 0<BR>SELECT * from sectors where level3num = '102001'Number Of Rows Found :1<BR>The Sector is Appliances<BR><BR>CRAIG TOTAL SHARES VALE : 1<BR><BR>MKCAP0.033593/n/ninsert into institSumNewHoldings values(
								 Null,
								'0001388855',
								'142755',
								'Deer Consumer Products Inc',
								'DEER',
								'0.000001',
								'24379J200',
								'33593',
								'0',
								'102001',
								'Appliances',
								 '0.033593',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '130',
								 '1',
								 '0',
								 '0',
								 '1',
								 '1',
								 '0',
								 '130',
								 '0',
								 '0',
								 '0',
								 '0',
								 '', 
 								 '', 
 								 '', 
 								 '0', 


								  NULL,  NULL,NULL)

OKbye