SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Legion of Sun' AND `server` = 'Perenolde'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Legion of Sun' AND `server` ='Perenolde'
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 `s`.*, `p`.`name` FROM `roster_skills` s, `roster_players` p
WHERE p.member_id = s.member_id
AND p.guild_id = '1'
AND SUBSTRING_INDEX( s.skill_level, ':', 1 ) > 1
AND skill_name IN ('Alchemy','Alchimie','Alchimie','Herbalism','Herboristerie','Kräuterkunde','Blacksmithing','Forge','Schmiedekunst','Mining','Minage','Bergbau','Leatherworking','Travail du cuir','Lederverarbeitung','Skinning','Dépeçage','Kürschnerei','Tailoring','Couture','Schneiderei','Enchanting','Enchantement','Verzauberkunst','Engineering','Ingénierie','Ingenieurskunst','Cooking','Cuisine','Kochkunst','Fishing','Pêche','Angeln','First Aid','Secourisme','Erste Hilfe')
ORDER BY s.skill_type,s.skill_name,(mid(skill_level FROM 1 FOR (locate(':', skill_level)-1)) + 0) DESC, p.name;