select * from board where ( ifnull(convert(begindate,DATETIME),DATE_ADD(utc_timestamp(),INTERVAL 8 DAY_HOUR)) <= convert(DATE_ADD(utc_timestamp(),INTERVAL 8 DAY_HOUR),DATETIME) ) and ( ifnull(convert(closedate,DATETIME),DATE_ADD(utc_timestamp(),INTERVAL 8 DAY_HOUR)) >= convert(DATE_ADD(utc_timestamp(),INTERVAL 8 DAY_HOUR),DATETIME) ) and ( ( kind='dvd' ) ) and ( ( alg='en' ) ) order by boardsort desc,id desc