HINT:

Try adding a condition to select the MAX(InvTransactions.TransDate) for that media.