SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=28584&title=battery-watering-system-f-8v-trojan-cc-ds-and-yamaha'