musicbrainz states that it's been released october 23rd in GB
i see
noobie
wiki is probably refering to the us release date
SultS
yeah
roosoft
ok... i am trying to figure out programatically which one is the most popular release
hawke_2 joined the channel
hawke_1
By what measure?
roosoft
well, it's quite subjective
reosarevok
Well, you could choose the one from the artist country, but for majors, countries barely matter...
roosoft
2 criterions are release date and country
i think that an album released in the artist's country has a good chance of being the most popular if it's release day is the oldest of all releases
SultS
roosoft: quite often Japanese versions are released even earlier and contain bonus tracks… but it doesn’t seem to be the case with this Smashing Pumpkins album
roosoft
in this case, no albums fits so my algo ouputs nothing
hawke_1
How are you defining "most popular"?
most likely to be the one someone wants for a search result? the one which someone is most likely to possess?
ijabz joined the channel
roosoft
i want to display artists tracks without regards about releases... but still link them to release groups
to figure out which tracks comes from which release group, i have to go through releases
in fact, i rely on last.fm scrobbling
hawke_1
I would say “whichever release group has the most releases where that track appears” if that makes sense.
roosoft
it may be another way to sort it out...
i've seen albums re-released with hundreds of tracks
congratulations for your database by the way... it's awesome :D
the main reason why i am doing this is because i do not think physical media have much future
kepstin-work
physical media might not, but the concept of an album will, imo.
roosoft
i expect in the future that albums may have only one initial release regardless media or country
yup
kepstin-work
nah, I still expect occasional remastered releases or versions with different bonus tracks
roosoft
i'm trying to apply that principle to albums released in the past as well.. that's my challenge
i don't care about remasters
well, my website don't
i want to list the number of times a song has been played by one of my users, regardless which edition