Mac Geekery - How to Execute Raw Spotlight Queries in the Finder

'Sometimes you need to do nested queries or more advanced boolean logic than "all or nothing" as the Finder gives, and the Finder gives you a way, though it's a might complicated.'