0 - 1 of 1 tags for error 2620

I have an unusual sitution. The below query works when I don't refer to any of the fields in the 'product_table'.
If I leave the product table join in it still works so it's not an issue with the join.