select device_id,substr(blog_url,11) user_name
from user_submit