UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 33139 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4367.T^G26' WHERE SecCode = 69109 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2763.T^G26' WHERE SecCode = 89199 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'IIP_u.TO^G26' WHERE SecCode = 95560 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'KOR.AX^G26' WHERE SecCode = 137529 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'DE000A41YF63', Ticker = 'MT30', SEDOL = 'BXFHV7', CUSIP = 'D2S0AZ11', RIC = 'MT30n.H', DisplayRIC = 'MT30n.H' WHERE SecCode = 145285 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU000000ADR1', Ticker = 'ADR', SEDOL = 'BYW6FR', CUSIP = 'Q0137R24', RIC = 'ADR.AX', DisplayRIC = 'ADR.AX' WHERE SecCode = 2963543 AND Type_ = 10; UPDATE data_universe_rkd SET SEDOL = 'BF20GH' WHERE SecCode = 3354563 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '7575.TWO^G26' WHERE SecCode = 5059311 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6310627 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6846681 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 7000373 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA5319651017', Ticker = 'LTNG', SEDOL = 'BXL2FP', CUSIP = '53196510', RIC = 'LTNG.V', DisplayRIC = 'LTNG.V' WHERE SecCode = 10934601 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'GVHGF', RIC = 'GVHGF.PK', DisplayRIC = 'GVHGF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11241899 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'PMA', RIC = 'PMA.O', DisplayRIC = 'PMA.OQ' WHERE SecCode = 11271948 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PTNM.OQ^G26' WHERE SecCode = 11278787 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11297308 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11299230 AND Type_ = 1; UPDATE data_universe_rkd SET SEDOL = 'BXM0R4' WHERE SecCode = 11299251 AND Type_ = 1;