select * from deals where `pagenumber`='1' and status = '1' and 1327748223 between publish_date and expire_date order by publish_date desc limit 0,10here