Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs
===================================================================
diff -u -r733d0d51adf737c52704cd80705507fdb34a2ba3 -ra77cd7f471b813c6a7218b42844d017fc10fb4ec
--- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs	(.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs)	(revision 733d0d51adf737c52704cd80705507fdb34a2ba3)
+++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs	(.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs)	(revision a77cd7f471b813c6a7218b42844d017fc10fb4ec)
@@ -29,25 +29,16 @@
     public static class HydraulicLocationConfigurationDatabaseQueryBuilder
     {
         /// <summary>
-        /// Returns the query to get the LocationId from the database.
+        /// Returns the query to get the LocationIds from the database.
         /// </summary>
-        /// <returns>The query to get the locationId from the database.</returns>
-        public static string GetLocationIdQuery()
+        /// <returns>The query to get the locationIds from the database.</returns>
+        public static string GetLocationsIdByRegionIdQuery()
         {
-            var countQuery = String.Format("Select COUNT({0}) FROM {1} WHERE {2} = @{2} AND {3} = @{3}",
-                                           LocationsTableDefinitions.LocationId,
-                                           LocationsTableDefinitions.TableName,
-                                           LocationsTableDefinitions.RegionId,
-                                           LocationsTableDefinitions.HrdLocationId);
-
-            return String.Format("SELECT {0}, ({1}) as {2} FROM {3} WHERE {4} = @{4} AND {5} = @{5};",
+            return String.Format("SELECT {0}, {1} FROM {2} WHERE {3} = @{3} ORDER BY {1};",
                                  LocationsTableDefinitions.LocationId,
-                                 countQuery,
-                                 LocationsTableDefinitions.Count,
+                                 LocationsTableDefinitions.HrdLocationId,
                                  LocationsTableDefinitions.TableName,
-                                 LocationsTableDefinitions.RegionId,
-                                 LocationsTableDefinitions.HrdLocationId
-                );
+                                 LocationsTableDefinitions.RegionId);
         }
     }
 }
\ No newline at end of file