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=1058 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1756 and productid=cache_Products.productid) order by PublishDate desc
Mohzy's USB bracelets are like accessories from the future. They're what TV producers in the 60s imagined we'd wear in the year 2020. Power and sync up your devices on the go with a micro USB cable patterned with custom OC prints. Sized for iPhone 5, the bracelets come with an adapter to fit a range of different devices.
Note: Not compatible with iPhone 5s.
Printed wristband with USB magnet closure I USB Apple dock connector adapter I Micro USB cable I Made in Taiwan.