SELECT * FROM `stock_list` WHERE `symbol` = "BOMXF" and stock_list.exchange IN (SELECT exchange FROM gurufocu_main.stock_list_exchanges where country='USA' and active=1) AND delisted = 0 limit 0,1