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=545 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=220 and productid=cache_Products.productid) order by PublishDate desc
T.G.I. Friday! All signs are pointing to a scorching hot weekend, so here's the second edition of our summer survival guide, this time for the boys! Swimmers, trunks, Speedos—whatever you want to call them, and however short you like to wear ...
MORE
When you hear, "Let's go to the beach!" you need to be ready. Like flashlights, tinned food, and blankets in an emergency, the perfect bikini, sunglasses, and towel would, in an ideal world, be packed in a bag by the door. ...
MORE
Every day up until December 23rd, we'll be highlighting a different category from our Holiday Gift Guide, which we curated with everyone on your list in mind! Today: Beach Bum and Beach Babe! It seems like the annual holiday tradition for the ...
MORE
Yvonne Force Villareal and Doreen Remen founded the Art Production Fund in 2000 for two special reasons: to help support ambitious artists with big dreams (but considerably smaller wallets), and to help expand art audiences, in general, through ...
MORE
Spotted on deck chairs at the pool of the Standard Miami: Art Production Fund 's beloved artist beach towels. Continuing their W.O.W., "Works on Whatever" project, A.P.F. unveiled two new towels just in time for Art Basel. ...
MORE
Just in case you were underwhelmed by the selection at Christie's and Sotheby's last week, look again to Art Production Fund to bring out the unexpected and fresh. ...
MORE
Wed, May 27, 2009
Not your typical pop up shop, Opening Ceremony last night hosted an art opening for Art Production Fund. Friends of A.P.F. and O.C. gathered at our Howard St. flagship to fete the latest public art project by Karl Haendel, the L.A. ...
MORE