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=955 and productid=cache_Products.productid) order by PublishDate desc

Bass Weejuns : all categories

PREVIOUS NEXT : 1~3 OF 3 ITEMS

Bass Weejuns News:

5
  • Fri, June 1, 2012
    Tomorrow we celebrate The Queen's Diamond Jubilee, marking 60 years of her glorious pastel-clad, Corgi-filled reign. Since 1953, Elizabeth has ruled with unshakable British resolve, riding horses through assasination attempts, talking down bedroom ... MORE

  • Fri, April 20, 2012
    The OC family wishes Pedro Winter the best for his birthday tomorrow! And if you haven't already, check out our Ed Banger photo diary of last week's Coachella festivities. ... MORE

  • Fri, December 16, 2011
    Happy Holidays from OC! To welcome the festive season, we’ve put together an array of MEN ’s, WOMEN’ s, and  KIDS ’ gift guides. ... MORE

  • Fri, September 16, 2011
    This year the iconic Bass Weejuns loafer turns 75! The Weejuns, Maine shoemaker G.H. Bass's adaptation of a little-known Scandinavian moccasin (get it, Norweejun?), has become an American design classic. ... MORE

  • Thu, July 15, 2010
    It's no secret that self-confessed prep Mark McNairy gravitates to the finer things in life (just look at his classic, Ivy-inspired shoe label, New Amsterdam). It seems only natural, then, that he and historical footwear manufacturer, G.H. ... MORE


ecommerce web design web development