Query failed: SELECT (SELECT GROUP_CONCAT(q.followedbyusername ORDER BY q.datestamp DESC SEPARATOR '|~|') FROM followers q WHERE q.username='yangsheng') as coolio,a.seofocus,a.banned,a.pagetitle,a.shortdescription,a.website,a.views AS va,a.sharebuttons,a.CRC,a.allow_CRguests,a.guestaccountprivates,a.CRChanges,a.backgroundc,a.chatroompassword,a.datestamp,a.aotu,a.maxuploadbytes,a.followers,a.maxchatroomusers,a.datestamplastlogin,a.country,a.region,a.city,a.geo_coords_X,a.geo_coords_Y,a.background_video,a.lastactiondatestamp,
(SELECT title FROM videos WHERE username='yangsheng' AND masterdatestamp=a.background_video LIMIT 1),(SELECT followedbyusername FROM followers WHERE username='yangsheng' AND followedbyusername='' LIMIT 1),(SELECT v.views FROM videos v WHERE  v.privacy='' AND v.username='yangsheng' ORDER BY v.masterdatestamp DESC LIMIT 1),(SELECT v.masterdatestamp FROM videos v WHERE  v.privacy='' AND v.username='yangsheng' ORDER BY v.masterdatestamp DESC LIMIT 1),(SELECT v.duration FROM videos v WHERE  v.privacy='' AND v.username='yangsheng' ORDER BY v.masterdatestamp DESC LIMIT 1),(SELECT v.title FROM videos v WHERE  v.privacy='' AND v.username='yangsheng' ORDER BY v.masterdatestamp DESC LIMIT 1),(SELECT t1.local_device_filename FROM pictures t1, (SELECT local_device_filename FROM pictures WHERE (privacy='' AND username='yangsheng') ORDER BY masterdatestamp DESC LIMIT 1) as t2 where t1.local_device_filename=t2.local_device_filename),(SELECT p.views FROM pictures p WHERE p.privacy='' AND p.username='yangsheng' ORDER BY p.masterdatestamp DESC LIMIT 1),(SELECT p.masterdatestamp FROM pictures p WHERE p.privacy='' AND p.username='yangsheng' ORDER BY p.masterdatestamp DESC LIMIT 1),(SELECT p.title FROM pictures p WHERE p.privacy='' AND p.username='yangsheng' ORDER BY p.masterdatestamp DESC LIMIT 1),(SELECT username FROM accounts WHERE banned='0' AND datestamp < a.datestamp AND emailconfirmed=1 ORDER BY datestamp DESC LIMIT 1),(SELECT pagetitle FROM accounts WHERE banned='0' AND datestamp < a.datestamp AND emailconfirmed=1 ORDER BY datestamp DESC LIMIT 1),(SELECT username FROM accounts WHERE banned='0' AND datestamp > a.datestamp AND emailconfirmed=1 ORDER BY datestamp ASC LIMIT 1),a.password,a.dcrpt,(SELECT pagetitle FROM accounts WHERE banned='0' AND datestamp > a.datestamp AND emailconfirmed=1 ORDER BY datestamp ASC LIMIT 1),a.logoutdatestamp,(SELECT likes FROM reactionsmaster WHERE username='yangsheng' LIMIT 1),(SELECT love FROM reactionsmaster WHERE username='yangsheng' LIMIT 1),(SELECT laugh FROM reactionsmaster WHERE username='yangsheng' LIMIT 1),(SELECT wow FROM reactionsmaster WHERE username='yangsheng' LIMIT 1),(SELECT sad FROM reactionsmaster WHERE username='yangsheng' LIMIT 1),(SELECT angry FROM reactionsmaster WHERE username='yangsheng' LIMIT 1),(SELECT username FROM groups WHERE username='yangsheng' LIMIT 1),a.local_profile_filename,a.firstname,a.lastname,a.groups FROM accounts a WHERE a.username='yangsheng' ORDER BY a.username DESC LIMIT 1