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]	DEAD DOWN WIND	Dead Down Wind	HUNTING	Hunting>Scent Elimination	[empty string]	1	6.99	0	9.99	8372-DEFAULT-l.jpg	6.99	8372-DEFAULT-m.jpg	DEAD DOWN WIND 11913	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2806	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Dead Down Wind Dryer Sheets - Natural Woods	<p>Dead Down Wind's Dryer Sheets deliver odor elimination coupled with anti-static performance - that's why they are wet coming out of the package. If you are using a regular dry sheet, then it probably isn't doing anything for odor elimination. DDW's Dryer Sheets are the only biodegradable dryer sheet on the market.</p><p>Enzyme ScentPrevent Technology is effective in eliminating a wider range of odors, while the addition of Natural Woods scent creates a distinct forest floor aroma for a familiar smell.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>8" x 7" sheets saturate</li><li>Anti-Static Guard built in</li><li>Treats up to 15 loads</li><li>DDW dryer sheets are biodegradable</li><li>Natural forest aroma</li><li>Size: 15 Count</li></ul>	[empty string]	N	9.99	9.99	[empty string]	8372-DEFAULT-s.jpg	[empty string]	1000	1000	11913	132002	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	dead-down-wind/dead-down-wind-dryer-sheets-natural-woods-132002	11913	0
10	[empty string]	DEAD DOWN WIND	Dead Down Wind	HUNTING	Hunting>Scent Elimination	[empty string]	1	9.99	0	9.99	8374-DEFAULT-l.jpg	9.99	8374-DEFAULT-m.jpg	DEAD DOWN WIND 1192018	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2806	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	5-to-10	0.00	[empty string]	Dead Down Wind Laundry Detergent - 20 Oz. Natural Woods	<p>Dead Down Wind's Laundry Detergent features Enzyme ScentPrevent Technology. As the only triple action laundry detergent on the market, Dead Down Wind's Laundry Detergent cleans, deodorizes & helps extend the life of the garments to keep you field ready.</p><p>Enzyme ScentPrevent Technology is effective in eliminating a wider range of odors, while the addition of Natural Woods scent creates a distinct forest floor aroma for a familiar smell.</p>	[empty string]	N	9.99	9.99	[empty string]	8374-DEFAULT-s.jpg	[empty string]	1000	1000	1192018	132003	EMPTY	EMPTY	EMPTY	0	0	0	SCENT ELIMINATION	dead-down-wind/dead-down-wind-laundry-detergent-20-oz-natural-woods-132003	1192018	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc