SHOW:
|
|
- or go back to the newest paste.
| 1 | - | insert into active_personas (`persona_id`) |
| 1 | + | insert into active_users (`user_id`) |
| 2 | - | select persona_id from users |
| 2 | + | |
| 3 | - | where id in ( |
| 3 | + | |
| 4 | join profile_collaborators | |
| 5 | join business_profiles | |
| 6 | ON accounts.id = profile_collaborators.account_id | |
| 7 | and accounts.active_business_profile_id = business_profiles.id | |
| 8 | where accounts.last_request_at > '2012-07-01 00:00:00' | |
| 9 | or business_profiles.subscription_type != 'free' |
