Hey list,

I've been tinkering with a query the past few hours, and it's about to drive me coconuts. It's using quite a few (messy) control statements, so I guess I'm staring myself blind trying to solve it.

Could be a combination of that, and too much coffee.

Anyway, here's the query:

http://pastebin.perl.se/b6e5b7f1cb/

The error I get while trying executing is "Unknown column 'products.product_id' in 'on clause'. Since I am selecting all columns from that table (products), I can't really see why there's a fuss about it!

I'm thankful for every tip I can get, and please let me know if you want to see the table layouts.

Best regards