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=21 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=706 and productid=cache_Products.productid) order by PublishDate desc
Before Beverly Hills, 90210 , Dawson’s Creek , The O.C , and Gossip Girl there was Saved by the Bell . For four years (plus the two spin-off series), Zack, Kelly, Lisa, A.C, Jessie, Screech, and Mr. Belding made us laugh, cry, and LUST. ...
MORE
Yes, Jerry Seinfeld the man is not the same as Jerry Seinfeld the character, but we like to think they're almost identical. We've gone ahead and taken his birthday (which was yesterday) as an opportunity to recall our favorite Seinfeld moments: the ...
MORE
Meet John, our dreamy model who we liked so much that we made him a blog intern at OC Worldwide. Check out John's first article here and you'll agree he's not just a pretty face! Your neighborhood (in NY): Soho Hometown: Saint Petersburg, ...
MORE
Make It Snappy is a photo series showcasing quick snaps from OC & friends as we navigate New York Fashion Week. Who: My friend Marcel Where: At the Riviera Club presentation, Bowery Hotel What: Modeling When: Tonight!
MORE
Models sipped wine and noshed on a decadent spread of cured meats, fluffy breads, cornichons, grapes, and cheese at the Riviera Club FW11 presentation tonight at the Bowery Hotel. ...
MORE