w8bTH4Dt

1EXPLAIN (SELECT FROM_UNIXTIME(`UserAction`.`created`) as action_created, `ToUser`.`opensocial_id`, `User`.`opensocial_id`, `Action`.`id`, `UserAction`.`message`, `UserAction`.`id`, `UserAction`.`type` FROM `user_actions` AS `UserAction` LEFT JOIN `users` AS `User` ON (`UserAction`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `ToUser` ON (`UserAction`.`user_id_to` = `ToUser`.`id`) LEFT JOIN `actions` AS `Action` ON (`UserAction`.`action_id` = `Action`.`id`) WHERE `UserAction`.`user_id_to` = 0 ORDER BY `UserAction`.`created` DESC LIMIT 15)
2UNION
3(SELECT FROM_UNIXTIME(`UserAction`.`created`) as action_created, `ToUser`.`opensocial_id`, `User`.`opensocial_id`, `Action`.`id`, `UserAction`.`message`, `UserAction`.`id`, `UserAction`.`type` FROM `user_actions` AS `UserAction` LEFT JOIN `users` AS `User` ON (`UserAction`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `ToUser` ON (`UserAction`.`user_id_to` = `ToUser`.`id`) LEFT JOIN `actions` AS `Action` ON (`UserAction`.`action_id` = `Action`.`id`) WHERE `UserAction`.`user_id` = 0 ORDER BY `UserAction`.`created` DESC LIMIT 15)
4ORDER BY action_created DESC LIMIT 15
5
6CREATE TABLE IF NOT EXISTS `user_actions` (
7  `id` int(11) NOT NULL auto_increment,
8  `user_id` int(11) unsigned NOT NULL,
9  `user_id_to` int(11) unsigned NOT NULL,
10  `action_id` int(11) unsigned NOT NULL,
11  `created` int(11) unsigned NOT NULL,
12  `message` varchar(255) default '',
13  `type` tinyint(5) default '0',
14  PRIMARY KEY  (`id`),
15  KEY `user_id_to` (`user_id_to`,`created`),
16  KEY `user_id` (`user_id`,`created`)
17) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15473 ;