The search term A or B and C or D may or may not give the results illustrated in the diagram. It is impossible to know, unless you make assumptions about what default priorities will be applied by the database. If you want to be sure, you should use an expression with appropriate parentheses.