SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-504-br06&title=ezgo-rxv-premium-oem-style-front-replacement-light-beige-seat-assemblies-2008-up'