It's not a lot, maybe 20k rows. I did just manage to get it working the way I like, and it's not running too terribly slow. Unfortunately I can't make...

I'm still having trouble with this, what you're saying is basically (one of the ways) I've tried but I can't quite wrap my brain around it.

Here's my original query:

SELECT i.product_name...