Dunno if this might work, but try:
select distinct prod_id, trans_status from my_table where user_id=207;