Index: Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs
===================================================================
diff -u -r64c21c2c91a3cef9df279e58efda8e45a9d598f7 -r0c4e4faf0839d9ad90af4ff556357fc27c1f333a
--- Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 64c21c2c91a3cef9df279e58efda8e45a9d598f7)
+++ Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 0c4e4faf0839d9ad90af4ff556357fc27c1f333a)
@@ -61,6 +61,27 @@
         }
 
         [Test]
+        public void GetPipingSoilProfileCountQuery_Always_ReturnsExpectedValues()
+        {
+            // Setup
+            const string expectedQuery = "SELECT " +
+                                         "(SELECT COUNT('1') " +
+                                         "FROM Mechanism AS m " +
+                                         "JOIN MechanismPointLocation AS mpl USING(ME_ID) " +
+                                         "JOIN SoilProfile2D AS p2 USING(SP2D_ID) " +
+                                         "WHERE m.ME_Name = @ME_Name) " +
+                                         " + " +
+                                         "(SELECT COUNT('1') " +
+                                         "FROM SoilProfile1D) AS nrOfRows;";
+
+            // Call
+            string query = SoilDatabaseQueryBuilder.GetPipingSoilProfileCountQuery();
+
+            // Assert
+            Assert.AreEqual(expectedQuery, query);
+        }
+
+        [Test]
         public void GetStochasticSoilModelOfMechanismCountQuery_Always_ReturnsExpectedValues()
         {
             // Setup