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]	ROSSI	Rossi	FIREARMS	Firearms>Rifle	[empty string]	1	899.99	1	749.99	16615-DEFAULT-l.jpg	899.99	16615-DEFAULT-m.jpg	ROSSI 920442013GLD RIFLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CBC	BRAZTECH	RIFLE	44MAG	[empty string]	265	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Rossi R92 Gold 44 Remington Magnum 20" Round Barrel \| Polished Black/Brazilian Hardwood & Gold Accents \| Lever Action	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The R92 Gold boast classic western styling with flair. It comes with a premium Brazilian hardwood forearm and stock with a traditional crescent buttplate. Providing an elegant accent to the polished black receiver, barrel, and magazine tube finish are gold-finish barrel bands, hammer, trigger, and lever.</p><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	Y	749.99	749.99	[empty string]	16615-DEFAULT-s.jpg	[empty string]	1000	1000	920442013GLD	65124	EMPTY	EMPTY	EMPTY	0	0	0	RIFLE	rossi/rossi-r92-gold-44-remington-magnum-20-round-barrel-polished-black-brazilian-hardwood-gold-accents-lever-action-65124	920442013GLD	0
2	[empty string]	ROSSI	Rossi	FIREARMS	Firearms>Rifle	[empty string]	1	699.99	0	699.99	16336-DEFAULT-l.jpg	699.99	16336-DEFAULT-m.jpg	ROSSI 920451613 R92 CARBINE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CBC	BRAZTECH	RIFLE	45LC	[empty string]	265	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Rossi R92 Carbine 45 Colt (LC) 16" Round Barrel \| Blued Black & Brazilian Hardwood \| Lever Action	<p>This model of the R92 lever action carbine features a carbon steel barrel, polished black finish, a Brazilian hardwood stock, and a fixed/adjustable buckhorn sight.</p><p><strong>SPECIFICATIONS</strong></p><ul><li>Manufacturer: Rossi</li><li>Model: Model 92 Carbine</li><li>Action: Lever</li><li>Caliber/Gauge: .45 Colt</li><li>Overall Length: 33.875"</li><li>Barrel Length: 16"</li><li>Capacity: 8</li><li>Sights: Buckhorn Front & Rear</li><li>Receiver Material: Steel</li><li>Stock Material: Brazilian Hardwood</li><li>Safety: Manual Thumb</li><li>Weight: 4.80 lbs</li><li>Additional Info: Field Application, Brazilian Hardwood Stock, Polished Black Finish.</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>	[empty string]	N	699.99	699.99	[empty string]	16336-DEFAULT-s.jpg	[empty string]	1000	1000	920451613	65125	EMPTY	EMPTY	EMPTY	0	0	0	RIFLE	rossi/rossi-r92-carbine-45-colt-lc-16-round-barrel-blued-black-brazilian-hardwood-lever-action-65125	920451613	0
3	[empty string]	ROSSI	Rossi	FIREARMS	Firearms>Rifle	[empty string]	1	399.99	1	329.99	17925-DEFAULT-l.jpg	399.99	17925-DEFAULT-m.jpg	ROSSI RP22181WD-EN17 GALLERY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CBC	BRAZTECH	RIFLE	22LR	[empty string]	265	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	300-to-350	0.00	[empty string]	Rossi Gallery .22 LR 18" Barrel \| Black Snakeskin Engraved Receiver & Wood \| Pump Action	<ul><li>MANUFACTURER: Rossi</li><li>FAMILY: GALLERY SERIES</li><li>MODEL: Rossi Gallery</li><li>TYPE: Rifle</li><li>ACTION: Pump Action</li><li>CALIBER/GAUGE: 22 LR</li><li>FINISH: Black</li><li>FINISH TYPE: Black</li><li>STOCK: Wood Stock</li><li>STOCK/GRIPS: Wood</li><li>BARREL: 18"</li><li>OVERALL LENGTH: 36"</li><li>CAPACITY: 15 + 1</li><li>SIGHTS: Fiber Optic Front & Rear</li><li>SIGHT TYPE: Adjustable Sights</li><li>WEIGHT: 84 oz.</li><li>SHIPPING WEIGHT: 7.25 lbs.</li><li>SAFETY FEATURES: Push Button Cross-Bolt</li><li>RECEIVER: SNAKESKIN Engraved Receiver</li><li>MFG MODEL NO: RP22181WD-EN17</li></ul><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	Y	329.99	329.99	[empty string]	17925-DEFAULT-s.jpg	[empty string]	1000	1000	RP22181WD-EN17	65132	EMPTY	EMPTY	EMPTY	0	0	0	RIFLE	rossi/rossi-gallery-22-lr-18-barrel-black-snakeskin-engraved-receiver-wood-pump-action-65132	RP22181WD-EN17	0
4	[empty string]	ROSSI	Rossi	FIREARMS	Firearms>Rifle	[empty string]	1	129.99	0	159.99	8439-DEFAULT-l.jpg	129.99	8439-DEFAULT-m.jpg	ROSSI RS22L1811 RIFLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CBC	BRAZTECH	RIFLE	22LR	[empty string]	265	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	150-to-200	0.00	[empty string]	Rossi RS22 .22 LR 18" Barrel \| Blued Black Monte Carlo \| With Hawke Scope	<p>Rossi's RS22 semi-automatic features an 18" free-float barrel with adjustable fiber optic sights, synthetic Monte Carlo stock, and a detachable magazine. This model has a black stock.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Rossi</li><li>Category Rifles</li><li>Caliber 22 LR</li><li>Model RS22</li><li>Stock Finish Black</li><li>Action Semi-Auto</li><li>Barrel Length Range 18" to 18.99"</li><li>Sights Fiber Optic Front & Rear</li><li>Capacity 10+1</li><li>Hand Right</li><li>OAL 36.25"</li><li>Receiver Finish Blued</li><li>Receiver Material Stainless Steel</li><li>Safety Manual</li><li>Stock Description Monte Carlo</li><li>Stock Finish Group Black</li><li>Stock Material Synthetic</li><li>Weight 4.10 lbs</li><li>Barrel Description Free-Floating Button-Rifled</li><li>Barrel Finish Blued</li><li>Barrel Length 18"</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p> <p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>	[empty string]	N	159.99	159.99	[empty string]	8439-DEFAULT-s.jpg	[empty string]	1000	1000	RS22L1811	65133	EMPTY	EMPTY	EMPTY	0	0	0	RIFLE	rossi/rossi-rs22-22-lr-18-barrel-blued-black-monte-carlo-with-hawke-scope-65133	RS22L1811	0
5	[empty string]	ROSSI	Rossi	FIREARMS	Firearms>Shotgun	[empty string]	1	149.99	0	169.99	28532-DEFAULT-l.jpg	149.99	28532-DEFAULT-m.jpg	ROSSI TUFFY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH	[empty string]	SHOTGUN	410GA	[empty string]	265	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Rossi Tuffy 410 Gauge 3" 18.50" Barrel \| Matte Black & Tan \| With Shell Holder \| Youth	<p>No other shotgun may have as many uses as the Tuffy break-action. With its redesigned thumbhole/pistol grip stock and short length-of-pull, the Tuffy is an ideal truck gun and great for small-frame shooters. The compact and light design also makes it the perfect choice for wilderness protection, survival scenarios, and is an easy grab-and-go shotgun for the farm or camp. The shell holder in the stock can hold up to 8 shells - 4 on each side.</p><ul><li>Brand Rossi</li><li>Category Shotguns</li><li>Series Single Shot</li><li>Model Tuffy</li><li>Gauge 410 Gauge</li><li>Barrel Length Range 18" to 18.99"</li><li>Stock Finish Group Brown</li><li>Capacity 1rd</li><li>Stock Material Synthetic</li><li>Action Break Open</li><li>OAL 31"</li><li>Hand Right Hand</li><li>Sights Bead Front</li><li>Size Youth</li><li>Chamber 3"</li><li>Barrel Finish Matte Black</li><li>Application Field</li><li>Chokes Included Modified</li><li>Receiver Material Steel</li><li>Safety Transfer Bar</li><li>Stock Description Fixed Thumbhole w / Shell Holder</li><li>Barrel Length 18.50"</li><li>Max Capacity 1</li><li>Receiver Finish Matte Black</li><li>Weight 2.95 lbs</li><li>Stock Finish Tan</li></ul><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	169.99	169.99	[empty string]	28532-DEFAULT-s.jpg	[empty string]	1000	1000	SSP1TAN	68486	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUN	rossi/rossi-tuffy-410-gauge-3-18-50-barrel-matte-black-tan-with-shell-holder-youth-68486	SSP1TAN	0
6	[empty string]	ROSSI	Rossi	FIREARMS	Firearms>Shotgun	[empty string]	1	229.99	0	244.99	7683-DEFAULT-l.jpg	229.99	7683-DEFAULT-m.jpg	ROSSI TUFFY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BRAZTECH	[empty string]	SHOTGUN	410GA	[empty string]	265	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	200-to-250	0.00	[empty string]	Rossi Tuffy Turkey Gun 410 Gauge 3" 26" Barrel \| Matte Black & OD Green	<p><strong>DESCRIPTION:</strong></p><p>Tuffy Turkey stands apart for its extended barrel length. At 26 inches, it is the longest barrel among the Tuffy .410-gauge shotguns. This cylinder-bore, 3-inch chamber shotgun includes an extra full choke tube installed on the barrel to provide increased pellet density in this .410 platform. This combination makes for a perfect match with Turkey .410 specific loads.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Rossi</li><li>Category Shotguns</li><li>Model Tuffy</li><li>Gauge 410 Gauge</li><li>Stock Finish OD Green</li><li>Action Break Open</li><li>Barrel Length Range 26" to 26.99"</li><li>Sights Bead Front</li><li>Capacity 1rd</li><li>Chamber 3"</li><li>Application Field</li><li>Chokes Included 1 Extra Full</li><li>Hand Right</li><li>Max Capacity 1</li><li>OAL 41"</li><li>Receiver Finish Matte Black</li><li>Receiver Material Steel</li><li>Safety Crossbolt</li><li>Stock Description Fixed Thumbhole</li><li>Stock Finish Group Green</li><li>Stock Material Synthetic</li><li>Weight 4 lbs</li><li>Barrel Finish Matte Black</li><li>Barrel Length 26"</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	244.99	244.99	[empty string]	7683-DEFAULT-s.jpg	[empty string]	1000	1000	SSPTKY	68487	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUN	rossi/rossi-tuffy-turkey-gun-410-gauge-3-26-barrel-matte-black-od-green-68487	SSPTKY	0
7	[empty string]	BORDER CROSSING	Border Crossing	HUNTING	Hunting>Scent Elimination	[empty string]	1	54.99	1	49.99	3978-DEFAULT-l.jpg	54.99	3978-DEFAULT-m.jpg	CONQUEST SCENTS VS-1	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3337	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Conquest Scents VS-1 Estrus Scent Stick 2.5 Oz	<p>Estrus Scent Stick - 2.5 oz<br />VS-1 is 100% estrus urine and vaginal secretions collected from superior breeding does that have been synchronized/cycled into peak estrus in order to produce the highest possible concentration of pheromones and encapsulated into our easy to use wax stick formula for No Spills, Leaks or Mess and it won't freeze!</p><p>Use during pre-rut, rut, or post-rut on scent pads and licking branches in high traffic areas.</p><p>Works great with a decoy! Use with EverCalm and RuttingBuck to create the smell of a deer herd and a dominant doe to create a seductive combination!</p>	[empty string]	Y	49.99	49.99	[empty string]	3978-DEFAULT-s.jpg	[empty string]	1000	1000	1202	91467	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	border-crossing/conquest-scents-vs-1-estrus-scent-stick-2-5-oz-91467	1202	0
8	[empty string]	BORDER CROSSING	Border Crossing	HUNTING	Hunting>Scent Elimination	[empty string]	1	19.99	0	24.99	4282-DEFAULT-l.jpg	19.99	4282-DEFAULT-m.jpg	CONQUEST SCENTS EVERCALM	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3337	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	20-to-25	0.00	[empty string]	Conquest Scents EverCalm Deer Herd Scent 2.5 Oz	<p>EverCalm is a collection of scents and smells from actual bedding areas; scents that are so familiar to deer that it puts them at ease!</p><p>100% bedding scents encapsulated into a wax stick formula for No Spills, Leaks, or Mess.</p><p>Dab on trees, rocks, or brush in your hunting area to turn it into the smell of a real bedding area; use all season long on blinds, decoys, trail cameras, scrapes, and licking branches to keep deer in the area.</p>	[empty string]	N	24.99	24.99	[empty string]	4282-DEFAULT-s.jpg	[empty string]	1000	1000	1214	91468	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	border-crossing/conquest-scents-evercalm-deer-herd-scent-2-5-oz-91468	1214	0
9	[empty string]	BORDER CROSSING	Border Crossing	HUNTING	Hunting>Scent Elimination	[empty string]	1	64.99	0	69.99	3980-DEFAULT-l.jpg	64.99	3980-DEFAULT-m.jpg	CONQUEST SCENTS EVERCALM/VS PK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3337	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	63	50-to-100	0.00	[empty string]	Conquest Scents Hunters Package (EverCalm & VS-1)	<p>VS-1 is 100% estrus urine and vaginal secretions collected from superior breeding does that have been synchronized/cycled into peak estrus in order to produce the highest possible concentration of pheromones. EverCalm is a collection of scents and smells from actual bedding areas; scents that are so familiar to deer that it puts them at ease!</p><p>Dab EverCalm on trees, rocks, or brush in your hunting area to turn it into the smell of a real bedding area. Use VS-1 during pre-rut, rut, or post-rut on scent pads and licking branches in high traffic areas.</p><p>Both are encapsulated into our easy to use wax stick formula for No Spills, Leaks or Mess and it won't freeze!</p><p>Use both with RuttingBuck to create the smell of a deer herd and a dominant buck to create a seductive combination!</p><p>Works great with a decoy!</p>	[empty string]	N	69.99	69.99	[empty string]	3980-DEFAULT-s.jpg	[empty string]	1000	1000	1240	91469	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	border-crossing/conquest-scents-hunters-package-evercalm-vs-1-91469	1240	0
10	[empty string]	BORDER CROSSING	Border Crossing	HUNTING	Hunting>Scent Elimination	[empty string]	1	14.99	0	14.99	3979-DEFAULT-l.jpg	14.99	3979-DEFAULT-m.jpg	CONQUEST SCENTS RUTTING BOAR	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3337	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	10-to-15	0.00	[empty string]	Conquest Scents Tyrant Rutting Boar Scent Stick	<p>Fire up their natural instincts and fool a pig's keen nose by covering your scent and attracting the Tyrant of the woods.</p><p>100% real pig urine encapsulated in our No Spills, No Leak, No Mess formula.</p><p>Use Rutting Boar scent to get the attention of and challenge boars in your area.</p><p>Works great with Estrus Sow scent to accelerate the aggressiveness of Boars in your area.</p><p><strong>Warning! Do NOT put on body or clothing!</strong></p>	[empty string]	N	14.99	14.99	[empty string]	3979-DEFAULT-s.jpg	[empty string]	1000	1000	1247	91470	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	border-crossing/conquest-scents-tyrant-rutting-boar-scent-stick-91470	1247	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc