Long story short, I made my query work last night and I look forward to it being the bedrock of a core feature that works fine for months or years until I hit some arbitrary scaling threshold and brings the whole site down and ruining some hypothetical future employees day.
