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=116 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=991 and productid=cache_Products.productid) order by PublishDate desc
"Grigri" is my new favorite word. A grigri is a voodoo amulet used to fend off bad juju (or bring it down on other people—up to you). But mostly, you wear one around your neck or carry one in a small pouch for protection. ...
MORE
Happy birthday to the Czech-born stunner Paulina Porizkova! With her icy penetrating stare and flawless jawline, it's no wonder she ruled the fashion world in her day. ...
MORE
For our latest online editorial, OC stylist Daria Radlinski, prop stylist Amy Henry, and photographer Jeremy Liebman came together to play their own version of Supermarket Sweep . ...
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
SKULLS! More of them. Yes, I know it's not Halloween anymore. But these ones are different. They haven't come from a crypt or from Rickys, they've come from the sunny shores of Saint-Tropez. ...
MORE