Using a series of COUNTIFs as conditional fields

If we wanted to filter W where X = 3 or 12 or 5, we could set up

=FILTER(W,(X=3)+(X=12)+(X=5))

But it’s a preference of mine to apply COUNTIF, by setting those values in Z2:Z4 then

=FILTER(W,COUNTIF(Z2:Z4,X))

With some inversion, we could set Z2 to >=3, Z3 to <12 and Z4 to <>5, and then

=FILTER(W,BYROW(X,LAMBDA(i,AND(COUNTIF(i,Z2:Z4)))))

Which allows us to set the comparisons operators in the source cell(s).

It’s around this that I’ve tinkering with setting series of critieria, which may apply in OR or AND conditions per set, but am a bit stuck. Example below. I can approach each critieria field independently, and byrow AND/PRODUCT the seperate results, but how do I get MAP to parse through each reference field and query field independently?