select device_id,substring(blog_url,11)
from user_submit