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	SAGE	BOB ALLEN	Bob Allen	UNCATEGORIZED	Uncategorized	SAGE\|NULL\|NULL	0	24.99	1	19.99	[empty string]	24.99	[empty string]	BOB ALLEN 240M SHOOTING VEST	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	240M..BOBALLEN240MSHOOTINGVEST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Bob Allen 240m Shooting Vest	[empty string]	[empty string]	Y	19.99	19.99	2XLARGE	[empty string]	[empty string]	1000	1000	240M	71479	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/bob-allen-240m-shooting-vest-71479	240M	0
2	MOSSYOAK_COUNTRY	FIELDLINE	Fieldline	UNCATEGORIZED	Uncategorized	MOSSYOAK_COUNTRY\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	FIELDLINE MATADOR BACKPACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	100	.FIELDLINEMATADORBACKPACK	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Fieldline Matador Backpack	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	1000	FCB037	73573	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fieldline/fieldline-matador-backpack-73573	FCB037	0
3	REALTREE_EDGE	FIELDLINE	Fieldline	UNCATEGORIZED	Uncategorized	REALTREE_EDGE\|NULL\|NULL	0	54.99	0	54.99	[empty string]	54.99	[empty string]	FIELDLINE RIDGE TRACKER BACKPA	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	100	.FIELDLINERIDGETRACKERBACKPA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Fieldline Ridge Tracker Backpa	[empty string]	[empty string]	N	54.99	54.99	[empty string]	[empty string]	[empty string]	1000	1000	FCB054	73574	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fieldline/fieldline-ridge-tracker-backpa-73574	FCB054	0
4	BLACK	FIELDLINE	Fieldline	HUNTING	Hunting>Bags>Tactical	BLACK\|NULL\|NULL	1	49.99	1	29.99	9556-DEFAULT-l.jpg	49.99	9556-DEFAULT-m.jpg	FIELDLINE ALPHA OPS DAY PACK	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	100	.FIELDLINEALPHAOPSDAYPACK	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Fieldline Alpha Ops Day Pack	<p><strong>DESCRIPTION:</strong></p><p>The Fieldline Alpha OPS daypack was designed for concealment and the tactically minded. Given the unique requirements of modern operators, the Alpha Ops has a built-in gear organizer, digital media pouch, integrated headset port and a fleece-lined sunglass pouch.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>- Hydration compatible pouch</li><li>- Velcro name-tape and patch holders</li><li>- Front panel with multiple MOLLE attachment points</li><li>- Heavy duty padded handle</li><li>- Dimensions: 17.25 (H) x 12.5 (W) x 6.5(D)</li><li>- Storage Capacity (Volume): 1,400 cu. in.</li></ul>	[empty string]	Y	29.99	29.99	[empty string]	9556-DEFAULT-s.jpg	[empty string]	1000	1000	TPB002	73575	TACTICAL	EMPTY	EMPTY	0	0	0	EMPTY	fieldline/fieldline-alpha-ops-day-pack-73575	TPB002	0
5	BROWN	BOB ALLEN	Bob Allen	UNCATEGORIZED	Uncategorized	BROWN\|NULL\|NULL	0	19.99	0	24.99	[empty string]	19.99	[empty string]	BOB ALLEN10544 SHOTGUNNR GLV	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Bob Allen10544 Shotgunnr Glv	[empty string]	[empty string]	N	24.99	24.99	MEDIUM	[empty string]	[empty string]	1000	1000	10544	91020	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/bob-allen10544-shotgunnr-glv-91020	10544	0
6	BROWN	BOB ALLEN	Bob Allen	UNCATEGORIZED	Uncategorized	BROWN\|NULL\|NULL	0	19.99	0	24.99	[empty string]	19.99	[empty string]	BOB ALLEN 10547 SHOTGUNNR GLV	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Bob Allen 10547 Shotgunnr Glv	[empty string]	[empty string]	N	24.99	24.99	XLARGE	[empty string]	[empty string]	1000	1000	10547	91021	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/bob-allen-10547-shotgunnr-glv-91021	10547	0
7	[empty string]	BOB ALLEN	Bob Allen	UNCATEGORIZED	Uncategorized	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	BOB ALLEN 1521 GLOVE MED	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Bob Allen 1521 Glove Med	[empty string]	[empty string]	N	16.99	16.99	MED	[empty string]	[empty string]	1000	1000	1521-2	91024	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/bob-allen-1521-glove-med-91024	1521-2	0
8	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting>Accessories>Gun Cases	[empty string]	1	14.99	0	14.99	10327-DEFAULT-l.jpg	14.99	10327-DEFAULT-m.jpg	BOB ALLEN BA650 SHOTGUN CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	Boyt Harness 16504 Classic Olive Green w/Khaki Panels 600D Nylon 48" Shotgun	[empty string]	[empty string]	N	14.99	14.99	48	10327-DEFAULT-s.jpg	[empty string]	1000	1000	16504	91027	GUN CASES	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-harness-16504-classic-olive-green-w-khaki-panels-600d-nylon-48-shotgun-91027	16504	0
9	[empty string]	BOB ALLEN	Bob Allen	SHOOTING	Shooting>Accessories>Gun Cases	[empty string]	1	14.99	0	14.99	10328-DEFAULT-l.jpg	14.99	10328-DEFAULT-m.jpg	BOB ALLEN BA650 SHOTGUN CASE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Boyt Harness 16504 Classic Olive Green w/Khaki Panels 600D Nylon 48" Shotgun	[empty string]	[empty string]	N	14.99	14.99	52	10328-DEFAULT-s.jpg	[empty string]	1000	1000	16505	91028	GUN CASES	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/boyt-harness-16504-classic-olive-green-w-khaki-panels-600d-nylon-48-shotgun-91028	16505	0
10	BRN	BOB ALLEN	Bob Allen	UNCATEGORIZED	Uncategorized	BRN\|NULL\|NULL	0	15.99	0	15.99	[empty string]	15.99	[empty string]	BOB ALLEN 27523 SHOOTING GLOVE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1026	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Bob Allen 27523 Shooting Glove	[empty string]	[empty string]	N	15.99	15.99	3XL	[empty string]	[empty string]	1000	1000	27523	91030	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bob-allen/bob-allen-27523-shooting-glove-91030	27523	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc