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	BLACK,ODGREEN,CARFI	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL,ODGREEN\|NULL\|NULL,CARFI\|NULL\|NULL	1	129.99	1	109.99	85637-DEFAULT-l.jpg	129.99	85637-DEFAULT-m.jpg	CTK-1 OTF AUTO KNIFE D2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	20	100-to-150	0.00	[empty string]	Ctk-1 Otf Auto Knife D2 Steel	[empty string]	[empty string]	N	109.99	129.99	MEDIUM,SMALL,LARGE	85637-DEFAULT-s.jpg	[empty string]	1000	CTK-1 D2	307025	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/ctk-1-otf-auto-knife-d2-steel-307025	1
2	BFP,RFP,LRFDP	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BFP\|NULL\|NULL,RFP\|NULL\|NULL,LRFDP\|NULL\|NULL	1	169.99	0	169.99	85628-DEFAULT-l.jpg	169.99	85628-DEFAULT-m.jpg	FANG FS-3 OTF AUTO KNIFE CERAKOTED2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[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]	4	150-to-200	0.00	[empty string]	Fang Fs-3 Otf Auto Knife Cerakoted2 Steel	[empty string]	[empty string]	N	169.99	169.99	LARGE	85628-DEFAULT-s.jpg	[empty string]	1000	FS-3 CERAKOTE	323542	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/fang-fs-3-otf-auto-knife-cerakoted2-steel-323542	1
3	SAND,BRONZE,AFLAG,COBRASKIN	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	SAND\|NULL\|NULL,BRONZE\|NULL\|NULL,AFLAG\|NULL\|NULL,COBRASKIN\|NULL\|NULL	1	169.99	1	149.99	86443-DEFAULT-l.jpg	169.99	86443-DEFAULT-m.jpg	CTK-1 OTF AUTO KNIFE CERAKOTE D2 STEEL	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	Ctk-1 Otf Auto Knife Cerakote D2 Steel	[empty string]	[empty string]	N	149.99	169.99	SMALL,LARGE,MEDIUM	86443-DEFAULT-s.jpg	[empty string]	1000	CTK-1 CERAKOTE	323543	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/ctk-1-otf-auto-knife-cerakote-d2-steel-323543	1
4	GREY,BLACK,CARBON,NYPDBLUE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	GREY\|NULL\|NULL,BLACK\|NULL\|NULL,CARBON\|NULL\|NULL,NYPDBLUE\|NULL\|NULL	1	79.99	0	79.99	85638-DEFAULT-l.jpg	79.99	85638-DEFAULT-m.jpg	LIGHTWEIGHT OTF D2 STEEL KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[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]	6	50-to-100	0.00	[empty string]	Lightweight Otf D2 Steel Knife	[empty string]	[empty string]	N	79.99	79.99	[empty string]	85638-DEFAULT-s.jpg	[empty string]	1000	LIGHTWEIGHT	323544	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/lightweight-otf-d2-steel-knife-323544	1
5	BLACK	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	BLACK\|NULL\|NULL	0	179.99	1	139.99	[empty string]	179.99	[empty string]	SIDEWINDER OTF D2 STEEL KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[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]	2	100-to-150	0.00	[empty string]	Sidewinder Otf D2 Steel Knife	[empty string]	[empty string]	N	139.99	179.99	SMALL	[empty string]	[empty string]	1000	SIDEWINDER	323545	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/sidewinder-otf-d2-steel-knife-323545	1
6	TIFFBLUE	COBRATEC KNIVES	Cobratec Knives	CUTLERY	Cutlery>Autos	TIFFBLUE\|NULL\|NULL	1	69.99	0	69.99	86621-DEFAULT-l.jpg	69.99	86621-DEFAULT-m.jpg	OTFTACTICAL PEN/ KNIFE	N	9 BILL	[empty string]	[empty string]	[empty string]	A	[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	50-to-100	0.00	[empty string]	Otftactical Pen/ Knife	[empty string]	[empty string]	N	69.99	69.99	[empty string]	86621-DEFAULT-s.jpg	[empty string]	1000	OTF PEN	323546	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cobratec-knives/otftactical-pen-knife-323546	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter