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=4 and productid=cache_Products.productid) and ( ( [Keywords] like '%Jason%' and [Keywords] like '%Tsai%' ) or productname like '%Jason Tsai%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%Jason Tsai%' or Remark='Jason Tsai'))) order by PublishDate desc
You've seen the CAMERA DIARIES kept by designers, now see what our model friends, JOHN and MARC , got up to during New York Fashion Week. When I was 16, I cut school to sneak into New York Fashion Week. ...
MORE
Check out what the staff are coveting! "I'm so happy to report that every baby girl can now channel her inner Rihanna with this Opening Ceremony by A for Apple bianca pointed collar dress . ...
MORE
Say hi to our buying intern, Jason! Name: Jason Tsai Hometown: Bridgewater, New Jersey Astrological sign: Aries It’s a deal-breaker when my date wears: A popped collar One can never go wrong wearing: A denim shirt. ...
MORE