select a.pid,a.topic,a.keyword,a.intro,a.article,a.code_file,a.notes,a.category_id,a.largeimage,u.fullname,u.about,u.googleplus_link,u.image,a.timestamp,a.thumbimage,a.pdate from articles a join users u on a.userId=u.id where a.pid='10'