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]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	18.99	0	18.99	[empty string]	18.99	[empty string]	INDIGLO UV LIGHT	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]	2012	[empty string]	[empty string]	SELL THRU	NOT ONLINE	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Uv Sight Light	The PSE UV Sight Light brightens the sight pins and reduces the halo affect. Easy to use on/off UV light.	[empty string]	N	18.99	18.99	[empty string]	[empty string]	[empty string]	1000	41572	56620	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/indiglo-uv-light-56620	1
2	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	PSE SIGHT LEVEL	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]	2012	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	5-to-10	0.00	[empty string]	Pse Sight Level	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	41269	56671	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/pse-sight-level-56671	1
3	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	GEMINI SIGHT	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]	2010	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Gemini Sight - 0.29 - Black	The PSE Gemini sight provides archers with PSE quality in a easy to use sight at a very affordable price.	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	41586	108821	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/gemini-sight-108821	1
4	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	PSE AMP SIGHT LEVEL	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	5-AND-under	0.00	[empty string]	Pse Amp Sight Level	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	42400	311234	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/pse-amp-sight-level-311234	1
5	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	PSE CARBON SIGHT LEVEL	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Pse Carbon Sight Level	[empty string]	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	42408	311308	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/pse-carbon-sight-level-311308	1
6	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	69.99	0	69.99	[empty string]	69.99	[empty string]	SIGHT AMP MICRO	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Sight Amp Micro	[empty string]	[empty string]	N	69.99	69.99	[empty string]	[empty string]	[empty string]	1000	42218BK	314890	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/sight-amp-micro-314890	1
7	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	18.99	0	18.99	[empty string]	18.99	[empty string]	TRUE BLUE SIGHT LIGHT	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	True Blue Sight Light	[empty string]	[empty string]	N	18.99	18.99	[empty string]	[empty string]	[empty string]	1000	42175	315224	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/true-blue-sight-light-315224	1
8	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	179.99	0	179.99	[empty string]	179.99	[empty string]	SIGHT CARBON DRIVE 4 PIN	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Sight Carbon Drive 4 Pin	[empty string]	[empty string]	N	179.99	179.99	[empty string]	[empty string]	[empty string]	1000	42305	347779	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/sight-carbon-drive-4-pin-347779	1
9	[empty string]	PSE	Pse	ARCHERY	Archery>Compound Bows and Accessories>Sights	[empty string]	0	59.99	0	59.99	[empty string]	59.99	[empty string]	SIGHT SIERRA MICRO BM	N	2 BOB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Sight Sierra Micro Bm	[empty string]	[empty string]	N	59.99	59.99	[empty string]	[empty string]	[empty string]	1000	42456	351331	SIGHTS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	pse/sight-sierra-micro-bm-351331	1

CACHED

false

EXECUTIONTIME

15

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter