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=17 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=362 and productid=cache_Products.productid) order by PublishDate desc
Dana Lee News:
5
-
Fri, May 17, 2013
From Jimmy Dean's red windbreaker in Rebel Without a Cause to Gwyneth's tennis dress in The Royal Tenenbaums , clothes have obviously played a big part in movies. ...
MORE
-
Tue, May 14, 2013
Those childhood summers spent building forts or model airplanes have been replaced by a different kind of industriousness: tinkering under the hood of a car, maybe, or building an outdoor movie theater from a shower curtain. ...
MORE
-
Thu, November 1, 2012
Last night, OCLA threw its very first Halloween party with our friends of the record label Fade to Mind. Hosted at Leonardo's (a venue better known as an LA prom hotspot), the party featured an all-star lineup, with Kingdom, Total Freedom, ...
MORE
-
Fri, June 10, 2011
Full of faded, casual cool, the Spring 2011 collection from Dana Lee features relaxed menswear in rich pigments, just in time for the sunny season. In lightweight cotton, each perfect-fit style is sure to secure heavy rotation in your summer closet. ...
MORE
-
Thu, June 9, 2011
Happy birthday to our favorite 90s badboy/heartthrob. Besides the fact that he dated both Kate AND Winona (probably the coolest girls in the world), his skills on the silver screen have never let us down. ...
MORE