根据游戏类型ID获取游戏服务器IP及硬件码的SQL

根据游戏类型ID获取游戏服务器IP及硬件码的SQL：

select case when (a.outerip1 is not NULL and a.outerip1 != '') then a.outerip1      when (a.outerip2 is not NULL and a.outerip2 !='') then a.outerip2      when (a.innerip1 is not NULL and a.innerip1 != '') then a.innerip1      when (a.innerip2 is not NULL and a.innerip2 != '') then a.innerip2      END as IP, b.HardKey from DAS_SVR_Info a, DAS_SVR_Hardware b, DAS_SVR_Business c where a.s_id=b.s_id and a.s_id=c.s_id and c.gametype=?