Just when I thought I was on top of the MB database tables “recording” and “release” - the following has confused me - I hope someone can explain why this is happening:-
I am using the API (JSON format) to find the Release (CD Name) from the Title and Artist. In this case the Artists are “John Farnham” and “Human Nature”, and the Title is “Every Time You Cry”, so the API request is:-
http://musicbrainz.org/ws/2/recording?query=recording:"Every Time You Cry" AND artist:"John Farnham" AND artist:"Human Nature"&limit=100&inc=tags&fmt=json
I am expecting the reply to include the release Title “Everytime You Cry” (FYI the mbid is f0db5756-2c98-4e11-9baf-fc64500077e4), however, this release is NOT included in the reply. Note the spelling difference between the recording (Every Time You Cry) and the release (Everytime You Cry).
However, if I change the spelling of the recording to that of the release as per below, I get the reply expected.
> http://musicbrainz.org/ws/2/recording?query=recording:"Everytime You Cry" AND artist:"John Farnham" AND artist:"Human Nature"&limit=100&inc=tags&fmt=json
Can someone please explain why the recording and release names seem to be swapped?
Thanks in advance