public static function getMatchedRowsForDt($importDt, PropelPDO $conn = null) { if (!isset($conn)) { $conn = Propel::getConnection(); } $c = new Criteria(); $c->addJoin(AutoCourseRatingPeer::COURSE_INS_ID, CourseInstructorAssociationPeer::ID); $c->addJoin(AutoCourseRatingPeer::FIELD_ID, RatingFieldPeer::ID); $crit = $c->getNewCriterion(AutoCourseRatingPeer::IMPORT_DT, $importDt); $c->addAnd($crit); $c->addAscendingOrderByColumn(CourseInstructorAssociationPeer::YEAR); $c->addAscendingOrderByColumn(CourseInstructorAssociationPeer::COURSE_ID); $c->addAscendingOrderByColumn(RatingFieldPeer::ID); $c->addAscendingOrderByColumn(AutoCourseRatingPeer::RATING); return AutoCourseRatingPeer::doSelectJoinAll($c, $conn); }