select device_id,
    substring_index(blog_url,'/',-1)
from user_submit