I recall seeing a Spanish movie roughly 15 years ago about a womanizer who was cheating on his wife.

She found out and naturally: was very upset. He manages to talk her into having a threesome with his mistress. She agrees but with ulterior motives. Whilst at the restaurant, the three of them are having dinner and he is bragging about how much of a 'man' he is etc...

The camera goes underneath the table: as she pulls out a small pistol from her purse and shoots him between the legs with it.

In the end he survives, but ends up dickless or impotent (I cant really remember). Its pretty tragic for him, but she ends up being free, etc....

I wish I could remember the title of the movie. Does anyone know what film I'm talking about?

(I also neglected to mention, the cast were all very attractive. Especially the wife. For the life of me, I cant remember names)