#musicbrainz

derwin: if you can figure out a SQL query, I'll run it on my local copy

hrm, yeah, I have the capability of doing that, but I'd have to understand the schema in question, and then look up some pgsql syntax

derwin: I may take a crack at it, but I'm rusty with the MB schema, still

(or, once again)

knew it pretty well a few years ago

if you paste the schema for the relevant tables, we could tag-team it a bit

derwin: sure, coming right up

https://minimalist.etherpad.com/p/j_d_mb_scratch -- this way we can actually work *together* on this

Apparently there are at least 5 releases with 227 different release_country entries.

derwin: Here's an example of an edit where someone added 227 (I think, all the possible countries): https://musicbrainz.org/edit/77644400

This was on Feb 26, 2021

This is one of the atisket edits

OK, but you wanted ones with multiple release *dates*

let me see about getting that

hmm, releases which happened on different dates in different regions used to be fairly common, but in the modern internet and social media age i guess that's getting pretty rare

derwin: OK, got the results. Yes, there are quite a few.

Here's the one with the most different years: https://musicbrainz.org/release/9bb92953-39f8-4...

awesome, thank you, sorry, busy irl :)

no worries

wow, that's crazy!!!

the suggestion to make a pastebin was a good idea

so.. it was added at 2020-08-21, but has grouped release dates from 2003, 2004 (2), 2005 (4), 2011 (2), 2012 (4), etc.

so the API returned those different dates, all on one date.

Kosovo

2020-04-21

Myanmar

2020-04-21

bleh, sorry paste

and then no release date for some countries?!?!?!

that's indeed very werid

There are only 32 releases with 3 or more different years.

does anyone know if there is a way to find out when a particular release got added to spotify or itunes?

Hi! Not sure if this will work, but I see y'all are discussing some digital releases that I added with different dates, etc. There was a time when I was really trying to pay attention to the dates that Apple Music, iTunes, Deezer & Spotify all first were available in certain countries. I have created a Word file with all the dates first available.

I did this so that releases from 2004 that were on iTunes wouldn't show up in say Suriname as the same year. That Dave Brubeck release is a prime example of this. All those dates are earliest dates of the 3 linked sites for each country. It's very time consuming as you can imagine.

So, no. The dates are not from the API. The earliest date is from the API. All the dates after that are from first availability date of 1 of the major 3 sites. This still isn't 100% as it the releases may have been on services other than iTunes, Spotify or Deezer. This is evident by Jaxsta showing many of these as released in countries that

a-tisket is saying the 3 sites don't have the release.

Also, I don't 100% rely on the API as many dates are wrong there as well. I check Soundexchange against the barcode to see when a barcode was first made avaialable.

Freso Will there be a separate link added to chatlogs.mb to make it easy to find the previous freenode chatlogs? i.e. https://chatlogs.metabrainz.org/brainzbot/music...

greetings

Oh, the release dates not being on some countries is due to the fact that Deezer's API returned those counties as available, but those countries aren't listed on Deezer's availability list. So, it was released in those countries by Deezer according to their API, even though their website (https://developers.deezer.com/guidelines/countries) says

Deezer is not there.

19:18 < JesseW> There are only 32 releases with 3 or more different years.

that tigerman325 comment is :mind-blown:

"api is wrong, soundexchange says something different"

finalsummer: also, definitely perspective on "the API says" !

https://beta.musicbrainz.org/edit/79970417 <-- as many eyes as possible please!

can somebody clarify something about atisket?

as far as I understand, the big list is the current availablity. is that correct? or is it the availability on the date given?

ev: it reports the availability at the time the requests are made to the store APIs

ok, so it's unrelated to the actual release date given. thanks.

Uploaded file: https://uploads.kiwiirc.com/files/0625875547895...