sql needed

[hugh_]

If someone could give me the SQL for the following I would be grateful...

1. Find all users who've not logged in for 365 days and move them to a specific group.

2. Unsubscribe users in a specific group from email notifications.

3a. Find all users registered to a specific timezone.

3b. Find all users registered to a specific timezone and move them to a specific group.

Thanks...

hugh

[Marco van Herwaarden]

1. AdminCP -> Users -> Prune / Move Members

Don't have an answer ready for the other questions, please let us know if you still need those.