Greetings,
I am trying to construct a query but no matter how i approach it the results aren't accurate and the performance is bad. I'll give a somewhat pseudo example of what i'm trying to achieve and hopefully someone knows how to accomplish it as ...