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 '%Elin%' and [Keywords] like '%Bieltvedt%' ) or productname like '%Elin Bieltvedt%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%Elin Bieltvedt%' or Remark='Elin Bieltvedt'))) order by PublishDate desc
Check out what the staff are coveting! Pick : Telfar bucket hat This piece is perfect for : The beach! I'll be taking mine to Barcelona this summer. ...
MORE
Thursday night saw the preview of longtime OC friend and lookbook photographer Max Farago 's Look Like Barbie, Smoke Like Marley exhibition at Jonathan Viner gallery in London's Mayfair. ...
MORE
Fish and chips is arguably the greatest and most popular English dish of all time (maybe aside from a roast dinner). Yet in the vast ocean of London chip shops, seldom can you find that perfectly beer-battered piece of cod, or chips that are ...
MORE
Last Friday, for one night only, street skating pioneer, Mark Gonzales, presented One Day, One Show at the home of HUCK Magazine in Shoreditch. ...
MORE
Picture K-pop, Korea’s finest street food, and our very own Winnebago beauty salon; OC London took over King Street last night to throw one hell of a Korean-themed party for Fashion’s Night Out . ...
MORE
Member: Elin Book/Magazine: Vestiarium Scoticum by Nick Relph Published in: Brooklyn, NY Price: $50 Why it's so great: I love the history of the Vestiarium Scoticum (try saying that after a drink or two)! In a sense this book is a copy, of a ...
MORE
Meet Elin, our new styling intern whose wrist snapped when she took a tumble off her bike on the Williamsburg Bridge. Get well soon, Elin! Name: Elin Bieltvedt Hometown: Reykjavik, Iceland (by way of Hong Kong) Astrological sign: Aries ...
MORE