select B.board_num, B.board_subject, B.board_write_name, B.board_filename1, B.board_write_date, DATEDIFF(now(),B.board_write_date) as su, B.board_hit, B.board_dap_flag, B.board_write_id, B.board_secret , ( SELECT file_name FROM rug_board_file WHERE board_num = B.board_num ORDER BY idx DESC LIMIT 1 ) AS board_sfile, B.board_content from rug_board B where board_flag=2 order by board_write_date desc limit 0 ,15