Propel 1.5.4 Query code

$contractObjectCollection = ContractQuery::create()
            ->filterByOrderId($this->getID())
            ->condition('contractToAfterNow', 'Contract.ContractTo > ?', date('Y-m-d'))
            ->condition('contractToIsNul', 'Contract.ContractTo = ?', '0000-00-00')
            ->combine(array('contractToAfterNow', 'contractToIsNul'), 'or', 'contractToCondition')
            ->condition('contractFromIsFilledIn', 'Contract.ContractFrom <= ?', date('Y-m-d'))
            ->combine(array('contractToCondition', 'contractFromIsFilledIn'))
            ->orderByContractFrom('asc')
            ->orderByContractId('asc')
            ->find();