경기정보 > 1군 일정결과

select s.gmKey, date, home, home_key, visit, visit_key, stadium, gtime ,isnull(case when c.gSeason is null or c.gSeason = '0' then b.tpoint else e.tpoint end,'999') tpoint ,isnull(case when c.gSeason is null or c.gSeason = '0' then b.bpoint else e.bpoint end,'999') bpoint, (select top 1 memo from schedule_cancel where gmkey=s.gmkey) memo, (select count(*) from gameinfo where gmkey=s.gmkey) gameinfo,DHeader,gSeason,hl,tv,radio from schedule_view s with(nolock) Left Outer Join (select gmKey,tpoint,bpoint from score with(nolock)) b On s.gmKey=b.gmKey Left Outer Join (select gmKey,tpoint,bpoint from score_etc with(nolock)) e On s.gmKey=e.gmKey Left Outer Join (select gmKey,gSeason,hl from schedule_info_add with(nolock)) c On s.gmKey=c.gmKey Left Outer Join (select gmKey,tv,radio from samsung_site_new_2013.dbo.onair_broadcast with(nolock)) d On s.gmKey=d.gmKey where (home_key='SS' or Visit_key='SS') AND substring(date, 1, 8) ='20150827' order by date,DHeader