create table `active_monitor` (`object_id` int(11) NOT NULL); insert into active_monitor (`object_id`) select s_object_id from s_object_monitors join active_users ON s_object_monitors.user_id = active_users.user_id where s_object_monitors.monitor_type=1
Comments