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=535 and productid=cache_Products.productid) order by PublishDate desc
“Screw kindness. You have to tell the truth, that’s what comedy is all about,” Joan Rivers once said. Sarah Silverman, Kathy Griffin, and the rest of today’s unapologetic comediennes wouldn’t exist had it not been for ...
MORE
Robots, rhinestones, and tiny animals. Excuse me while I hyperventilate. I can't decide what I like most about Mark Walsh and Leslie Chin's fall collection: the little glass ducklings suspended in silver hoop earrings or the monsters with ...
MORE
There aren’t many designers who can claim both the fashion darlings and the sneaker freaks as factions of their fan base, but Jeremy Scott has found a way to unite their disparate closets. ...
MORE
To celebrate the start of the lunar new year, we raided OC for these red, fiery, and show-stopping finds to bring you all the luck you need in the Year of the Dragon. Gong hei fat choy!
MORE
An inspiration to almost every R&B artist out there these days (Drizzy for one), Aaliyah had her first record contract on lockdown at age twelve. ...
MORE