We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Great code, thank you! One thing to note is that if you change WHERE to AND in
WHEREs.score=d.score
and move it up right after the second JOIN...ON..., it should run faster, as it would use the condition in a join, not after all the joins. This is my version:
Top Competitors
You are viewing a single comment's thread. Return to all comments →
Great code, thank you! One thing to note is that if you change WHERE to AND in
and move it up right after the second JOIN...ON..., it should run faster, as it would use the condition in a join, not after all the joins. This is my version: