then why not just use

select distinct prod_id, user_id
from activity_tracker
where user_id = 207


however as an added thought, it seems like your database layout isn't very normalized. if you normalize it you won't have to rely on DISTINCT queries (which slow down performance) and will generally make things easier to organize.