$query = new Doctrine_Query();
        $query->from(__CLASS__);
#$query->where('Promotion.endDate <= NOW() AND Promotion.endTime <= NOW()');
        $query->where('CONCAT(Promotion.endDate," ",Promotion.endTime) date <= NOW()');
        $query->orderBy('Promotion.endDate DESC, Promotion.name DESC, Promotion.promoId DESC');
        return $query->execute();