diff --git a/src/main/kotlin/dao/AlbumDao.kt b/src/main/kotlin/dao/AlbumDao.kt
index 57b3b7d..b92fe0d 100644
--- a/src/main/kotlin/dao/AlbumDao.kt
+++ b/src/main/kotlin/dao/AlbumDao.kt
@@ -17,6 +17,19 @@
 interface AlbumDao {
 
     @ResultMap("net.piedpiper.bremer.AlbumEntity")
+    @Select("""<script>
+    SELECT * FROM album WHERE artist_id IN
+    <foreach item="artistId" collection="artistIds" open="(" separator="," close=")">
+    #{artistId}
+    </foreach>
+    LIMIT #{limit}
+    </script>""")
+    fun findAllByArtistIdInLimit(
+        @Param("artistIds") artistIds: List<Long>,
+        @Param("limit") limit: Int
+    ): List<AlbumEntity>
+
+    @ResultMap("net.piedpiper.bremer.AlbumEntity")
     @Select("SELECT * FROM album WHERE name LIKE CONCAT('%', #{nameLike}, '%') LIMIT #{limit}")
     fun findAllByNameLikeLimit(
         @Param("nameLike") nameLike: String,