-- MySQL dump 10.13 Distrib 5.1.41, for unknown-linux-gnu (x86_64) -- -- Host: localhost Database: mysql -- ------------------------------------------------------ -- Server version 5.1.41-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `slow_log` -- DROP TABLE IF EXISTS `slow_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `slow_log` ( `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `user_host` mediumtext NOT NULL, `query_time` time NOT NULL, `lock_time` time NOT NULL, `rows_sent` int(11) NOT NULL, `rows_examined` int(11) NOT NULL, `db` varchar(512) DEFAULT NULL, `last_insert_id` int(11) DEFAULT NULL, `insert_id` int(11) DEFAULT NULL, `server_id` int(11) DEFAULT NULL, `sql_text` mediumtext NOT NULL ) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `slow_log` -- LOCK TABLES `slow_log` WRITE; /*!40000 ALTER TABLE `slow_log` DISABLE KEYS */; INSERT INTO `slow_log` VALUES ('2008-06-01 07:35:11','global[global] @ [69.93.50.154]','00:00:11','00:00:00',0,339055,'esea',0,0,1,'SELECT t.subject, t.id AS tid, t.replies, u.id AS uid, u.alias, c2.id AS country, c2.name AS country_name, u2.id AS latest_user_id, u2.alias AS latest_user_alias, c3.id AS latest_country_abbr, c3.name AS latest_country_name, c.id AS latest_id, c.post_time AS most_recent \n FROM comments c, forums_topics t, users u, users u2, countries c2, countries c3, forums f \n WHERE f.id = 3 \n AND t.forum_id = f.id \n AND t.last_comment_id = c.id \n AND c.user_id = u2.id \n AND u2.country = c3.id \n AND t.user_id = u.id \n AND u.country = c2.id \n AND f.site_id = 1 \n ORDER BY t.is_sticky DESC, t.last_comment_post_time DESC LIMIT 58100, 25'),('2008-06-01 15:59:46','global[global] @ [69.93.50.154]','00:00:14','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.wins) AS sorted_stat, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY wins desc LIMIT 5'),('2008-06-01 15:59:58','global[global] @ [69.93.50.154]','00:00:12','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.5k) AS sorted_stat, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY 5k desc LIMIT 5'),('2008-06-01 16:00:10','global[global] @ [69.93.50.154]','00:00:12','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.frags) AS sorted_stat, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY frags desc LIMIT 5'),('2008-06-01 16:00:22','global[global] @ [69.93.50.154]','00:00:11','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, AVG(s.fpr) AS sorted_stat, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY fpr desc LIMIT 5'),('2008-06-01 16:00:35','global[global] @ [69.93.50.154]','00:00:12','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, SUM(s.rounds_played) AS sorted_stat, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY rounds_played desc LIMIT 5'),('2008-06-01 16:00:48','global[global] @ [69.93.50.154]','00:00:12','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, AVG(s.skill) AS sorted_stat, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY skill desc LIMIT 5'),('2008-06-01 16:01:00','global[global] @ [69.93.50.154]','00:00:12','00:00:00',5,1448898,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuses) AS sorted_stat, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY bomb_defuses desc LIMIT 5'),('2008-06-01 19:13:18','global[global] @ [69.93.50.154]','00:00:10','00:00:00',12,16383,'esea',0,0,1,'(SELECT d.id, \'downloads\' AS parent_type, d.name AS `string` , d.replies, d.post_time, c.post_time AS last_reply_time \n FROM (downloads d, downloads_types d2) \n LEFT JOIN comments c \n ON c.parent_type = \'downloads\' \n AND c.id = d.last_comment_id \n WHERE d.type = d2.id \n AND d2.display = 1 \n AND d.status = \'public\' \n AND d.site_id = 1 \n AND d.region_id IN(0, 1) \n ORDER BY post_time DESC ) UNION (SELECT d.id, \'demos\' AS parent_type, CONCAT( d.pov_name, \' (\', d.team_one_country, \') vs \', d.team_two_tag, \' (\', d.team_two_country, \')\' ) AS `string` , d.replies, d.post_time, c.post_time AS last_reply_time \n FROM (demos d, servers_maps m) \n LEFT JOIN comments c \n ON c.parent_type = \'demos\' \n AND c.id = d.last_comment_id \n WHERE STATUS = \'public\' \n AND d.map = m.id \n AND d.site_id = 1 \n AND d.region_id IN(0, 1) \n ORDER BY post_time DESC ) ORDER BY post_time DESC LIMIT 12'),('2008-06-01 19:13:18','global[global] @ [69.93.50.154]','00:00:10','00:00:00',12,16383,'esea',0,0,1,'(SELECT d.id, \'downloads\' AS parent_type, d.name AS `string` , d.replies, d.post_time, c.post_time AS last_reply_time \n FROM (downloads d, downloads_types d2) \n LEFT JOIN comments c \n ON c.parent_type = \'downloads\' \n AND c.id = d.last_comment_id \n WHERE d.type = d2.id \n AND d2.display = 1 \n AND d.status = \'public\' \n AND d.site_id = 1 \n AND d.region_id IN(0, 1) \n ORDER BY post_time DESC ) UNION (SELECT d.id, \'demos\' AS parent_type, CONCAT( d.pov_name, \' (\', d.team_one_country, \') vs \', d.team_two_tag, \' (\', d.team_two_country, \')\' ) AS `string` , d.replies, d.post_time, c.post_time AS last_reply_time \n FROM (demos d, servers_maps m) \n LEFT JOIN comments c \n ON c.parent_type = \'demos\' \n AND c.id = d.last_comment_id \n WHERE STATUS = \'public\' \n AND d.map = m.id \n AND d.site_id = 1 \n AND d.region_id IN(0, 1) \n ORDER BY post_time DESC ) ORDER BY post_time DESC LIMIT 12'),('2008-06-01 19:13:18','global[global] @ [69.93.50.154]','00:00:10','00:00:00',12,16383,'esea',0,0,1,'(SELECT d.id, \'downloads\' AS parent_type, d.name AS `string` , d.replies, d.post_time, c.post_time AS last_reply_time \n FROM (downloads d, downloads_types d2) \n LEFT JOIN comments c \n ON c.parent_type = \'downloads\' \n AND c.id = d.last_comment_id \n WHERE d.type = d2.id \n AND d2.display = 1 \n AND d.status = \'public\' \n AND d.site_id = 1 \n AND d.region_id IN(0, 1) \n ORDER BY post_time DESC ) UNION (SELECT d.id, \'demos\' AS parent_type, CONCAT( d.pov_name, \' (\', d.team_one_country, \') vs \', d.team_two_tag, \' (\', d.team_two_country, \')\' ) AS `string` , d.replies, d.post_time, c.post_time AS last_reply_time \n FROM (demos d, servers_maps m) \n LEFT JOIN comments c \n ON c.parent_type = \'demos\' \n AND c.id = d.last_comment_id \n WHERE STATUS = \'public\' \n AND d.map = m.id \n AND d.site_id = 1 \n AND d.region_id IN(0, 1) \n ORDER BY post_time DESC ) ORDER BY post_time DESC LIMIT 12'),('2008-06-01 19:14:25','overlord[overlord] @ [69.93.50.152]','00:00:56','00:00:00',1,120562,'0',0,0,1,'SELECT n.id, n.title, n.post_time, COUNT(r.id) FROM (esea.content n, esea.users u, esea.content_types c) LEFT JOIN esea.comments r ON r.parent_type = \'content\' AND r.parent_id = n.id WHERE n.status = \'public\' AND n.type = c.id AND c.display = 1 AND n.author = u.id AND n.site_id = 1 GROUP BY n.id ORDER BY n.post_time DESC LIMIT 1'),('2008-06-01 19:14:46','global[global] @ [69.93.50.154]','00:00:13','00:00:00',15,5860,'esea',0,0,1,'SELECT m.id, m.type, m.time_start, m.time_end, m.players_per_side, m.rounds_per_half, g.id AS game_id, g.name AS game_name, g.abbr AS game_abbr, g.icon AS game_icon, m4.name AS map_name, s.id AS server_id, s.host AS server_host, s.name AS server_name, d.id AS demo_id, d.file_time_start AS demo_file_time_start, d.file_size AS demo_file_size, d.downloads AS demo_downloads, m3.team, m.team_1_id, t.name AS team_1_name, SUM(m2.team_1_score) AS team_1_score, m.team_2_id, t2.name AS team_2_name, SUM(m2.team_2_score) AS team_2_score \r\n FROM (statistics.matches m, statistics.matches_periods m2, statistics.`cs_stats_match` m3, statistics.references r, statistics.maps m4, esea.servers s, esea.games g) \r\n LEFT JOIN esea.demos_hltv d \r\n ON m.spectv_demo_id = d.id \r\n LEFT JOIN esea.teams t \r\n ON m.team_1_id = t.id \r\n LEFT JOIN esea.teams t2 \r\n ON m.team_2_id = t2.id \r\n WHERE m.map_id = m4.id \r\n AND m.server_id = s.id \r\n AND m.id = m2.match_id \r\n AND m.id = m3.match_id \r\n AND m3.ref_id = r.id \r\n AND r.type = \'user_id_esea\' \r\n AND m.game_id = g.id \r\n AND m2.period = m3.period AND r.user_id = \'186372\' AND m.type = \'pug\' GROUP BY m.id \r\n ORDER BY m.time_end DESC LIMIT 15'),('2008-06-01 19:15:00','global[global] @ [69.93.50.154]','00:00:25','00:00:00',5,41109,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, s.time, s.skill, s.frags, s.assists, s.deaths, s.suicides, s.tks, s.errors, s.bomb_plants, s.bomb_explosions, s.bps, s.bomb_defuses, s.bomb_defuse_attempts, s.bds, s.1v1, s.1v2, s.1v3, s.1v4, s.1v5, s.1k, s.2k, s.3k, s.4k, s.5k, s.5k AS sorted_stat, s.damage, s.rounds_played, s.adr, s.fpr, s.wins, s.losses, s.ties, s.win_pct FROM statistics.`css_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND s.date BETWEEN \'2008-06-01\' AND \'2008-06-01\' AND c2.region_id IN(1) AND s.type = \'pug\' ORDER BY 5k desc LIMIT 5'),('2008-06-01 19:19:25','global[global] @ [69.93.50.154]','00:00:28','00:00:00',5,1449522,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.wins) AS sorted_stat, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY wins desc LIMIT 5'),('2008-06-01 19:19:46','global[global] @ [69.93.50.154]','00:00:10','00:00:00',5,1449522,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.frags) AS sorted_stat, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY frags desc LIMIT 5'),('2008-06-01 20:20:15','global[global] @ [69.93.50.154]','01:00:10','00:00:00',5,1449522,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, AVG(s.skill) AS sorted_stat, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY skill desc LIMIT 5'),('2008-06-01 20:20:25','global[global] @ [69.93.50.154]','00:00:10','00:00:00',5,1449522,'esea',0,0,1,'SELECT u.id, u.alias, u.image_file_name, u.image_thumb, c.id AS country_abbr, c.name AS country_name, s.date, SUM(s.time) AS time, AVG(s.skill) AS skill, SUM(s.frags) AS frags, SUM(s.assists) AS assists, SUM(s.deaths) AS deaths, SUM(s.suicides) AS suicides, SUM(s.tks) AS tks, SUM(s.errors) AS errors, SUM(s.bomb_plants) AS bomb_plants, SUM(s.bomb_explosions) AS bomb_explosions, AVG(s.bps) AS bps, SUM(s.bomb_defuses) AS bomb_defuses, SUM(s.bomb_defuses) AS sorted_stat, SUM(s.bomb_defuse_attempts) AS bomb_defuse_attempts, AVG(s.bds) AS bds, SUM(s.1v1) AS 1v1, SUM(s.1v2) AS 1v2, SUM(s.1v3) AS 1v3, SUM(s.1v4) AS 1v4, SUM(s.1v5) AS 1v5, SUM(s.1k) AS 1k, SUM(s.2k) AS 2k, SUM(s.3k) AS 3k, SUM(s.4k) AS 4k, SUM(s.5k) AS 5k, SUM(s.damage) AS damage, SUM(s.rounds_played) AS rounds_played, AVG(s.adr) AS adr, AVG(s.fpr) AS fpr, SUM(s.wins) AS wins, SUM(s.losses) AS losses, SUM(s.ties) AS ties, AVG(s.win_pct) AS win_pct FROM statistics.`cs_stats_type_m` s, statistics.references r, esea.users u, esea.countries c, esea.countries c2 WHERE r.type = \'user_id_esea\' \r\n AND r.user_id = u.id \r\n AND s.ref_id = r.id \r\n AND u.is_premium = 1 \r\n AND u.country = c.id \r\n AND u.geo_country = c2.id AND c2.region_id IN(1) AND s.type = \'pug\' GROUP BY u.id ORDER BY bomb_defuses desc LIMIT 5'),('2008-06-01 20:30:57','global[global] @ [69.93.50.154]','00:00:12','00:00:00',7,153124,'esea',0,0,1,'SELECT u.user_id, COUNT(DISTINCT c.parent_id) AS tickets \n FROM users_groups_sites u, comments c \n WHERE c.parent_type = \'support_tickets\' \n AND c.post_time BETWEEN 1212278400 AND 1214870399 \n AND u.group_id = 13 \n AND u.site_id = c.site_id \n AND c.site_id = 1 \n AND u.user_id = c.user_id \n GROUP BY u.user_id'),('2008-06-01 21:43:58','global[global] @ [69.93.50.154]','00:00:19','00:00:00',1,876991,'esea',0,0,1,'SELECT ip_address FROM users_ips WHERE ban_id=26013'); /*!40000 ALTER TABLE `slow_log` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2009-12-31 17:37:22