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=1607 and productid=cache_Products.productid) and ( ( [Keywords] like '%cat%' ) or productname like '%cat%' or productID in (select distinct ProductID from msS_Index where TypeID in (select TypeID from mss_Types where TypeName like '%cat%' or Remark='cat'))) and GroupID <> 5433 order by PublishDate desc
Covernat's key chains are a little bit creepy and a lot cute! The Korean brand makes everything from trousers to trinkets and specializes in surprising details. We couldn't say no to their multicolor mushrooms, skulls, and cats. Look out for oozing brains and eerie hidden faces!