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]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	550	0	650	[empty string]	550	[empty string]	700 ADL 300WIN MAG BOLT RIFLE	N	11 JJ	300 WIN MAG	26IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	700 Adl 300win Mag Bolt Rifle	[empty string]	[empty string]	N	650	650	[empty string]	[empty string]	[empty string]	1000	R27099	354974	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-300win-mag-bolt-rifle-354974	1
2	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	650	0	650	[empty string]	650	[empty string]	700 ADL 6.5CM BOLT RIFLE	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	700 Adl 6.5cm Bolt Rifle	[empty string]	[empty string]	N	650	650	[empty string]	[empty string]	[empty string]	1000	R85447	354977	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-6-5cm-bolt-rifle-354977	1
3	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	650	0	650	[empty string]	650	[empty string]	700 ADL 308WIN BOLT RIFLE	N	11 JJ	308 WIN	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	700 Adl 308win Bolt Rifle	[empty string]	[empty string]	N	650	650	[empty string]	[empty string]	[empty string]	1000	R85407	354978	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-308win-bolt-rifle-354978	1
4	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	650	0	650	[empty string]	650	[empty string]	REM 700 ADL 30-06 BOLT RIFLE	N	11 JJ	30-06 SPRG	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	4	500-or-more	0.00	[empty string]	Rem 700 Adl 30-06 Bolt Rifle	[empty string]	[empty string]	N	650	650	[empty string]	[empty string]	[empty string]	1000	R27095	354979	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700-adl-30-06-bolt-rifle-354979	1
5	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	550	0	650	[empty string]	550	[empty string]	700 ADL 270WIN BOLT RIFLE	N	11 JJ	270 WIN	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	4	500-or-more	0.00	[empty string]	700 Adl 270win Bolt Rifle	[empty string]	[empty string]	N	650	650	[empty string]	[empty string]	[empty string]	1000	R27094	354980	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-270win-bolt-rifle-354980	1
6	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	1095	0	1095	[empty string]	1095	[empty string]	REM 700 CDL 30-06 BOLT RIFLE	N	11 JJ	30-06 SPRG	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	Rem 700 Cdl 30-06 Bolt Rifle	[empty string]	[empty string]	N	1095	1095	[empty string]	[empty string]	[empty string]	1000	R27017	354983	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700-cdl-30-06-bolt-rifle-354983	1
7	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	665	0	780	[empty string]	665	[empty string]	REM 700SPS 6.5CM BOLT RIFLE	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	Rem 700sps 6.5cm Bolt Rifle	[empty string]	[empty string]	N	780	780	[empty string]	[empty string]	[empty string]	1000	R84148	354986	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700sps-6-5cm-bolt-rifle-354986	1
8	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	770	0	895	[empty string]	770	[empty string]	REM 700 SPS TACTICAL 308WIN BOLT RIFLE	N	11 JJ	308 WIN	20IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	Rem 700 Sps Tactical 308win Bolt Rifle	[empty string]	[empty string]	N	895	895	[empty string]	[empty string]	[empty string]	1000	R84203	354987	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700-sps-tactical-308win-bolt-rifle-354987	1
9	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	0	440	0	475	[empty string]	440	[empty string]	870 EXP SUPER MAG SYNTH 12GA PUMP	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	1	450-to-500	0.00	[empty string]	870 Exp Super Mag Synth 12ga Pump	[empty string]	[empty string]	N	475	475	[empty string]	[empty string]	[empty string]	1000	R25103	354989	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-exp-super-mag-synth-12ga-pump-354989	1
10	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	0	415	0	485	[empty string]	415	[empty string]	REMINGTON 870 EXPRESS TACT 12GA PUMP SHOTGUN	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	2	450-to-500	0.00	[empty string]	Remington 870 Express Tact 12ga Pump Shotgun	[empty string]	[empty string]	N	485	485	[empty string]	[empty string]	[empty string]	1000	R25559	355000	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/remington-870-express-tact-12ga-pump-shotgun-355000	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter