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	595	[empty string]	550	[empty string]	700 ADL 308WIN W SCOPE 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	4	500-or-more	0.00	[empty string]	700 Adl 308win W Scope Bolt Rifle	[empty string]	[empty string]	N	595	595	[empty string]	[empty string]	[empty string]	1000	R85407	354978	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-308win-w-scope-bolt-rifle-354978	1
2	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	550	0	595	[empty string]	550	[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	3	500-or-more	0.00	[empty string]	Rem 700 Adl 30-06 Bolt Rifle	[empty string]	[empty string]	N	595	595	[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
3	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	0	415	0	450	[empty string]	415	[empty string]	870 EXP 12 GA SHOTGUN 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	2	400-to-450	0.00	[empty string]	870 Exp 12 Ga Shotgun Pump	[empty string]	[empty string]	N	450	450	[empty string]	[empty string]	[empty string]	1000	R25568	354988	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-exp-12-ga-shotgun-pump-354988	1
4	[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	4	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

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter