select top 5 a.*,
(select case when left(a.start_date, 10)<='2023-04-01' and left(a.end_date, 10)>='2023-04-01' then '1'
when left(a.start_date, 10)>'2023-04-01' then '2' else '3' end)
dateStr,
(select top 1 server_filename from bulletin_file where bulletin_seq=a.seq order by main_yn desc) img_filename,
(select count(1) cnt from bulletin_comment where bulletin_seq=a.seq) comment_cnt FROM bulletin a WHERE a.board_seq='28'
and display_yn='y' and th_seq='16'
order by hit desc
Puchon International Fantastic Film Festival 196
