MySQL select

[Eikinskjaldi]

Originally Posted by 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.

[sql]
select u.userid, uf.field19
from user u
join userfield uf using (userid)
where find_in_set('15',u.membergroupids) > 0
and to_days(now()) - to_days(from_unixtime(u.lastactivity)) <= 30
[/sql]