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]	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
10	BLACK	LODGE MANUFACTURING	Lodge Manufacturing	HUNTING	Hunting>Outdoor Recreation>Cookers	BLACK\|NULL\|NULL	1	69.99	0	69.99	8803-DEFAULT-l.jpg	69.99	8803-DEFAULT-m.jpg	LODGE L10CO3 4 QT CAMP OVEN	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]	5	50-to-100	0.00	[empty string]	Lodge 4 Quart Camp Dutch Oven With Lid	<ul><li>Flanged lid holds coals/briquettes</li><li>Legs on bottom allow Dutch oven to be put in fire</li><li>The bail handle is for use with a tripod</li><li>Flip lid to use as griddle</li></ul><p>Dutch ovens cast iron - camp lid/feet pre-seasoned cap. 4 quarts dia. 10 inch Provides even heat distribution. Flanged lid for hot coals inverts for use as griddle. Integral legs on oven for camp fire and fireplace cooking.</p><p>The Lodge portable"camp stove" is the pot that does it all. The flanged lid holds hot coals and inverts for use as a griddle. The integral legs allow the oven to sit ideally over hot coals. The bail handle is for use with a tripod. Provides even heat distribution. Flanged lid for hot coals inverts for use as griddle. Integral legs on oven for camp fire and fireplace cooking.</p>	[empty string]	N	69.99	69.99	4_QT	8803-DEFAULT-s.jpg	[empty string]	1000	1000	L10CO3	215953	EMPTY	EMPTY	EMPTY	0	0	0	OUTDOOR RECREATION	lodge-manufacturing/lodge-4-quart-camp-dutch-oven-with-lid-215953	L10CO3	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc