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=374 and productid=cache_Products.productid) order by PublishDate desc
When does work end and play begin? For Assembly New York designer Greg Armas’ fall collection, all work and no play was not going to cut it, so he examined a way to combine the two. ...
MORE
Gun-toting, cigarette smoking, patriarch of the gonzo school of journalism Hunter S. Thompson rewrote the rules of journalism (with a little assistance from one Raoul Duke). ...
MORE
The men's Assembly NY Fall/Winter 2012 collection is what happens when Neo of The Matrix takes the blue pill, trades in the black trench for a tan one, tops off the look with a leather cap, and says, "Thanks––but no thanks," to ...
MORE
Matty and Megan, OCLA's fun-loving duo , are back! Get ready for the parties, the fireworks, and the water guns! Matty and Megan picked their favorite red, white, and blue outfits for this weekend. ...
MORE
Humberto wishes his pal Jason a happy one for his b-day (yesterday)! It's only appropriate to say that Jason is one of my favorite people I've met in this decade. ...
MORE