How do I search for a Release with only the 'Track Names'


#1

Hi!

I must missed something ‘very basic’ so please help me out!
How do I search for a Release with only the ‘Track Names’.

Let say for this release: https://musicbrainz.org/release/85e3cca8-ad4b-442e-97a0-fc564d054529

All 12 tracks are:
“Next Time You See Me” “Mother In Law Blues” “That’s Alright” “Peaches” “Sweet Home Chicago” “Five Long Years” “Driving Wheel” “Stand By Me” “Yonders Wall” “Annie Get Your Yo-Yo” “Things I Used To Do” “Goodbye Little Girl”

If I search in https://www.discogs.com/ the correct release is presented directly:
https://www.discogs.com/Junior-Parker-The-Best-Of-Junior-Parker/master/436157

But how should I do in: https://musicbrainz.org

Later I will use the API for the final search but I need to know the basics in searching first.

/Thanks in Advance
Phil


#2

Hi!

Aren’t there anybody who knows if this works or not…


#3

What exactly do you expect as result?
The pure titles of the tracks as a list like

Next Time You See Me
Mother In Law Blues
Peaches
Sweet Home Chicago
That’s Alright
Five Long Years
Driving Wheel
Stand By Me
Yonders Wall
Annie Get Your Yo-Yo
Things I Used To Do
Goodbye Little Girl
without any track numbers?

I don’t think that you get such a list directly and without any scripts or own coding.
I would start to look at this documentations:
https://wiki.musicbrainz.org/Development/XML_Web_Service/Version_2
and
https://wiki.musicbrainz.org/Development/JSON_Web_Service


#4

Hi @Phil67ago, you can easily look for releases of a certain track name by entering the track title in the search field on top of your editor page, then in the select box next to that search field select “release”, then hit the button at the right of the select box to search, and then releases show up in a list.

For example I entered “Next Time You See Me” and then got this page of search results.

Hope this helps you! :slight_smile:


#5

Hi!

Maybe I was to short in wordings…

It’s the other way around.
Search by names of the tracks and get the release.

I’m familiar with the Python API after been using it for a couple of weeks now.
So I can get the result from queering each recording’s title.
One track gives a long list with release id’s which it has been released on.
In this case I need to do 13 queries by the API.
Make cross match between the results and see if there is a common release in all the 13 queries.
Possible to do, but it loads the server with 13 request and it will miss the associate scoring which is done by a normal indexed query.

So I thought it must be possible to do it as follow, but it seems that I am doing something wrong or it can’t be done.

– Test cases –

In Recordings by indexed search:
Query: “Next Time You See Me” (Result: Junior Parker as 3:e but wrong release)
https://musicbrainz.org/search?query=“Next+Time+You+See+Me”&type=recording&limit=25&method=indexed

In Recordings by indexed search:
Query: “Next Time You See Me” and “Mother In Law Blues” (no result!)
Query: “Next Time You See Me” “Mother In Law Blues” (no result!)

In Recording by advanced query index:
Query: recording:“Next Time You See Me” and recording:“Mother In Law Blues” (18841 Result: Junior Parker as 6:e but wrong release)
https://musicbrainz.org/search?query=recording%3A"Next+Time+You+See+Me"+and+recording%3A"Mother+In+Law+Blues"&type=recording&limit=25&method=advanced

In Recording by advanced query index:
Query: recording:“Mother In Law Blues” (40 Result: Junior Parker as 11:e correct release)
https://musicbrainz.org/search?query=recording%3A"Mother+In+Law+Blues"&type=recording&limit=25&method=advanced

In Recording by advanced query index:
Query: recording:“Next Time You See Me” or recording:“Mother In Law Blues” or recording:“Peaches” (1094 Result: Junior Parker as 6:e but wrong release)
https://musicbrainz.org/search?query=recording%3A"Next+Time+You+See+Me"+or+recording%3A"Mother+In+Law+Blues"+or+recording%3A"Peaches"&type=recording&limit=25&method=advanced

‘And’ seems to have no affect…
‘Or’ seems strange…


#6

Hi Again!

This is query I thought I could use to get the release The Best of Junior Parker

In Recording by advanced query index:
Query: recording:“Next Time You See Me” and recording:“Mother In Law Blues” and recording:“Peaches” and recording:“Sweet Home Chicago” and recording:“That’s Alright” and recording:“Five Long Years” and recording:“Driving Wheel” and recording:“Stand By Me” and recording:“Yonders Wall” and recording:“Annie Get Your Yo-Yo” and recording:“Things I Used To Do” and recording:“Goodbye Little Girl”

https://musicbrainz.org/search?query=recording%3A"Next+Time+You+See+Me"+and+recording%3A"Mother+In+Law+Blues"+and+recording%3A"Peaches"+and+recording%3A"Sweet+Home+Chicago"+and+recording%3A"That's+Alright"+and+recording%3A"Five+Long+Years"+and+recording%3A"Driving+Wheel"+and+recording%3A"Stand+By+Me"+and+recording%3A"Yonders+Wall"+and+recording%3A"Annie+Get+Your+Yo-Yo"+and+recording%3A"Things+I+Used+To+Do"+and+recording%3A"Goodbye+Little+Girl"&type=recording&limit=25&method=advanced


#7

I don’t think what you want is possible without local processing, because the search server doesn’t associate the track names with the release. In your query, you are searching for a single recording which has several names (which of course isn’t possible).

Well, and and or search for the terms “and” and “or”, respectively. What you seem to want, however, is the operators AND and OR.


#8

You are so right!! It must be capital letters!
So with ‘AND’ the results seems more real, but my query doesn’t work…

I saw someone mention a way of sending special custom made scripts (SQL?) to the server. Is that doable?
Need to download the database and see if there is a way…


#9

You can set up your own replicated database and query it as you like, of course, but it’s more work. :slight_smile: The web service won’t accept any SQL, though.