Simmons' Sporting Goods

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	BLADES	AVIAN X	Avian X	HUNTING	Hunting	BLADES\|NULL\|NULL	1	399.99	0	399.99	24083-DEFAULT-l.jpg	399.99	24083-DEFAULT-m.jpg	AVIAN X A FRAME BLIND	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	350-to-400	0.00	[empty string]	Avian X A-Frame Blind \| Mossy Oak Shadow Grass Blades	<p>Redefining field mobility and portability, the Avian-X A-Frame Blind offers the next best thing to total invisibility in marshes, fence lines, waterways, and even open fields. Don't waste time searching for cover; take it with you. The A-Frame Blind features a non-corrosive aluminum modular frame complemented by a rugged 900-Denier Mossy Oak Shadow Grass Blades shell. Grass straps and pockets incorporated into the blind's outer cover allow for quick, easy, and complete concealment using natural vegetation, while the A-Frame design eliminates those bird-flaring hard edges and shadows so common with other blinds. Measuring 96L X 60W X 48T and weighing 26 pounds, the A-Frame can easily accommodate four hunters, yet sets up in mere minutes. The A-Frame blind comes complete with four adjustable gun clips and EZ-Carry webbing strap, which makes packing A-Frame into the field a cinch.</p><p> </p>	[empty string]	N	399.99	399.99	[empty string]	24083-DEFAULT-s.jpg	[empty string]	1000	1000	67001	166187	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-a-frame-blind-mossy-oak-shadow-grass-blades-166187	67001	0
2	[empty string]	AVIAN X	Avian X	HUNTING	Hunting	[empty string]	1	124.99	1	109.99	8407-DEFAULT-l.jpg	124.99	8407-DEFAULT-m.jpg	AVIAN X TOP FLIGHT MALLARDS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Avian X Top Flight Fusion \| Mallards	<p>No two mallards are alike in nature, and they aren't in this fusion pack either. Six unique postures create a spot-on depiction of the natural behavior of mallards over water. Ultra-realistic paint schemes combine with the ultimate in paint adhesion and durability for the final word in floating mallard decoys. All Topflight decoys feature an innovative weight-forward swim keel. Simply snap the line through the swim clip to give decoys natural motion on the water.</p><p><strong>FEATURES</strong></p><ul><li>Perfect replication of mature mallards</li><li>Weight-forward swim keel for realistic movement</li><li>Unmatched coloration and detail</li><li>Rugged durability</li><li>No-flake paint for lasting finish</li><li>6 true-to-life postures - surface feeder hen; surface feeder drake; swimmer hen; low-head drake; high-head hen; high-head drake</li></ul><p> </p>	[empty string]	Y	109.99	109.99	[empty string]	8407-DEFAULT-s.jpg	[empty string]	1000	1000	8076	166188	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-top-flight-fusion-mallards-166188	8076	0
3	PINTAIL	AVIAN X	Avian X	HUNTING	Hunting	PINTAIL\|NULL\|NULL	1	89.99	0	109.99	143-DEFAULT-l.jpg	89.99	143-DEFAULT-m.jpg	AVIAN X TOP FLIGHT PINTAIL	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	100-to-150	0.00	[empty string]	Avian X Top Flight Pintails	<p>Avian-X presents their newest series of true, custom-style painted Pintail decoys. If you are looking for the best Pintails on the market, look no further. The incredible realism and paint schemes make these decoys a work of art. Couple that with the advanced rubberized molding material and non-chip paint and you have the best of the best. The Avian-X Topflight Pintails are available in 6 packs that include 4 drakes (2 feeders and 2 low-heads) and 2 low-head hens. All Topflight Series decoys feature the innovative weight-forward swim keel design; simply snap the line through the swim clip creating a natural motion to the decoys, whether in current or in the slightest breeze. Decoys are slightly over-sized measuring 17" breast to tail. Sold in 6 packs.</p><p><strong>FEATURES</strong></p><ul><li>Perfect replication of mature pintails</li><li>Weight-forward swim keel for realistic movement</li><li>3 true-to-life postures</li><li>Unmatched coloration and detail</li><li>Rugged durability</li><li>No-flake paint for lasting finish</li></ul><p> </p>	[empty string]	N	109.99	109.99	6_PACK	143-DEFAULT-s.jpg	[empty string]	1000	1000	AVIAN-8082	166189	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-top-flight-pintails-166189	AVIAN-8082	0
4	JAKE_QUARTER_STRUT	AVIAN X	Avian X	HUNTING	Hunting	JAKE_QUARTER_STRUT\|NULL\|NULL	1	119.99	0	119.99	19456-DEFAULT-l.jpg	119.99	19456-DEFAULT-m.jpg	AVIAN X TOM/JAKE TURKEY DECOY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	14	100-to-150	0.00	[empty string]	Avian-X Tom and Jake Turkey Decoys	<p><strong>LCD Quarter-Strut Jake</strong> - Give them something to pick on with the LCD Quarter-Strut Jake. This guy's non-aggressive pose makes him attractive to both dominant and sub-dominant gobblers, while his size - 15 percent smaller than a real jake - keeps him non-threatening and portable. Crafted from rugged dura-rubber, the Quarter-Strut Jake easily fits in a turkey vest, and won't crease or dent like other folding decoys. Pair with the LCD Laydown Hen to mimic a breeding pair that will drive longbeards absolutely wild.</p><ul><li>Avian-X's original jake decoy</li><li>Non-aggressive and non-dominant</li><li>Easy target for gobblers to pick on</li><li>Lifelike Collapsible Decoy (LCD)</li><li>Easy transport and storage</li><li>15% smaller than a real turkey</li><li>Includes pre-attached beard</li><li>PVC dura-rubber quiets movements</li><li>Realistic movement without unnatural spin</li></ul><p> </p><p><strong>Trophy Tom</strong> - Turn your gobbler into a taxidermy-style showpiece with the Trophy Tom. The one-piece design easily holds a dried tail fan and beard surrounded by detailed carvings and ultra-realistic paint. It's a great way for turkey hunters to relive memories over and over again. (And maybe have an excuse to do a little bragging.) The Trophy Tom also includes a mounting stake and handle to double as a 2D strutting-style decoy in the field.</p><ul><li>Showpiece for tail fan and beard</li><li>Great way to capture memories</li><li>Heavy-duty clip easily holds tail fan</li><li>Includes instructions on tail fan prep</li><li>Doubles as 2D decoy</li></ul><p> </p><p><strong>HDR Jake</strong> - Introducing the Heavy-Duty Realism (HDR) line of turkey decoys. Blow-molded into reality from hand-carved designs, these decoys harness unbeatable detail and durability.The HDR jake is sized slightly smaller than a real turkey, but just big enough that he'll make a tempting target. His quarter-strut posture and subdominant feathers signal he's content but ready to fight if an opportunity presents itself. Choose from two included removable head designs - one with a curled, aggressive posture, the other straight and submissive. Pair with any Avian-X hen for a completely customized setup, and you'll paint a picture that'll draw in every boss gobbler for miles.</p><p> </p><ul><li>Quarter-Strut Jake Decoy</li><li>2 Removable Heads</li><li>Carbon Stake</li><li>Carry Bag</li><li>Durable blow-molded design for many seasons of use</li><li>Relaxed quarter-strut body posture</li><li>Rubber molded leg stumps with authentic spur detail</li><li>Customize setups with two removable head designs</li><li>Includes aggressive and submissive head postures</li><li>Pre-attached synthetic beard</li><li>True-to-life paint scheme and feather detail</li><li>Storage for mounting stake in tail</li><li>Pairs well with any hen to mimic breeding pair</li><li>Includes mounting stake for quick setup</li><li>Realistic movement without unnatural spin</li></ul><p> </p><p><strong>Half-Strut Jake</strong> - The LCD Half-Strut Jake tells the tragic tale of a young gobbler living dangerously outside the pecking order. His sub-dominant head and relaxed feather positioning show he's fearless in his pursuit to establish dominance. Not to be tested, wild gobblers will be all too willing to teach him a swift lesson. This decoy is especially good for the early season when turkeys are working through the pecking order. Combine with your favorite LCD hens and watch a tragedy unfold.</p><ul><li>Sub-dominant posture tests dominant gobblers</li><li>Relaxed wings and sub-dominant head</li><li>Lifelike Collapsible Decoy (LCD)</li><li>Easy transport and storage</li><li>15% smaller than a real turkey</li><li>Unmatched realism and detail</li><li>Includes pre-attached beard</li><li>PVC dura-rubber quiets movements</li><li>Great for early season</li><li>Realistic movement without unnatural spin</li></ul>	[empty string]	N	119.99	119.99	[empty string]	19456-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8003	166192	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-tom-and-jake-turkey-decoys-166192	AVX8003	0
5	LOOKOUT_HEN	AVIAN X	Avian X	HUNTING	Hunting	LOOKOUT_HEN\|NULL\|NULL	1	99.99	0	99.99	13679-DEFAULT-l.jpg	99.99	13679-DEFAULT-m.jpg	AVIAN X LOOKOUT TURKEY DECOY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	50-to-100	0.00	[empty string]	Avian X LCD Lookout Hen	<p>The LCD Lookout Hen has a similar look and effect as the popular Breeder Hen, but she's got a little something extra. The Lookout's raised height aids visibility so passing gobblers can spot her even in tall grass and dense vegetation. She features the same attention to detail and authentic paint scheme you expect from Avian-X, and the Lifelike Collapsible Decoy design you need for easy setups and transport.</p><ul><li>- Similar effect as breeder posture</li><li>- Added height for improved visibility</li><li>- Lifelike Collapsible Decoy (LCD)</li><li>- Easy transport and storage</li><li>- 15% smaller than a real turkey</li><li>- Unmatched realism and detail</li><li>- Mimics natural reflection of real hen feathers</li><li>- PVC dura-rubber quiets movements</li><li>- Realistic movement without unnatural spin</li></ul>	[empty string]	N	99.99	99.99	[empty string]	13679-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8006	166193	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-lcd-lookout-hen-166193	AVX8006	0
6	FEEDER_HEN	AVIAN X	Avian X	HUNTING	Hunting	FEEDER_HEN\|NULL\|NULL	1	99.99	0	99.99	13680-DEFAULT-l.jpg	99.99	13680-DEFAULT-m.jpg	AVIAN X FEEDER TURKEY DECOY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	66	50-to-100	0.00	[empty string]	Avian X LCD Feeder Hen	<p>The LCD Feeder Hen draws gobblers in close to set up the perfect kill shot. Typically, a hen will notice a gobbler's advances and approach, signaling she's ready to breed. So if a longbeard's gobbles go ignored, he'll assume she didn't hear or see him - and he'll move closer to make sure she does. As he gets closer, the LCD Feeder's ultra-detailed paint schemes with true-to-life reflective feathers will pull him even deeper under her spell. This little lady will surprise you with what she's able to accomplish during her morning snack.</p><p><strong>Includes:</strong></p><ul><li>-Feeder Hen Decoy</li><li>-Storage Compression Strap</li><li>-Carry Bag</li><li>-Collapsible Carbon Stake</li></ul><p><strong>Features:</strong></p><ul><li>-Relaxed, content position</li><li>-Draws gobblers in close</li><li>-Lifelike Collapsible Decoy (LCD)</li><li>-Easy transport and storage</li><li>-15% smaller than a real turkey</li><li>-Unmatched realism and detail</li><li>-Mimics natural reflection of real hen feathers</li><li>-PVC dura-rubber quiets movements</li><li>-Realistic movement without unnatural spin</li></ul><p> </p>	[empty string]	N	99.99	99.99	[empty string]	13680-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8007	166194	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-lcd-feeder-hen-166194	AVX8007	0
7	BREEDER_HEN	AVIAN X	Avian X	HUNTING	Hunting	BREEDER_HEN\|NULL\|NULL	1	89.99	0	99.99	13681-DEFAULT-l.jpg	89.99	13681-DEFAULT-m.jpg	AVIAN X BREEDER TURKEY DECOY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	58	50-to-100	0.00	[empty string]	Avian X LCD Breeder Hen	<p>Avian-X has spent countless hours designing and developing the ultimate turkey decoy, one to replace its own industry leading LCD Hen. The new Lifelike Collapsible Decoy (LCD) designs incorporate the highest quality feather detail ever created in the decoy world and has refined the true-to-life paint scheme to match the natural reflective feathers of a real hen. All of these features are packed into a decoy 15% smaller than the original LCD, making the decoy lighter, easier to pack and less dominant and aggressive to real hens. Three unique decoy postures give the hunter flexibility to choose the correct posture for any situation; this was developed through years of studying body postures, moods, and behaviors of wild turkeys. Combine all of this and that is what you get when you put an Avian-X decoy in with your turkey gear.<br />felike Collapsible Decoy with incredible detail and no-flake paint. Made from Dura-Rubber for years of use without creasing or denting. One piece folding stake gives the decoy realistic movement without spinning. Breeder hen in a receptive posture stimulates the mating desire of incoming Jakes and Toms.</p><ul><li>Item Package Dimensions L x W x H (11.57 x 11.5 x 5.28 inches)</li><li>Package Weight 1.52 Kilograms</li><li>Item Dimensions LxWxH (1 x 1 x 1 inches)</li><li>Item Weight 15.8 Ounces</li><li>Brand Name Avian-X</li><li>Model Name AVX-AVX8008</li><li>Color - Multi</li><li>Material - Blend</li><li>Suggested Users - unisex-adult</li><li>Number of Items - 1</li><li>Manufacturer AvianX</li><li>Part Number 8008</li><li>Model Year 2015</li><li>Included Components LCD BREEDER HEN DECOY</li><li>Size - One Size</li><li>Sport Type - Hunting</li></ul><p><strong>FEATURES</strong></p><ul><li>15% smaller than the originals</li><li>True body position</li><li>Incredible feather detailing</li><li>Revolutionary no flake paint</li><li>Crafted from rugged Dura-Rubber</li><li>Folds and fits easily into a vest</li><li>Won't crease or dent</li><li>Natural movement</li></ul><p> </p>	[empty string]	N	99.99	99.99	[empty string]	13681-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8008	166195	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-lcd-breeder-hen-166195	AVX8008	0
8	LAYDOWN_HEN	AVIAN X	Avian X	HUNTING	Hunting	LAYDOWN_HEN\|NULL\|NULL	1	89.99	0	99.99	13682-DEFAULT-l.jpg	89.99	13682-DEFAULT-m.jpg	AVIAN X LAYOUT TURKEY DECOY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	113	50-to-100	0.00	[empty string]	Avian X LCD Layout Hen	<p>Avian-X Turkey decoys are designed for the ultimate in turkey attraction, while still being hunter friendly. The design in every pose is not just your average look-a-like. From the detailed feather lines and feather positions, to the correct, relaxed wing position with each body pose and head position, Avian-X Lifelike Collapsible Decoy (LCD) decoys are designed to be completely collapsible with an advanced dura-rubber material, and come with a drawstring carrying bag. The body, head and wing positions of the Laydown Hen simulate the true breeding position of a hen turkey. She is squatting for the mating ritual and displaying to incoming gobblers that she is 100% receptive. Along with the breeding ritual, this pose can double for those great midmorning setups simulating a dusting hen. The Laydown Hen is just another way to simulate the most realistic poses and tell the whole story in your turkey decoys.</p><p><strong>FEATURES</strong></p><ul><li>Most realistic and effective turkey decoy</li><li>Incredible feather detailing</li><li>Quickly deflate and fold down for transporting</li><li>Collapsible stake for swiveling in the breeze</li></ul><p> </p>	[empty string]	N	99.99	99.99	[empty string]	13682-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8011	166196	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-lcd-layout-hen-166196	AVX8011	0
9	1_2_STRUT_JAKE	AVIAN X	Avian X	HUNTING	Hunting	1_2_STRUT_JAKE\|NULL\|NULL	1	149.99	0	149.99	990-DEFAULT-l.jpg	149.99	990-DEFAULT-m.jpg	AVIAN X TOM/JAKE TURKEY DECOY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	31	100-to-150	0.00	[empty string]	Avian-X Tom and Jake Turkey Decoys	<p><strong>LCD Quarter-Strut Jake</strong> - Give them something to pick on with the LCD Quarter-Strut Jake. This guy's non-aggressive pose makes him attractive to both dominant and sub-dominant gobblers, while his size - 15 percent smaller than a real jake - keeps him non-threatening and portable. Crafted from rugged dura-rubber, the Quarter-Strut Jake easily fits in a turkey vest, and won't crease or dent like other folding decoys. Pair with the LCD Laydown Hen to mimic a breeding pair that will drive longbeards absolutely wild.</p><ul><li>Avian-X's original jake decoy</li><li>Non-aggressive and non-dominant</li><li>Easy target for gobblers to pick on</li><li>Lifelike Collapsible Decoy (LCD)</li><li>Easy transport and storage</li><li>15% smaller than a real turkey</li><li>Includes pre-attached beard</li><li>PVC dura-rubber quiets movements</li><li>Realistic movement without unnatural spin</li></ul><p> </p><p><strong>Trophy Tom</strong> - Turn your gobbler into a taxidermy-style showpiece with the Trophy Tom. The one-piece design easily holds a dried tail fan and beard surrounded by detailed carvings and ultra-realistic paint. It's a great way for turkey hunters to relive memories over and over again. (And maybe have an excuse to do a little bragging.) The Trophy Tom also includes a mounting stake and handle to double as a 2D strutting-style decoy in the field.</p><ul><li>Showpiece for tail fan and beard</li><li>Great way to capture memories</li><li>Heavy-duty clip easily holds tail fan</li><li>Includes instructions on tail fan prep</li><li>Doubles as 2D decoy</li></ul><p> </p><p><strong>HDR Jake</strong> - Introducing the Heavy-Duty Realism (HDR) line of turkey decoys. Blow-molded into reality from hand-carved designs, these decoys harness unbeatable detail and durability.The HDR jake is sized slightly smaller than a real turkey, but just big enough that he'll make a tempting target. His quarter-strut posture and subdominant feathers signal he's content but ready to fight if an opportunity presents itself. Choose from two included removable head designs - one with a curled, aggressive posture, the other straight and submissive. Pair with any Avian-X hen for a completely customized setup, and you'll paint a picture that'll draw in every boss gobbler for miles.</p><p> </p><ul><li>Quarter-Strut Jake Decoy</li><li>2 Removable Heads</li><li>Carbon Stake</li><li>Carry Bag</li><li>Durable blow-molded design for many seasons of use</li><li>Relaxed quarter-strut body posture</li><li>Rubber molded leg stumps with authentic spur detail</li><li>Customize setups with two removable head designs</li><li>Includes aggressive and submissive head postures</li><li>Pre-attached synthetic beard</li><li>True-to-life paint scheme and feather detail</li><li>Storage for mounting stake in tail</li><li>Pairs well with any hen to mimic breeding pair</li><li>Includes mounting stake for quick setup</li><li>Realistic movement without unnatural spin</li></ul><p> </p><p><strong>Half-Strut Jake</strong> - The LCD Half-Strut Jake tells the tragic tale of a young gobbler living dangerously outside the pecking order. His sub-dominant head and relaxed feather positioning show he's fearless in his pursuit to establish dominance. Not to be tested, wild gobblers will be all too willing to teach him a swift lesson. This decoy is especially good for the early season when turkeys are working through the pecking order. Combine with your favorite LCD hens and watch a tragedy unfold.</p><ul><li>Sub-dominant posture tests dominant gobblers</li><li>Relaxed wings and sub-dominant head</li><li>Lifelike Collapsible Decoy (LCD)</li><li>Easy transport and storage</li><li>15% smaller than a real turkey</li><li>Unmatched realism and detail</li><li>Includes pre-attached beard</li><li>PVC dura-rubber quiets movements</li><li>Great for early season</li><li>Realistic movement without unnatural spin</li></ul>	[empty string]	N	149.99	149.99	[empty string]	990-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8012	166197	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-tom-and-jake-turkey-decoys-166197	AVX8012	0
10	OPEN_WATER	AVIAN X	Avian X	HUNTING	Hunting	OPEN_WATER\|NULL\|NULL	1	129.99	1	99.99	142-DEFAULT-l.jpg	129.99	142-DEFAULT-m.jpg	AVIAN X TOP FLIGHT MALLARDS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	Avian-X Top Flight Mallards	<p><strong>BACKWATER</strong></p><p>This backwater pack includes several unique feeding postures true to the natural dabbling behavior of mallards in shallow water. Ultra-realistic paint schemes combine with the ultimate in paint adhesion and durability for the final word in floating mallard decoys. All Topflight decoys feature an innovative weight-forward swim keel. Simply snap the line through the swim clip to give decoys natural motion on the water.</p><p><strong>LATE SEASON</strong></p><p>This level of detail is something you can only find at Avian-X. Our late season pack accurately captures the late plumage of hens and drake mallards. Ultra-realistic paint schemes combine with the ultimate in paint adhesion and durability for the final word in floating mallard decoys. All Topflight decoys feature an innovative weight-forward swim keel. Simply snap the line through the swim clip to give decoys natural motion on the water.</p><p><strong>OPEN WATER</strong></p><p>Brutal open water conditions are no problem for these mallards. A combination of high-head and low-head postures authentically replicate the natural behavior of active mallards. Ultra-realistic paint schemes combine with the ultimate in paint adhesion and durability for the final word in floating mallard decoys. All Topflight decoys feature an innovative weight-forward swim keel. Simply snap the line through the swim clip to give decoys natural motion on the water.</p><p><strong>OVERSIZED</strong></p><p>This oversized pack includes both high-heads and low-heads that are 30% larger than standard Avian-X mallard decoys. These 17-inch birds stand out with a larger footprint that'll turn high-flying greenheads. Ultra-realistic paint schemes combine with the ultimate in paint adhesion and durability for the final word in floating mallard decoys. All Topflight decoys feature an innovative weight-forward swim keel. Simply snap the line through the swim clip to give decoys natural motion on the water</p>	[empty string]	Y	99.99	99.99	6_PACK	142-DEFAULT-s.jpg	[empty string]	1000	1000	AVX8060	166201	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	avian-x/avian-x-top-flight-mallards-166201	AVX8060	0

CACHED

false

EXECUTIONTIME

SQL

SELECT top 10 style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS