SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Pour la Justice' AND `server` = 'Kirin Tor'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Pour la Justice' AND `server` ='Kirin Tor'
SELECT IF(`officer_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 `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`, `honorpoints` FROM `roster_players` ORDER BY `honorpoints` DESC LIMIT 0 , 1
SELECT `name`, `arenapoints` FROM `roster_players` ORDER BY `arenapoints` DESC LIMIT 0 , 1
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`, '%d/%m/%Y %H:%i:%s' ) AS 'last_online', `players`.`race`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale` , `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`.`guild_rank` ASC, `members`.`level` DESC, `members`.`name` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4515' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4543' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4546' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4578' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4594' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4541' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4623' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '3456' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4540' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4715' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4754' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4528' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4608' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4274' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '3468' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4651' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4778' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4740' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4770' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4781' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4749' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4695' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4609' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4539' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4700' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4759' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC