query
RESULTSET
query
  ATTR1LIST BRAND BRANDDISPLAY DEPT DEPTTREE FAMLIST HASIMAGE INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE LARGEPICTURE LISTPRICE MEDIUMPICTURE NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 OVERALLQOH PRICERANGE PRODREVIEWSAVERAGE RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SIZELIST SMALLPICTURE SOLD SORTPOSITION SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TYP URL WEBSTYLE WEIGHTED_SEARCH
1 NATURAL NATURAL GEAR Natural Gear HUNTING Hunting NATURAL|NULL|NULL 1 29.99 0 59.99 257-DEFAULT-l.jpg 29.99 257-DEFAULT-m.jpg NATURAL GEAR MNS STORM WFOWL G N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 465 .NATURALGEARSTORMWATERFOWLG [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 9 50-to-100 0.00 [empty string] Natural Gear Storm Waterfowl Gloves <p>Every hunter knows how vital it is to keep your hands warm. No matter what type of prey you're stalking keeping your hands warm and dry is paramount for being ready to take that perfect shot. This insulated hunting glove will keep your hands toasty warm and is constructed of a durable 600D Hard Shell Material that won't wear out after putting it to the test over the course of a few hunts. This technical hunting glove is also waterproof, keeping your hands dry, even in the dampest conditions. The Grip palm and Insulation add another layer of durability while maintaining flexibility when it's crucial to make your shot quickly. These camo hunting gloves have Cinch Strap wrist closures ensure a snug fit to retain heat. Whether you're up against, water, snow, or ice the Natural Gear Insulated Waterfowl Glove will keep your hands warm and mobile, all you need to do is focus on the hunt.</p><ul><li>600D Hard Shell Material</li><li>Waterproof</li><li>Windproof</li><li>Flexible Grip Palm</li><li>Fixed Insulation</li><li>Cinch Strap Wrist</li><li>Draw Cord Closure</li></ul> [empty string] N 59.99 59.99 L,XL,2X 257-DEFAULT-s.jpg [empty string] 1000 1000 820 76215 EMPTY EMPTY EMPTY 0 0 0 EMPTY natural-gear/natural-gear-storm-waterfowl-gloves-76215 820 0
2 [empty string] BURR PAW Burr Paw HUNTING Hunting [empty string] 1 29.99 0 29.99 28586-DEFAULT-l.jpg 29.99 28586-DEFAULT-m.jpg BURR PAW STICKER REMOVER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6124 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 17 25-to-50 0.00 [empty string] Burr Paw Sticker Remover <p>Your Burr Paw Sticker/Burr Removal Tool is non-abrasive, meaning it will not damage clothing or skin. The puncture-resistant liner provides an extra layer of protection during use. Easy to maintain - after rubbing the affected area, use the cleaning card included to scrape larger stickers off the mitten. Reusable in the field or at home to keep gear, pets, and clothing clean. Gift idea - for any man or woman in your life interested in hunting, fishing, climbing, hiking, shooting, farming, ranching, ATV riding, bird watching, or conservation.</p><p><br /><strong>Specifications</strong></p><ul><li>SIMPLE BURR REMOVAL - The Burr Paw burr removal accessory tool is an easy fix for removing burrs from clothing</li><li>KEEP GEAR CLEAN - No more burrs covering your clothing, your hunting gear, or your pets fur</li><li>NON-ABRASIVE - Your Burr Paw sticker/burr removal tool is non-abrasive</li><li>GIFT IDEA - Gift idea for any man or woman in your life interested in hunting</li><li>EASY TO MAINTAIN - After rubbing the affected area, use the cleaning card included to scrape larger stickers off the mitten</li></ul> [empty string] N 29.99 29.99 [empty string] 28586-DEFAULT-s.jpg [empty string] 1000 1000 79830418799 227344 EMPTY EMPTY EMPTY 0 0 0 EMPTY burr-paw/burr-paw-sticker-remover-227344 79830418799 0
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc