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	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	34.99	0	34.99	7886-DEFAULT-l.jpg	34.99	7886-DEFAULT-m.jpg	ANTLER KING TROPHY CLOVER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	Antler King Trophy Clover	<p>TROPHY CLOVER MIX is a mixture of 4 perennial varieties of clover, a unique variety of chicory and a variety of rapeseed that is Antler King's hardiest and longest lasting perennial mix. Trophy Clover Mix can be planted in the Spring or Fall and provide your deer herd a 30% protein diet during the Spring, Summer and Fall. If you are looking for a food plot to give the deer what they need, when they need it, this is it!</p><p>WHY TROPHY CLOVER MIX? Because it is a hardy perennial, Trophy Clover Mix can last 6 years on a single planting! Offering high protein food sources like those found in Trophy Clover Mix are critical to your herd during Spring, Summer and Fall as protein will provide the driving force behind body, bone and antler growth. More protein=Bigger Bucks and Healthier Deer. The hand selected varieties of Clover and Chicory were chosen specifically because they are highly nutritious, palatable, digestible and attract more deer and turkeys than generic clover varieties. At maturity Trophy Clover Mix can grow 2-3 feet tall and provide up to 10 tons of high protein forage per acre. For best maintenance practice, mow trophy clover down to 6-8"" once it has reached 24"" tall or begins to flower, as flowers indicate maturity. Trophy Clover Mix provides it's highest level of protein, digestibility and nutrition when it is growing, so mowing will increase attraction. The variety of Rapeseed found in Trophy Clover Mix is present as a cover crop to help the small clovers establish themselves in year one (as Trophy Clover can grow roots as long as 24-30""), provide shade during a hot dry Summer and act as late season forage in the first year.</p><p>NUTRITION: Trophy Clover Mix is a very important part of your deer management program because it can provide 30% protein all Spring and Summer to help maximize your herd's potential...bucks, does and fawns all require high levels of protein during the "growing season" to survive and thrive. While the 4 varieties of clover and 1 variety of chicory provide high protein and important minerals for many years they aren't the only plants offering high quality nutrition to your deer herd. The leafy greens in this special rape variety can provide 15-20% protein and as the weather turns cold it will convert it's stored up starches into sweet high energy sugars, triggering maturity and increased consumption in the colder months. The plant varieties in Trophy Clover Mix offer your deer herd a year round food source that will grow and thrive well into the winter months and will green up early in the Spring offering your deer herd the optimum nutrition they need all year long. Trophy Clover Mix should be the foundation of your deer and land management program. We recommend planting 1/2 of your available food plots in a long lasting, high protein perennial like Trophy Clover Mix.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>The highest protein and tonnage producing clover and chicory perennial mix on the market.</li><li>Provides up to 10 tons of 30% forage per acre.</li><li>Great food plot for deer and turkeys.</li><li>Lasts up to 6 years.</li><li>Treated with Antler King's Ultra Coat Orange for higher germination rates and increased forage yield.</li><li>Plant TROPHY CLOVER seeds less than 1/4"" deep.</li><li>Recommended starter fertilizer is 5-10-30 or 9-23-30 or 6-24-24 at 250lbs. per acre. Use 0-0-60 after plot is established.</li><li>pH should be between 6.2-7.0.</li><li>Available in 1/2 acre</li></ul>	[empty string]	N	34.99	34.99	[empty string]	7886-DEFAULT-s.jpg	[empty string]	1000	1000	00003	116642	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-trophy-clover-116642	00003	0
2	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	4.99	0	4.99	7870-DEFAULT-l.jpg	4.99	7870-DEFAULT-m.jpg	ANTLER KING CEREAL RYE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-and-under	0.00	[empty string]	Antler King Cereal Rye	<p>The Antler King brand Cereal Rye can be planted as a stand alone food plot seed or can be mixed with Rape, Turnip, Radish or other barssica species for a Fall hunt plot. Plant only in the Fall.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Protein can be 20% to 25%.</li><li>Ideal pH range 6.0 or higher.</li><li>1 Lb. covers approximately 1/70 acre.</li><li>Plant seeds 1 inch deep.</li><li>Use 19-19-19 fertilizer, or use Antler King PLOT MAX soil conditioner and Antler King JOLT Foliar Fertilizer.</li></ul>	[empty string]	N	4.99	4.99	[empty string]	7870-DEFAULT-s.jpg	[empty string]	1000	1000	AKCR1	116653	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-cereal-rye-116653	AKCR1	0
3	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	29.99	0	34.99	7868-DEFAULT-l.jpg	29.99	7868-DEFAULT-m.jpg	ANTLER KING BLEND	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Antler King Fall/Winter/Spring Food Plot Blend	<p>*Please note change in bag size. Now 17 lbs, plants 1/4 acre.*</p><p>FALL/WINTER/SPRING Blend is comprised of a special variety of winter peas and a unique variety of fall rye. These unique varieties grow extremely fast (can be 6"" tall in only 10 days) and stay green all fall and winter. If you are an avid hunter and are looking for an unbelievable hunt plot, this is it!!</p><p>WHY FALL/WINTER/SPRING? While other plants like oats or clover die or become dormant during the winter, FALL/WINTER/SPRING Blend will continue to grow and be in excess of 20% protein during this time period. Fall/Winter/Spring is unique in that it grows extremely fast, stays green all winter long and can provide a highly nutritious, palatable and digestible diet that can sustain intense graze pressure all Fall and Winter. The special variety of Fall Rye (cereal Rye) is a cool-season plant that stays green and palatable all Winter long. It is easy to plant and can withstand less than ideal soil conditions and still grow well and be extremely attractive to your deer herd. The special variety of winter peas found in Fall/Winter/Spring are a great compliment to the Fall Rye and offer quick germination, fast growth, and highly nutritious forage. Fall/Winter/Spring also offers the ability to be mixed with other Antler King brand seed mixes as it does well in this environment and can be mixed with Honey Hole or Slam Dunk adding even more early and late season attraction!</p><p>NUTRITION: The Winter Peas in Fall/Winter Spring offer a 20-30% protein forage, are very cold tolerant and the entire plant (stem, leaves, pod) will be browsed and eaten by deer. The special variety of Fall Rye will offer a tender green food source with up to 15% protein and stay green all winter long. This combination of cool-season food sources makes Fall/Winter/Spring an extremely important Fall and Winter food plot mix for your deer and an extremely effective Fall and Winter hunt plot, as deer will congregate in this plot.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Unique annual blend that grows fast and stays green all winter long.</li><li>Contains Fall Rye and Winter Peas.</li><li>Unbelievable hunt plot.</li><li>Can be 6-8"" tall in 10 days.</li><li>Plant in fall only.</li><li>Will attract deer September thru January.</li><li>Great source of protein in early Spring to enhance antler development.</li><li>Recommended fertilizer is 19-19-19 or 15-15-15 at 300lbs. per acre.</li><li>pH should be between 5.5-7.0.</li></ul>	[empty string]	N	34.99	34.99	[empty string]	7868-DEFAULT-s.jpg	[empty string]	1000	1000	AKFWS17	116657	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-fall-winter-spring-food-plot-blend-116657	AKFWS17	0
4	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	21.99	0	24.99	7865-DEFAULT-l.jpg	21.99	7865-DEFAULT-m.jpg	ANTLER KING HONEY HOLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Antler King Honey Hole	<p>HONEY HOLE is a mixture of 5 unique varieties of brassicas, which include 3 varieties of rape, and 2 varieties of turnips. This awesome Hunt Plot is an ideal plot for the fall and winter. After the first frost the plants go from bitter to sweet and the deer love them!! Because these plants will thrive with little or no tilling, anyone can create their own "HONEY HOLE."</p><p>WHY HONEY HOLE? Planted in the Spring, Summer or early Fall the plant varieties in Honey Hole will mature in 60-90 days and provide the whole deer family the PERFECT Fall and Winter food source. The plant varieties that make up Honey Hole are easy to use, establish fast and grow quickly...while a 6.0-7.0 pH is preferred Honey Hole can grow in a wide variety of soil conditions and is a little more tolerant to soil acidity than some food plot mixes. Deer will begin to consume the leafy greens as the plants begin to grow and mature, but once the weather turns cold and the plants are impacted by a hard killing frost or multiple hard frosts a molecular change occurs...this dramatic change triggers plant maturity and allows the plants to convert their stored up starches into sweet sugars. This change increases consumption and deer will flock to your Honey Hole plot to consume the sweet tasting sugary plants providing an extremely palatable, highly digestible energy source the deer need for survival. The hand picked plant varieties in Honey Hole make it the best Fall and Winter hunt plot available and is the foundation of any late season food plot and deer management program.</p><p>NUTRITION: Once established the leafy greens in this Brassica mixture will provide 16-22% protein and the bulbs in both turnip varieties slightly less protein. As the weather turns cold and the molecular change helps convert the starch to sugar these Brassicas will provide 4% gross energy (equivalent to corn). The benefit to Honey Hole over corn is that it provides the same amount of highly sought after energy in the Fall and Winter, but is much easier for a ruminant animal like a deer to digest as 60-90% of the turnip plant is digestible. When the weather turns cold deer seek what they need to survive and Honey Hole provides the vital food sources deer seek the most! Create your Honey Hole today!</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Fast growing and easy to establish.</li><li>Cool weather will increase consumption.</li><li>Comprised of 5 varieties of Rape and Turnips.</li><li>For best results plant in late summer or early fall.</li><li>Treated with Antler King's Ultra Coat Orange for higher germination rates and increased forage yield.</li><li>Plant HONEY HOLE less than 1/4"" deep.</li><li>Recommended fertilizer is 19-19-19 or 13-13-13 at 300lbs. per acre.</li><li>pH should be between 5.5-6.5.</li><li>3 lb. Bag Plants 1/2 acre.</li></ul>	[empty string]	N	24.99	24.99	[empty string]	7865-DEFAULT-s.jpg	[empty string]	1000	1000	AKHH3	116661	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-honey-hole-116661	AKHH3	0
5	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	9.99	0	9.99	7890-DEFAULT-l.jpg	9.99	7890-DEFAULT-m.jpg	ANTLER KING KALE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Antler King Kale	<p>This special variety of Antler King brand Kale is a member of the brassica family and is extremely cold tolerant, easy to establish and provides a fantastic cool-season food source for your deer. Kale is packed with protein (20-30%) and vitamins and can produce up to 10 tons of forage per acre. Kale will grow best in cooler climates as the plant's leaves will sweeten as the temps get colder. Like other brassicas, a frost will create a molecular change and further sweeten the leaves and increase attraction. Kale is best planted from July through October and works as a great Fall and Winter forage crop in the Southern US and a Summer, Fall and Winter forage crop in the North, Northeast, and Midwest. Kale prefers lighter soils; sandy, sandy loam or light clay and will perform best in a pH ranging from 5.5-7.0. Kale is a great food source planted on its own or mixed with grains or other brassicas. When planning your food plot program this year, including this special variety of Antler King brand Kale will add more variety and help create a smorgasbord to keep more deer on your property all season long.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>pH tolerant and can grow in pH range 5.5-7.0</li><li>Easy to establish and fast growing</li><li>Drought and weather tolerant</li><li>1 lb. covers approximately 1/8 acre</li><li>15-30% protein depending on soil quality</li><li>Plant seeds 1/8"" or less</li><li>13-13-13 or 19-19-19 at 100-200 lbs. per acre</li></ul>	[empty string]	N	9.99	9.99	[empty string]	7890-DEFAULT-s.jpg	[empty string]	1000	1000	AKK1	116662	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-kale-116662	AKK1	0
6	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	16.99	0	16.99	7866-DEFAULT-l.jpg	16.99	7866-DEFAULT-m.jpg	ANTLER KING NO SWEAT NO TILL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	15-to-20	0.00	[empty string]	Antler King No Sweat No Till Plot Mix	<p>NO SWEAT PLOT MIX is an excellent hunt plot for minimum or no till areas, such as logging roads, shady locations, or areas where you cannot use equipment. NO SWEAT contains the ideal mix of perennial and annual seeds, which have been chosen because they are shade tolerant, easy to establish, fast growing, pH tolerant and deer love them!</p><p>WHY NO SWEAT NO TILL? Finally a no till hunt plot with no fillers that provides protein in the Spring and Summer and Energy in the Fall and Winter. This unique no till hunt plot will come back for 2-3 years and will "sweeten" up your back woods deer stand. The special variety of perennial clover will provide high protein forage all Spring and Summer, keeping deer on your property until hunting season. As the weather turns cool deer will be attracted to the special variety of Oat found in No Sweat, which is extremely soil, weather and cold tolerant and is a superior Fall attractant that is ideal for bow and gun hunting. The variety of Rye will stay green well into the Fall and help sustain intense graze pressure allowing the cold season plants the time to mature for Fall/Winter consumption. When the first frost hits the Brassicas will turn from bitter to sweet, converting the starch to sugar and creating a highly attractive food source that is high in energy.</p><p>NUTRITION: No Sweat provides a versatile food plot option to feed deer the necessary protein and energy they require on a year round basis. The perennial clover will provide 20-30% protein forage all Spring and Summer to benefit body, bone and antler growth, whereas the highly digestible, palatable and nutritious Oats will provide optimum attraction and food during the Fall, allowing the Brassicas to mature. As the weather turns and your first killing frost occurs, a molecular change within the Brassica plants will trigger maturity and in turn convert starch to sugar offering late season energy sources for your resident deer herd. The "smorgasbord" that is No Sweat offers your deer a wide variety of food sources all Spring, Summer, Fall and Winter...it is easy to establish, grows fast and makes it easy to create your very own backwoods hunt plot with no equipment at all!</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Shade tolerant.</li><li>Easy to establish.</li><li>Fast growing.</li><li>pH tolerant.</li><li>Little or no tilling needed.</li><li>Ideal mix of perennials and annuals.</li><li>Contains varieties of oats, rye, clover, canola and more.</li><li>4.5 lb. Bag Plants 1/4 acre.</li></ul>	[empty string]	N	16.99	16.99	[empty string]	7866-DEFAULT-s.jpg	[empty string]	1000	1000	AKNS	116664	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-no-sweat-no-till-plot-mix-116664	AKNS	0
7	[empty string]	ANTLER KING	Antler King	HUNTING	Hunting	[empty string]	1	4.99	0	6.99	7889-DEFAULT-l.jpg	4.99	7889-DEFAULT-m.jpg	ANTLER KING RAPE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5105	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Antler King Rape	<p>The Antler King brand Rape can be planted as a stand alone food plot or planted with virtually any other food plot mix. If you plant Rape in the spring it will become a sought-after food source late in the winter - December through March. For a hunt plot this seed is best planted in July through September.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Ideal pH range is 6.0 to 7.0.</li><li>1 Lb. covers approximately ? acre.</li><li>Plant seeds inch or less deep.</li><li>Use 19-19-19 fertilizer, or use Antler King PLOT MAX soil conditioner and Antler King JOLT Foliar Fertilizer.</li></ul>	[empty string]	N	6.99	6.99	[empty string]	7889-DEFAULT-s.jpg	[empty string]	1000	1000	AKRAPE1	116668	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	antler-king/antler-king-rape-116668	AKRAPE1	0
8	[empty string]	PRIMOS INC	Primos Inc	HUNTING	Hunting	[empty string]	1	49.99	0	49.99	12226-DEFAULT-l.jpg	49.99	12226-DEFAULT-m.jpg	PRIMOS HENSANITY	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	245	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Primos Hensanity Turkey Pot - Call, Hardwood Pot	<p>Primos 00299 Hensanity Turkey Pot - Call, Hardwood Pot, Premium Striker</p>	[empty string]	N	49.99	49.99	[empty string]	12226-DEFAULT-s.jpg	[empty string]	1000	1000	00299	233330	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	primos-inc/primos-hensanity-turkey-pot-call-hardwood-pot-233330	00299	0
9	[empty string]	PRIMOS INC	Primos Inc	HUNTING	Hunting	[empty string]	1	9.99	0	9.99	4617-DEFAULT-l.jpg	9.99	4617-DEFAULT-m.jpg	PRIMOS DEER BLEAT AND BAWL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	245	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Primos Deer Bleat And Bawl	<p>Hunters just cannot believe how the bawl brings does charging in during the early season. This call also reproduces a short bleat and Estrus bleat, perfect for all season hunting when you're after that big buck.</p><ul><li>Great for Early Season Bow Hunting</li></ul>	[empty string]	N	9.99	9.99	[empty string]	4617-DEFAULT-s.jpg	[empty string]	1000	1000	00702	233332	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	primos-inc/primos-deer-bleat-and-bawl-233332	00702	0
10	[empty string]	PRIMOS INC	Primos Inc	HUNTING	Hunting	[empty string]	1	24.99	0	24.99	4616-DEFAULT-l.jpg	24.99	4616-DEFAULT-m.jpg	PRIMOS HARDWOOD FAWN BLEAT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	245	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Primos 721 Hardwood Fawn Bleat	<p>The Hardwood Fawn Bleat is the "original" call introduced in 1986 which started the craze of calling doe. It is perfect for the early bow season, reproduces the distress bleat and bawl of a young deer; thus, appealing to the maternal instinct of all doe.</p><p><strong>Attributes</strong></p><ul><li><strong>Type:</strong> Bleat Call</li><li><strong>Species:</strong> Deer</li><li><strong>Material:</strong> Hardwood</li><li><strong>Sound Species:</strong> Fawn</li><li><strong>Electronic:</strong> No</li><li><strong>Battery:</strong> N/A</li><li><strong>Color:</strong> Brown</li><li><strong>Style:</strong> Hand</li><li><strong>Preset Features:</strong> N/A</li><li><strong>Hands Free:</strong> No</li><li><strong>Manufacturer Part Number:</strong> 721 </li></ul>	[empty string]	N	24.99	24.99	[empty string]	4616-DEFAULT-s.jpg	[empty string]	1000	1000	00721	233333	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	primos-inc/primos-721-hardwood-fawn-bleat-233333	00721	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 ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Hunting
2	%antler%king%
3	%turtlebox%
4	%halo%nocks%
5	%rolling%thunder%
6	%b%square%company%
7	%primos%inc%

Filter By

Sort By

Item # 00721 $24.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Antler King Trophy Clover

Antler King Cereal Rye

Antler King Fall/Winter/Spring Food Plot Blend

Antler King Honey Hole

Antler King Kale

Antler King No Sweat No Till Plot Mix

Antler King Rape

Primos Hensanity Turkey Pot - Call, Hardwood Pot

Primos Deer Bleat And Bawl

Primos 721 Hardwood Fawn Bleat

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Antler King Trophy Clover

Antler King Cereal Rye

Antler King Fall/Winter/Spring Food Plot Blend

Antler King Honey Hole

Antler King Kale

Antler King No Sweat No Till Plot Mix

Antler King Rape

Primos Hensanity Turkey Pot - Call, Hardwood Pot

Primos Deer Bleat And Bawl

Primos 721 Hardwood Fawn Bleat