SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis'
SELECT `guild_id`, `guild_name`, DATE_FORMAT(`update_time`, '%d/%m/%Y %H:%i:%s') FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis'
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 = '25'
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 = '54'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '8'
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 = '14'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '6'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '51'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '1'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '46'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '40'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '44'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '21'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '47'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '20'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '9'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '17'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '11'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '43'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '50'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '66'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '37'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '7'
SELECT * FROM `roster_items` WHERE item_parent = 'equip' and item_slot not in ('ammo', 'shirt', 'tabard') AND member_id = '29'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` ='Sinstralis'
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