|
||||||||||||||||||||
|
||
Donjon 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 `faction` FROM `roster_guild` where `guild_name` = 'Dark side of the Horde' and `server` ='Dalaran' SELECT distinct class FROM `roster_players` ORDER BY class ASC SELECT name, level, member_id, class, clientLocale FROM `roster_players` WHERE level > 50 GROUP BY name ORDER BY class ASC, name ASC SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Tunique de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Gants de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Coiffe de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Pantalon de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de bestiaire' AND member_id = '29' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Tunique de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Gants de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Coiffe de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Pantalon de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de bestiaire' AND member_id = '118' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Robe de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Gants de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Masque de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de Brume-funeste' AND member_id = '254' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Robe de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Gants de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Masque de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de Brume-funeste' AND member_id = '193' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Robe de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Gants de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Masque de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de Brume-funeste' AND member_id = '281' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Bottes du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Gilet du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Gants du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Coiffe du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Kilt du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Spallières du Coeur-Sauvage' AND member_id = '119' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Bottes du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Gilet du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Gants du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Coiffe du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Kilt du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Spallières du Coeur-Sauvage' AND member_id = '23' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Cuirasse de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Gantelets de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Casque de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Spallières de vaillance' AND member_id = '234' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Cuirasse de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Gantelets de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Casque de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Spallières de vaillance' AND member_id = '26' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Cuirasse de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Gantelets de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Casque de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Spallières de vaillance' AND member_id = '4' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Cuirasse de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Gantelets de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Casque de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Spallières de vaillance' AND member_id = '24' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Robe de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Gants de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Manteau de magistère' AND member_id = '13' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Robe de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Gants de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Manteau de magistère' AND member_id = '5' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Robe de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Gants de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Manteau de magistère' AND member_id = '126' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Robe de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Gants de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Manteau de magistère' AND member_id = '91' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Bottes de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Cuirasse de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Gantelets de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Casque de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Jambières de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Spallières de sancteforge' AND member_id = '296' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Gants de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de dévôt' AND member_id = '67' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Gants de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de dévôt' AND member_id = '16' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Gants de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de dévôt' AND member_id = '260' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Sandales de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Bracelets de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Gants de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Collerette de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Robe de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Mantelet de dévôt' AND member_id = '30' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Bottes Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Brassards Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Tunique Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Gants Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Cagoule Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Pantalon Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Spallières Sombreruse' AND member_id = '263' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Bottes Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Brassards Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Tunique Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Gants Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Cagoule Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Pantalon Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Spallières Sombreruse' AND member_id = '280' SELECT * FROM `roster_items` WHERE item_name = 'Ceinture Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Bottes Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Brassards Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Tunique Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Gants Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Cagoule Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Pantalon Sombreruse' AND member_id = '84' SELECT * FROM `roster_items` WHERE item_name = 'Spallières Sombreruse' AND member_id = '84' 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 |
||