SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Nova' AND `server` = 'Hakkar'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Nova' AND `server` ='Hakkar'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Nova' AND `server` = 'Hakkar'
SELECT `name`, `RankName` FROM `roster_players` ORDER BY `RankInfo` DESC LIMIT 0,1
SELECT `name`, `lifetimeRankName` FROM `roster_players` ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1
SELECT `name`, `lifetimeHK` FROM `roster_players` ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1
SELECT `name`, `lifetimeCP` FROM `roster_players` ORDER BY `lifetimeCP` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Nova' AND `server` = 'Hakkar'
SELECT `guild`, COUNT(`guild`) AS countg FROM `roster_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC
SELECT `guild`, COUNT(`guild`) AS countg FROM `roster_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `guild` ORDER BY countg DESC
SELECT `name`, COUNT(`name`) AS countg FROM `roster_pvp2` WHERE `win` = '1' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC
SELECT `name`, COUNT(`name`) AS countg FROM `roster_pvp2` WHERE `win` = '0' AND `enemy` = '1' GROUP BY `name` ORDER BY countg DESC
SELECT pvp2.member_id, members.name AS gn, COUNT(pvp2.member_id) AS countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY countg DESC
SELECT pvp2.member_id, members.name AS gn, COUNT(pvp2.member_id) as countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '0' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY countg DESC
SELECT pvp2.member_id, members.name as gn, AVG(pvp2.`leveldiff`) as ave, COUNT(pvp2.member_id) as countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY ave DESC
SELECT pvp2.member_id, members.name as gn, AVG(pvp2.`leveldiff`) as ave, COUNT(pvp2.member_id) as countg FROM `roster_pvp2` pvp2 LEFT JOIN `roster_members` members ON members.member_id = pvp2.member_id WHERE win = '0' AND enemy = '1' GROUP BY pvp2.member_id ORDER BY ave DESC
SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`note`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`level`, `members`.`guild_rank`, `members`.`guild_title`, `members`.`zone`, DATE_FORMAT( `members`.`last_online`, '%a %b %D, %l:%i %p' ) AS 'last_online', `players`.`race`, `players`.`RankName`, `players`.`RankInfo`, IF( `players`.`RankInfo` IS NULL OR `players`.`RankInfo` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale` , `players`.`RankIcon`, `players`.`Rankexp`, `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`class` ASC, `members`.`level` DESC, `members`.`name` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '283' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '199' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '285' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '278' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '158' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '72' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '102' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '110' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '345' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '35' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '91' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '184' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '37' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '106' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '243' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '216' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '192' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '81' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '63' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '257' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '55' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '120' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '155' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '301' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '86' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '179' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '159' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '298' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '9' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '103' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '57' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '371' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '92' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '356' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '22' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '334' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '232' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '174' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '51' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '89' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '119' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '308' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '136' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '253' AND (`skill_type` = 'Professions' OR `skill_type` = 'Secondary Skills') ORDER BY `skill_order` ASC