select device_id,SUBSTRING_INDEX(blog_url,'/',-1) as user_name from user_submit