[오늘하루 열지 않기] [닫기]   
<
SELECT event_idx, title, titleimg, go_url, bannerimg, LINKTYPE, eventtype, top_bg_color FROM MYELITE_EVENT WHERE event_idx > 0 and startdate<=getdate() and convert(varchar(10), getdate(), 120) <= enddate and linktype='top' and bannerimg<>'' and view_event = '1' order by site_order desc
  • 오늘 하루 창 열지 않기
SELECT top 1 event_idx, title, titleimg, go_url, bannerimg, LINKTYPE, eventtype, top_bg_color FROM MYELITE_EVENT WHERE event_idx > 0 and startdate<=getdate() and convert(varchar(10), getdate(), 120) <= enddate and linktype in ('event','blog') AND bannerimg <> '' and view_event = '1' order by site_order desc
SELECT event_idx, title, titleimg, go_url, bannerimg, LINKTYPE, eventtype, top_bg_color FROM MYELITE_EVENT WHERE event_idx > 0 and startdate<=getdate() and convert(varchar(10), getdate(), 120) <= enddate and linktype='cafe' and bannerimg<>'' and view_event = '1' order by site_order desc
SELECT top 1 event_idx, title, titleimg, go_url, bannerimg, LINKTYPE, eventtype, top_bg_color FROM MYELITE_EVENT WHERE event_idx = 368 order by site_order desc