select ProductID,ProductName,ImagePath,Designer,SalePrice,Price, GRoupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=1 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=116 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=745 and productid=cache_Products.productid) order by PublishDate desc
Make It Snappy is a photo series showcasing quick snaps from OC & friends. Who: Our model, Logan What: Showing some leg in Hixsept SS12 (coming soon!) Where: OC photo studio Why: Uh, he has a Hogwarts tattoo When: Today!
MORE
Aurélien Arbet and Jérémie Egry can kind of do everything. As well as designing the clothes for their super cool French clothing label Hixsept , they handle all of the brand's creative direction, are working on a ...
MORE
Name: Zacq Rosen Hometown: Deerfield, IL Astrological sign: Pisces One can never go wrong wearing: A leather jacket I aspire to dress as well as: Patti Smith First AOL Screen name: LowfatChocolategod Favorite brands at OC: AUREL SCHMIDT ...
MORE
We're ready for summer to hit! Matty and Megan pick outfits to go with their favorite summertime activities. These pics are for entertainment purposes only -- we do not recommend jumping rope in heels. Photographs by Teena Sahebi
MORE
Probing the subtle implications and influences a garment has on its wearer, Paris-based brand HIXSEPT offers a refreshing, adventurous approach to textiles in menswear. ...
MORE