Sex and the City - Season 2 - Eps 12: La Douleur Exquise!
Carrie is horrified when Big casually tells her he's moving to Paris for seven months. Miranda dates a man who only wants to have sex in places where they might get caught. Charlotte meets Buster, a high-end shoe salesman with a serious foot fetish. Samantha introduces the girls to a hot new S&M restaurant.
About Sex and the City

Title: Sex and the City
First Air Date: 1998-06-06
Last Air Date: 2004-02-22
Status: Ended
Rating: 7.4/10 (from 2044 votes)
Language: EN
Seasons: 7
Total Episodes: 94
Network: HBO
Genres: Comedy, Drama
Production Companies: Darren Star Productions, HBO
Synopsis
Based on the bestselling book by Candace Bushnell, Sex and the City tells the story of four best friends, all single and in their late thirties, as they pursue their careers and talk about their sex lives, all while trying to survive the New York social scene.
Cast

Sarah Jessica Parker
Carrie Bradshaw

Kim Cattrall
Samantha Jones

Cynthia Nixon
Miranda Hobbes

Kristin Davis
Charlotte York