select top 5 a.*,
(select case when left(a.start_date, 10)<='2024-04-19' and left(a.end_date, 10)>='2024-04-19' then '1'
when left(a.start_date, 10)>'2024-04-19' 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
