• Lightning to USB-C Cable
  • MagBuddy Wireless Collection
  • SmartPack
  • Elite Series Cable
  • HyperGear Wireless Charging Dock
  • Ultimate Power Station

 

cannot run query SELECT TOP 50 Inv.PRS_TYPE,Inv.RG_0,Inv.RG_1,Inv.RG_2,Inv.RG_3,Inv.RG_4,Inv.RG_5,Inv.RG_6, Inv.PRICE_1,Inv.PRICE_2,Inv.PRICE_3,Inv.PRICE_4,Inv.PRICE_5,Inv.PRICE_6,Inv.RETAIL_PRS,Inv.CORP_PRS,Inv.WHOLE_PRS,Inv.CREATE_DT,Inv.WHOLE_PRS2,Inv.WHOLE_PRS3,WebInv.BRANDID,WebInv.SmallPic,WebInv.ShortDescription,WebInv.Title,WebInv.PROD_CD FROM WebInv JOIN WebInvExt ON WebInv.PROD_CD=WebInvExt.PROD_CD JOIN inv ON WebInv.PROD_CD=Inv.PROD_CD WHERE (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInv.PROD_CD LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInv.ShortDescription LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInv.Title LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.Title LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.description LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.keywords LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.og_title LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.og_description LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.dcterms_title LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.twitter_description LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.parselytags LIKE '%elite%') OR (WebInv.Active=1) AND (WebInv.BRANDID=∏ucttype=) AND (WebInvExt.Short_description LIKE '%elite%') ORDER BY WebInv.PROD_CD
Item No. Title/Description Brand Price Add to Cart