Simmons' 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	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	DESERT_ROSE	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	DESERT_ROSE\|NULL\|NULL	0	29.99	1	19.99	[empty string]	29.99	[empty string]	VELVET FAWN TOD SADIE SHORT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNSADIESHORT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Velvet Fawn Tod Sadie Short	[empty string]	[empty string]	Y	19.99	19.99	2T	[empty string]	[empty string]	1000	1000	CFSS2330	80325	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-tod-sadie-short-80325	CFSS2330	0
2	HEATHERED_ROSE	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	HEATHERED_ROSE\|NULL\|NULL	0	19.99	1	9.99	[empty string]	19.99	[empty string]	VELVET FAWN INF CLASSIC BLOOME	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNINFCLASSICBLOOME	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	5-to-10	0.00	[empty string]	Velvet Fawn Inf Classic Bloome	[empty string]	[empty string]	Y	9.99	9.99	3/6	[empty string]	[empty string]	1000	1000	VFFW2330	80368	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-inf-classic-bloome-80368	VFFW2330	0
3	HEATHERED_ROSE	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	HEATHERED_ROSE\|NULL\|NULL	0	49.99	1	29.99	[empty string]	49.99	[empty string]	VELVET FAWN TOD PIPER SWEATER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNTODPIPERSWEATER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Velvet Fawn Tod Piper Sweater	[empty string]	[empty string]	Y	29.99	29.99	2T,3T,4T	[empty string]	[empty string]	1000	1000	VFFW2390	80370	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-tod-piper-sweater-80370	VFFW2390	0
4	SURF_DOG	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	SURF_DOG\|NULL\|NULL	0	36.99	1	14.99	[empty string]	36.99	[empty string]	VELVET FAWN INF SWIM SHORTIE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNSWIMSHORTIE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Velvet Fawn Inf Swim Shortie	[empty string]	[empty string]	Y	14.99	14.99	0/3M,12/18M	[empty string]	[empty string]	1000	1000	VFSS23104	80375	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-inf-swim-shortie-80375	VFSS23104	0
5	SEERSUCKER	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	SEERSUCKER\|NULL\|NULL	0	39.99	1	14.99	[empty string]	39.99	[empty string]	VELVET FAWN TOD NASH BD SHIRT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNNASHBUTTONDOWN	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Velvet Fawn Tod Nash Bd Shirt	[empty string]	[empty string]	Y	14.99	14.99	6,7	[empty string]	[empty string]	1000	1000	VFSS2370	80381	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-tod-nash-bd-shirt-80381	VFSS2370	0
6	SURF_DOG	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	SURF_DOG\|NULL\|NULL	0	36.99	1	19.99	[empty string]	36.99	[empty string]	VELVET FAWN TOD 2PC JAMMIE SET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNTOD2PCJAMMIESET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Velvet Fawn Tod 2pc Jammie Set	[empty string]	[empty string]	Y	19.99	19.99	4T	[empty string]	[empty string]	1000	1000	VFSS2389	80382	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-tod-2pc-jammie-set-80382	VFSS2389	0
7	FLAMINGO	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	FLAMINGO\|NULL\|NULL	0	36.99	1	19.99	[empty string]	36.99	[empty string]	VELVET FAWN TOD 2PC JAMMIE SET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNTOD2PCJAMMIESET	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Velvet Fawn Tod 2pc Jammie Set	[empty string]	[empty string]	Y	19.99	19.99	4T	[empty string]	[empty string]	1000	1000	VFSS2390	80383	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-tod-2pc-jammie-set-80383	VFSS2390	0
8	WATERMELON	VELVET FAWN	Velvet Fawn	UNCATEGORIZED	Uncategorized	WATERMELON\|NULL\|NULL	0	44.99	1	29.99	[empty string]	44.99	[empty string]	VELVET FAWN INF LILIAN SWIMSUI	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5619	.VELVETFAWNLILIANSWIMSUIT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Velvet Fawn Inf Lilian Swimsui	[empty string]	[empty string]	Y	29.99	29.99	0/3M	[empty string]	[empty string]	1000	1000	VFSS2393	80384	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	velvet-fawn/velvet-fawn-inf-lilian-swimsui-80384	VFSS2393	0
9	[empty string]	GREAT DAY INC.	Great Day Inc.	UNCATEGORIZED	Uncategorized	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	GREAT DAY PFH250	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2301	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Great Day Pfh250	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	1000	PFH250	137189	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	great-day-inc/great-day-pfh250-137189	PFH250	0
10	[empty string]	LODGE MANUFACTURING	Lodge Manufacturing	UNCATEGORIZED	Uncategorized	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	LODGE EC8ST13 OYSTER TRIVET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1681	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Lodge Ec8st13 Oyster Trivet	[empty string]	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	1000	EC8ST13	215951	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lodge-manufacturing/lodge-ec8st13-oyster-trivet-215951	EC8ST13	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc