$query = "
SELECT t1.USER_DISPLAY_NAME,t1.USER_ID,t2.USER_NAME_COLOR,t1.USER_MEMBERSHIP_LEVEL,t2.USER_AVATAR,t1.USER_REGISTERED_ON,t2.USER_TOTAL_POSTS,t2.USER_AVATAR_WIDTH,t2.USER_AVATAR_HEIGHT
FROM {$config['TABLE_PREFIX']}USERS as t1,
{$config['TABLE_PREFIX']}USER_PROFILE as t2,
{$config['TABLE_PREFIX']}USER_DATA as t3
WHERE t1.USER_ID = t2.USER_ID
AND t1.USER_ID = t3.USER_ID
AND t1.USER_IS_BANNED != '1'
AND t1.USER_ID > 1
$thisclause
ORDER BY rand() limit 1
";
