As tye suggested, you need parentheses around all of the OR options too.
In reply to Re^3: in, ands, ors in query by chromatic in thread in, ands, ors in query by Anonymous Monk