amuzi
amuzi copied to clipboard
change the algorithm to search similar items to an album
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