diff options
| author | Brad Beattie <bradbeattie@gmail.com> | 2023-04-07 11:55:02 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-04-07 11:55:02 -0700 |
| commit | 9d37c0feec9187145af8759e83175da0467fa96c (patch) | |
| tree | e9f11fad072840ea1393216ebc8614c78a52370a | |
| parent | f3db9244522d9f90697868263fcc99c1200b5534 (diff) | |
Augment similarity with person matches
The code comment says "genres, tags, studios, _person_, year?", but does no matching on common people between films. This PR augments similarity score treating people similar to tags.
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index fcff5f98c..f3fb0e285 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -2392,6 +2392,7 @@ namespace Emby.Server.Implementations.Data // genres, tags, studios, person, year? builder.Append("+ (Select count(1) * 10 from ItemValues where ItemId=Guid and CleanValue in (select CleanValue from ItemValues where ItemId=@SimilarItemId))"); + builder.Append("+ (Select count(1) * 10 from People where ItemId=Guid and Name in (select Name from People where ItemId=@SimilarItemId))"); if (item is MusicArtist) { |
