select b.sid, p.width, p.height, p.position_x, p.position_y, p.popup_close, p.popup_scroll, p.popup_resize, p.startdate, p.enddate from bbs_tbl b join bbs_popup p on b.sid= p.bsid where b.code='news' and b.popup='Y' and b.del='N'and ( (p.startdate = '0000-00-00' and p.enddate = '0000-00-00') or(p.startdate <= DATE_FORMAT(now(), '%Y-%m-%d') and p.enddate >= DATE_FORMAT(now(), '%Y-%m-%d')) or (p.startdate = '0000-00-00' and p.enddate >= DATE_FORMAT(now(), '%Y-%m-%d')) or (p.startdate <= DATE_FORMAT(now(), '%Y-%m-%d') and p.enddate = '0000-00-00') )