diff --git a/src/main/kotlin/dao/AudioDao.kt b/src/main/kotlin/dao/AudioDao.kt index b910e77..56b7fa0 100644 --- a/src/main/kotlin/dao/AudioDao.kt +++ b/src/main/kotlin/dao/AudioDao.kt @@ -52,7 +52,6 @@ @JvmStatic fun findOneById(): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE("audio.id = #{id}") .toString() @@ -60,7 +59,6 @@ @JvmStatic fun findOneBySlug(): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE("audio.slug = #{slug}") .toString() @@ -69,7 +67,6 @@ fun findAllByArtistIdIn(@Param("artistIds") artistIds: List): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE_IN("audio.artist_id", "artistIds", artistIds.size) .toString() @@ -78,7 +75,6 @@ fun findAllByAlbumIdIn(@Param("albumIds") albumIds: List): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE_IN("audio.album_id", "albumIds", albumIds.size) .toString() @@ -87,7 +83,6 @@ fun findAllByIdIn(@Param("ids") ids: List): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE_IN("audio.id", "ids", ids.size) .toString() @@ -96,7 +91,6 @@ fun findAllBySlugIn(@Param("slugs") slugs: List): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE_IN("audio.slug", "slugs", slugs.size) .toString() @@ -108,7 +102,6 @@ ): String = SelectSQLBuilder(AudioEntity::class) .leftOuterJoin(AlbumEntity::class, "audio.album_id = album.id") - .leftOuterJoin(ArtistEntity::class, "audio.artist_id = artist.id") .toSql() .WHERE("audio.name LIKE CONCAT('%', #{nameLike}, '%')") .LIMIT("#{limit}")