SHOW:
|
|
- or go back to the newest paste.
| 1 | - | create table `active_personas` (`persona_id` int(11) NOT NULL); |
| 1 | + | create table `active_monitor` (`object_id` int(11) NOT NULL); |
| 2 | - | insert into active_personas (`persona_id`) |
| 2 | + | insert into active_monitor (`object_id`) |
| 3 | - | select persona_id |
| 3 | + | select s_object_id |
| 4 | - | from users where id in (select user_id from active_users) |
| 4 | + | from s_object_monitors |
| 5 | join active_users | |
| 6 | ON s_object_monitors.user_id = active_users.user_id | |
| 7 | where s_object_monitors.monitor_type=1 |
