@Select({"<script> " + " select * "+ " from business_threat bt \n" + " join abnormal_event_type aet on bt.event_type_id = aet.id " + " where 1=1 " + " <if test = ' ids != null'> " + " and bt.id in " + " <foreach item = 'item' index = 'index' collection = 'ids' open = '(' separator = ',' close = ')' > " + " #{item} " + " </foreach> " + " </if> " + "</script>"}) List<BusinessThreatVO> getByBusinessThreadId(@Param("ids") List<Long> ids);