SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Armageddon' AND `server` = 'Varimathras'
SELECT a.*, b.*, c.guild_name FROM `roster_players` a, `roster_members` b, `roster_guild` c WHERE a.member_id = b.member_id AND a.name = 'Jaag' AND a.server = 'Varimathras' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Jaag'
SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '76' AND `enemy` = '0' ORDER BY 'date' DESC, 'guild', 'name'
SELECT name, guild, race, class, leveldiff, COUNT(name) AS countn FROM `roster_pvp2` WHERE `member_id` = '76' AND `enemy` = '0' AND `bg` = '0' AND `win` = '0' GROUP BY name ORDER BY countn DESC LIMIT 0,1
SELECT name, guild, race, class, leveldiff, COUNT(name) AS countn FROM `roster_pvp2` WHERE `member_id` = '76' AND `enemy` = '0' AND `bg` = '0' AND `win` = '1' GROUP BY name ORDER BY countn DESC LIMIT 0,1
SELECT *, DATE_FORMAT(date, '%d/%m/%Y %H:%i:%s') AS date2 FROM `roster_pvp2` WHERE `member_id` = '76' AND `enemy` = '0' ORDER BY 'date' DESC, 'guild', 'name' LIMIT 0, 50