SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran'
SELECT `guild_id`, `guild_name`, DATE_FORMAT(`update_time`, '%d/%m/%Y %H:%i:%s') FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran'
SELECT distinct class FROM `roster_players` WHERE level >= 55 ORDER BY class ASC
Select distinct item_slot from roster_items WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') order by item_slot
SELECT name, level, member_id, class, clientLocale FROM `roster_players` WHERE level >= 55 GROUP BY name ORDER BY name ASC
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '119'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '13'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '67'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '234'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '263'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '16'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '296'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '280'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '26'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '5'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '126'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '23'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '368'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '254'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '260'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '4'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '84'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '30'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '91'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '193'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '24'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '281'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '118'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` ='Dalaran'
SELECT IF(`note` LIKE '%reroll%',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