SELECT DISTINCT TOP 100 fv.symbol, fv.description, fv.prev_close, fv.[broker_call_value], sr.exchange AS scan_exchange, sr.[company] AS sr_company, sr.[col1] AS col1, fa.[inst_holders_count] AS fa_inst_holders_count, fa.[has_buyback_ttm] AS fa_has_buyback_ttm, fa.[pe_gt_last3y] AS fa_pe_gt_last3y, fa.[pb_gt_last3y] AS fa_pb_gt_last3y, fa.[ps_gt_last3y] AS fa_ps_gt_last3y, fa.[navps_gt_last3y] AS fa_navps_gt_last3y FROM db_owner.fundamental_tv AS fv JOIN livescanner.dbo.scanresults AS sr ON REPLACE(sr.symbol,'.SI','') = REPLACE(fv.symbol,'.SI','') JOIN fundamental.dbo.fa_scanner AS fa ON fa.ticker = fv.symbol WHERE fv.market IN ('SES') AND sr.exchange IN ('SGX') AND sr.date = (SELECT MAX([date]) FROM livescanner.dbo.scanresults WHERE exchange IN ('SGX')) AND ((sr.[col1] IS NOT NULL AND sr.[col1] LIKE '%BULLISH%'))