|
||||||||||||||||||||
|
|
| WoWRoster Addons | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||
| SQL Queries | ||
|---|---|---|
|
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 `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 |
||