Find Files in Multiple Folders

I have a huge collection of music samples, like "bass, piano, synth, arp..." within multiple folders. I would like to find the samples that only match the key and bpm, but these are written only in the folders they're in and not in the actual file names.

Example: folder name > subfolder name 110 Gmaj > piano.wav

I want to be able to find all the "piano" samples that are in the folders with "Gmaj" and have "110Bpm" in their names. I tried to play with filters and matching but nothing seems to work.

Tools > Find Files > Advanced, then match on either Location (the path up to, but not including, the filename) or Full Path (all of the path, including the filename).