Monitors Has Many Events Events Has One Monitor

gistfile1.sql

SELECT COUNT(*) AS `count` FROM `zm`.`Events` AS `Event` LEFT JOIN `zm`.`Monitors` AS `Monitor` ON (`Event`.`MonitorId` = `Monitor`.`Id`) WHERE `Event`.`MonitorId` = 1

php

                $eventreport[$key] = $this->Event->find('count', array(
                        'conditions' => array(
                                'StartTime >=' => 'DATE_SUB(NOW(), INTERVAL 1 DAY)',
                                'MonitorId' => $monitor['Monitor']['Id']
                        ),
                        'recursive' => -1
                ));