cakephp2.3 find conditions and条件、or条件

忘れてしまうので、メモ。

  $conditions = array(
  'or' => array(
    'or' => array(
     array("Schedule.from BETWEEN ? AND ?" => array($from, $to)),
     array("Schedule.to BETWEEN ? AND ?" => array($from, $to))
     ),
    'and' => array(
     array("Schedule.from >=" => $from),
     array("Schedule.from <=" => $to),
     array("Schedule.to     >=" => $to)
     ),
    'and' => array(
     array("Schedule.from <=" => $from),
     array("Schedule.to     <=" => $to),
     array("Schedule.to  >=" => $from)
     ),
    'and' => array(
     array("Schedule.from <=" => $from),
     array("Schedule.to     >=" => $to)
     )
    ),
  'and' => array(
    'SchedulesUser.user_id' => $user_id
     )
   );