SELECT `config_name`, `config_value` FROM `roster2_config` ORDER BY `id` ASC;
SELECT * FROM `roster2_guild` WHERE `guild_name` = 'Imperial Defenders' AND `server` = 'Terenas'
SELECT m.member_id, m.name as member_name, m.note as member_note, m.officer_note as member_officer_note, i.*, sum(i.item_quantity) as total_quantity
FROM `roster2_items` as i, `roster2_members` as m
WHERE i.member_id=m.member_id
AND m.officer_note LIKE '%bankmule%'
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Soulbound%'
OR i.item_tooltip
LIKE '%Binds when equipped%')
GROUP BY i.item_name
SELECT m.member_id, m.name as member_name, m.note as member_note, m.officer_note as member_officer_note, i.*
FROM `roster2_items` as i, `roster2_members` as m
WHERE i.member_id=m.member_id
AND m.officer_note LIKE '%bankmule%'
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Soulbound%'
OR i.item_tooltip
LIKE '%Binds when equipped%')
ORDER BY i.item_name
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster2_guild` WHERE `guild_name` = 'Imperial Defenders' AND `server` ='Terenas'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster2_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC