Selection of applications suitable for the condition

Question

MySQL

There are requests, the request has parameters, each parameter is in its own table. You must select applications that meet the conditions. (those for where everything is known)
Everything seems to be simple, but the eye is already blurry, somewhere I'm stupid.

Different requests may contain different number of parameters.

an example from life is to select an object from the “rent” rubric, ads from the “rent” rubric (those who want to rent)

the scheme


is valid:
application # 1
prop1 = 25 and 6
prop2 = 5

application # 2
prop1 = 25

under the initial condition:
prop1 = 25 select 2 requests
prop2 = 5 select 1st request
prop2 = 7 select none
prop3 = 6 select none

Answer 1

Well, one join for each attribute, what's the problem then?