North Drive Press : 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=1 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=298 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~1 OF 1 ITEM

Mens News:

5
  • Fri, January 22, 2010
    Last night's fete for North Drive Press was as much to say goodbye as it was to say hello to the publication created by OC Art Director Su Barber and our friend Matt Keegan. ... MORE

  • Thu, January 21, 2010
    Since it's debut in 2003, North Drive Press has published hundreds of artist's multiples, interviews, and texts. Editor Matt Keegan and I are thrilled to present the fifth (and final) issue this evening at X initiative. ... MORE

  • Thu, July 16, 2009
    Last night, friends and featured artists of North Drive Press gathered at White Columns for a good time and a great cause. The silent auction raised funds for the upcoming fifth and final issue of the annual art-focused publication co-edited by Matt ... MORE

  • Wed, July 8, 2009
    Started by Matt Keegan and Lizzy Lee in 2003, North Drive Press has collaborated with artists to distribute everything from 7" records to temporary tattoos to exquisite corpse prints (one edition of which hangs at the Whitney). ... MORE


ecommerce web design web development