Index: Ringtoets/Common/src/Ringtoets.Common.IO/SoilProfile/SoilDatabaseQueryBuilder.cs
===================================================================
diff -u -rbe4427a66ef77dfa213048b0a823824ea679bce3 -r133fb73ed33467075fa1317ab736902755ff6e4f
--- Ringtoets/Common/src/Ringtoets.Common.IO/SoilProfile/SoilDatabaseQueryBuilder.cs	(.../SoilDatabaseQueryBuilder.cs)	(revision be4427a66ef77dfa213048b0a823824ea679bce3)
+++ Ringtoets/Common/src/Ringtoets.Common.IO/SoilProfile/SoilDatabaseQueryBuilder.cs	(.../SoilDatabaseQueryBuilder.cs)	(revision 133fb73ed33467075fa1317ab736902755ff6e4f)
@@ -83,6 +83,20 @@
         }
 
         /// <summary>
+        /// Returns the query to get the amount of <see cref="StochasticSoilModel"/> 
+        /// that can be read from the database.
+        /// </summary>
+        /// <returns>The query to get the amount of <see cref="StochasticSoilModel"/> 
+        /// from the database.</returns>
+        public static string GetStochasticSoilModelOfMechanismCountQuery()
+        {
+            return $"SELECT COUNT() AS {StochasticSoilModelTableDefinitions.Count} " +
+                $"FROM {StochasticSoilModelTableDefinitions.TableName} SSM " +
+                $"INNER JOIN {SegmentTableDefinitions.TableName} S USING({StochasticSoilModelTableDefinitions.StochasticSoilModelId}) " +
+                $"INNER JOIN {MechanismTableDefinitions.TableName} M USING({MechanismTableDefinitions.MechanismId});";
+        }
+
+        /// <summary>
         /// Returns the SQL query to execute to check if the probabilities of the stochastic
         /// soil profiles are valid.
         /// </summary>