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=25 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1339 and productid=cache_Products.productid) order by PublishDate desc
Lucio Castro News:
5
-
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
-
Tue, April 30, 2013
In an early episode of The X-Files , Mulder spray paints the street to mark the location of an alien disturbance (while looking like a mega babe, as always). In my head, that's what all of those neon sidewalk markings in New York are. ...
MORE
-
Thu, April 18, 2013
Stop whatever you're doing and take a second to honor the birthday of a 90s silver screen, teen dream queen. The daughter of a TV exec. ...
MORE
-
Mon, February 11, 2013
Everyone was grinning at Lucio Castro's fall presentation yesterday. It was a combination of all the yellow (on the clothes, the floor, and a translucent vinyl partition), the rotating lineup of male models (I love menswear shows), and the story ...
MORE
-
Fri, October 26, 2012
Why buy one coat when you can buy two—or even three? Having endless options doesn't have to be about going on an next-level spending spree. It can also be about smart design and smart choices. ...
MORE
-
Mon, October 1, 2012
A man walks out of a bar. What's the punch line? Watch Lucio Castro 's new video below and get your chuckles here first. "Last Call" (the name of the video and the collection) was inspired by Aki Kaurismäki, the Finnish movie director ...
MORE
-
Wed, September 19, 2012
In the bustle before NYFW, we dispatched cameras to a handful of OC designers. The aim: to see how many snacks, coffee runs, and late-night pizzas go into making a collection. ...
MORE
-
Thu, September 13, 2012
It's New York Fashion Week and we’re nearly as excited to find out what’s playing during the shows as we are to see what’s on the catwalks. We asked some OC friends to hit us with their Spring/Summer 2013 show soundtracks. ...
MORE
-
Wed, September 12, 2012
Some people look at spray-painted markings on the pavement by construction sites and think nothing, LUCIO CASTRO , on the other hand, created an entire Spring/Summer collection around them. ...
MORE
-
Tue, September 11, 2012
Over the next week we'll be sharing the outfits of two of our buyers, Jesse and Carol. These two are partly responsible for all the awesome collections you see at OC, so expect some kyute looks! We caught Jesse yesterday, on his way to a ...
MORE
-
Fri, August 24, 2012
Tim Burton's birthday is tomorrow! Here, a birthday card in true OC style to one of our favorite visionaries. As a child of the 90s, it is unthinkable not to name one of Tim Burton's masterpieces as one of my favorite films. ...
MORE
-
Mon, March 5, 2012
This is Lucio Castro 's debut collection, not just at OC, but full stop. And the list of reasons why it's special goes on... For one, the designer was born in Argentina , which also happens to be OC's country of the year. ...
MORE
-
Tue, January 17, 2012
The OC Showroom is a bustling space that represents over twenty international and domestic designer collections. In our new column, Showroom and Tell , the Showroom team will be sharing sneak peeks of upcoming collections, snaps of visiting buyers ...
MORE