amuzi icon indicating copy to clipboard operation
amuzi copied to clipboard

change the algorithm to search similar items to an album

Open dmelo opened this issue 11 years ago • 0 comments

instead of get the amt with smallest ID, get the amt using this query:

select artist_music_title_id, count(f_artist_music_title_id) as c from album_has_artist_music_title as a join music_similarity on a.artist_music_title_id = music_similarity.f_artist_music_title_id or a.artist_music_title_id = s_artist_music_title_id where album_id = 52 group by artist_music_title_id order by c desc limit 1

dmelo avatar Mar 05 '13 00:03 dmelo