SELECT `new_url` FROM `redirects` WHERE `old_url` = '/get-married/ladies-wedding-bands/hearts-on-fire-acclaim-diamond-wedding-band-00111002533.html' AND `status` = '1' LIMIT 1