How to make 2 condition sets inside one script.

Sometimes you want to do a query where you want the records that match either at least one of two sets of conditions. There is a couple of ways, some easier than others and some easier to setup but harder to maintain etc. Here I give you a couple of examples.