[ExAvIoUr]

here it is

PHP Code:

  $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,

                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar

                               FROM user

                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid

                               LEFT JOIN customavatar ON customavatar.userid=user.userid

                               WHERE user.userid=$userid");