Troubleshooting SQL queries with omni_id

Once you have a complex SQL query, sometimes the query doesn't fail, but it returns unexpected results. Something is going on with it, but it's hard to tell what exactly, and SQL and databases don't always help you figure that out. Let's look at this...