The long-awaited film, with a huge female fan base, surprisingly knocked the latest Indiana Jones action-adventure from atop the box office, with the Harrison Ford flick selling 46 million dollars its second over the three-day period, according to studio figures released yesterday.

"Indiana Jones and the Kingdom of the Crystal Skull," last weekend's box office leader, continued with strong business, as the Paramount release has earned US$216.9 million in US and Canadian theaters after its opening on May 22.

Released by Warner Bros., "Sex and the City" became the top-opening romantic comedy of all-time, and the second biggest debut for a TV adaptation after "Mission: Impossible II," which opened with US$57.8 million in 2000.

Amid reports of group parties and thousands of sold-out screenings, women moviegoer flocking to theaters helped "Sex And The City" beat the most optimistic projections, which expected a gross in the US$40-million range for the weekend.

Its phenomenal success at box office also trumped Hollywood's conventional wisdom that a film with a largely female cast and girlish storylines would limit its ability to sell tickets.

Meanwhile, Universal's low budget horror "The Strangers" debuted with an estimated US$20.7 million at No. 3, followed by Paramount's "Iron Man" and Disney's "The Chronicles of Narnia: Prince Caspian," respectively with US$14 million and 13 million for the weekend.