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=1450 and productid=cache_Products.productid) order by PublishDate desc

Hood by Air : all categories

PREVIOUS NEXT : 1~2 OF 2 ITEMS

Hood by Air News:

5
  • Tue, May 28, 2013
    OCLA's Memorial weekend bash this past Saturday was pumpin' thanks to Caribbean food by Cha Cha Chicken, pineapple floats by Whipp'd LA, and rad tunes courtesy of Nguzunguzu , MASSACOORAMAAN, and special DJ guest Shayne from Hood By ... MORE

  • Fri, February 22, 2013
    Meet James, the newest addition to team OCLA! Name: James Flemons Hometown:  Los Angeles Twitter name:   @jamfries Astro sign: Virgo Currently obsessed with: All things mesh, oversized, and cropped. ... MORE

  • Wed, February 13, 2013
    Women with shaved heads clearly play a big role in Shayne Oliver 's imagination. As we saw at the designer's show for  Hood by Air 's  fall collection  on Sunday, San Francisco performance arist Boychild (also of the shaved head) is ... MORE

  • Mon, February 11, 2013
    Yesterday, Shayne Oliver presented his Fall/Winter 2013 Hood by Air collection with an amazing runway show, the word show not to be taken lightly. ... MORE

  • Fri, September 7, 2012
    Make It Snappy is a photo series showcasing quick snaps from OC & friends Who: Performance artist Boy Child What: The season's must-have accessory, the HBA pillow Where: The Hood by Air SS13 presentation at the OUT Hotel, NYC When: Today MORE
  • Tue, August 7, 2012
    While all you East Coasters were at work last Friday counting down the last seconds of your work week, Tokyo was a dozen time zones ahead of you with a party in full swing. ... MORE

  • 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

  • Thu, July 5, 2012
    Khalif Diouf, aka LE1F, has been hard to miss in 2012. He's rocked shows with everyone from SSION to Araabmuzik , while also releasing the next-level mixtape Dark York  in April. But he's no newcomer. ... MORE

  • Thu, June 21, 2012
    Shayne Oliver 's cult streetwear line Hood By Air , which began with simple Ts emblazoned "HOOD" made for friends in 2006, has finally landed at OC. ... MORE
  • Wed, May 16, 2012
    Meet Ezra, our newest blog intern, all the way from the sunny Bay Area.  Name: Ezra Marcus Hometown: Berkeley, California Astrological Sign : Leo Currently obsessed with: Livestrong bracelets Last song I downloaded:  "Put cha back in ... MORE


ecommerce web design web development