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=510 and productid=cache_Products.productid) order by PublishDate desc
Earthworm Jim , Dinosaurs , Catdog , Samurai Pizza Cats , and Muppet Babies all have a special place in my heart, but no other program fried as many of my tween brain cells as Daria did. ...
MORE
Plucked from the hoards of potential DJs in hopes of cue'ing it up for lady rap group Salt-N-Pepa, Deidra "Dee Dee" Roper was only sixteen at the time that she became the Spinderella we know and love. ...
MORE
Happy birthday to our favorite apple-cheeked cutie, Kevin Arnold AKA Fred Savage! Hope this one's even more wonderful than all of the Wonder Years episodes combined! As always, our prezzies below.
MORE
Known for her temper as much as the "boom-boom" in her walk (as Vogue once put it), Naomi Campbell has been a force to reckon with since débuting as the face of YSL in the 80s. ...
MORE
Janet, Miss Jackson (if you're nasty) first captured my generation's attention in 1990 with "Rhythm Nation 1814." From that moment on, I was hooked. A Janet fan for life. ...
MORE
On Thursdays, you'll find them navigating the streets of the LES, hopping from gallery to gallery, hitting up as many openings as they can cram into the night. ...
MORE