CREATE TABLE `servers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `machine_id` int(11) NOT NULL DEFAULT '0',
  `site_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `is_external_auth` tinyint(1) NOT NULL DEFAULT '0',
  `is_up` tinyint(1) NOT NULL DEFAULT '0',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_free` tinyint(1) NOT NULL DEFAULT '0',
  `restrict_voicecom` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `monitor_status` tinyint(1) NOT NULL DEFAULT '0',
  `gsp` int(11) NOT NULL DEFAULT '0',
  `game_id` int(11) NOT NULL DEFAULT '0',
  `mod` varchar(16) NOT NULL DEFAULT 'cstrike',
  `level` enum('free','lite','premium') NOT NULL DEFAULT 'premium',
  `type` enum('public','aim','csdm','event','fun','lms','pug','jump','private','scrim','lesson') NOT NULL DEFAULT 'public',
  `name` varchar(255) NOT NULL DEFAULT '',
  `players_max` int(11) NOT NULL DEFAULT '0',
  `players_current` int(11) NOT NULL DEFAULT '0',
  `spectv_slave_id` int(11) NOT NULL DEFAULT '0',
  `spectv_slave_port` int(11) NOT NULL DEFAULT '0',
  `spectv_slave_status` enum('public','private') NOT NULL DEFAULT 'public',
  `map` varchar(255) NOT NULL DEFAULT '',
  `location` varchar(255) NOT NULL DEFAULT '',
  `host` varchar(255) NOT NULL DEFAULT '',
  `port` int(11) NOT NULL DEFAULT '0',
  `rcon` varchar(255) NOT NULL DEFAULT '',
  `pug_id` int(11) NOT NULL DEFAULT '0',
  `esea_match_id` int(11) unsigned NOT NULL DEFAULT '0',
  `esea_match_players` int(11) NOT NULL DEFAULT '0',
  `esea_match_rounds` int(11) NOT NULL DEFAULT '0',
  `esea_match_state` int(11) NOT NULL DEFAULT '0',
  `esea_play_state` int(11) NOT NULL DEFAULT '0',
  `esea_scrim_state` int(11) NOT NULL DEFAULT '0',
  `esea_scrim_map` varchar(255) NOT NULL DEFAULT '',
  `esea_scrim_divinfo` varchar(255) NOT NULL DEFAULT '',
  `esea_scrim_admin` int(11) NOT NULL DEFAULT '0',
  `pingboost` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `subscr_period` varchar(4) NOT NULL DEFAULT '',
  `subscr_expire` int(11) NOT NULL DEFAULT '0',
  `subscr_mailed` tinyint(1) NOT NULL DEFAULT '0',
  `safe_shutdown` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `esea_match_id` (`esea_match_id`),
  KEY `id` (`id`,`location`)
) ENGINE=MyISAM AUTO_INCREMENT=242 DEFAULT CHARSET=latin1 



SELECT part of the deadlock:

SELECT s.id AS server_id, s.host AS server_host, g.icon AS game_icon, u3.user_id AS is_playing, u.id, u.is_premium, u.alias, u.profile_xfire, c.id AS country_abbr, c.name AS country_name, u4.last_view 
FROM (users u, countries c, users_buddies u2) 
LEFT JOIN users_playing u3 
	ON u3.user_id = u.id 
LEFT JOIN servers s 
	ON u3.server_id = s.id 
LEFT JOIN games g 
	ON s.game_id = g.id 
LEFT JOIN users_online u4 
	ON u4.user_id = u.id 
	AND u4.site_id = '1' 
WHERE u2.buddy_id = u.id 
	AND u.country = c.id 
	AND u2.user_id = '4'


CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL DEFAULT '0',
  `geo_country` varchar(4) NOT NULL DEFAULT '',
  `geo_subdivision` varchar(16) NOT NULL DEFAULT '',
  `is_premium` tinyint(1) NOT NULL DEFAULT '0',
  `is_manual` tinyint(1) NOT NULL DEFAULT '0',
  `is_previous_subscriber` tinyint(1) NOT NULL DEFAULT '0',
  `is_free` tinyint(1) NOT NULL DEFAULT '0',
  `is_vip` tinyint(1) NOT NULL DEFAULT '0',
  `is_free_reason` varchar(30) NOT NULL DEFAULT '',
  `vip_game` int(11) NOT NULL DEFAULT '1',
  `vip_req_activation` tinyint(1) NOT NULL DEFAULT '0',
  `vip_last_activation` int(11) NOT NULL DEFAULT '0',
  `vip_lesson_status` tinyint(1) NOT NULL DEFAULT '0',
  `karma_level` double NOT NULL DEFAULT '0',
  `karma_snapshot` double NOT NULL DEFAULT '0',
  `last_visit` int(11) NOT NULL DEFAULT '0',
  `last_comment_time` int(11) NOT NULL DEFAULT '0',
  `last_ticket_time` int(11) NOT NULL DEFAULT '0',
  `last_password_change` int(11) NOT NULL DEFAULT '0',
  `login_total_attempts` tinyint(4) NOT NULL DEFAULT '0',
  `steam_id` varchar(32) DEFAULT NULL,
  `source_steam_id` varchar(32) DEFAULT NULL,
  `cscz_steam_id` varchar(32) DEFAULT NULL,
  `tf2_steam_id` varchar(32) DEFAULT NULL,
  `cod4_guid` varchar(32) DEFAULT NULL,
  `alias` varchar(50) NOT NULL DEFAULT '',
  `irc_auth_name` varchar(50) DEFAULT NULL,
  `irc_setinfo` varchar(255) NOT NULL DEFAULT '',
  `name_first` varchar(50) NOT NULL DEFAULT '',
  `name_last` varchar(50) NOT NULL DEFAULT '',
  `sex` varchar(15) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `security_question` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `security_answer` varchar(32) NOT NULL,
  `email` varchar(50) NOT NULL DEFAULT '',
  `birth_date` int(11) NOT NULL DEFAULT '0',
  `country` varchar(15) NOT NULL DEFAULT '',
  `state` varchar(15) NOT NULL DEFAULT '',
  `zip_code` varchar(16) NOT NULL DEFAULT '0',
  `settings_default_game` int(11) NOT NULL DEFAULT '1',
  `settings_featured_servers` enum('vips_friends','friends','vips') NOT NULL DEFAULT 'vips_friends',
  `settings_notify_buddy` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `settings_notify_guestbook` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `settings_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `settings_utc_offset` float DEFAULT NULL,
  `settings_is_dst` tinyint(1) NOT NULL DEFAULT '0',
  `settings_lang` varchar(8) NOT NULL DEFAULT 'en-us',
  `image_file_name` varchar(50) NOT NULL DEFAULT '',
  `image_thumb` tinyint(1) NOT NULL DEFAULT '0',
  `cfg_file_name` varchar(50) NOT NULL DEFAULT '',
  `cs_cl_cmdrate` int(11) NOT NULL DEFAULT '0',
  `cs_cl_updaterate` int(11) NOT NULL DEFAULT '0',
  `cs_rate` int(11) NOT NULL DEFAULT '0',
  `gaming_sens_windows` varchar(50) NOT NULL DEFAULT '',
  `gaming_sens_ingame` varchar(50) NOT NULL DEFAULT '',
  `gaming_sens_extra` varchar(50) NOT NULL DEFAULT '',
  `gaming_refresh_rate` varchar(50) NOT NULL DEFAULT '',
  `gaming_vsync` tinyint(1) NOT NULL DEFAULT '0',
  `gaming_resolution` varchar(50) NOT NULL DEFAULT '',
  `profile_location` varchar(50) NOT NULL DEFAULT '',
  `profile_fav_map` varchar(50) NOT NULL DEFAULT '',
  `profile_fav_team` varchar(50) NOT NULL DEFAULT '',
  `profile_fav_player` varchar(50) NOT NULL DEFAULT '',
  `profile_fav_food` varchar(50) NOT NULL DEFAULT '',
  `profile_fav_drink` varchar(50) NOT NULL DEFAULT '',
  `profile_fav_band` varchar(50) NOT NULL DEFAULT '',
  `profile_website` varchar(50) NOT NULL DEFAULT '',
  `profile_xfire` varchar(50) NOT NULL DEFAULT '',
  `profile_icq` varchar(50) NOT NULL DEFAULT '',
  `profile_aim` varchar(50) NOT NULL DEFAULT '',
  `profile_msn` varchar(50) NOT NULL DEFAULT '',
  `profile_yahoo` varchar(50) NOT NULL DEFAULT '',
  `profile_steam` varchar(50) NOT NULL DEFAULT '',
  `profile_xbox` varchar(50) NOT NULL DEFAULT '',
  `profile_biography` text NOT NULL,
  `comp_memory` varchar(32) NOT NULL DEFAULT '',
  `comp_cpu` varchar(32) NOT NULL DEFAULT '',
  `comp_hd` varchar(32) NOT NULL DEFAULT '',
  `comp_monitor` varchar(32) NOT NULL DEFAULT '',
  `comp_manufacturer` varchar(32) NOT NULL DEFAULT '',
  `comp_os` varchar(32) NOT NULL DEFAULT '',
  `comp_video` varchar(32) NOT NULL DEFAULT '',
  `comp_sound` varchar(32) NOT NULL DEFAULT '',
  `comp_headphones` varchar(32) NOT NULL DEFAULT '',
  `comp_mouse` varchar(32) NOT NULL DEFAULT '',
  `comp_mousepad` varchar(32) NOT NULL DEFAULT '',
  `comp_keyboard` varchar(32) NOT NULL DEFAULT '0',
  `total_posts` int(11) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `commission` double NOT NULL DEFAULT '0.15',
  `hours_notice` int(11) NOT NULL DEFAULT '0',
  `biography` text NOT NULL,
  `lesson_plan` text NOT NULL,
  `demos_current_month` int(11) NOT NULL DEFAULT '0',
  `team` varchar(50) NOT NULL DEFAULT '',
  `team_irc_channel` varchar(50) NOT NULL DEFAULT '',
  `email_paypal` varchar(50) NOT NULL DEFAULT '',
  `servers_pug_leave_init` int(11) NOT NULL DEFAULT '0',
  `servers_pug_leave_time` int(11) NOT NULL DEFAULT '0',
  `servers_pug_leave_count` int(11) NOT NULL DEFAULT '0',
  `servers_pug_leave_id` int(11) NOT NULL DEFAULT '0',
  `bonus_loyalty_points` int(11) NOT NULL DEFAULT '0',
  `subscription_period` varchar(16) NOT NULL DEFAULT '0',
  `subscription_agreed_tos` tinyint(1) NOT NULL DEFAULT '0',
  `subscription_start` int(11) NOT NULL DEFAULT '0',
  `subscription_expire` int(11) NOT NULL DEFAULT '0',
  `subscription_mailed` tinyint(1) NOT NULL DEFAULT '0',
  `roster_order` int(11) NOT NULL DEFAULT '0',
  `roster_position` varchar(255) NOT NULL DEFAULT '',
  `is_locked` tinyint(1) NOT NULL DEFAULT '0',
  `last_comment_id` int(11) NOT NULL DEFAULT '0',
  `last_comment_post_time` int(11) NOT NULL DEFAULT '0',
  `replies` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `cscz_steam_id` (`cscz_steam_id`),
  UNIQUE KEY `tf2_steam_id` (`tf2_steam_id`),
  UNIQUE KEY `cod4_guid` (`cod4_guid`),
  UNIQUE KEY `steam_id` (`steam_id`),
  UNIQUE KEY `source_steam_id` (`source_steam_id`),
  UNIQUE KEY `irc_auth_name` (`irc_auth_name`),
  KEY `is_premium` (`is_premium`),
  KEY `site_id` (`site_id`),
  KEY `is_vip` (`is_vip`),
  KEY `servers_pug_leave_count` (`servers_pug_leave_count`),
  KEY `servers_pug_leave_time` (`servers_pug_leave_time`)
) ENGINE=MyISAM AUTO_INCREMENT=317796 DEFAULT CHARSET=latin1 


CREATE TABLE `countries` (
  `id` varchar(4) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `region_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 


CREATE TABLE `users_buddies` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `buddy_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`buddy_id`),
  KEY `buddy_id` (`buddy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


CREATE TABLE `users_playing` (
  `game_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `server_id` int(11) NOT NULL DEFAULT '0',
  `join_time` int(11) NOT NULL DEFAULT '0',
  KEY `server_id` (`server_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1


CREATE TABLE `games` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_avail` tinyint(1) NOT NULL DEFAULT '0',
  `abbr` varchar(16) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `developer` varchar(255) NOT NULL DEFAULT '',
  `genre` varchar(255) NOT NULL DEFAULT '',
  `website` varchar(255) NOT NULL DEFAULT '',
  `file_name` varchar(255) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL DEFAULT '',
  `teams_avail` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 


CREATE TABLE `users_online` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `site_id` int(11) NOT NULL DEFAULT '0',
  `medium` enum('irc','website') NOT NULL DEFAULT 'website',
  `page` varchar(255) NOT NULL DEFAULT '',
  `initial_view` int(11) NOT NULL DEFAULT '0',
  `last_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`),
  KEY `site_id` (`site_id`),
  KEY `page` (`page`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1