SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Les fondateurs d Azeroth' AND `server` = 'Krasus'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Les fondateurs d Azeroth' AND `server` ='Krasus'
SELECT IF(`guild_title` LIKE '%civil%',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 *,
DATE_FORMAT( `update_time`, '%d/%m/%Y %H:%i:%s' ) AS 'date'
FROM `roster_memberlog` ORDER BY `class` DESC
SELECT *,
DATE_FORMAT( `update_time`, '%d/%m/%Y %H:%i:%s' ) AS 'date'
FROM `roster_memberlog` ORDER BY `class` DESC LIMIT 0 , 30