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=545 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=272 and productid=cache_Products.productid) order by PublishDate desc
Before moving to their current location in New York's Fashion District, Philip and Courtney Crangi, the siblings behind Giles & Brother , worked from a tiny space in the Meatpacking District, making the most of the McDonald's dollar menu. ...
MORE
Philip Crangi and his sister Courtney were born and raised in Palm Beach, a place where priceless estate jewelry and miles of sand combine, so it's no wonder they grew up with fantasies of finding buried treasure. ...
MORE
Philip Crangi and his sister Courtney are the jeweling duo behind Giles & Brother , a diffusion line of African-influenced, antique-driven, yet distinctly modern accessories. ...
MORE