Giles & Brother : GIFTS

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
PREVIOUS NEXT : 1~1 OF 1 ITEM

Womens News:

5
  • Tue, February 7, 2012
    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

  • Mon, January 23, 2012
    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

  • Tue, August 3, 2010
    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


ecommerce web design web development