Jay's 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	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	1	25.99	0	25.99	96844-DEFAULT-l.jpg	25.99	96844-DEFAULT-m.jpg	SIGHT LIGHT W/ BRACKET	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	sight light with bracket	<p>Sight light with bracket </p>	[empty string]	N	25.99	25.99	[empty string]	96844-DEFAULT-s.jpg	[empty string]	1000	FPSL	168237	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/sight-light-with-bracket-168237	1
2	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	1	114.99	0	114.99	96783-DEFAULT-l.jpg	114.99	96783-DEFAULT-m.jpg	SIGHT RUSH RH 3 PIN BLACK 19-19-10	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	100-to-150	0.00	[empty string]	RUSH	<ul> <li>Premium materials and durability are built into every Rush sight.</li> <li>The .019 Micro Groove pins provide a clear aiming point with minimal target obstruction.</li> <li>The high-performance PhotoChromatic shell adapts pin brightness to all light conditions for perfect pin clarity.</li> <li>Non-Micro adjustable 2nd Axis for precise bow-to-sight alignment.</li> </ul>	[empty string]	N	114.99	114.99	[empty string]	96783-DEFAULT-s.jpg	[empty string]	1000	FPRU3	172728	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/rush-172728	1
3	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	249.99	0	249.99	[empty string]	249.99	[empty string]	SIGHT ASCENT VERDICT RH 1 PIN BLK GRN PI	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Ascent Verdict Sight - Right Hand - 1 Pin - Black/green	<p><strong>PRODUCT FEATURES:</strong></p> <p>-All Verdict models now feature 3rd axis adjustability</p> <p>- X-Frame base is stronger, lighter</p> <p>-Level Head sight ring is far easier to adjust, far more secure; can be customized to fit into top of sight ring</p> <p>-Indicator needle is indexable for easy re-sighting should your set up change</p> <p>-Splined vertical drive gear increases durability by 80% and provides a quieter, more solid feel!</p> <p>-High performance PhotoChromatic shell – 80% tougher, changes color faster</p> <p>-More range and adjustability than traditional hunting movable sights</p> <p>-Angled (45°) sight tape can be seen from side or back</p> <p>-54 sight tapes included – choose the one that’s right for you!</p> <p>-Precision 1st, 2nd and 3rd axis adjustability</p> <p>-Works great with one-piece quivers (unlike most movable sights)</p> <p>-Quick, smooth and quiet adjustment</p> <p> </p> <p><strong>PACKED WITH POWER</strong></p> <p>-High performance PhotoChromatic Technology automatically darkens in bright light to dull pins, prevent pin halo. Patent #7290345.</p> <p>-The revolutionary SkyCoil gathers light from above for unmatched pin brightness when you need it!</p> <p><strong>-“Dial-of-Death”</strong> adjustment system gives target sight accuracy to bowhunters; 80% more gear surface interface means smoother operation, no gear burnout;     reliable new SureGrip knob.</p> <p><span class=`new`>-New</span> X-Frame base with 3rd axis adjustability.</p> <p>-Level Head sight ring with pre-installed level that’s much easier to adjust and far more secure.</p> <p>-Machined aluminum guard for maximum durability and pin protection.</p>	[empty string]	N	249.99	249.99	[empty string]	[empty string]	[empty string]	1000	AV1	266628	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/sight-ascent-verdict-rh-1-pin-blk-grn-pi-266628	1
4	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	1	249.99	0	249.99	96840-DEFAULT-l.jpg	249.99	96840-DEFAULT-m.jpg	SIGHT ASCENT VERDICT LH 1 PIN BLK GRN PI	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	VERDICT	<ul> <li>Dial of death adjustment system gives bowhunters target sight accuracy, lets you quicly adjust distance. </li> <li>More range and adjustability that traditional moveable sights</li> <li>Quick, smooth and quiet adjustment </li> <li>Readily accepts one piece quivers </li> <li>1st and 2nd axis adjustability </li> </ul>	[empty string]	N	249.99	249.99	[empty string]	96840-DEFAULT-s.jpg	[empty string]	1000	AV1-L	281712	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/verdict-281712	1
5	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	1	114.99	0	114.99	96845-DEFAULT-l.jpg	114.99	96845-DEFAULT-m.jpg	SIGHT RUSH LH 3 PIN BLACK 19-19-10	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Rush	<ul> <li>Machined bombproof micro groove pins are virtually indestructable.</li> <li>Level head fluorscent sight ring with easy to adjust, secure level for setting 2nd axis.</li> <li>Compact head; low profile photochromatic shell. </li> </ul>	[empty string]	N	114.99	114.99	[empty string]	96845-DEFAULT-s.jpg	[empty string]	1000	FPRU3-L	297815	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/rush-297815	1
6	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories	[empty string]	1	109.99	0	109.99	96841-DEFAULT-l.jpg	109.99	96841-DEFAULT-m.jpg	QUICK LINK PICATTINNY RAIL ADAPTER	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	100-to-150	0.00	[empty string]	Quick-link	<ul> <li>SIght adapter to quickly convert any Black Gold sight to work with a picatinny sight mount.</li> <li>Fits both RH and LH model sights. </li> <li>Made in U.S.A</li> </ul>	[empty string]	N	109.99	109.99	[empty string]	96841-DEFAULT-s.jpg	[empty string]	1000	BGQLA	363545	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/quick-link-363545	1
7	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	1	349.99	0	349.99	96839-DEFAULT-l.jpg	349.99	96839-DEFAULT-m.jpg	SIGHT PRO DUAL TRACK RH 2 PIN BLACK 19	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	300-to-350	0.00	[empty string]	DUAL TRAC	<p>Dual trac two pin sight with single pin visibiltiy.</p> <p> </p> <p> </p> <ul> <li>Single up pin, with a 2nd independently adjustable pin in line with the first.</li> <li>Dual indicator system reduces time and movement.</li> <li>Micro adjustable windage and elevation. </li> <li>Pro pin allos for less targer blackout and a precise aiming point. </li> </ul>	[empty string]	N	349.99	349.99	[empty string]	96839-DEFAULT-s.jpg	[empty string]	1000	BGPDT2	367969	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/dual-trac-367969	1
8	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories	[empty string]	1	16.99	0	16.99	96842-DEFAULT-l.jpg	16.99	96842-DEFAULT-m.jpg	SIGHT TAPE ASCENT	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Sight tape kit	<p>Sight tape kit </p>	[empty string]	N	16.99	16.99	[empty string]	96842-DEFAULT-s.jpg	[empty string]	1000	STA	367972	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/sight-tape-kit-367972	1
9	[empty string]	BLACK GOLD	Black Gold	ARCHERY	Archery>Compound Bows and Accessories	[empty string]	1	21.99	0	21.99	96843-DEFAULT-l.jpg	21.99	96843-DEFAULT-m.jpg	DOUBLE INDICATOR SYSTEM 4 POINTERS HARDWARE	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Double Indicator system	<p>Double Indicator System: 4 pointers/hardware </p>	[empty string]	N	21.99	21.99	[empty string]	96843-DEFAULT-s.jpg	[empty string]	1000	BGDIS	367973	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	black-gold/double-indicator-system-367973	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter