If I use AND with TYPE1 alone, then I get 72 records,

If I use AND with TYPE2 alone, then I get 0 records,

If I use AND with TYPE3 alone, then I get 10 records,

If I use AND with NEW_TYPE alone, then I get 7 records.

Also, can you test if you still get 7 records when you use both

TYPE2

and

NEW_TYPE

. Since

TYPE2

matches 0 records. Also try same with

TYPE1

and

TYPE3

.