검색
Select * from (select code as bcode, name as bname from red_bbs where s_cnt > 0) A, red_bbs_data B where A.bcode = B.code and code in ('notice', 'media') and notice < 2 order by reg_date desc, ref desc, re_step ASC LIMIT 15., 15