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=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=873 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1377 and productid=cache_Products.productid) order by PublishDate desc
Make It Snappy is a photo series showcasing quick snaps from OC & friends. Who: OCLA's Karen (wearing her Sade T-shirt) and Dana of DeerDana ! Where: OCLA When: Yesterday afternoon
MORE
We love love no matter what shape or form it takes, so in anticipation of the big day on February 14, we called on some of our favorite power couples around the city. ...
MORE
Rudy's Barbershop moved onto our cozy block at the Ace Hotel last summer. Jimmy and I dropped in on our neighbors where barber veterans Louise and KC gave our fall locks a much needed trim. ...
MORE
Who says downtown creative types are apathetic and apolitical? Last night's Downtown for Democracy and VICE Fight Night event proved otherwise, with plenty of OC friends (including the original downtown democrat Glenn O'Brien) gathering around ...
MORE
Once a week in Silver Lake, LA, Ivory and OCLA's Michelangelo teach others about astrology. Now, at the turn of every sign, these two stargazers are here to offer us advice on love, life, sex, and fashion. CANCER Warrior you are... ...
MORE
The OC family wishes Pedro Winter the best for his birthday tomorrow! And if you haven't already, check out our Ed Banger photo diary of last week's Coachella festivities. ...
MORE
I wish there was a Jessica character from American Pie at my high school when I was growing up. Some sassy girl who verbally throws a bucket of ice cold water over any teenage fascinations and subsequent paths to disillusionment. ...
MORE