UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? How Do I generate an email list of new registrant this month?

SELECT t1.USER_DISPLAY_NAME,t2.USER_REAL_EMAIL
FROM ubbt_USERS as t1,
     ubbt_USER_PROFILE as t2
WHERE t1.USER_ID=t2.USER_ID
and t1.USER_ID >5000