SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Armageddon' AND `server` = 'Varimathras'
SELECT m.member_id, m.name AS member_name, m.note AS member_note, m.officer_note AS member_officer_note, p.server AS muleservername, p.money_g AS gold, p.money_s AS silver, p.money_c AS copper FROM `roster_players` AS p, `roster_members` AS m WHERE m.note LIKE '%BankMule%' AND p.member_id = m.member_id ORDER BY m.name
SELECT member.name as member_name, member.member_id as member_id, item.*, LEFT(item.item_id, (LOCATE(':',item.item_id)-1)) as real_itemid FROM `roster_items` as item LEFT JOIN `roster_members` as member ON item.member_id=member.member_id WHERE member.note LIKE '%BankMule%' AND item.item_parent!='bags' AND item.item_parent!='equip' AND (item.item_tooltip NOT LIKE '%Lié%' OR item.item_tooltip LIKE '%Lié quand équipé%') ORDER BY item.item_name
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Armageddon' AND `server` ='Varimathras'
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