Critico
Sexy
- Joined
- Mar 25, 2010
- Messages
- 370
- Reaction score
- 176
Query: SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `players` ORDER BY `experience` DESC
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `houses` WHERE `owner`=0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `houses` WHERE `owner`=1;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `players` WHERE `id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `accounts` WHERE `id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `account_bans` WHERE `account_id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `guilds` WHERE `id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;
SQLSTATE: 00000
Driver code:
Error message:
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `players` ORDER BY `experience` DESC
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `houses` WHERE `owner`=0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `houses` WHERE `owner`=1;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `players` WHERE `id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `accounts` WHERE `id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `account_bans` WHERE `account_id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT COUNT(*) FROM `guilds` WHERE `id`>0;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;
SQLSTATE: 00000
Driver code:
Error message: