SELECT new_url , code, store_id FROM mbs_redirect_manager WHERE old_url = 'smoke-sticks' AND visible = 1 AND store_id = 0 LIMIT 1
smoke-sticks