$g = $this->User->Download->find('first', array(
            'fields'        => array('COUNT(Download.id) AS today'),
            'conditions'    =>
                array(
                    'Download.user_id' => $this->Auth->user('id'),
                    'DATE_SUB(CURDATE(), INTERVAL 24 HOUR) >= Download.created'
                )
        ));