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]	EXCALIBUR CROSSBOWS	Excalibur Crossbows	ARCHERY	Archery>Crossbows and Accessories>Crossbows	[empty string]	1	1999.99	0	1999.99	99347-DEFAULT-l.jpg	1999.99	99347-DEFAULT-m.jpg	TWIN STRIKE MOBU	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	500-or-more	0.00	[empty string]	Twin Strike Mossy Oak Crossbow	<p>Double or nothing just became the new standard. The TwinStrike Crossbow with DualFire Technology gives you two arrows locked and loaded for double the confidence, double the opportunity, and zero reasons to choose anything less. The TwinStrike is the first crossbow of its kind, giving you Excalibur signature durability and an immediate follow-up shot the moment you need it.</p> <p> </p> <ul> <li>The only crossbow to give you an instant follow-up shot in milliseconds</li> <li>DualFire Technology features dual triggers, engineered to accurately fire two shots from a single crossbow with tight groupings to maximize a shooter's effective range</li> <li>Dual match-grade 4lb. frictionless triggers. Front trigger fires the top rail, back trigger fires the bottom rail</li> <li>CeaseFire technology ensures the crossbow will not fire unless an arrow is loaded</li> <li>Includes the Charger EXT, an easy and silent mechanical crank with the ability to securely and safely cock and decock the TwinStrike without shooting an arrow</li> <li>Engineered for ideal weight and perfect balance in the field</li> </ul>	[empty string]	N	1999.99	1999.99	[empty string]	99347-DEFAULT-s.jpg	[empty string]	1000	E74353	346021	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	excalibur-crossbows/twin-strike-mossy-oak-crossbow-346021	1
2	[empty string]	EXCALIBUR CROSSBOWS	Excalibur Crossbows	ARCHERY	Archery>Crossbows and Accessories>Crossbows	[empty string]	1	1999.99	0	1999.99	99348-DEFAULT-l.jpg	1999.99	99348-DEFAULT-m.jpg	TWIN STRIKE STRATA	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	500-or-more	0.00	[empty string]	Twin Strike True Tiber Strata Crossbow	<p>Double or nothing just became the new standard. The TwinStrike Crossbow with DualFire Technology gives you two arrows locked and loaded for double the confidence, double the opportunity, and zero reasons to choose anything less. The TwinStrike is the first crossbow of its kind, giving you Excalibur signature durability and an immediate follow-up shot the moment you need it.</p> <p> </p> <ul> <li>The only crossbow to give you an instant follow-up shot in milliseconds</li> <li>DualFire Technology features dual triggers, engineered to accurately fire two shots from a single crossbow with tight groupings to maximize a shooter's effective range</li> <li>Dual match-grade 4lb. frictionless triggers. Front trigger fires the top rail, back trigger fires the bottom rail</li> <li>CeaseFire technology ensures the crossbow will not fire unless an arrow is loaded</li> <li>Includes the Charger EXT, an easy and silent mechanical crank with the ability to securely and safely cock and decock the TwinStrike without shooting an arrow</li> <li>Engineered for ideal weight and perfect balance in the field</li> </ul>	[empty string]	N	1999.99	1999.99	[empty string]	99348-DEFAULT-s.jpg	[empty string]	1000	E74383	346022	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	excalibur-crossbows/twin-strike-true-tiber-strata-crossbow-346022	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter