The card should come with an active and a passive mini-dp to DVI adaptors. Both the adaptors mentioned also work, the first (powered accell) is required if you will be running greater than 1920x1080 (per monitor) otherwise the second listed and the one that should come with the card will suffice.
Each display is only running 1920x1080, so I won't need one of the powered adapters then? That definitely saves me some cash.
So it will be:
1st TV: DVI to HDMI cable
2nd TV: passive display port adapter (included with card)
3rd TV: active display port adapter (dont need the USB powered one, said to be included with card?) - again, only ever running at 1080p