Details
Description
$qb->from('Tournaments_Model_StageBracketTeamRegistration', 'r')
->innerJoin('r.teamSelection', 'ts')
->innerJoin('ts.players', 'tsp')
->select('r, ts, tsp')
->where('r.stageBracket = ?1')
->andWhere('r.opponentIsReserve = false')
->orderBy('r.registrationDateTime')
->setParameter(1, $bracket);
Generates:
SELECT s0_.id AS id0, s0_.opponent_is_reserve AS opponent_is_reserve1, s0_.opponent_checked_in AS opponent_checked_in2, s0_.registration_date_time AS registration_date_time3, t1_.id AS id4,, s0_.type AS type5, s0_.stage_bracket_id AS stage_bracket_id6, s2_.team_selection_id AS team_selection_id7, t1_.team_id AS team_id8, t3_.team_selection_id AS team_selection_id9, t3_.player_id AS player_id10 FROM stage_bracket_team_registrations s2_ INNER JOIN stage_bracket_registrations s0_ ON s2_.id = s0_.id INNER JOIN team_selections t1_ ON s2_.team_selection_id = t1_.id INNER JOIN team_selection_players t3_ ON t1_.id = t3_.team_selection_id WHERE s0_.stage_bracket_id = 22 AND s0_.opponent_is_reserve = 0 ORDER BY s0_.registration_date_time ASC
Note the 2nd comma after "t1_.id AS id4". TeamSelectionPlayer uses a composite PK. I have attached the relevant entity classes.
Fixed