On Mon, 27 Jul 2015 at 16:24, rotaiv wrote: > I am more than open to a more logical and/or more efficient query if > anyone has suggestions.
One alternative was posted by Igor, but it might end up as the same
query plan after the optimizer has done its thing (EXPLAIN will tell
you).
Adding indexes to the columns you are JOINing on might also help, if
you haven't done already, but you'll have to test whether index
creation time pays off in saved query time.
cu
Reinhard
