MySQL select

[dodjer42]

I'm using the vbulletin db classes.

I want to select field19 from users where users is member of group 15 and last activity was within 30 days.

Anybody know how to do this?

--------------- Added [DATE]1224909756[/DATE] at [TIME]1224909756[/TIME] ---------------

Got this far:

SELECT user.userid, userfield.field19
FROM user
INNER JOIN userfield ON user.userid = userfield.userid
WHERE (
user.membergroupids LIKE 15
OR user.usergroupid LIKE 15
)
AND userfield.field19 != '';

Just have to work out how to do the dates.