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]	LAZYMAN	Lazyman	HUNTING	Hunting	[empty string]	1	1599.99	0	1599.99	11599-DEFAULT-l.jpg	1599.99	11599-DEFAULT-m.jpg	LAZYMAN TROPHY HUNT COMBO ALL DAMAGED	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5058	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Lazyman Trophy Hunt Combo	<p>DESCRIPTION:</p><p>Lazyman's new Trophy Hut Stand was created for the serious hunter and will change the way you hunt! Total concealment, scent deterring, fiberglass stands are indestructable. These models have 8 of Lazyman's patented injection-molded windows that are built for quiet and ease of use. These stand will ship in a box ready for assembly.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Dimensions and Weight</li><li>60 " X 60 " X 76 " at 180 lbs.</li><li>Windows</li><li>Each blind, depending on specific model comes with 4 injection molded windows.</li><li>- Bow Windows Dimensions = 13.75" x 23.35" placed 27" from the bottom of the stand.</li></ul>	[empty string]	N	1599.99	1599.99	[empty string]	11599-DEFAULT-s.jpg	[empty string]	1000	1000	TROPHY HUNT	200649	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lazyman/lazyman-trophy-hunt-combo-200649	TROPHY HUNT	0
2	[empty string]	THE BLYND	The Blynd	HUNTING	Hunting	[empty string]	1	399.99	0	399.99	4193-DEFAULT-l.jpg	399.99	4193-DEFAULT-m.jpg	THE BLYND TOWER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1231	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	350-to-400	0.00	[empty string]	The Blynd 10' 4x4 Tower	<p><strong>THIS ITEM CAN BE PURCHASED IN-STORE ONLY</strong></p><p>Construction: Made of EMT conduit.<br />Legs are 1-1/2" in diameter and the cross-bracings are 1" in diameter.<br />Towers will easily support 500 lbs.<br />The Blynd and Towers require a tie-down system to secure them. See our tie-downs here.<br />Ease of Use:<br />The Blynd Towers come with assembly instructions and hardware.<br />A tower should be able to be assembled within 1 - 2 hours by two people. You will need to supply an open end " socket wrench and a deep " socket wrench.</p>	[empty string]	N	399.99	399.99	10_FT	4193-DEFAULT-s.jpg	[empty string]	1000	1000	3050	209171	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	the-blynd/the-blynd-10-4x4-tower-209171	3050	0
3	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	249.99	1	199.99	7335-DEFAULT-l.jpg	249.99	7335-DEFAULT-m.jpg	FOX PRO GUNFIRE KIT G/W/IR	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	FoxPro Gun Fire Hunting Light Kit - GREEN/WHITE/IR	<p>The FOXPRO Gunfire Kit is the perfect choice for nighttime predator hunters. This all-in-one gun mounted light kit comes complete with the Gunfire light, (2) 18650 batteries, 18650 advanced battery charger, wall plug/USB charge cord, car charger adapter, wired "quick access" gun stock remote, scope/light mounting bracket, pistol grip light holder, and (2) extension shrouds. The light and accessories all pack up neatly into the included EVA foam soft shell kit with a handle so you can safely take your light on the go. The Gunfire light is a quick color change, 3 color LED predator hunting light, using the brightest LED's available today. The Gunfire is all metal construction, yet extremely lightweight so it can handle the toughest in-field use while adding as little weight as possible to your setup. Quickly switch between the 3-color LED's by rotating the color selector switch without having to take your eye out of the gun. Turn the light on and off or adjust the brightness of the light by operating the dimmer switch on the tail cap. Focus the beam to a specific spot or open it up to flood the field by rotating the beam focus ring at the end of the light. Keep the light off of your gun and better concealed by screwing on the included metal shroud(s) to the end of the lens of the Gunfire. The FOXPRO Gunfire Kit is backed by a 3 year LED replacement warranty, a 1 year tail cap and accessories warranty, and FOXPRO's unmatched customer support.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>3 color LED selection: GREEN/WHITE/IR</li><li>Brightness control</li><li>Focus ring</li><li>(2) 18650 batteries</li><li>18650 advanced battery charger</li><li>Wall plug/USB charge cord</li><li>Car charger adapter</li><li>Wired quick access gun stock remote</li><li>Scope/light mounting bracket</li><li>Pistol grip light holder</li><li>(2) Extension shrouds</li><li>EVA foam soft shell case</li><li>3 year LED replacement warranty</li><li>1 year tail cap and accessories warranty</li></ul>	[empty string]	Y	199.99	199.99	[empty string]	7335-DEFAULT-s.jpg	[empty string]	1000	1000	GUNFIRE KITG	230078	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/foxpro-gun-fire-hunting-light-kit-green-white-ir-230078	GUNFIRE KITG	0
4	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	659.99	1	499.99	6344-DEFAULT-l.jpg	659.99	6344-DEFAULT-m.jpg	FOX PRO DIGITAL GAME CALL CLOSEOUT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	450-to-500	0.00	[empty string]	Foxpro Snow Pro Digital Game Call	<p>Bring those circling snow geese and crows within gun range, with the compact and powerful SNOW PRO from FOXPRO. This caller comes standard with 75 high quality FOXPRO sounds and can store and access up to 300 sounds. The SNOW PRO comes with 37 of the most proven snow goose sounds, 29 predator sounds, and 9 crow sounds. The SNOW PRO is powered by an 11.1 lithium battery pack (battery and charger included). The SNOW PRO comes with two 10 watt external speakers and allows you to connect up to four external speakers, which have heavy duty connector plugs to hold up in the worst conditions. The SNOW PRO is USB reprogrammable and offers the ability to add an external battery source for extended run times. The SNOW PRO remote offers long range control and comes standard with an elastomeric keypad to make operation easier when wearing gloves.</p><p>The Snow Pro is backed by a 5 year limited warranty and FOXPRO's unmatched customer support and is proudly made in the USA.</p><p><br /><strong>Feature Highlights</strong></p><ul><li>Comes with 37 waterfowl, 9 crow, and 29 predator sounds (Holds 300 sounds)</li><li>4 External speaker jacks</li><li>Auxiliary jack</li><li>Rugged and compact housing</li><li>Power/Low battery indicator</li><li>Operates on (1) Sealed Lithium kit</li><li>USB port to reprogram sounds</li></ul>	[empty string]	Y	499.99	499.99	[empty string]	6344-DEFAULT-s.jpg	[empty string]	1000	1000	SNOWPRO	230087	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/foxpro-snow-pro-digital-game-call-230087	SNOWPRO	0
5	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	999.99	1	749.99	13722-DEFAULT-l.jpg	999.99	13722-DEFAULT-m.jpg	FOX PRO SSCPW CLOSEOUT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Foxpro Super Snow-Crow Pro \| Attracts Crow/Predator/Snow Goose Features TX1000 Transmitter	<p><strong>DESCRIPTION:</strong></p><p>SUPER SNOW CROW PRO-W Bring those circling snow geese and crows within gun range, with the extreme volume capabilities of the SUPER SNOW CROW PRO-W from FOXPRO. This caller comes standard with 100 high quality FOXPRO sounds and can store and access up to 1000 sounds. The SSCP-W (Super Snow Crow Pro[1]W) is powered by two 12 volt gel cell batteries. The SSCP-W comes with two 30 watt external speakers and allows you to connect up to four external speakers, which have heavy duty connector plugs to hold up in the worst conditions. The SSCP-W comes standard with the TX-1000 remote control. The TX-1000 features a full color graphic LCD screen which displays your sound list or sound categories, has a barometer indicator, moon phase indicator, temperature indicator, battery level indicator, timer or time clock, FOXBANG technology and much more. FOXMotion allows you to fade the sound from the left speakers to the right speakers to help "sell" the reality of your call sounds. FOXFusion allows you to mix and match any two sounds at the same time during your calling sequence. FOXPitch allows you to manipulate the "pitch" of the sound in an effort to trigger a response. FOXData allows you to record real time information from each and every hunt so you can access the data for future reference. The Super Snow Crow Pro-W is backed by a 5 year limited warranty and FOXPRO's unmatched customer support and is proudly made in the USA</p>	[empty string]	Y	749.99	749.99	[empty string]	13722-DEFAULT-s.jpg	[empty string]	1000	1000	SSCPW	230088	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/foxpro-super-snow-crow-pro-attracts-crow-predator-snow-goose-features-tx1000-transmitter-230088	SSCPW	0
6	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	549.99	0	549.99	4117-DEFAULT-l.jpg	549.99	4117-DEFAULT-m.jpg	FOX PRO X24	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	500-or-more	0.00	[empty string]	FoxPro X24 Digital Game Call	<p>The FOXPRO X24 is a powerful and compact unit that features a positional Xtreme High Definition (XHD) speaker. The XHD speaker is a horn speaker with an added tweeter for improved frequency response. The XHD speaker system allows for extreme volume capabilities and realistic sound clarity. The X24's handle folds out into a positional stand to provide elevation over various terrains that you might encounter. There is 1 external speaker jack if you desire even more volume, an auxiliary jack to connect an approved device such as a Jack Predator Decoy, and a charge jack. The X24 comes with 100 high-quality FOXPRO sounds and over 100 sounds from FOXPRO's Free Sound Library, with the ability to store and access up to 1000 sounds. The X24 comes complete with a lithium battery and charger kit in the box!</p><p>The TX-1000 features a full color graphic LCD screen, which displays your sound list or sound categories. It also has a barometer indicator, moon phase indicator, temperature indicator, battery level indicator, timer or time clock, FOXBANG technology and much more. FOXMotion allows you to fade the sound from the left speakers to the right speakers to help "sell" the reality of your call sounds. FOXCast allows you to play a pre-set custom sequence to include your favorite sounds, volume levels, and even pauses. FOXData allows you to record real time information from each and every stand so you can access the data for future reference. The X24 is backed by a 5 year limited warranty and FOXPRO's unmatched customer support and is proudly made in the USA.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>FOXBANG: Automatically maps your caller to a predetermined setting after discharging your firearm. (See instruction manual for FOXBANG options.)</li><li>FOXMOTION: Mimic moving prey by fading sound from left speaker to right one.</li><li>FOXDATA: Activate FOXDATA and it records real time information (temp, barometer, moon phase, stand duration, shot time) from each stand. Over time you will be able to predict animal activity/hunting success based on hard data.</li><li>FOXCAST: Virtually hands-free calling with FOXCAST sequence files.</li><li>AUTO VOLUME: Automatically ramps up and modulates your volume.</li></ul>	[empty string]	N	549.99	549.99	[empty string]	4117-DEFAULT-s.jpg	[empty string]	1000	1000	X24	230093	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/foxpro-x24-digital-game-call-230093	X24	0
7	[empty string]	RAYOVAC	Rayovac	HUNTING	Hunting	[empty string]	1	9.99	0	11.99	10475-DEFAULT-l.jpg	9.99	10475-DEFAULT-m.jpg	RAYOVAC 8244J	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Rayovac 9V Alkaline \| 2 Pack	<p><strong>DESCRIPTION:</strong></p><p>Customers look for Rayovac alkaline batteries because they give them more power for their money everyday. Rayovac traditional carded packs come in small packages great to capture impulse purchases as well as to provide power but take up little space.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Rayovac</li><li>Category Batteries</li><li>Model 9V</li><li>Series Alkaline 9V</li><li>Size 9V</li><li>ANSI NEDA 1604A</li><li>Charge Time N / A</li><li>Chemical Composition Alkaline</li><li>Configuration Battery Stick</li><li>Nominal Voltage 9 Volt</li><li>Quantity 2</li><li>Rated Capacity mAh 565</li></ul>	[empty string]	N	11.99	11.99	[empty string]	10475-DEFAULT-s.jpg	[empty string]	1000	1000	8244J	234908	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	rayovac/rayovac-9v-alkaline-2-pack-234908	8244J	0
8	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	279.99	1	269.99	22623-DEFAULT-l.jpg	279.99	22623-DEFAULT-m.jpg	FOX PRO HELLCAT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	Fox Pro Hellcat Digital Game Caller	<p>The Foxpro Hellcat is a small and portable all-in-one digital game caller/decoy that comes standard with 175+ high-quality Foxpro sounds that cover a variety of species' distress sounds and vocalizations and the unit can store up to 300 sounds. Its upgraded remote has a larger LCD screen than previous entry-level models, making screen navigation simple and easy to read. The company's popular Bluebird Topper decoy adds realism to the setup, providing visual confirmation to wary predators. The Hellcat weighs only 2.2 pounds with batteries, which makes it easy to transport, and its remote is easy to operate and navigate through the sound categories, allowing the user to quickly change sounds while hunting. It has an easy to press elastomeric keypad with two user buttons, a mute button, volume up and down buttons and more. The user buttons can be set to a preselected sound or an auxiliary function. The made-in-the-USA Foxpro Hellcat has an auxiliary jack to add additional approved devices (sold separately) and is backed by a three-year limited warranty and unmatched customer support.</p>	[empty string]	Y	269.99	269.99	[empty string]	22623-DEFAULT-s.jpg	[empty string]	1000	1000	HELLCAT	242192	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/fox-pro-hellcat-digital-game-caller-242192	HELLCAT	0
9	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	399.99	0	399.99	22624-DEFAULT-l.jpg	399.99	22624-DEFAULT-m.jpg	FOX PRO HELLCAT PRO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	350-to-400	0.00	[empty string]	Fox Pro Hellcat Pro	<p>The FOXPRO Hellcat Pro is an all-in-one decoy and digital game call that's small and portable while delivering big volume. One of the industry's most popular remotes is included, the TX-1000, making it a great choice for both beginner and more advanced hunters. It comes standard with 200+ sounds that cover a variety of species, distress sounds, and vocalizations and can store up to 1000 sounds. With our popular bluebird topper, the decoy adds realism to your stand, giving visual confirmation to weary predators. It has an auxiliary jack to add additional approved devices (sold separately). The Hellcat Pro comes with a lithium battery and charger kit in the box! The TX-1000 features a full-color graphic LCD screen, which displays your sound list or sound categories. It also has auto-volume, wireless upload to the remote, a battery level indicator, timer or time clock, FOXCast, and FOXBang technology. The Hellcat Pro is backed by a 5-year limited warranty, FOXPRO's unmatched customer support, and is proudly made in the USA.</p><p> </p>	[empty string]	N	399.99	399.99	[empty string]	22624-DEFAULT-s.jpg	[empty string]	1000	1000	HELLCAT PRO	242193	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/fox-pro-hellcat-pro-242193	HELLCAT PRO	0
10	[empty string]	FOX PRO GAME CALLS	Fox Pro Game Calls	HUNTING	Hunting	[empty string]	1	99.99	0	99.99	24178-DEFAULT-l.jpg	99.99	24178-DEFAULT-m.jpg	FOX PRO X DECOY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3242	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	32	50-to-100	0.00	[empty string]	Foxpro X-Decoy Predator Decoy \| Multi Color Compatible With FoxPro X-Series except XWave	<p>The X-Decoy from FOXPRO turns your X-Series game call into an all-inclusive and portable predator-calling machine. Attach the decoy to the top of your X-Series call (must use as a stand-alone if using with XWAVE) and connect the decoy to the call by using the supplied Aux cable or wireless IR port connection (IR only available in later X-Series call models). The X-Decoy may also be used along with any other FOXPRO call (that has an aux jack) as a separate stand-alone decoy. Simply screw the included stake into the bottom of the decoy body and connect the decoy to your FOXPRO unit via the included Aux cord and Aux Jacks. The X-Decoy gives predators the visual confirmation they're looking for and listening for! It comes standard with a removable stake, Fuzzy Wuzzy topper, XHD speaker mounting hinge, and included allen wrench for assembly, stowed in the battery compartment. This decoy has a whisper quiet motor and Jacked Up Chaotic Motion for great action and realism. The X-Decoy has a 3 position switch that features 2 speed selectable motion (Off, High Speed, and Slow Speed) and is powered by 4AA batteries (not included). The X-Decoy is backed by a 1 year limited warranty and FOXPRO's unmatched customer support and is proudly made in the USA.</p><p><strong>Feature Highlights</strong></p><ul><li>Jacked-Up Chaotic Motion for added realism and maximum effectiveness.</li><li>Variable speeds</li><li>IR port connection (for newer versions of X-Series Calls)</li><li>Compatible with any FOXPRO Game Call that has an aux jack and mounts to all X-Series units with the exception of the XWAVE</li></ul><p> </p>	[empty string]	N	99.99	99.99	[empty string]	24178-DEFAULT-s.jpg	[empty string]	1000	1000	XDECOY	242195	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	fox-pro-game-calls/foxpro-x-decoy-predator-decoy-multi-color-compatible-with-foxpro-x-series-except-xwave-242195	XDECOY	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 ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? 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