|
||||||||||||||||||||
|
||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 class FROM `roster_players` ORDER BY class ASC SELECT name, level, member_id, class, clientLocale FROM `roster_players` WHERE level > 47 GROUP BY name ORDER BY class ASC, name ASC SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Tir tranquillisant' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Aspect du faucon' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Flèches multiples' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Morsure de serpent' AND member_id = '29' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Tir tranquillisant' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Aspect du faucon' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Flèches multiples' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Morsure de serpent' AND member_id = '118' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Inferno' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rituel de Malédiction' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'un Destrier de l\'Effroi' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de l\'ombre' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Corruption' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Immolation' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Trait de l\'Ombre' AND member_id = '254' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Inferno' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rituel de Malédiction' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'un Destrier de l\'Effroi' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de l\'ombre' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Corruption' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Immolation' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Trait de l\'Ombre' AND member_id = '193' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Inferno' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rituel de Malédiction' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'un Destrier de l\'Effroi' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de l\'ombre' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Corruption' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Immolation' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Trait de l\'Ombre' AND member_id = '281' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Don du fauve' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Don du fauve' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Morsure féroce' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Toucher guérisseur' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Récupération' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Feu stellaire' AND member_id = '119' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Don du fauve' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Don du fauve' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Morsure féroce' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Toucher guérisseur' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Récupération' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Feu stellaire' AND member_id = '23' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Cri de guerre' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Frappe héroïque' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Vengeance' AND member_id = '234' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Cri de guerre' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Frappe héroïque' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Vengeance' AND member_id = '26' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Cri de guerre' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Frappe héroïque' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Vengeance' AND member_id = '4' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Cri de guerre' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Frappe héroïque' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Vengeance' AND member_id = '24' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'eau' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : cochon' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Illumination des arcanes' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de givre' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : tortue' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation de nourriture' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Projectiles des arcanes' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Boule de feu' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eclair de givre' AND member_id = '13' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'eau' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : cochon' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Illumination des arcanes' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de givre' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : tortue' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation de nourriture' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Projectiles des arcanes' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Boule de feu' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eclair de givre' AND member_id = '5' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'eau' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : cochon' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Illumination des arcanes' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de givre' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : tortue' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation de nourriture' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Projectiles des arcanes' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Boule de feu' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eclair de givre' AND member_id = '126' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation d\'eau' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : cochon' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Illumination des arcanes' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Gardien de givre' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Métamorphose : tortue' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation de nourriture' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Projectiles des arcanes' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Boule de feu' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eclair de givre' AND member_id = '91' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Invocation de destrier' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Bénédiction de sagesse' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Bénédiction de puissance' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Lumière sacrée' AND member_id = '296' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de protection contre l\'Ombre' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Soins supérieurs' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de soins' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rénovation' AND member_id = '67' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de protection contre l\'Ombre' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Soins supérieurs' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de soins' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rénovation' AND member_id = '16' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de protection contre l\'Ombre' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Soins supérieurs' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de soins' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rénovation' AND member_id = '260' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de robustesse' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de protection contre l\'Ombre' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Soins supérieurs' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Prière de soins' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Rénovation' AND member_id = '30' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eviscération' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Attaque sournoise' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Poison mortel V' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Feinte' AND member_id = '263' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eviscération' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Attaque sournoise' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Poison mortel V' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Feinte' AND member_id = '280' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Eviscération' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = '' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Attaque sournoise' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Poison mortel V' AND member_id = '84' SELECT * FROM `roster_spellbook` WHERE spell_name = 'Feinte' 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 |
||