Compid = 130710Number Of Rows Found :1<BR>Compid Found :130710 Tic Found :JNY<BR>FINALJNY | 130710<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130710 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 :1<BR><HR><BR>liquidatedTotalCompanies1<BR>liquidatedTotalValue0<BR>liquidatedTotalShares-1<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies0<BR>oldDecreaseHoldingTotalValue0<BR>oldDecreaseHoldingTotalShares0<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 0<BR>unchangedHoldingTotalValue 0<BR>unchangedHoldingTotalShares 0<BR><BR><BR>totalSharesHeld0<BR>totalSharesValue0<BR>totalPostionChange-1<BR>totalValueChange0<BR>totalHolders0<BR>COMPID130710<BR>TICJNY<BR>CIK0000874016<BR>SHSOUT79800<BR>NAMEJones Group Inc<BR>SECTOR502007<BR>CUSIP48020T101<BR>PRICE<BR>virgina 0<BR><BR>virgina2 -0<BR>SELECT * from sectors where level3num = '502007'Number Of Rows Found :1<BR>The Sector is Textile - Apparel Clothing<BR><BR>CRAIG TOTAL SHARES VALE : 0<BR><BR>MKCAP0/n/ninsert into institSumNewHoldings values(
								 Null,
								'0000874016',
								'130710',
								'Jones Group Inc',
								'JNY',
								'',
								'48020T101',
								'79800',
								'0',
								'502007',
								'Textile - Apparel Clothing',
								 '0',
								 '1',
								 '0',
								 '-1',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '-1',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '-0',
								 '-0',
								 '-0',
								 '-0',
								 '', 
 								 '', 
 								 '', 
 								 '0', 


								  NULL,  NULL,NULL)

OKbye