Schier : all categories

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=1442 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~1 OF 1 ITEM
  • Handmade Springbok Vellies
    $380.00

Schier News:

5
  • Wed, February 13, 2013
    It was definitely a family affair at the  WILLIAM OKPO  Fall/Winter presentation on Monday night. Several OCers, proud as punch, mingled about the room celebrating another awesome presentation by OC alumni Lizzy and Darlene Okpo. ... MORE

  • Wed, May 23, 2012
    With so many fresh items popping up each day, OC's stylist Daria brings you her favorites in  This just in . Isn't it weird when a print becomes so ubiquitous it turns into a neutral? I feel like this is what's happening with camo. ... MORE

  • Thu, May 10, 2012
    Colloquially known as "vellies," Veldskoen boots (pronounced Vel-skoon ) are worn by just about everyone in Namibia, from bushrangers to university students. ... MORE


ecommerce web design web development