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.

[Jeff_Mash]

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.

I understand, and THANK YOU for the help. I hope my previous reply didn't insinuate that your query was not what I has asked for. I simply used that as a "base" to modify and add more parameters to return fields from the database (like product name, image, etc). That was when I noticed it wasn't as easy as asking for those fields in the query.