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...
