This question has already been answered:
There is a filter in which the user has selected the necessary.
And we got the following array:
[ 'property_id'=>8, 'value'=>2 ] [ 'property_id'=>99, 'value'=>10 ] And we need the first pair of values to match, and the second. Those. so that there is not either the second or the first, and that both pairs are equal to the values and both such rows are in the table.
Like that:
SELECT * FROM tables WHERE (property_id=8 AND value=2) AND (property_id=99 AND value=10) 
