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	[empty string]	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Youth	[empty string]	1	99.99	0	99.99	2747-DEFAULT-l.jpg	99.99	2747-DEFAULT-m.jpg	DRYSHOD YTH ARTIC STORM BOOTOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODYTHARTICSTORMBOOTOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	24	50-to-100	0.00	[empty string]	Dryshod Artic Storm Kid's Winter Boot (Camo/Timber)	<p>Extreme-Cold Conditions Boot, Extra layers of rugged protection for active kids! Comfort, warmth and stability for all-day play even on the coldest days.</p><ul><li>DS1 molded outsole - outer and inner grip</li><li>6 layers of protection</li><li>Extra layers of insulating warmth and protection! 5.5 mm bootie; 2.5 mm DENSOPRENE XD foam (extreme density) for extra protection; 2 mm airmesh; 2 mm warm fleece lining</li><li>Removable molded EVA sockliner</li><li>Double achilles heel and instep reinforcement for comfort and protection</li><li>Nylon shank</li></ul><p><strong>100% WATERPROOF</strong><br />Designed and built to be 100% waterproof from top to bottom.<br /></p><p><strong>5 mm DENSOPRENE FOAM INSULATED BOOTIE</strong><br />Keeps out the cold & wet. Keeps in the warm & dry.<br /></p><p><strong>HYDROKOTE WATER-REPELLENT</strong><br />No more soggy boots. Water rolls off and dries in seconds.<br /></p><p><strong>4-WAY STRETCH BREATHABLE AIRMESH LINING</strong><br />Moves the air to keep your feet dry and comfortable.<br /></p><p><strong>EASY-ON/EASY-OFF</strong><br />4-way stretch materials and generous heel kick for easy-on/easy-off convenience.<br /></p><p><strong>ROLL-DOWN CALF PIPE</strong><br />Roll down the top to tuck in your pant leg or vent in warm temperatures.<br /></p><p><strong>GENUINE NATURAL-RUBBER OVERLAYS</strong><br />Only genuine hand-laid rubber. No PVC, PU, or TPR.<br /></p><p><strong>SUPERIOR STABILITY</strong><br />Reinforced tuck board with rigid shanks for added stability.<br /></p><p><strong>SUPERIOR FIT AND COMFORT</strong><br />Slipper-soft comfort and sized to athletic-shoe standards.<br /></p><p><strong>CONVENIENT BACK-PULL TABS</strong><br />Sturdy pull tabs for easy-on/easy-off convenience and safety.</p>	[empty string]	N	99.99	99.99	1,12,13,11,2,3,4,5	2747-DEFAULT-s.jpg	[empty string]	1000	1000	ARS-KD-CM	73074	YOUTH	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-artic-storm-kid-s-winter-boot-camo-timber-73074	ARS-KD-CM	0
2	[empty string]	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Men	[empty string]	1	144.99	0	154.99	2741-DEFAULT-l.jpg	144.99	2741-DEFAULT-m.jpg	DRYSHOD MNS HAYMAKER HI BOOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSHAYMAKERHIBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	150-to-200	0.00	[empty string]	Dryshod Haymaker Men's Hard-Working Hi Boot (Brown/Peanut)	<p>Hard-Working Farm Boot, Tough conditions call for a tough boot - the Haymaker is ideal for messy, rugged outdoor terrain!</p><p>Hard-Working Farm Boots</p><p>Tough conditions call for a tough boot - the Haymaker is ideal for messy, rugged outdoor terrain!</p><ul><li>DS1 molded outsole for grip on rugged terrain</li><li>Compression molded non-pigmented gum rubber outsole</li><li>EVA mid-sole for comfort and cold-block</li><li>Removable molded EVA sockliner</li><li>Nylon shank</li><li>Comfort Range: -20 F to 75 F</li></ul><p><strong>100% WATERPROOF</strong><br />Designed and built to be 100% waterproof from top to bottom.<br /></p><p><strong>5 mm DENSOPRENE FOAM INSULATED BOOTIE</strong><br />Keeps out the cold & wet. Keeps in the warm & dry.<br /></p><p><strong>HYDROKOTE WATER-REPELLENT</strong><br />No more soggy boots. Water rolls off and dries in seconds.<br /></p><p><strong>4-WAY STRETCH BREATHABLE AIRMESH LINING</strong><br />Moves the air to keep your feet dry and comfortable.<br /></p><p><strong>EASY-ON/EASY-OFF</strong><br />4-way stretch materials and generous heel kick for easy-on/easy-off convenience.<br /></p><p><strong>ROLL-DOWN CALF PIPE</strong><br />Roll down the top to tuck in your pant leg or vent in warm temperatures.<br /></p><p><strong>GENUINE NATURAL-RUBBER OVERLAYS</strong><br />Only genuine hand-laid rubber. No PVC, PU, or TPR.<br /></p><p><strong>SUPERIOR STABILITY</strong><br />Reinforced tuck board with rigid shanks for added stability.<br /></p><p><strong>SUPERIOR FIT AND COMFORT</strong><br />Slipper-soft comfort and sized to athletic-shoe standards.<br /></p><p><strong>CONVENIENT BACK-PULL TABS</strong><br />Sturdy pull tabs for easy-on/easy-off convenience and safety.</p>	[empty string]	N	154.99	154.99	10,13,11,8,9	2741-DEFAULT-s.jpg	[empty string]	1000	1000	HAY-MH-BR	73075	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-haymaker-men-s-hard-working-hi-boot-brown-peanut-73075	HAY-MH-BR	0
3	KHAKI_TIMBER	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Men	KHAKI_TIMBER\|NULL\|NULL	1	104.99	0	104.99	2735-DEFAULT-l.jpg	104.99	2735-DEFAULT-m.jpg	DRYSHOD MNS LEGEND ANKLE BOOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSLEGENDANKLEBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	100-to-150	0.00	[empty string]	Dryshod Men's Legend Camp Boots	<p>Camp Ankle Boot, When you don't need a tall boot, but still need protection, the Legend Camp Ankle Boot is ideal. It's like stepping into your favorite slippers.</p><p>Calendared outsole</p><p>Steel shank for added arch support</p><p>Comfort range: -10 F to 75 F</p><p><strong>100% WATERPROOF</strong><br />Designed and built to be 100% waterproof from top to bottom.<br /></p><p><strong>5 mm DENSOPRENE FOAM INSULATED BOOTIE</strong><br />Keeps out the cold & wet. Keeps in the warm & dry.<br /></p><p><strong>HYDROKOTE WATER-REPELLENT</strong><br />No more soggy boots. Water rolls off and dries in seconds.<br /></p><p><strong>4-WAY STRETCH BREATHABLE AIRMESH LINING</strong><br />Moves the air to keep your feet dry and comfortable.<br /></p><p><strong>EASY-ON/EASY-OFF</strong><br />4-way stretch materials and generous heel kick for easy-on/easy-off convenience.<br /></p><p><strong>ROLL-DOWN CALF PIPE</strong><br />Roll down the top to tuck in your pant leg or vent in warm temperatures.<br /></p><p><strong>GENUINE NATURAL-RUBBER OVERLAYS</strong><br />Only genuine hand-laid rubber. No PVC, PU, or TPR.<br /></p><p><strong>SUPERIOR STABILITY</strong><br />Reinforced tuck board with rigid shanks for added stability.<br /></p><p><strong>SUPERIOR FIT AND COMFORT</strong><br />Slipper-soft comfort and sized to athletic-shoe standards.<br /></p><p><strong>CONVENIENT BACK-PULL TABS</strong><br />Sturdy pull tabs for easy-on/easy-off convenience and safety.</p>	[empty string]	N	104.99	104.99	12,13,9	2735-DEFAULT-s.jpg	[empty string]	1000	1000	LGD-MA-KH	73077	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-men-s-legend-camp-boots-73077	LGD-MA-KH	0
4	MOSS_GREEN	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Men	MOSS_GREEN\|NULL\|NULL	1	129.99	0	129.99	4053-DEFAULT-l.jpg	129.99	4053-DEFAULT-m.jpg	DRYSHOD MNS LEGEND HI BOOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSLEGENDHIBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	100-to-150	0.00	[empty string]	Dryshod Legend Hi Men's Adventure Boots - Moss Green	<p><strong>Steel shank for added arch support</strong></p><p><strong>Comfort range: -10 F to 75 F</strong></p><p><strong>"Calendar" soles</strong> are made by running a continuous sheet of uncured rubber through a dual-roller press. The top roller is etched with a tread pattern while the bottom roller is smooth. Once pressed, the soles are hand cut on a template with a hot knife. The uncured soles are then applied to the upper boot and vulcanized together to form a seamless permanent chemical bond. The calendar soles on all DRYSHOD models are clad over with a rigid puncture-resistant tuck board with steel shank and latex-sponge heel wedge. Calendar soles can be cut in a variety of shapes and contours to suit the use of the model. The inherent low center of gravity on calendar soles provides excellent stability on uneven terrain.</p><p><strong>100% WATERPROOF</strong><br />Designed and built to be 100% waterproof from top to bottom.<br /></p><p><strong>5 mm DENSOPRENE FOAM INSULATED BOOTIE</strong><br />Keeps out the cold & wet. Keeps in the warm & dry.<br /></p><p><strong>HYDROKOTE WATER-REPELLENT</strong><br />No more soggy boots. Water rolls off and dries in seconds.<br /></p><p><strong>4-WAY STRETCH BREATHABLE AIRMESH LINING</strong><br />Moves the air to keep your feet dry and comfortable.<br /></p><p><strong>EASY-ON/EASY-OFF</strong><br />4-way stretch materials and generous heel kick for easy-on/easy-off convenience.<br /></p><p><strong>ROLL-DOWN CALF PIPE</strong><br />Roll down the top to tuck in your pant leg or vent in warm temperatures.<br /></p><p><strong>GENUINE NATURAL-RUBBER OVERLAYS</strong><br />Only genuine hand-laid rubber. No PVC, PU, or TPR.<br /></p><p><strong>SUPERIOR STABILITY</strong><br />Reinforced tuck board with rigid shanks for added stability.<br /></p><p><strong>SUPERIOR FIT AND COMFORT</strong><br />Slipper-soft comfort and sized to athletic-shoe standards.<br /></p><p><strong>CONVENIENT BACK-PULL TABS</strong><br />Sturdy pull tabs for easy-on/easy-off convenience and safety.</p>	[empty string]	N	129.99	129.99	8,10,12,9,7	4053-DEFAULT-s.jpg	[empty string]	1000	1000	LGX-MH-MS	73078	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-legend-hi-men-s-adventure-boots-moss-green-73078	LGX-MH-MS	0
5	CAMO	DRYSHOD WEST	Dryshod West	UNCATEGORIZED	Uncategorized	CAMO\|NULL\|NULL	1	159.99	0	174.99	4037-DEFAULT-l.jpg	159.99	4037-DEFAULT-m.jpg	DRYSHOD MNS SOUTHLAND VEIL CAM	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSSOUTHLANDVEILCAM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	18	150-to-200	0.00	[empty string]	Dryshod Men's Southland Veil Camo	<p>Southland Men's Hunting Boot<br />WIXIT Cool-Clad lining provides all day comfort in warmer hunting conditions.</p><ul><li>Features WIXIT Cool-Clad wicking airmesh lining with added micro-dot perforations. Wicks away moisture and allows the air to flow more than traditional airmesh. Keeps the foot cooler in warmer temperatures.</li><li>DS1 molded outsole - outer and inner grip</li><li>4 mm neoprene bootie</li><li>Removable molded EVA sockliner</li><li>Double achilles heel and instep reinforcement for comfort and protection</li><li>Genuine VEIL Whitetail camouflage print</li><li>Nylon shank</li></ul>	[empty string]	N	174.99	174.99	11,12,14,10,7,8,9,13	4037-DEFAULT-s.jpg	[empty string]	1000	1000	STH-MH-CM	73079	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-men-s-southland-veil-camo-73079	STH-MH-CM	0
6	DARK_GREEN	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Men	DARK_GREEN\|NULL\|NULL	1	139.99	0	139.99	2755-DEFAULT-l.jpg	139.99	2755-DEFAULT-m.jpg	DRYSHOD MNS TEEBEEDEE BOOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSTEEBEEDEEBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	74	100-to-150	0.00	[empty string]	Dryshod Men's Teebeedee Boots	<p><strong>100% WATERPROOF</strong><br />Designed and built to be 100% waterproof from top to bottom.<br /></p><p><strong>5 mm DENSOPRENE FOAM INSULATED BOOTIE</strong><br />Keeps out the cold & wet. Keeps in the warm & dry.<br /></p><p><strong>HYDROKOTE WATER-REPELLENT</strong><br />No more soggy boots. Water rolls off and dries in seconds.<br /></p><p><strong>4-WAY STRETCH BREATHABLE AIRMESH LINING</strong><br />Moves the air to keep your feet dry and comfortable.<br /></p><p><strong>EASY-ON/EASY-OFF</strong><br />4-way stretch materials and generous heel kick for easy-on/easy-off convenience.<br /></p><p><strong>ROLL-DOWN CALF PIPE</strong><br />Roll down the top to tuck in your pant leg or vent in warm temperatures.<br /></p><p><strong>GENUINE NATURAL-RUBBER OVERLAYS</strong><br />Only genuine hand-laid rubber. No PVC, PU, or TPR.<br /></p><p><strong>SUPERIOR STABILITY</strong><br />Reinforced tuck board with rigid shanks for added stability.<br /></p><p><strong>SUPERIOR FIT AND COMFORT</strong><br />Slipper-soft comfort and sized to athletic-shoe standards.<br /></p><p><strong>CONVENIENT BACK-PULL TABS</strong><br />Sturdy pull tabs for easy-on/easy-off convenience and safety.</p>	[empty string]	N	139.99	139.99	13,11,9,8,12,10,7,14	2755-DEFAULT-s.jpg	[empty string]	1000	1000	TBD-MH-DG	73081	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-men-s-teebeedee-boots-73081	TBD-MH-DG	0
7	EDGE	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Men	EDGE\|NULL\|NULL	1	159.99	0	159.99	15287-DEFAULT-l.jpg	159.99	15287-DEFAULT-m.jpg	DRYSHOD MNS TEEBEEDEE BOOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSTEEBEEDEEBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25	150-to-200	0.00	[empty string]	Dryshod Men's Teebeedee Boots	<p><strong>100% WATERPROOF</strong><br />Designed and built to be 100% waterproof from top to bottom.<br /></p><p><strong>5 mm DENSOPRENE FOAM INSULATED BOOTIE</strong><br />Keeps out the cold & wet. Keeps in the warm & dry.<br /></p><p><strong>HYDROKOTE WATER-REPELLENT</strong><br />No more soggy boots. Water rolls off and dries in seconds.<br /></p><p><strong>4-WAY STRETCH BREATHABLE AIRMESH LINING</strong><br />Moves the air to keep your feet dry and comfortable.<br /></p><p><strong>EASY-ON/EASY-OFF</strong><br />4-way stretch materials and generous heel kick for easy-on/easy-off convenience.<br /></p><p><strong>ROLL-DOWN CALF PIPE</strong><br />Roll down the top to tuck in your pant leg or vent in warm temperatures.<br /></p><p><strong>GENUINE NATURAL-RUBBER OVERLAYS</strong><br />Only genuine hand-laid rubber. No PVC, PU, or TPR.<br /></p><p><strong>SUPERIOR STABILITY</strong><br />Reinforced tuck board with rigid shanks for added stability.<br /></p><p><strong>SUPERIOR FIT AND COMFORT</strong><br />Slipper-soft comfort and sized to athletic-shoe standards.<br /></p><p><strong>CONVENIENT BACK-PULL TABS</strong><br />Sturdy pull tabs for easy-on/easy-off convenience and safety.</p>	[empty string]	N	159.99	159.99	10,9,11,7,8,13,14	15287-DEFAULT-s.jpg	[empty string]	1000	1000	TBD-MH-RTE	73082	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-men-s-teebeedee-boots-73082	TBD-MH-RTE	0
8	EDGE	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Women	EDGE\|NULL\|NULL	1	149.99	0	149.99	15292-DEFAULT-l.jpg	149.99	15292-DEFAULT-m.jpg	DRYSHOD WMS TEEBEEDEE BOOT	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODWMSTEEBEEDEEBOOT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	100-to-150	0.00	[empty string]	Dryshod Women's Teebeedee Boot	[empty string]	[empty string]	N	149.99	149.99	10,11,6	15292-DEFAULT-s.jpg	[empty string]	1000	1000	TBD-WH-RTE	73084	WOMEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-women-s-teebeedee-boot-73084	TBD-WH-RTE	0
9	CAMO	DRYSHOD WEST	Dryshod West	CLOTHING	Clothing>Footwear>Men	CAMO\|NULL\|NULL	1	179.99	0	199.99	4043-DEFAULT-l.jpg	179.99	4043-DEFAULT-m.jpg	DRYSHOD MNS VIPER STOP SNAKE B	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5340	.DRYSHODMNSVIPERSTOPSNAKEB	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	150-to-200	0.00	[empty string]	Dryshod Men's Viper Stop Snake Boots	<p>Snake Hunting Boot With Gusset</p><p>Snake-protection and adjustable gusset provide all day comfort while hunting.</p><ul><li>Hand-laid penetration-resistant rubber from top to bottom</li><li>Features WIXIT Cool-Clad wicking airmesh lining with added micro-dot perforations. Wicks away moisture and allows the air to flow more than traditional airmesh. Keeps the foot cooler in warmer temperatures. Less scent helps you stay undetected by snakes.</li><li>2"" taller than our other models for extra protection from the elements, brush and debris</li><li>Adjustable Gusset Style - customize to fit larger calves for optimum comfort and protection with our expandable gusset and adjustable locking strap. Extra room also accommodates layers of clothing being tucked into the boot.</li><li>DS1 molded outsole - outer and inner grip</li><li>Removable molded EVA sockliner</li><li>Double achilles heel and instep reinforcement for comfort and protection</li><li>Genuine VEIL camouflage print</li><li>Nylon shank</li></ul>	[empty string]	N	199.99	199.99	9,13,14,8,7	4043-DEFAULT-s.jpg	[empty string]	1000	1000	VPS-MH-CM	73086	MEN	EMPTY	EMPTY	0	0	0	FOOTWEAR	dryshod-west/dryshod-men-s-viper-stop-snake-boots-73086	VPS-MH-CM	0
10	EDGE	HOYT USA	Hoyt Usa	ARCHERY	Archery>Compound Bow	EDGE\|NULL\|NULL	1	699.99	0	699.99	6296-DEFAULT-l.jpg	699.99	6296-DEFAULT-m.jpg	HOYT TORREX XT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	140	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Hoyt Torrex Xt	[empty string]	[empty string]	N	699.99	699.99	60LBS	6296-DEFAULT-s.jpg	[empty string]	1000	1000	1049214	107898	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hoyt-usa/hoyt-torrex-xt-107898	1049214	0

CACHED

false

EXECUTIONTIME

SQL

SELECT top 10 style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products WHERE 1=1 --AND pictureid is not null AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS