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=209 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=701 and productid=cache_Products.productid) order by PublishDate desc
Gerlan Marcel wants to open the first Gerlan Jeans flagship store in the town of Jean, Nevada. "It's in the desert in the middle of nowhere outside Las Vegas. But it's worth it to be in Jean, Nevada," she says. ...
MORE
Created by Brits Jamie Hewlett and Alan Martin, the comic book Tank Girl was released in a 1988 issue of comic magazine Deadline , introducing us all to our favorite tank-driving outlaw. ...
MORE
Meet Jo, the latest intern to join the styling team at OC Worldwide! Name: Jo Goldstein Hometown: Christchurch, New Zealand Astro sign: Virgo Currently obsessed with: Friedensreich Hundertwasser Last album I downloaded: ...
MORE
Buying a "99% angel, 1% devil" T-shirt from my local shopping center was a big deal. It was the first piece of clothing my mom didn't buy for me. My Gap Kids days are over, I thought as I pinned back my bangs with butterfly clips. ...
MORE
At the end of a super long fashion week, after hundreds of looks and too many shows, we still somehow always look forward to Gerlan Jeans , because we know it's going to be fun, unpretentious, witty, and super-cute. ...
MORE
Check out what the staff are coveting! "I am totally feeling the slime on this Gerlan Jeans Ghostbuster bomber ! I love the mesh sleeves and shoulders." —Marcus. See all of Marcus' picks | Shop all Gerlan Jeans
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends What: The oh-so-sludgey and amazing Gerlan Jeans Slime Bra, available in OC stores (online soon!) Where: In line to be shot at the OC Online studio Why: Is it ...
MORE
Allow me to introduce you to our homegirl and latest model, Jeanette Hayes . Thanks to her self-aware Twitter autobiography, I don't think I can describe her better than she does herself: Here are some people I may remind you of: Ivanka Trump, ...
MORE
For fall, Gerlan Jeans is back in all its loud and printed glory. This season, the playful street label covered its sweats, jackets, and cheeky doll-like dresses in faux-quilt and denim pocket prints (so 90s Guess!)––and the result is a ...
MORE
Coffin-shaped backpacks, patent platform sneakers from outer space, cone bras made of tiny witch hats, skateboards with attitude, suicidal hair dos and literally everything covered in mutant green slime... ...
MORE
Friday was the opening of the second edition of Dadarhea--"the video art equivalent to fantasy island"--at Canada gallery , curated by Jim Drain and Devin Flynn. ...
MORE
She loves color, glamour, and most of all, prints! Gerlan Marcel, designer of Gerlan Jeans , takes us to the malls of America and our adolescence in her SS11 collection for guys and girls. ...
MORE