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=4 and productid=cache_Products.productid) and ( ( [Keywords] like '%Kam%' and [Keywords] like '%Tambini%' ) or productname like '%Kam Tambini%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%Kam Tambini%' or Remark='Kam Tambini'))) order by PublishDate desc
On Saturday, six OCers repped Opening Ceremony in the fight for the adidas Fanatic XI soccer tournament cup. We went, we saw, but alas, we did not conquer. ...
MORE
This Saturday, OC is back in play at the Adidas ADICUP tournament – and we're readier than ever! Meet the OCers holding it down on the field (champ-style, obviously) this Saturday at Chelsea Waterside Park. ...
MORE
Meet Kam, the newest sales associate to hit the floor at OCNY! Name: Kam Tambini Hometown: Colombia by way of Lima, Peru Astrological sign: Libra Clothes on pets, right or wrong?: Very, very wrong Currently obsessed with: Raymond Pettibon graphics ...
MORE