SELECT COUNT(*) AS c_nums FROM dc_coupons WHERE store='1739' AND approved=1 UNIX_TIMESTAMP(expiration_date_dt)>(UNIX_TIMESTAMP(DATE(NOW()))-86399);