추억의 행성 퍼블로그 : 포토북, 사진인화, 포토달력, 졸업앨범, 인화포토북, 포토앨범, 포토액자, 돌잔치
달력 졸업앨범 할인
select *, ( case when convert(char(10),t.eventenddate,120) >= convert(char(10),getdate(),120) then 1 else 2 end ) as event_sort from t_event as t left join t_event_sub as s on t.seq=s.euid where s.status='1' and convert(varchar(10),getdate(),120) between convert(varchar(10),t.EventShowTime,120) and convert(varchar(10),t.EventEndDate,120) order by event_sort asc, t.eventregdate desc