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=1787 and productid=cache_Products.productid) and ( ( [Keywords] like '%jeremy%' and [Keywords] like '%scott%' ) or productname like '%jeremy scott%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%jeremy scott%' or Remark='jeremy scott'))) and GroupID <> 5433 order by PublishDate desc
Headline-worthy headgear is here care of Jeremy Scott and New Era! This spring, the statement-making designer teams up with the legendary cap company to create faux snakeskin, patent croc, and embroidered leopard versions of the iconic 59Fifty and 9Fifty snapback.
Hat box included while stocks last.
Patent crocodile snapback cap | Adjustable strap | 100% leather | Made in China.