| 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 |
GREEN
|
MENDOTA
|
Mendota
|
HUNTING
|
Hunting
|
GREEN|NULL|NULL
|
1
|
19.99
|
0
|
19.99
|
525-DEFAULT-l.jpg
|
19.99
|
525-DEFAULT-m.jpg
|
MENDOTA 016 SNAP LEAD
|
N
|
AMAZON
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2401
|
.MENDOTA016SNAPLEAD
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2
|
15-to-20
|
0.00
|
[empty string]
|
Mendota Snap Lead (1/2"x4')
|
<p>Premium, strong (1/2" x 4 feet) solid braid UV coated polypropylene rope, leather sleeves, and a heavy gauge brass snap. Available in Camouflage and Green</p>
|
[empty string]
|
N
|
19.99
|
19.99
|
[empty string]
|
525-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
016
|
75806
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
mendota/mendota-snap-lead-1-2-x4-75806
|
016
|
0
|
| 2 |
GREEN
|
MENDOTA
|
Mendota
|
HUNTING
|
Hunting
|
GREEN|NULL|NULL
|
1
|
16.99
|
0
|
16.99
|
522-DEFAULT-l.jpg
|
16.99
|
522-DEFAULT-m.jpg
|
MENDOTA 019 TRAFFIC LEAD
|
N
|
AMAZON
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2401
|
.MENDOTA019TRAFFICLEAD
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2
|
15-to-20
|
0.00
|
[empty string]
|
Mendota Traffic Leash - Large 1/2 Inch
|
<p>Traffic Lead -A short 1.5 foot handled snap lead for situations where you need your dog close at all times.</p><ul><li>Soft on the hands with its "Broken in Feel" easy to use and pliable enough to fit in your coat pocket</li><li>Brass, satin nickel or black metallic hardware and oil tanned leather splices</li><li>Made of waterproof, vibrant, long-lasting multi-filament polypropylene rope.</li><li>Matches Mendota's Double Braid Collars</li><li>Machine washable, air dry only.</li><li>Handmade in the U.S.A.</li><li>100% satisfaction guarantee</li><li>Shipping Weight 4 oz.</li><li>Package size: 4"x5"x1.5" </li></ul><p>We also have 4' and 6' foot available:</p><ul><li>Small Snap Leash: 3/8"" x 4' and 3/8"" x 6' (for dogs under 50 pounds)</li><li>Large Snap Leash: 1/2"" x 4' and 1/2"" x 6'</li><li>Traffic Lead: 1/2"" x 16""</li></ul>
|
[empty string]
|
N
|
16.99
|
16.99
|
[empty string]
|
522-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
019
|
75807
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
mendota/mendota-traffic-leash-large-1-2-inch-75807
|
019
|
0
|
| 3 |
CLEAR_ACRYLIC
|
RICH N TONE
|
Rich N Tone
|
HUNTING
|
Hunting
|
CLEAR_ACRYLIC|NULL|NULL
|
1
|
149.99
|
0
|
149.99
|
2783-DEFAULT-l.jpg
|
149.99
|
2783-DEFAULT-m.jpg
|
RICH N TONE HANCOCK
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
906
|
.RICHNTONEHANCOCK
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2
|
100-to-150
|
0.00
|
[empty string]
|
Rich N Tone Hancock
|
<p>RNT Hancock Single Reed Duck Call. Clyde Hancock, 1948 World Duck Calling Champion, was a legendary hunter, caller, and call-maker (1920's-50's) from Stuttgart, AR. He made a great patterned checkered call and a smooth style call. These are open water style calls, with or without checkering.</p>
|
[empty string]
|
N
|
149.99
|
149.99
|
[empty string]
|
2783-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
RNT7107
|
77392
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
rich-n-tone/rich-n-tone-hancock-77392
|
RNT7107
|
0
|
| 4 |
[empty string]
|
DOGTRA
|
Dogtra
|
HUNTING
|
Hunting
|
[empty string]
|
1
|
179.99
|
0
|
249.99
|
40416-DEFAULT-l.jpg
|
179.99
|
40416-DEFAULT-m.jpg
|
DOGTRA TRAINING
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2128
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2
|
200-to-250
|
0.00
|
[empty string]
|
Dogtra 1900s Remote Training System
|
<p><span style="font-size:18px;">Dogtra has committed over 20 years to crafting dog training e-collars, perfecting the precise fit-and-finish, intuitive design, and accountable performance. The Dogtra 1900S e-collar exemplifies this dedication, providing an ultimate dog training tool that is durable, dependable, and designed for the most demanding conditions. This high-output e-collar is the unit of choice for serious amateurs and award-winning professional trainers in pet obedience, hunting, competition trials, and K-9 training.</span></p>
<p><span style="font-size:18px;"><strong>Key Features:</strong></span></p>
<ul>
<li><span style="font-size:18px;">3/4-Mile Range: The 1900S e-collar offers an extended range, making it ideal for various training environments.</span></li>
<li><span style="font-size:18px;">Fully Waterproof: The durable design ensures the collar remains functional even in wet conditions.</span></li>
<li><span style="font-size:18px;">Unique Modern Receiver Design: The collar strap wraps around the receiver and your dog’s neck for enhanced comfort and a seamless appearance.</span></li>
<li><span style="font-size:18px;">Low-High Stimulation Levels: With 0-127 levels, the wide range of stimulation fits any dog’s personality, <strong><em>from mild to the most stubborn.</em></strong></span></li>
<li><span style="font-size:18px;">Patented Rheostat Dial: Allows for gradual and precise stimulation control, displayed on the illuminated LCD screen on the handheld transmitter.</span></li>
</ul>
<p><span style="font-size:18px;"><strong>Ideal For:</strong></span></p>
<ul>
<li><span style="font-size:18px;">Pet obedience training</span></li>
<li><span style="font-size:18px;">Hunting</span></li>
<li><span style="font-size:18px;">Competition trials</span></li>
<li><span style="font-size:18px;">K-9 training</span></li>
</ul>
<p><span style="font-size:18px;"><strong>Product Benefits:</strong></span></p>
<ul>
<li><span style="font-size:18px;">Durable and Dependable: Crafted to withstand the most demanding conditions.</span></li>
<li><span style="font-size:18px;">Enhanced Comfort: Designed with your dog’s comfort in mind, ensuring a seamless fit.</span></li>
<li><span style="font-size:18px;">Wide Range of Stimulation: Accommodates all dog personalities, providing low to high stimulation levels.</span></li>
<li><span style="font-size:18px;">Precise Control: The Rheostat Dial offers gradual and precise control over stimulation levels.</span></li>
</ul>
|
[empty string]
|
N
|
249.99
|
249.99
|
[empty string]
|
40416-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
1900S
|
99142
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
dogtra/dogtra-1900s-remote-training-system-99142
|
1900s
|
0
|
| 5 |
[empty string]
|
DOGTRA
|
Dogtra
|
HUNTING
|
Hunting
|
[empty string]
|
1
|
299.99
|
0
|
299.99
|
13116-DEFAULT-l.jpg
|
299.99
|
13116-DEFAULT-m.jpg
|
DOGTRA 1900S HANDSFREE PLUS
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2128
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
1
|
250-to-300
|
0.00
|
[empty string]
|
Dogtra 1900s Handsfree Plus Training System
|
<p><strong>DESCRIPTION</strong>:</p>
<p>The Dogtra 1900S HANDSFREE PLUS combines our most versatile 1900S e-collar with a compact Dogtra HANDSFREE SQUARE, which allows you to control a transmitter remotely. The new HANDSFREE SQUARE features allow users to add up to 14 SQUARES delivering a diverse range of training scenarios.</p>
<p>Each SQUARE can be paired to different functions (Nick, Constant, or HPP Vibration) and allows many users to quickly access any feature, at any time within 33 feet of the transmitter. This versatile system allows for multiple users to engage in the training process simply by pairing additional HANDSFREE SQUARES. This hands-free system is great for a family household or a trainer working hands on with a client.</p>
<p>With comfort and safety in mind, the -mile range 1900S HANDSFREE PLUS is IPX9K waterproof certified making it durable and reliable for demanding training conditions. In addition to the easy hands-free access, the 1900S HANDSFREE PLUS also offers 127 stimulation levels to choose from for accurate control, HPP (High Performance Pager) vibration, and an ergonomic receiver shaped to the dog's neck.</p>
<ul>
<li>HANDSFREE SQUARE for Remote Control</li>
<li>Expandable up to 14 HANDSFREE SQUARES</li>
<li>3/4-Mile Range</li>
<li>IPX9K Waterproof Certified</li>
<li>High Output Receiver</li>
<li>127 Stimulation Levels/Rheostat Dial/LCD Screen</li>
<li>Nick/Constant Stimulation & HPP (High Performance Pager) Vibration</li>
</ul>
|
[empty string]
|
N
|
299.99
|
299.99
|
[empty string]
|
13116-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
1900SHFPLUS
|
99143
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
dogtra/dogtra-1900s-handsfree-plus-training-system-99143
|
1900SHFPLUS
|
0
|
| 6 |
[empty string]
|
DOGTRA
|
Dogtra
|
HUNTING
|
Hunting
|
[empty string]
|
1
|
429.99
|
0
|
429.99
|
13117-DEFAULT-l.jpg
|
429.99
|
13117-DEFAULT-m.jpg
|
DOGTRA PATHFINDER 2
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2128
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
4
|
400-to-450
|
0.00
|
[empty string]
|
Dogtra Pathfinder SE
|
<p>Tracking and Training in one system!</p><p>New features include: GPS Connector E-Collar Function button, Pager Vibration, LED Locate Light and a new PATHFINDER2 app with more features.</p><p>Explore more with you dogs on all outdoor activities from hiking to hunting with the newest GPS Dog Tracking and Training System. The new Dogtra PATHFINDER2 is a complete GPS tracking and training system featuring a newly redesigned FREE real time tracking and training app, tracking up to 21 dogs within a 9-mile range.* The new PATHFINDER2 system features the latest in dog tracking collars equipped with E-Collar training functions now including a LED Locate Light and Pager Vibration. The new GPS Connector is designed with a new E-Collar Function button for quicker response.</p><p>The PATHFINDER2 works with a FREE app based dog tracking system with no monthly subscription required, allowing users to track and train their dogs straight from their phone featuring offline maps access with no signal required. The app allows users to: share locations, create custom fences, customize activity modes and access e-collar training features, battery saving sleep mode, lost collar lock, a lost GPS Connector locator and more. Smart watch users can now track their dogs from their watch with quick access to the extended PATHFINDER2 dog tracking app that is available for Apple Watch Series 5 and Galaxy Watch4 and above. The Dogtra PATHFINDER2 App requires the Dogtra PATHFINDER2 system to operate. *Range may vary depending on the surroundings.</p><p>PATHFINDER2 App Phone Requirements: iOS 12.1 or Android 6.0 and above and devices must include Bluetooth 5.0 and up.</p><p>New PATHFINDER2 System Features:</p><p>New GPS Connector with E-Collar Function Button<br />New GPS Receiver with Pager Vibration & LED Locate Light<br />New Receiver Lock Mode<br />New Sleep Mode<br />New E-Collar Functions: Pager Vibration & LED Locate Light<br />New USB 5V Charger<br />*New PATHFINDER2 System is only compatible with the PATHFINDER2 Series Systems*</p><p>New PATHFINDER2 App Features:</p><p>New FREE PATHFINDER2 App with updated user interface<br />New Smart Watch compatibility:<br /> Now available on Samsung Galaxy Watch4 Series<br /> Apple Watch Series 5 and above<br />Free maps powered by MapBox<br />New Fence Modes:<br /> E-Fence ( NEW)<br /> Geo-Fence<br /> Mobile-Fence</p><p>*PATHFINDER2 App is only compatible with the PATHFINDER2 Series</p><p>Compatibility:<br />App: PATHFINDER2<br />Systems: PATHFINDER2 Receiver, PATHFINDER2 TRX Receiver, PATHFINDER2 GPS Connector</p><p>Not Compatible With:<br />Apps: PATHFINDER APP<br />Systems: PATHFINDER, PATHFINDER SE, PATHFINDER TRX, PATHFINDER MINI, PATHFINDER GPS Connector</p><p> </p>
|
[empty string]
|
N
|
429.99
|
429.99
|
[empty string]
|
13117-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
PATHFINDERSE
|
99154
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
dogtra/dogtra-pathfinder-se-99154
|
PATHFINDERSE
|
0
|
| 7 |
ELECTRIC_BLUE_BLACK
|
RICH N TONE
|
Rich N Tone
|
HUNTING
|
Hunting
|
ELECTRIC_BLUE_BLACK|NULL|NULL
|
1
|
139.99
|
0
|
149.99
|
247-DEFAULT-l.jpg
|
139.99
|
247-DEFAULT-m.jpg
|
RICH N TONE MONDO
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
906
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
8
|
100-to-150
|
0.00
|
[empty string]
|
Rich N Tone Mondo Calls
|
<p>The DC "Mondo" was developed after a style of calling that built it's reputation on putting "Mondo" wads of ducks in the woods. This call is reminiscent of the Cut Down Key Hole calls made famous by guides hunting high pressured, public ground ducks in the hardwood bottoms of Arkansas and Louisiana. The Mondo has a very short insert that creates very little back pressure which allows the call to produce that hard,loud, raspy lick of a a mallard hen, as well as that trademark loud squeaky chatter desired by the guides on these public areas. The "DC Mondo" has the range to Break 'em out high, set 'em up down wind and talk 'em into given up... All you have to do is drive it! Single Reed. <br></p>
|
[empty string]
|
N
|
149.99
|
149.99
|
[empty string]
|
247-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
RNT032
|
154151
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
rich-n-tone/rich-n-tone-mondo-calls-154151
|
RNT032
|
0
|
| 8 |
SMOKE
|
RICH N TONE
|
Rich N Tone
|
HUNTING
|
Hunting
|
SMOKE|NULL|NULL
|
1
|
149.99
|
0
|
149.99
|
16706-DEFAULT-l.jpg
|
149.99
|
16706-DEFAULT-m.jpg
|
RICH N TONE ROCKIN R
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
906
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2
|
100-to-150
|
0.00
|
[empty string]
|
Rich N Tone Rockin' R
|
<p>The Rockin' R, while very similar to the Mondo series of calls, is uniquely based on the way Jimbo likes to set up one of his old black calls. With a tapered mouthpiece that takes away backpressure but allows the caller more versatility of air delivery depending on what sounds they are trying to achieve. Along with that, he opened up and tapered the bore on the insert adding a touch more volume on top but also to be very loose on the bottom. Like the Mondo series, Jimbo went back to an original keyhole and worked forward to develop a smoother top end with lots of punch but also retain that signature rattle. He was looking for a separate shape that honored the classic look of a reversed Olt and his RNT Roots but also stood on its own. So with the help of John Stephens making sense of his crude drawing, what you see as the Rockin' R came to life. The Rockin' R Logo evolved to what you see on the call with the help of Blake Fisher's creative talent using Jim's initials, JR. We are very proud to introduce the Rockin' R regular duck call as part of the many great calls in the RNT line-up.</p><p> </p>
|
[empty string]
|
N
|
149.99
|
149.99
|
[empty string]
|
16706-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
RNT07177
|
154153
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
rich-n-tone/rich-n-tone-rockin-r-154153
|
RNT07177
|
0
|
| 9 |
BLACK
|
RICH N TONE
|
Rich N Tone
|
HUNTING
|
Hunting
|
BLACK|NULL|NULL
|
1
|
149.99
|
0
|
149.99
|
16707-DEFAULT-l.jpg
|
149.99
|
16707-DEFAULT-m.jpg
|
RICH N TONE ROCKIN R
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
906
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
1
|
100-to-150
|
0.00
|
[empty string]
|
Rich N Tone Rockin' R
|
<p>The Rockin' R, while very similar to the Mondo series of calls, is uniquely based on the way Jimbo likes to set up one of his old black calls. With a tapered mouthpiece that takes away backpressure but allows the caller more versatility of air delivery depending on what sounds they are trying to achieve. Along with that, he opened up and tapered the bore on the insert adding a touch more volume on top but also to be very loose on the bottom. Like the Mondo series, Jimbo went back to an original keyhole and worked forward to develop a smoother top end with lots of punch but also retain that signature rattle. He was looking for a separate shape that honored the classic look of a reversed Olt and his RNT Roots but also stood on its own. So with the help of John Stephens making sense of his crude drawing, what you see as the Rockin' R came to life. The Rockin' R Logo evolved to what you see on the call with the help of Blake Fisher's creative talent using Jim's initials, JR. We are very proud to introduce the Rockin' R regular duck call as part of the many great calls in the RNT line-up.</p><p> </p>
|
[empty string]
|
N
|
149.99
|
149.99
|
[empty string]
|
16707-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
RNT07178
|
154154
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
rich-n-tone/rich-n-tone-rockin-r-154154
|
RNT07178
|
0
|
| 10 |
GREEN_ORANGE
|
RICH N TONE
|
Rich N Tone
|
HUNTING
|
Hunting
|
GREEN_ORANGE|NULL|NULL
|
1
|
149.99
|
0
|
149.99
|
16708-DEFAULT-l.jpg
|
149.99
|
16708-DEFAULT-m.jpg
|
RICH N TONE ROCKIN R
|
N
|
AMAZON,EBAY
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
906
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
3
|
100-to-150
|
0.00
|
[empty string]
|
Rich N Tone Rockin' R
|
<p>The Rockin' R, while very similar to the Mondo series of calls, is uniquely based on the way Jimbo likes to set up one of his old black calls. With a tapered mouthpiece that takes away backpressure but allows the caller more versatility of air delivery depending on what sounds they are trying to achieve. Along with that, he opened up and tapered the bore on the insert adding a touch more volume on top but also to be very loose on the bottom. Like the Mondo series, Jimbo went back to an original keyhole and worked forward to develop a smoother top end with lots of punch but also retain that signature rattle. He was looking for a separate shape that honored the classic look of a reversed Olt and his RNT Roots but also stood on its own. So with the help of John Stephens making sense of his crude drawing, what you see as the Rockin' R came to life. The Rockin' R Logo evolved to what you see on the call with the help of Blake Fisher's creative talent using Jim's initials, JR. We are very proud to introduce the Rockin' R regular duck call as part of the many great calls in the RNT line-up.</p><p> </p>
|
[empty string]
|
N
|
149.99
|
149.99
|
[empty string]
|
16708-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
RNT07183
|
154155
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
rich-n-tone/rich-n-tone-rockin-r-154155
|
RNT07183
|
0
|
|
| 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 ?
)
GROUP BY STYLE_ID |
