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=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1210 and productid=cache_Products.productid) order by PublishDate desc

Nick Relph : all categories

PREVIOUS NEXT : 1~1 OF 1 ITEM

Nick Relph News:

5
  • Mon, February 4, 2013
    Not one, but two remarkable exhibitions currently occupy the gallery spaces of Gavin Brown's Enterprise. Both artists Christopher Knowles and Nick Relph draw on subjects of popular culture and bring their unique perspective to their shows. ... MORE

  • Tue, June 12, 2012
    Last Saturday, the DJ duo Rub N Tug (Eric Duncan and Thomas Bullock) curated a show at White Columns titled DO YOUR THING . As the former DJs of Gavin Brown 's now defunct bar Passerby, they both mourn and cherish the institution's bygone era in ... MORE

  • Fri, November 11, 2011
    Member: Elin Book/Magazine: Vestiarium Scoticum by Nick Relph Published in: Brooklyn, NY Price: $50 Why it's so great: I love the history of the Vestiarium Scoticum (try saying that after a drink or two)! In a sense this book is a copy, of a ... MORE

  • Fri, September 30, 2011
    One of our newest interns Etienne visited the preview of the New York Art Book Fair at PS1 last night. Take a look at what he got up to!   Print is not dead. ... MORE

  • Wed, May 25, 2011
    Make It Snappy is a photo series showcasing quick snaps from OC & friends. Who: The Artist with Lord and Lady L'Ange! What: Nick Relph's book launch Where:  Donlon Books on Broadway Market in London When: On Wednesday MORE

ecommerce web design web development