select device_id,substring(blog_url,11,length(blog_url)-10) as user_name
from user_submit