|
results:
SQL query:
SELECT u.username, u.homepage, u.usertitle, u.posts, u.joindate, uf.field2, s.host, t.signature, avatar.avatarpath, NOT ISNULL( customavatar.filedata ) AS hascustomavatar, u.avatarrevision
FROM user u
LEFT JOIN userfield uf ON uf.userid = u.userid
LEFT JOIN SESSION s ON s.userid = u.userid
LEFT JOIN usertextfield t ON t.userid = u.userid
LEFT JOIN avatar AS avatar ON ( avatar.avatarid = u.avatarid )
LEFT JOIN customavatar AS customavatar ON ( customavatar.userid = u.userid )
WHERE u.userid =905
LIMIT 1
|