Query displays results only when other values and parameters are removed

Things I have tried

I created a note with the following frontmatter:

tags: notes
type: voicebank
gender: feminine
voicebank_language:
- chinese
- japanese
software:
- ace_studio
- vocaloid_3
- vocaloid_5
developer:
- bplats
- mercury_inc
- yamaha

Here is my query:

table gender, software
from "/"
where type = "voicebank" and software = "ace_studio"

or

table gender, software
from "/"
where contains(type,"voicebank") and contains(software,"ace_studio")

When I reduce just down to this, I finally get a result:
image


tags: notes
type: voicebank
gender: feminine
software:
- ace_studio

It only works when I pare it down that far, otherwise no luck

What I’m trying to do

I want a query that lists voicebanks and ace_studio in the table, along with the gender and all the software packages it comes in.