public static function doSelectJoinAll(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
    {
        $criteria = clone $criteria;

        // Set the correct dbName if it has not been overridden
        if ($criteria->getDbName() == Propel::getDefaultDB()) {
            $criteria->setDbName(UserRolePeer::DATABASE_NAME);
        }

        UserRolePeer::addSelectColumns($criteria);
        $startcol2 = UserRolePeer::NUM_HYDRATE_COLUMNS;

        UserPeer::addSelectColumns($criteria);
        $startcol3 = $startcol2 + UserPeer::NUM_HYDRATE_COLUMNS;

        RolePeer::addSelectColumns($criteria);
        $startcol4 = $startcol3 + RolePeer::NUM_HYDRATE_COLUMNS;

        $criteria->addJoin(UserRolePeer::USER_ID, UserPeer::ID, $join_behavior);

        $criteria->addJoin(UserRolePeer::ROLE_ID, RolePeer::ID, $join_behavior);

        $stmt = BasePeer::doSelect($criteria, $con);
        $results = array();

        while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
            $key1 = UserRolePeer::getPrimaryKeyHashFromRow($row, 0);
            if (null !== ($obj1 = UserRolePeer::getInstanceFromPool($key1))) {
                // We no longer rehydrate the object, since this can cause data loss.
                // See http://www.propelorm.org/ticket/509
                // $obj1->hydrate($row, 0, true); // rehydrate
            } else {
                $cls = UserRolePeer::getOMClass();

                $obj1 = new $cls();
                $obj1->hydrate($row);
                UserRolePeer::addInstanceToPool($obj1, $key1);
            } // if obj1 already loaded

            // Add objects for joined User rows

            $key2 = UserPeer::getPrimaryKeyHashFromRow($row, $startcol2);
            if ($key2 !== null) {
                $obj2 = UserPeer::getInstanceFromPool($key2);
                if (!$obj2) {

                    $cls = UserPeer::getOMClass();

                    $obj2 = new $cls();
                    $obj2->hydrate($row, $startcol2);
                    UserPeer::addInstanceToPool($obj2, $key2);
                } // if obj2 loaded

                // Add the $obj1 (UserRole) to the collection in $obj2 (User)
                $obj2->addUserRole($obj1);
            } // if joined row not null

            // Add objects for joined Role rows

            $key3 = RolePeer::getPrimaryKeyHashFromRow($row, $startcol3);
            if ($key3 !== null) {
                $obj3 = RolePeer::getInstanceFromPool($key3);
                if (!$obj3) {

                    $cls = RolePeer::getOMClass();

                    $obj3 = new $cls();
                    $obj3->hydrate($row, $startcol3);
                    RolePeer::addInstanceToPool($obj3, $key3);
                } // if obj3 loaded

                // Add the $obj1 (UserRole) to the collection in $obj3 (Role)
                $obj3->addUserRole($obj1);
            } // if joined row not null

            $results[] = $obj1;
        }
        $stmt->closeCursor();

        return $results;
    }