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]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	24.99	0	24.99	13688-DEFAULT-l.jpg	24.99	13688-DEFAULT-m.jpg	LUX PRO LP1044 FLASHLIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	20-to-25	0.00	[empty string]	Lux Pro Flashlight \| LP1044	<p>The LUXPRO rechargeable focusing LED penlight flashlight is extremely lightweight and compact. This flashlight is made durable with aircraft-grade aluminum and comes equipped with a quality pocket clip so you can attach it to your tool bag or pocket. The flashlight features a tactical on/off button to select between high and low mode. The output range on high is 360 lumens and on low is 50 lumens. It has a runtime of 1.5 hours on high and 7 hours on low. This light comes with a rechargeable 10850 3.7V 750mAh lithium-ion battery that charges in approximately 3 hours, and it can alternatively run on 2 AAA batteries. Included is a USB-C cable for convenient charging. The charging indicator light next to the charging port will turn red to indicate that the light is charging, and blue when it is fully charged. For additional peace of mind, this rechargeable tactical light comes with a Limited Warranty against Manufacturer's Defects.</p><ul><li>Durable aircraft-grade aluminum construction</li><li>- Dual power option </li><li>- O-ring sealed, weather-resistant</li><li>- 360-lumen output on high mode </li><li>- High quality pocket clip for easy portability</li><li>- LPE Optics, flood to spot focus beam</li><li>- IPX4 water-resistant rating</li><li>Lumens: 360 -50</li><li>Run Time: 1.5h - 7h</li><li>Beam Distance: 70m - 22m</li><li>Battery Count/Size: 10850 3.7V 750mAh or 2 AAA</li><li>Width: 0.625 in</li><li>Height: 6.125 in</li><li>Weight: 0.14 lb</li></ul><p> </p>	[empty string]	N	24.99	24.99	[empty string]	13688-DEFAULT-s.jpg	[empty string]	1000	1000	871553	156909	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/lux-pro-flashlight-lp1044-156909	871553	0
2	[empty string]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	14.99	0	14.99	24106-DEFAULT-l.jpg	14.99	24106-DEFAULT-m.jpg	LUX PRO LP1042 FLASHLIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	24	10-to-15	0.00	[empty string]	Lux Pro 140 Lumen LED Penlight Flashlight with Pocket Clip	<p>The LUXPRO penlight 140 lumen LED flashlight with a pocket clip is extremely lightweight and compact. This flashlight features a tactical on/off button to select between high and low mode. The output range on high is 140 lumens and on low is 50 lumens. It has a run time of 45 minutes on high and 1.25 hours on low. This flashlight is made durable with aircraft-grade aluminum and comes equipped with a quality pocket clip so you can attach it to your tool bag or pocket. It conveniently runs on and includes 2 AAA batteries.</p><p><strong>Features:</strong></p><ul><li>- 140-lumen output on high mode</li><li>- Quality pocket clip for easy portability</li><li>- Aircraft-grade aluminum</li><li>- Knurling metal handle</li><li>- Run time of 45 minutes -1.25 hours</li><li>- IPX4 waterproof rating</li><li>- Limited manufacturer's warranty </li></ul><p><strong>Technical Specs:</strong></p><ul><li>Lumens: 140 - 50</li><li>Run Time: 0.75h - 1.25h</li><li>Beam Distance: 65m - 35m</li><li>Battery Count/Size: 2 AAA</li><li>Width: 0.55 in</li><li>Height: 5.8 in</li><li>Weight: 0.11 lb</li></ul>	[empty string]	N	14.99	14.99	[empty string]	24106-DEFAULT-s.jpg	[empty string]	1000	1000	LP1042	156913	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/lux-pro-140-lumen-led-penlight-flashlight-with-pocket-clip-156913	LP1042	0
3	[empty string]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	44.99	0	49.99	13687-DEFAULT-l.jpg	44.99	13687-DEFAULT-m.jpg	LUX PRO LP1530 LANTERN/SPEAKER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Lux Pro Lantern/Speaker	<ul><li>- Rechargeable battery built-in</li><li>- Bluetooth speaker & controls</li><li>- 360 LEDs for continuous and even light</li><li>- Power bank to charge portable devices</li><li>- Variable mode dial</li><li>- IPX4 weather-resistant</li><li>- Rubberized metal handle</li><li>- USB-C charging cable included</li></ul><p><strong>Technical Specs:</strong></p><ul><li>LED: 360 Broadbeam LED</li><li>Lumens: 37 - 572 </li><li>Run Time: 29h 45m - 3h 45m</li><li>Beam Distance: 6m - 25m</li><li>Battery Count/Size: 4000mAh 3.7V Li-on built-in</li><li>Width: 4.25 in</li><li>Height: 6.50 in</li><li>Weight: 1.05 lb</li></ul>	[empty string]	N	49.99	49.99	[empty string]	13687-DEFAULT-s.jpg	[empty string]	1000	1000	LP1530	156917	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/lux-pro-lantern-speaker-156917	LP1530	0
4	[empty string]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	9.99	0	11.99	8629-DEFAULT-l.jpg	9.99	8629-DEFAULT-m.jpg	LUX PRO LP200C POCKET LIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	26	10-to-15	0.00	[empty string]	Lux Pro Compact 1AA 100 Lumen LED Pocket Flashlight	<ul><li>Max Lumen: 100</li><li>Max Run Time: 2.5h</li><li>Battery: 1 AA</li><li>Model: LP200C</li></ul><p>The LP200C LED pocket-sized tactical flashlight is bright with 100 lumens. This flashlight has 3 modes: high, low, and strobe. Easily cycle through the modes with soft press functionality. With a waterproof rating for IPX4, this flashlight can withstand the elements of the weather. It's made with sturdy aircraft-grade aluminum. The design is compact with a high-quality pocket clip, so you can easily attach it to belts, pockets, and tool bags. Conveniently operates on and comes loaded with 1 AA battery, so you can get to work right away.</p><p><strong>Features:</strong></p><ul><li>- High-quality pocket clip</li><li>- Aircraft-grade aluminum</li><li>- IPX4 waterproof rating</li><li>- Limited manufacturer's warranty</li></ul><p><strong>Technical Specs:</strong></p><ul><li>Lumens: 100 - 40 </li><li>Run Time: 1.5h - 2.5h</li><li>Beam Distance: 55m - 25m</li><li>Battery Count/Size: 1 AA</li><li>Width: 1 in</li><li>Height: 4.2 in</li><li>Weight: 0.10 lb</li></ul>	[empty string]	N	11.99	11.99	[empty string]	8629-DEFAULT-s.jpg	[empty string]	1000	1000	LP200C	156918	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/lux-pro-compact-1aa-100-lumen-led-pocket-flashlight-156918	LP200C	0
5	[empty string]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	39.99	0	39.99	8602-DEFAULT-l.jpg	39.99	8602-DEFAULT-m.jpg	LUX PRO XP913 FLASHLIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	LuxPro Pro Series 1100 Lumen LED Rechargeable Focus Flashlight	<ul><li>Max Lumen: 1100</li><li>Max Run Time: 12h</li><li>Battery: 3.7V 2000mAh</li><li>Model: XP913</li></ul><p>Pro Series 1100 lumen LED rechargeable focus flashlight with TackGrip by LUXPRO. This rechargeable flashlight is compact, tactical, and illuminates up to 1,100 ultra-bright lumens. With a one-hand push/pull focus feature you can adjust the beam size according to your lighting needs. There are 4 modes to choose from: High, Medium, Low and Hidden Strobe. Run times range from 3 hours on High to an impressive 12 hours on Low. Low mode casts a dim, yet usable beam of 70 lumens. This light comes equipped with a rechargeable 3.7V 2000mAh battery that charges in approximately 4 hours. Conveniently charge the flashlight with the included micro-USB cable. TackGrip rubber grip is molded directly to the aluminum body for longer-lasting durability that won't slide or curl. TackGrip is a distinguishing patented feature that is exclusive to LUXPRO. </p><p><strong>Features:</strong></p><ul><li>- 1100-lumen output</li><li>- Single hand push/pull focus head </li><li>- Aircraft-grade aluminum</li><li>- LPE Optics and patented TackGrip</li><li>- Max run time of 12 hours </li><li>- IPX4 waterproof rating</li><li>- Limited Manufacturer's Warranty</li></ul><p><strong>Technical Specs:</strong></p><ul><li>Lumens: 1100 - 70 </li><li>Run Time: 3h - 12h</li><li>Beam Distance: 250m - 70m</li><li>Battery Count/Size: 3.7V 2000mAh</li><li>Width: 1.75 in</li><li>Height: 5.75 in</li><li>Weight: 0.48 lb</li></ul>	[empty string]	N	39.99	39.99	[empty string]	8602-DEFAULT-s.jpg	[empty string]	1000	1000	XP913	156939	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/luxpro-pro-series-1100-lumen-led-rechargeable-focus-flashlight-156939	XP913	0
6	[empty string]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	49.99	0	49.99	8603-DEFAULT-l.jpg	49.99	8603-DEFAULT-m.jpg	LUX PRO XP915 FLASHLIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	LuxPro Pro Series 1600 Lumen LED Rechargeable Flashlight	<ul><li>Max Lumen: 1600</li><li>Max Run Time: 11.75h</li><li>Battery: 3.7V 4000mAh</li><li>Model: XP915</li></ul><p>Pro Series 1600 lumen LED rechargeable flashlight with TackGrip by LUXPRO. This rechargeable flashlight is compact, tactical, and illuminates up to 1600 ultra-bright lumens. There are 4 modes: High, Medium, Low and Hidden Strobe. The hidden strobe has been incorporated into this light with an access/exit feature by pressing the on/off button for approximately 3 seconds. Innovative electronics allows user to turn the light off with one click after using the selected mode for more than 5 seconds.</p><p>This light comes equipped with two built-in Lithium-ion 3.7V, 4000mAh rechargeable batteries, and includes a micro-USB cable for convenient charging. Run times are excellent with 3 hours on high mode with 1600 lumens and over 11 hours on Low mode which still offers 120 lumens of light. This light features LUXPRO's patented TackGrip that is molded directly to the aluminum body for added durability and handling comfort. It's made sturdy with aircraft grade anodized aluminum with a sleek black matte finish. For additional peace of mind, this rugged rechargeable tactical flashlight comes with a Limited Warranty against Manufacturer's Defects.</p><p><strong>Features:</strong></p><ul><li>- 1600-lumen output</li><li>- 4 modes: High, Med, Low, Hidden Strobe</li><li>- Patented TackGrip </li><li>- Aircraft-grade aluminum and LPE Optics</li><li>- Micro USB cable included</li><li>- Built-in micro USB charge port</li><li>- IPX4 waterproof rating</li><li>- Warranty Against Manufacturer's Defects</li></ul><p><strong>Technical Specs:</strong></p><ul><li>Lumens: 1600 - 120 </li><li>Run Time: 3h - 11.75h</li><li>Beam Distance: 400m - 80m</li><li>Battery Count/Size: 3.7V 4000mAh</li><li>Width: 1.75 in</li><li>Height: 8.75 in</li><li>Weight: 0.64 lb</li></ul>	[empty string]	N	49.99	49.99	[empty string]	8603-DEFAULT-s.jpg	[empty string]	1000	1000	XP915	156940	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/luxpro-pro-series-1600-lumen-led-rechargeable-flashlight-156940	XP915	0
7	[empty string]	LUXPRO	Luxpro	HUNTING	Hunting	[empty string]	1	29.99	0	34.99	8601-DEFAULT-l.jpg	29.99	8601-DEFAULT-m.jpg	LUX PRO XP916 FLASHLIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4678	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	LuxPro Pro Series Bright 800 Lumen LED Flashlight	<ul><li>Max Lumen: 800</li><li>Max Run Time: 18h</li><li>Battery: 3.7V 2000mAh</li><li>Model: XP916</li></ul><p>Pro Series 800 lumen LED rechargeable flashlight with TackGrip by LUXPRO. This rechargeable flashlight is compact, tactical, and illuminates 800 ultra-bright lumens. There are 4 modes: High, Medium, Low and Hidden Strobe. With innovative electronics, users can turn the light off with one click after using the selected mode for more than 5 seconds. The hidden strobe has an access/exit feature by pressing the on/off button for approximately 3 seconds. This light comes equipped with a built-in Lithium-ion 3.4V 2000mAh rechargeable battery and includes a micro-USB cable for convenient charging. Run times are excellent with 3.5 hours when all 800 lumens are at work and over 18 hours on Low mode, which still offers 50 usable lumens of light. This flashlight features LUXPRO's patented TackGrip that is molded directly to the aluminum body for added durability and handling comfort. It's made sturdy with aircraft grade anodized aluminum and has a sleek black matte finish. For additional peace of mind, this rechargeable tactical light comes with a Limited Warranty against Manufacturer's Defects.</p><p><strong>Features:</strong></p><ul><li>- 800-lumen output</li><li>- Modes: High, Med, Low, & Hidden Strobe</li><li>- Patented TackGrip</li><li>- Aircraft-grade aluminum and LPE Optics</li><li>- Micro-USB cable included</li><li>- Built-in micro-USB charge port</li><li>- IPX4 waterproof rating</li><li>- Limited Manufacturer's Warranty</li></ul><p><strong>Technical Specs:</strong></p><ul><li>Lumens: 800 - 50</li><li>Run Time: 3.5h - 18h</li><li>Beam Distance: 350m - 80m</li><li>Battery Count/Size: 3.7V 2000mAh</li><li>Width: 1.5 in</li><li>Height: 6.5 in</li><li>Weight: 0.42 lb</li></ul>	[empty string]	N	34.99	34.99	[empty string]	8601-DEFAULT-s.jpg	[empty string]	1000	1000	XP916	156941	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	luxpro/luxpro-pro-series-bright-800-lumen-led-flashlight-156941	XP916	0
8	[empty string]	SOG	Sog	HUNTING	Hunting	[empty string]	1	99.99	0	99.99	16572-DEFAULT-l.jpg	99.99	16572-DEFAULT-m.jpg	SOG AEGIS AT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3710	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	SOG Aegis AT - Tanto - Rescue Red/Indigo	<p>Designed for outdoor users, the SOG Aegis AT Tanto is an assisted opening knife that features SOG's innovative ambidextrous AT-XR Lock with an ergonomic handle and grip pattern for comfortable use. Aegis AT is a pocket knife that is easy to carry, with a highly functional 3.1 in cryogenically heat-treated D2 steel blade. Its powerful XR locking mechanism also features solid built-in blade locking safety and spine-mounted safety system. The next evolution of the legendary Aegis folding knife.</p><ul><li>Shipping Width 3.6</li><li>Dimension Width 3.60</li><li>Shipping Height 11.1</li><li>Shipping Length 1.35</li><li>Dimension Height 11.10</li><li>Dimension Length 1.35</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	99.99	99.99	[empty string]	16572-DEFAULT-s.jpg	[empty string]	1000	1000	11-41-08-41	157445	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sog/sog-aegis-at-tanto-rescue-red-indigo-157445	11-41-08-41	0
9	[empty string]	SOG	Sog	HUNTING	Hunting	[empty string]	1	99.99	0	99.99	16573-DEFAULT-l.jpg	99.99	16573-DEFAULT-m.jpg	SOG AEGIS AT TANTO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3710	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	SOG Aegis AT - Tanto - Black/Moss Green	<p>Designed for outdoor users, the Aegis AT features rapid assisted opening with SOG's innovative ambidextrous AT-XR Lock with an ergonomic handle and grip pattern for comfortable use. The Aegis AT is easy to carry, with a highly functional 3.11" cryogenically heat-treated D2 tool steel blade. Its powerful XR locking mechanism also features solid built-in blade locking safety and a spine-mounted safety system. The tanto blade is optimized for tasks that include penetrating cuts through harder material and precise slicing. The next evolution of the legendary Aegis.</p><p>Whether you are hiking, camping, or hunting, you need a knife that can handle the unexpected. With help from the adventurers and explorers out there, SOG made the Aegis the perfect outdoor companion. When going into the uncharted, every piece of gear needs to be precise and dependable. Purposefully designed for working outdoors, Aegis AT feels great in hand and great to use. Smooth, yet textured for optimal grip, the handle is designed for comfort and confidence in outdoor conditions. Including a prominent lanyard loop that also acts as a hand-stop to mitigate slippage.</p><p><strong>Specifications</strong></p><ul><li>Blade Length: 3.11" (79 mm)</li><li>Closed Length: 5.00" (127 mm)</li><li>Overall Length: 8.11" (206 mm)</li><li>Blade Material: D2 Tool Steel</li><li>Blade Thickness: 0.12"</li><li>Blade Style: Tanto</li><li>Blade Grind: Flat</li><li>Blade Finish: Black Titanium Nitride</li><li>Handle Material: Black Glass Reinforced Nylon</li><li>Locking Mechanism: AT-XR Lock</li><li>Pivot Assembly: AT Assisted Technology</li><li>Pocket Clip: Deep Carry Stainless Steel (Tip-Up, Right/Left Carry)</li><li>Weight: 4.55 oz. (129 g)</li><li>Moss Green Colored Accents</li><li>Ambidextrous Spine-Mounted Safety</li><li>Made in Taiwan</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	99.99	99.99	[empty string]	16573-DEFAULT-s.jpg	[empty string]	1000	1000	11-41-09-41	157446	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sog/sog-aegis-at-tanto-black-moss-green-157446	11-41-09-41	0
10	[empty string]	SOG	Sog	HUNTING	Hunting	[empty string]	1	219.99	0	219.99	11533-DEFAULT-l.jpg	219.99	11533-DEFAULT-m.jpg	SOG SEAL XR	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3710	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	SOG Seal XR - Clip Point - Black	<ul><li>Manufacturer: SOG Specialty Knives & Tools</li><li>Blade Length: 3.9 in</li><li>Closed Length: 5.3 in</li><li>Blade Material: S35VN</li><li>Serrated: Straight Edge</li><li>Knife Application: Folding Blade</li><li>Overall Length: 9.2 in</li><li>Blade Shape: Clip Point</li><li>Handle Material: 30% GRN</li><li>Handle Finish: Sand Blasted</li><li>Blade Finish: Stone Washed</li><li>Condition: New</li><li>Handle Color: Grey, Black</li><li>Weight: 0.51 lb</li><li>Additional Features: Hardness 59-61</li><li>Color: Grey/Black</li><li>Thickness: 0.19 in</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	219.99	219.99	[empty string]	11533-DEFAULT-s.jpg	[empty string]	1000	1000	12-21-02-57	157448	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	sog/sog-seal-xr-clip-point-black-157448	12-21-02-57	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 ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Hunting
2	%tipton%
3	%egw%
4	%horton%mfg%co%inc%
5	%police%security%
6	%lazyman%
7	%fox%pro%game%calls%
8	%sog%
9	%luxpro%

Filter By

Sort By

Item # 12-21-02-57 $219.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Lux Pro Flashlight | Lp1044

Lux Pro 140 Lumen Led Penlight Flashlight With Pocket Clip

Lux Pro Lantern/Speaker

Lux Pro Compact 1aa 100 Lumen Led Pocket Flashlight

Luxpro Pro Series 1100 Lumen Led Rechargeable Focus Flashlight

Luxpro Pro Series 1600 Lumen Led Rechargeable Flashlight

Luxpro Pro Series Bright 800 Lumen Led Flashlight

Sog Aegis At - Tanto - Rescue Red/Indigo

Sog Aegis At - Tanto - Black/Moss Green

Sog Seal Xr - Clip Point - Black

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Lux Pro Flashlight | Lp1044

Lux Pro 140 Lumen Led Penlight Flashlight With Pocket Clip

Lux Pro Lantern/Speaker

Lux Pro Compact 1aa 100 Lumen Led Pocket Flashlight

Luxpro Pro Series 1100 Lumen Led Rechargeable Focus Flashlight

Luxpro Pro Series 1600 Lumen Led Rechargeable Flashlight

Luxpro Pro Series Bright 800 Lumen Led Flashlight

Sog Aegis At - Tanto - Rescue Red/Indigo

Sog Aegis At - Tanto - Black/Moss Green

Sog Seal Xr - Clip Point - Black