如何从一个列中分组的MySQL表中选择具有所需值的行

I need to filter products where certain attributes are stored in a joined table that match all the required properties, i.e. users need to be able to gradually narrow down their search by adding requirements. I need to filter products where certain attribu