Related Topics
CMS-MENU-ERROR(OPEN - ): SELECT TOP 8 Publish_ItemVersion.ItemId,Publish_ItemVersion.Name,Publish_ItemVersion.Description,Publish_ItemVersion.StartDate,Publish_ItemVersion.MetaTitle,SUM(Publish_AAP_Calais_Article_Subjects.calculated_score) AS tot_score,Publish_ItemVersion_1.ItemId,Publish_ItemVersion_1.Name FROM Publish_ItemVersion LEFT OUTER JOIN Publish_ItemRelationship AS Publish_ItemRelationship1 ON (Publish_ItemRelationship1.ChildItemVersionId=Publish_ItemVersion.ItemVersionId) AND (Publish_ItemRelationship1.RelationshipTypeId=24) LEFT OUTER JOIN Publish_ItemVersion AS Publish_ItemVersion_1 ON (Publish_ItemRelationship1.ParentItemId=Publish_ItemVersion_1.ItemId) AND (Publish_ItemVersion_1.ApprovalStatusId=3) INNER JOIN Publish_Item ON Publish_ItemVersion.ItemVersionId = Publish_Item.ApprovedItemVersionId INNER JOIN Publish_ItemRelationship ON (Publish_ItemVersion.ItemVersionId=Publish_ItemRelationship.ChildItemVersionId) AND (Publish_ItemRelationship.RelationshipTypeId=28) AND (Publish_ItemRelationship.ParentItemId=20) INNER JOIN Publish_AAP_Calais_Article_Subjects ON (Publish_Item.ItemId=Publish_AAP_Calais_Article_Subjects.ItemId) AND (Publish_AAP_Calais_Article_Subjects.subject_id IN (SELECT TOP 3 Publish_AAP_Calais_Article_Subjects.subject_id FROM Publish_AAP_Calais_Article_Subjects WHERE (Publish_ItemVersion.DisplayTabId<>26) AND (Publish_AAP_Calais_Article_Subjects.ItemId=34785) AND (Publish_AAP_Calais_Article_Subjects.calculated_score>0) ORDER BY Publish_AAP_Calais_Article_Subjects.calculated_score DESC)) WHERE (NOT (Publish_ItemVersion.ItemVersionId IN (SELECT ChildItemVersionId FROM Publish_ItemRelationship WHERE (ParentItemId=19662) AND (RelationshipTypeId=29)))) AND (Publish_ItemVersion.ItemId IN (SELECT ItemId FROM Publish_AAP_Calais_Article_Subjects AS Publish_AAP_Calais_Article_Subjects_2 WHERE (subject_id IN (SELECT TOP 3 subject_id FROM Publish_AAP_Calais_Article_Subjects AS Publish_AAP_Calais_Article_Subjects_1 WHERE (ItemId=34785) AND (used_in_article_title=1) ORDER BY calculated_score DESC)))) AND (NOT (Publish_ItemVersion.ItemId IN (34785))) GROUP BY Publish_ItemVersion.Name,Publish_ItemVersion.Description,Publish_ItemVersion.StartDate,Publish_ItemVersion.MetaTitle,Publish_ItemVersion.ItemId,Publish_ItemVersion_1.ItemId,Publish_ItemVersion_1.Name ORDER BY tot_score DESC
Haute in the French Riviera
by Rima Suqi
Manuel Zublena
The French Riviera has historically attracted the rich, the famous and the very attractive. Now, the jet set have yet another stylish property on which to lay their sleepy heads when they’re not ensconced on one of the many yachts docked at the harbor in Saint-Tropez. Hotel Sezz Saint-Tropez, the sister property to the Hotel Sezz in
Paris, offers breezy, modern interiors and furniture by design-world darling Christophe Pille; a Dom Pérignon champagne bar; and the restaurant Colette, presided over by the multiple-Michelin-starred chef Pierre Gagnaire (who, in addition to his eponymous restaurant in Paris, made his U.S. debut with Twist at the Mandarin Oriental in Las Vegas). The hotel’s 37 rooms, suites and villas are set amid lush landscaping that also surrounds a heated swimming pool. New this season: two villas, complete with outdoor showers, private pools and terraces, as well as the recently completed Spa Sezz by Payot, which offers the full range of face and body treatments as well as, yes, a French manicure. Mais oui! From $460,
www.hotelsezz.com
Share Your Comments