Quick help with MySQL Query - Selecting OLD Product at Random

[DrByte]

However, when I request to return other information (like the product NAME, the product IMAGE, things that I need for my other function), then the results returned give me some duplicates.

Your duplicates are because you're joining multiple tables but not accounting for mismatched joins.
I built my suggestions based on you saying you wanted product_ids. Not complete product details. I assumed since you were only returning 1 item in your examples that you were intending to do a separate query for the rest of any truly needed data.