select ProductID , 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 cache_products.GroupID <> 5433) and exists (select top 1 1 from mss_index where typeid=1676 and productid=cache_Products.productid) order by PublishDate desc
"rooklyn-based jewelry line Sorelle is brand new to OC this season! But designer Francesca Grosso is already one of the family. The OCNY old-timer crafts each pair of delicate hoop earrings by hand, using a treasure trove of precious metals and Indian beads. The five styles are all named after Francesca's friends and family, so look out for pieces with familiar OC names!
Sterling silver hoop earrings with gold-plated flower petals | Hook closure | Made in the USA.