|
||||||||||||||||||||
Gemmes pour Châsse : Bleue | ||||||
---|---|---|---|---|---|---|
|
||||||
Gemmes pour Châsse : Rouge | ||||||
---|---|---|---|---|---|---|
|
||||||
Gemmes pour Châsse : Jaune | ||||||
---|---|---|---|---|---|---|
|
||||||
Gemmes pour Châsse : Méta-gemme | ||||||
---|---|---|---|---|---|---|
|
||||||
SQL Queries | ||
---|---|---|
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 DISTINCT p.clientLocale FROM `roster_players` p; SELECT DISTINCT `recipe_name` , `reagents`, `recipe_tooltip`, `recipe_texture`, `item_color` FROM `roster_recipes` WHERE (`recipe_type` = 'Gemmes' AND `skill_name` = 'Joaillerie') ORDER BY `reagents` ASC 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 |
||