I have been wondering about that as well.
Potent Deo stick that I had tried:
Dune for men - The scent will stick on your clothes for days!
Givenchy pour men - Very long lasting as well. (This is the non-transparent ones you are looking for. I think they all have anti-perspirant)
There are more, I will post them when I remember...