SELECT new_url , code, store_id FROM mbs_redirect_manager WHERE old_url = 'PR-8-No-2383-and-higher' AND visible = 1 AND store_id = 0 LIMIT 1
PR-8-No-2383-and-higher