SELECT `new_url` FROM `redirects` WHERE `old_url` = '/fine-jewelry/rings/john-hardy-essentials-crossover-ring-00162001006.html' AND `status` = '1' LIMIT 1