Index: Ringtoets/Common/src/Ringtoets.Common.IO/SoilProfile/SoilDatabaseQueryBuilder.cs
===================================================================
diff -u -r17a2476bd707ad3da72ba4d6382915b9cc3fed07 -rbe4427a66ef77dfa213048b0a823824ea679bce3
--- Ringtoets/Common/src/Ringtoets.Common.IO/SoilProfile/SoilDatabaseQueryBuilder.cs	(.../SoilDatabaseQueryBuilder.cs)	(revision 17a2476bd707ad3da72ba4d6382915b9cc3fed07)
+++ Ringtoets/Common/src/Ringtoets.Common.IO/SoilProfile/SoilDatabaseQueryBuilder.cs	(.../SoilDatabaseQueryBuilder.cs)	(revision be4427a66ef77dfa213048b0a823824ea679bce3)
@@ -106,7 +106,7 @@
         public static string GetStochasticSoilModelPerMechanismQuery()
         {
             return $"SELECT SSM.{StochasticSoilModelTableDefinitions.StochasticSoilModelId}, " +
-                   $"M.{MechanismTableDefinitions.MechanismName}, " +
+                   $"M.{MechanismTableDefinitions.MechanismId}, M.{MechanismTableDefinitions.MechanismName}, " +
                    $"SSM.{StochasticSoilModelTableDefinitions.StochasticSoilModelName}, " +
                    $"SSP.{StochasticSoilProfileTableDefinitions.Probability}, " +
                    $"SSP.{StochasticSoilProfileTableDefinitions.SoilProfile1DId}, " +