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]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	699.99	1	499.99	[empty string]	699.99	[empty string]	USED RUGER PISTOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	RUGER + COMPANY INC	[empty string]	PISTOL	9MM	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	450-to-500	0.00	[empty string]	Used Ruger Pistol	[empty string]	[empty string]	Y	499.99	499.99	[empty string]	[empty string]	[empty string]	1000	1000	672-59640	65287	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-ruger-pistol-65287	672-59640	0
2	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	1199.99	0	1199.99	[empty string]	1199.99	[empty string]	USED SAVAGE RIFLE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SAVAGE ARMS	[empty string]	RIFLE	6.5CREEDMOOR	[empty string]	272	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Used Savage Rifle	[empty string]	[empty string]	N	1199.99	1199.99	[empty string]	[empty string]	[empty string]	1000	1000	K516825	65393	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-savage-rifle-65393	K516825	0
3	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	349.99	1	299.99	[empty string]	349.99	[empty string]	USED S+W PISTOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SMITH + WESSON	[empty string]	PISTOL	9MM	[empty string]	288	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	250-to-300	0.00	[empty string]	Used S+w Pistol	[empty string]	[empty string]	Y	299.99	299.99	[empty string]	[empty string]	[empty string]	1000	1000	M+P9	65618	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-s-w-pistol-65618	M+P9	0
4	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	549.99	1	519.99	[empty string]	549.99	[empty string]	USED WALTHER PDP F-SERIES	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CARL WALTHER	WALTHER ARMS	PISTOL	9MM	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Used Walther Pdp F-series	[empty string]	[empty string]	Y	519.99	519.99	[empty string]	[empty string]	[empty string]	1000	1000	2849313Z	65899	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-walther-pdp-f-series-65899	2849313Z	0
5	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	449.99	1	349.99	[empty string]	449.99	[empty string]	USED RUGER EC9S/LASER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	RUGER + COMPANY INC	[empty string]	PISTOL	9MM	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Used Ruger Ec9s/laser	[empty string]	[empty string]	Y	349.99	349.99	[empty string]	[empty string]	[empty string]	1000	1000	458-50186	65900	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-ruger-ec9s-laser-65900	458-50186	0
6	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	749.99	1	699.99	[empty string]	749.99	[empty string]	USED WALTHER PPK 380	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CARL WALTHER	WALTHER ARMS	PISTOL	380ACP	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Used Walther Ppk 380	[empty string]	[empty string]	Y	699.99	699.99	[empty string]	[empty string]	[empty string]	1000	1000	4796001Z	65901	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-walther-ppk-380-65901	4796001Z	0
7	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	749.99	1	699.99	[empty string]	749.99	[empty string]	USED WALTHER PPK/S 380	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CARL WALTHER	WALTHER ARMS	PISTOL	380ACP	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Used Walther Ppk/s 380	[empty string]	[empty string]	Y	699.99	699.99	[empty string]	[empty string]	[empty string]	1000	1000	4796004Z	65902	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-walther-ppk-s-380-65902	4796004Z	0
8	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	449.99	1	419.99	[empty string]	449.99	[empty string]	USED WALTHER CCP M2	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CARL WALTHER	WALTHER ARMS	PISTOL	9MM	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	400-to-450	0.00	[empty string]	Used Walther Ccp M2	[empty string]	[empty string]	Y	419.99	419.99	[empty string]	[empty string]	[empty string]	1000	1000	5083500Z	65903	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-walther-ccp-m2-65903	5083500Z	0
9	[empty string]	USED GUNS	Used Guns	UNCATEGORIZED	Uncategorized	[empty string]	0	449.99	1	399.99	[empty string]	449.99	[empty string]	USED WALTHER PPQ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CARL WALTHER	WALTHER ARMS	PISTOL	22LR	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	Used Walther Ppq	[empty string]	[empty string]	Y	399.99	399.99	[empty string]	[empty string]	[empty string]	1000	1000	5083505Z-22LR	65904	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	used-guns/used-walther-ppq-65904	5083505Z-22LR	0
10	[empty string]	USED GUNS	Used Guns	FIREARMS	Firearms>Used	[empty string]	1	799.99	0	799.99	29435-DEFAULT-l.jpg	799.99	29435-DEFAULT-m.jpg	USED SIG P320 ZEV	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SIG SAUER	[empty string]	PISTOL	9MM	[empty string]	4987	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Used Sig Sauer P320 Zev 9MM	<p>The SIG Sauer/ZEV P320 XCarry Semi-Auto Pistol is a feature rich, match-grade pistol, designed with competition shooters in mind. The Z320 XCarry slide features a factory RMR optics cut readily accepting a variety of handgun optics and sports a corrosion-resistant titanium gray finish for lasting performance.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Condition: Used</li><li>Minor Blemishes</li><li>Caliber: 9MM</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	799.99	799.99	[empty string]	29435-DEFAULT-s.jpg	[empty string]	1000	1000	58J169909	65908	EMPTY	EMPTY	EMPTY	0	0	0	USED	used-guns/used-sig-sauer-p320-zev-9mm-65908	58J169909	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc