SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis'
SELECT m.member_id, m.name AS member_name, m.note AS member_note, m.officer_note AS member_officer_note, 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.guild_title LIKE '%Banque%' AND p.member_id = m.member_id
ORDER BY m.name
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
SELECT SUM( p.money_g ) AS gold, SUM( p.money_s ) AS silver, SUM( p.money_c ) as copper
FROM `roster_players` AS p, `roster_members` AS m
WHERE m.guild_title LIKE '%Banque%'
AND p.member_id = m.member_id
ORDER BY m.name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Ba'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 64=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Baldkaar'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 3=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Bankpriest'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 53=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Bisty'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 5=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Deï'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 28=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Ebayeur'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 22=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Laury'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 60=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Lindire'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 62=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Louriaka'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 61=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Minimae'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 58=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Moch'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 45=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Mulindir'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 63=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Porteursa'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 39=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Sirhana'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 31=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Tîtou'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 67=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Titouneter'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 69=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Titoupopo'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 68=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Zutbank'
SELECT i.*,LEFT(i.item_id, (LOCATE(':',i.item_id)-1)) as real_itemid,sum(i.item_quantity) as total_quantity
FROM `roster_items` as i
WHERE 78=i.member_id
AND i.item_parent!='bags'
AND i.item_parent!='equip'
AND (i.item_tooltip
NOT LIKE '%Lié%'
OR i.item_tooltip
LIKE '%Lié quand équipé%')
GROUP BY real_itemid
ORDER BY i.item_name