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=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=26 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=688 and productid=cache_Products.productid) order by PublishDate desc
Jordan Askill 's jewelry is the stuff of fairy tales. Galloping crystal horses, china swallows, and amethyst hearts sound like they come from Hans Christian Andersen stories, not East London. ...
MORE
In a family portrait, taken when she was 19, Frida Kahlo appears dressed as a man. She was badass. Frida is an inspiration because she didn't care what people thought, or at least she didn't let on that she did. ...
MORE
In 1997, my friend got a birthday cake iced with Leonardo DiCaprio's face. Earlier that year, he'd sketched Kate Winslet in nothing but a heart-shaped necklace, which then sunk to the bottom of the ocean and stayed there, until Britney's astronaut ...
MORE
Meet our pup-loving OC accessories designer, Zoë! Name: Zoë Wendel Hometown: Miami , FL Astrological sign: Scorpio Currently obsessed with: Dogs (always) Last song I downloaded: "Chi Chi" by Satan's Pilgrims When I was 13, I was ...
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
Jordan Askill is a conjurer. Taking cues from what surrounds him, the young Australian focuses on purity–primarily in the form of wild creatures–to inspire his work. ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends as we navigate Fashion Week. Who: Humberto and Sara Moonves with Jordan Askill Where: In front of Jordan's exhibition at LFW
MORE
Inspired by the energy of childhood, wildlife, architecture, and travel, Dior Homme alum Jordan Askill approaches jewelry-making with a sculptor's eye, an aesthete's taste, and a romantic's heart. ...
MORE