UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 10008 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 10010 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 54983 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'DE000A41YDG0', Ticker = 'QBY0', SEDOL = 'BW5TWK', CUSIP = 'D6S41S12', RIC = 'QBY0k.DE', DisplayRIC = 'QBY0k.DE' WHERE SecCode = 65452 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'NXTG-M' WHERE SecCode = 67304 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'UAMY' WHERE SecCode = 78176 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'Y8532Y14' WHERE SecCode = 81064 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA0889361097', Ticker = 'BEAR', SEDOL = 'BS0DRR', CUSIP = '08893610', RIC = 'BEAR.V', DisplayRIC = 'BEAR.V' WHERE SecCode = 92669 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9719.T^C26' WHERE SecCode = 96478 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'MARSONS', RIC = 'MARS.NS', DisplayRIC = 'MARS.NS', RkdExchCode = 'NSE' WHERE SecCode = 122690 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'KYG2287A1426', SEDOL = 'BS0DMR', CUSIP = 'G2287A14' WHERE SecCode = 306753 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'PREN.PFT^C26' WHERE SecCode = 433789 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CHEON.PFT^C26' WHERE SecCode = 433851 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 2488650 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SDIPpref.ST^C26' WHERE SecCode = 2830896 AND Type_ = 10; UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6258394 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6431509 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6509571 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6580781 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6590637 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6635166 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6658281 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 10977605 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11037077 AND Type_ = 1; UPDATE data_universe_rkd SET RkdListingType = 'OSR', ShPerListing = NULL WHERE SecCode = 11073795 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, SEDOL = NULL, RIC = 'ENMPY.PK^C26', DisplayRIC = 'ENMPY.PK^C26' WHERE SecCode = 11145235 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11200546 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'QUCY', RIC = 'QUCY.O', DisplayRIC = 'QUCY.OQ' WHERE SecCode = 11233390 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'GRML', RIC = 'GRML.O', DisplayRIC = 'GRML.OQ' WHERE SecCode = 11241417 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'KYG3016G1293', SEDOL = 'BS0DML', CUSIP = 'G3016G12' WHERE SecCode = 11252534 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'GMEX', RIC = 'GMEX.O', DisplayRIC = 'GMEX.OQ' WHERE SecCode = 11256200 AND Type_ = 1;