After running the modified queries using different Spam entries in the DB (no Spam. Spam on child records, Spam on parent records, different Spam values in Akismet and B8), the query results match between the old and new code. And looking at the actual SQL, this makes perfect sense. So, I'd say the changes all look good.