Acne Studios : 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=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=112 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid in (select typeid from mss_types where sign='designers' and remark = (select typename from mss_types where typeid=1265)) and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~8 OF 48 ITEMS SHOW ME EVERYTHING

Sweden News:

5
  • Fri, September 9, 2011
    Our Stockholm correspondent Gustaf von Arbin gives us the lowdown on this year's Polar Music Prize, which was recently awarded to Patti Smith and The Kronos Quartet! Last week, the prestigious Polar Music Prize was handed out at the Stockholm ... MORE

  • Fri, September 2, 2011
    Our Stockholm correspondent Gustaf von Arbin sends us an update from the Swedish music festival, Popaganda! Last weekend, the fantastic Popaganda festival brought the heat back to Stockholm. ... MORE

  • Tue, June 7, 2011
    Our Stockholm-based contributor Gustaf Von Arbin sends us his latest! Recently, it was my birthday, as well as that of one of the world's biggest flowers. ... MORE

  • Wed, February 9, 2011
    The man with a cap came to show us how to clap. Four years ago, Steve Reich received the prestigious Polar Music Prize with jazz saxophonist Sonny Rollins. ... MORE

  • Tue, February 8, 2011
    Our Swedish correspondent Gustaf Von Arbin gives us a recap of Fashion Week, the Scandinavian edition! Last week was fashion week in Stockholm. ... MORE

  • Mon, December 27, 2010
    Hohoho! Happy Holidays and God Jul! Sweden is the whitest it's ever been at this time of year. Stockholm looks like a big marshmallow land, and it's very beautiful and freezing cold. ... MORE

  • Mon, November 15, 2010
    Our Stockholm-based contributor Gustaf Von Arbin sends us his latest! I went to see Lykke Li play at Kägelbanan in Stockholm last week. She put on a fantastic show with some new banging tunes. ... MORE

  • Fri, November 5, 2010
    Our Swedish correspondent, illustrator Gustaf von arbin , delivers his latest ! Fall has arrived in Stockholm and so has the art. ... MORE

  • Fri, September 24, 2010
    Despite being an exporter of the world’s finest denim (Acne!), Sweden has long been an exporter of some of the most interesting music in the world. ... MORE

  • Thu, September 23, 2010
    Our Stockholm correspondent, illustrator Gustaf Von Arbin , takes us on a shroom-tastic tour of the depths of the Swedish forest. ... MORE

  • Fri, September 3, 2010
    Stockholm correspondent Gustaf Von Arbin contiues his series of posts from Sweden, this time reporting on the Polar Music Prize! This past Monday in a ceremony in the Stockholm Concert Hall, Björk and the Italian conductor/ ... MORE

  • Mon, August 16, 2010
    Gustaf Von Arbin files his second report from Sweden, this time investigating a traditional textile studio. I went with my brother Carl to the Märta Måås-Fjetterström textile art studio situated in the little town of ... MORE

  • Mon, August 2, 2010
    Gustaf Von Arbin is a Swedish illustrator and artist who will be posting drawings and reportage from Stockholm for OC. We look forward to his delicately hand-drawn missives! My name is Gustaf and live in Stockholm, Sweden. ... MORE

  • Thu, May 27, 2010
    Despite missing my life as a Brooklyn expat turned photography intern at Opening Ceremony, the will of an Icelandic volcano and the customs department have kept me captive in my hometown of Lund, Sweden for the past couple of weeks. ... MORE


ecommerce web design web development