select ck,bbs_no,bbs_name,bbs_title,bbs_content,bbs_email,bbs_hits,DATE_FORMAT(bbs_regdate,'%y.%m.%d')as rday,(UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(bbs_regdate))/3600 as elapsed_time,bbs_tab,bbs_pos,bbs_filename,num from bbs1 where tbl_name='bbs1' and view='y' order by ck desc,bbs_no desc limit 3