Common Projects : 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=1084 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~1 OF 1 ITEM

Common Projects News:

5
  • Mon, October 15, 2012
    Meet Alex, our newest sales associate at OCLA! Name: Alexander Hadyn Blatt Hometown: San Fernando Valley, CA Astrological sign: Virgo Currently obsessed with: Jacques Audiard films, Janet Jackson's "Rhythm Nation," and Hedi Slimane's ... MORE

  • Mon, August 6, 2012
    Meet Kenny, one of our new friends at Opening Ceremony London! Name: Ken T Hometown: London Astro sign: Gemini Currently obsessed with: Black Last film I downloaded: Babylon (1980) My vice: Not getting enough sleep My virtue: Clean footwear When I ... MORE

  • Wed, June 20, 2012
    Meet Kevin, our newest blog intern, all the way from Philly. Name: Kevin Pires Hometown: Philadelphia Astro sign: Aires Last song I downloaded: "Henny & Gingerale" by Mayer Hawthorne When I was 13, I was wearing: Rocawear Vice: TV ... MORE


ecommerce web design web development