UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support query - email address for users with X posts

select t1.USER_ID,t2.USER_DISPLAY_NAME,t1.USER_REAL_EMAIL,t1.USER_TOTAL_POSTS
from ubbt_USER_PROFILE as t1,
     ubbt_USERS as t2
where t1.USER_ID = t2.USER_ID