Advertisement
ran5000

Untitled

Sep 25th, 2012
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table `active_monitor` (`object_id` int(11) NOT NULL);
  2. insert into active_monitor (`object_id`)
  3. select s_object_id
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement