SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'The Wipe' AND `server` = 'Rashgarroth'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'The Wipe' AND `server` ='Rashgarroth'
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 ('Alchimie','Alchemy','Kräuterkunde','Herbalism','Schmiedekunst','Blacksmithing','Bergbau','Mining','Lederverarbeitung','Leatherworking','Kürschnerei','Skinning','Schneiderei','Tailoring','Verzauberkunst','Enchanting','Ingenieurskunst','Engineering','Kochkunst','Cooking','Angeln','Fishing','Erste Hilfe','First Aid')
ORDER BY s.skill_type,s.skill_name,(mid(skill_level FROM 1 FOR (locate(':', skill_level)-1)) + 0) DESC, p.name;