Index: Riskeer/HydraRing/src/Riskeer.HydraRing.Calculation/Parsers/OvertoppingCalculationWaveHeightParser.cs =================================================================== diff -u -r9e9976818f1b446948c3bf815cafe2e023f98ac1 -rb3625b8e105f713541ce274ef412dfeb3f159d6b --- Riskeer/HydraRing/src/Riskeer.HydraRing.Calculation/Parsers/OvertoppingCalculationWaveHeightParser.cs (.../OvertoppingCalculationWaveHeightParser.cs) (revision 9e9976818f1b446948c3bf815cafe2e023f98ac1) +++ Riskeer/HydraRing/src/Riskeer.HydraRing.Calculation/Parsers/OvertoppingCalculationWaveHeightParser.cs (.../OvertoppingCalculationWaveHeightParser.cs) (revision b3625b8e105f713541ce274ef412dfeb3f159d6b) @@ -46,13 +46,13 @@ "(SELECT SubMechanismId = 102 " + "FROM DesignBeta db " + "JOIN " + - "(SELECT ClosingSituationId, d.PeriodId, d.OuterIterationId, d.WindDirectionId, d.LevelTypeId " + + "(SELECT d.ClosingSituationId, d.PeriodId, d.OuterIterationId, d.WindDirectionId, d.LevelTypeId " + "FROM GoverningWind g " + "JOIN DesignBeta d ON d.WindDirectionId = g.WindDirectionId AND d.OuterIterationId = g.OuterIterationId And d.PeriodId = g.PeriodId " + $"WHERE LevelTypeId = 7 AND SectionId = {HydraRingDatabaseConstants.SectionIdParameterName} " + "AND SubmechanismId = 102 " + "ORDER BY d.OuterIterationId DESC, d.PeriodId, BetaValue " + - "LIMIT 1) as s on s.WindDirectionId = db.WindDirectionId AND s.OuterIterationId = db.OuterIterationId AND s.PeriodId = db.PeriodId " + + "LIMIT 1) AS s on s.WindDirectionId = db.WindDirectionId AND s.OuterIterationId = db.OuterIterationId AND s.PeriodId = db.PeriodId " + "AND s.ClosingSituationId = db.ClosingSituationId AND s.LevelTypeId = db.LevelTypeId " + "ORDER BY BetaValue " + $"LIMIT 1) AS {isOvertoppingDominantColumn};";