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]	LBE UNLIMITED	Lbe Unlimited	SHOOTING	Shooting	[empty string]	1	24.99	0	24.99	11413-DEFAULT-l.jpg	24.99	11413-DEFAULT-m.jpg	LBE UNLIMITED LBTOOL-AKSKS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5873	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	LBE Unlimited TOOL-AKSKS Wind and Elevation Tool for Ak/SKS	<table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Model</td><td>Sight Adjustment Tool</td></tr><tr><td>Manufacturer Part Number</td><td>TOOL-AKSKS </td></tr></table>	[empty string]	N	24.99	24.99	[empty string]	11413-DEFAULT-s.jpg	[empty string]	1000	1000	LBTOOL-AKSKS	200699	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lbe-unlimited/lbe-unlimited-tool-aksks-wind-and-elevation-tool-for-ak-sks-200699	LBTOOL-AKSKS	0
2	[empty string]	TECHNA CLIP	Techna Clip	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	761-DEFAULT-l.jpg	29.99	761-DEFAULT-m.jpg	TECHNA CLIP 238BR	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4635	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Techna Clip for Sig Sauer P238	<p>The Techna Clip comes with screws and an Allen key that secures the Techna Clip to right side of the gun. Extra screws are included. The high quality Teflon coating prevents abrasion to the gun by providing a thin but highly durable cushion between the Techna Clip and the slide. The Techna Clip comes in Nickel plated and fits all Sig Sauer P238 models. We do NOT use double-sided sticky tape like our competitors.</p><ul><li>Included: (Black) High Carbon Spring Steel belt clip, plated with Teflon Stone Coat 5100 and grip plate replacement screws.</li><li>Quick 5-minute install with NO modification required. (Installs on the Right Side of the gun)</li><li>Techna Clip is a Minimalist Holster solution for those who Conceal Carry.</li></ul>	[empty string]	N	29.99	29.99	[empty string]	761-DEFAULT-s.jpg	[empty string]	1000	1000	238BR	208918	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	techna-clip/techna-clip-for-sig-sauer-p238-208918	238BR	0
3	[empty string]	TECHNA CLIP	Techna Clip	SHOOTING	Shooting	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	TECHNA CLIP G2BA CONCEALED CRY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4635	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Techna Clip Conceal Carry Gun Belt Clip For Taurus Millennium G2 \| G2BA	<table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Type</td><td>Belt Clip</td></tr><tr><td>Color</td><td>Black</td></tr><tr><td>Material</td><td>Carbon Fiber</td></tr><tr><td>Model</td><td>Conceal Carry</td></tr><tr><td>Model Fit</td><td>Taurus Millennium G2, Slim</td></tr><tr><td>Mount Type</td><td>Belt</td></tr><tr><td>Manufacturer Part Number</td><td>G2BA </td></tr></table>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	1000	G2BA	208921	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	techna-clip/techna-clip-conceal-carry-gun-belt-clip-for-taurus-millennium-g2-g2ba-208921	G2BA	0
4	[empty string]	TECHNA CLIP	Techna Clip	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	756-DEFAULT-l.jpg	29.99	756-DEFAULT-m.jpg	TECHNA CLIP G42BRL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4635	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Techna Clip for Glock 42	<ul><li>Techna Clip is a Minimalist Holster solution for those who Conceal Carry.</li><li>Included: (Black) Milled Billet back plate, High Carbon Spring Steel belt clip, plated with Teflon Stone Coat 5100, Screws and locking Washers.</li><li>Quick 5 minute install with NO modification required. (Installs on the Right Side of the gun)</li></ul>	[empty string]	N	29.99	29.99	[empty string]	756-DEFAULT-s.jpg	[empty string]	1000	1000	G42BRL	208922	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	techna-clip/techna-clip-for-glock-42-208922	G42BRL	0
5	[empty string]	TECHNA CLIP	Techna Clip	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	757-DEFAULT-l.jpg	29.99	757-DEFAULT-m.jpg	TECHNA CLIP G43BRL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4635	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Techna Clip for Glock 43	<ul><li>Techna Clip is a Minimalist Holster solution for those who Conceal Carry.</li><li>Included: (Black) Milled Billet back plate, High Carbon Spring Steel belt clip, plated with Teflon Stone Coat 5100, Screws and locking Washers.</li><li>Quick 5 minute install with NO modification required. (Installs on the Right Side of the gun)</li></ul><p> </p>	[empty string]	N	29.99	29.99	[empty string]	757-DEFAULT-s.jpg	[empty string]	1000	1000	G43BRL	208923	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	techna-clip/techna-clip-for-glock-43-208923	G43BRL	0
6	[empty string]	TECHNA CLIP	Techna Clip	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	755-DEFAULT-l.jpg	29.99	755-DEFAULT-m.jpg	TECHNA CLIP GLOCKBRL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4635	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Techna Clip For Glock Models	<ul><li>Techna Clip is a Minimalist Holster solution for those who Conceal Carry.</li><li>Included: (Black) Milled Billet back plate, High Carbon Spring Steel belt clip, plated with Teflon Stone Coat 5100, Screws and locking Washers.</li><li>Quick 5 minute install with NO modification required. (Installs on the Right Side of the gun)</li></ul>	[empty string]	N	29.99	29.99	[empty string]	755-DEFAULT-s.jpg	[empty string]	1000	1000	GLOCKBRL	208924	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	techna-clip/techna-clip-for-glock-models-208924	GLOCKBRL	0
7	[empty string]	TECHNA CLIP	Techna Clip	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	760-DEFAULT-l.jpg	29.99	760-DEFAULT-m.jpg	TECHNA CLIP JFRBR	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4635	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Techna Clip for S&W J Frame	<p>The Techna Clip comes with a high-carbon spring-steel Belt Clip that has been Teflon coated and a replacement Yoke Screw and Side Plate Screw for mounting the Techna Clip to the Small J-Frame. The high quality Teflon coating prevents abrasion to the gun by providing a thin but highly durable cushion between the Techna Clip and the slide. The Techna Clip comes in Black and fits all Small J-Frame models made after 1998.</p><ul><li>Included: (Black) High Carbon Spring Steel belt clip, plated with Teflon Stone Coat 5100 and replacement frame screws.</li><li>Quick 5-minute install with NO modification required. (Installs on the Right Side of the gun) </li><li>Techna Clip is a Minimalist Holster solution for those who Conceal Carry.</li></ul>	[empty string]	N	29.99	29.99	[empty string]	760-DEFAULT-s.jpg	[empty string]	1000	1000	JFRBR	208925	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	techna-clip/techna-clip-for-s-w-j-frame-208925	JFRBR	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts104 ORDER BY sortposition asc