bwj_server/src/dsb/com/cnd3b/restcontroller/publicmethod/bannermag/SQL/广告位查询.sql

select tbannerlocationid, flocation, fisused
from tbannerlocation
where siteid = $siteid$
  and fclienttype = 'WEB'
  and flocation LIKE('portal%')