Light Asylum : Music

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=30 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1422 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~1 OF 1 ITEM

Light Asylum News:

5
  • Tue, July 10, 2012
    The only thing hotter than the sun on Saturday were the beats, as MoMA PS1 launched its annual Warm Up concert series. Arca and Shayne of Hood By Air (available at OC here ) kicked off the afternoon with a heavy DJ set, followed by blazing ... MORE

  • Tue, May 22, 2012
    Once a week in Silver Lake, LA, Ivory and OCLA's Michelangelo teach others how to read and understand astrology. Now, at the turn of every sign, these two stargazers are here to offer us advice  on love, life, sex, and fashion. ... MORE

  • Tue, May 8, 2012
    If you've ever been to a Light Asylum show, you know that half the experience is the theatrics of their performance. The group's record release show at Le Poisson Rouge last Thursday was evidence of this. ... MORE

  • Mon, April 30, 2012
    Make It Snappy is a photo series showcasing quick snaps from OC & friends What: Just in! The new Light Asylum LP When: This afternoon Why : Available at OC stores and online! MORE

ecommerce web design web development