SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Nox Oriens' AND `server` = 'Lightninghoof'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Nox Oriens' AND `server` ='Lightninghoof'
SELECT IF(`guild_title` LIKE '%%',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`, `p`.`clientLocale` 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', 'Kräuterkunde', 'Schmiedekunst', 'Bergbau', 'Lederverarbeitung', 'Juwelenschleifen', 'Kürschnerei', 'Schneiderei', 'Verzauberkunst', 'Ingenieurskunst', 'Kochkunst', 'Angeln', 'Erste Hilfe', 'GifteAlchemy', 'Herbalism', 'Blacksmithing', 'Mining', 'Leatherworking', 'Jewelcrafting', 'Skinning', 'Tailoring', 'Enchanting', 'Engineering', 'Cooking', 'Fishing', 'First Aid', 'PoisonsAlquimia', 'Botánica', 'Herrería', 'Minería', 'Peletería', 'Joyería', 'Desollar', 'Sastrería', 'Encantamiento', 'Ingeniería', 'Cocina', 'Pesca', 'Primeros auxilios', 'VenenosAlchimie', 'Herboristerie', 'Forge', 'Minage', 'Travail du cuir', 'Joaillerie', 'Dépeçage', 'Couture', 'Enchantement', 'Ingénierie', 'Cuisine', 'Pêche', 'Premiers soins', 'Poisons')
ORDER BY s.skill_type,s.skill_name,(mid(skill_level FROM 1 FOR (locate(':', skill_level)-1)) + 0) DESC, p.name;