Just a follow up...
(You never know!)

Users with more than x posts and active in last y days


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,
ubbt_USER_DATA as t3
where t1.USER_ID = t2.USER_ID
AND t1.USER_ID = t3.USER_ID
AND t3.USER_LAST_VISIT_TIME > UNIX_TIMESTAMP() - (86400 * Y)
AND USER_TOTAL_POSTS > X
ORDER BY USER_TOTAL_POSTS DESC