Cliquer ici pour les instructions de mise à jour.

Une Seule Technique : Charger, Tapper, Looter. Site web : chevalierswow.free.fr        Chan inter-guildes : ancienschevaliers

Chevaliers @ Sinstralis (PvE)
Dernière mise à jour: 22/09/2007 21:32:18 (PST)
Membres: 90 (+0 Alts)
  • Average Level: 40
  • Niveau 70: 28
  • Niveau 60-69: 4
  • Niveau 50-59: 6
  • Niveau 40-49: 13
  • Niveau 30-39: 6
  • Niveau 1-29: 33
WoW Server Status
Addons:


 Chaman
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
Arakìs
 Chaman
70
Membre    22/09/2007 14:32:00   []
 Chaman
70
Reroll   22/09/2007 17:32:00 22/09/2007 21:31:28 []
Ziuh
 Chaman
46
Reroll    22/09/2007 23:32:00   []
Qara
 Chaman
41
Reroll    21/09/2007 15:32:00   []
 Chaman
27
Vacancier   25/08/2007 20:32:00 26/10/2007 14:18:49 []
 Chaman
22
Reroll   02/09/2007 07:32:00 06/07/2007 20:04:11 []
 Chaman
21
Reroll   11/09/2007 00:32:00 23/09/2007 08:29:42 []
Ethanael
 Chaman
6
Vacancier    03/09/2007 04:32:00   []

 Chasseur
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Chasseur
70
Reroll   21/09/2007 06:32:00 20/09/2007 14:02:24 []
 Chasseur
70
Reroll   22/09/2007 00:32:00 22/08/2007 12:04:20 []
 Chasseur
70
Membre   17/09/2007 03:32:00 08/07/2007 12:34:11 []
 Chasseur
70
Membre   22/09/2007 00:32:00 03/07/2007 18:13:48 []
 Chasseur
69
Reroll   22/09/2007 22:32:00 23/09/2007 08:23:56 []
Zitô
 Chasseur
57
Membre    22/09/2007 23:32:00   []
 Chasseur
54
Vacancier   08/09/2007 11:32:00 01/08/2007 18:28:04 []
Altésia
 Chasseur
45
Vacancier    21/09/2007 15:32:00   []
 Chasseur
43
Reroll   27/08/2007 20:32:00 06/11/2007 16:30:26 []
Silméria
 Chasseur
35
Novice    28/08/2007 02:32:00   []
Timha
 Chasseur
30
Reroll    01/09/2007 09:32:00   []
 Chasseur
10
Banque   22/09/2007 22:32:00 22/09/2007 21:30:16 []
 Chasseur
3
Vacancier   19/09/2007 00:32:00 09/09/2007 21:54:25 []

 Démoniste
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Démoniste
70
Membre   22/09/2007 05:32:00 23/09/2007 19:13:08 []
 Démoniste
53
Reroll   22/09/2007 22:32:00 22/09/2007 21:32:02 []
Kniack
 Démoniste
42
Vacancier    18/09/2007 01:32:00   []
 Démoniste
40
Reroll   09/09/2007 20:32:00 31/07/2007 12:45:43 []
Azraêlle
 Démoniste
37
Reroll    22/09/2007 14:32:00   []
Naburu
 Démoniste
23
Reroll    25/08/2007 02:32:00   []
 Démoniste
15
Vacancier   22/09/2007 23:32:00 23/09/2007 08:29:11 []
 Démoniste
15
Reroll   25/08/2007 01:32:00 27/10/2007 20:03:06 []
 Démoniste
1
Banque   21/09/2007 06:32:00 16/07/2007 11:05:33 []
 Démoniste
1
Banque   22/09/2007 22:32:00 03/07/2007 18:15:28 []
Titoupwette
 Démoniste
1
Banque    28/08/2007 00:32:00   []

 Druide
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Druide
70
Membre   22/09/2007 22:32:00 22/09/2007 21:29:49 []
 Druide
52
Reroll   22/09/2007 21:32:00 22/09/2007 21:33:38 []
 Druide
49
Reroll   21/09/2007 21:32:00 03/07/2007 18:00:04 []
Leanna
 Druide
45
Vacancier    22/09/2007 01:32:00   []
 Druide
44
Reroll   21/09/2007 06:32:00 29/07/2007 10:12:21 []
Ahrnix
 Druide
25
Vacancier    07/06/2007 21:32:00   []

 Guerrier
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
Archael
 Guerrier
70
Membre    03/09/2007 08:32:00   []
 Guerrier
70
Reroll   04/09/2007 09:32:00 11/08/2007 11:13:15 []
 Guerrier
70
Reroll   22/09/2007 06:32:00 15/07/2007 15:03:25 []
 Guerrier
70
Membre   22/09/2007 15:32:00 22/08/2007 11:59:43 []
Makime
 Guerrier
70
Membre    22/09/2007 09:32:00   []
Tima
 Guerrier
70
Membre    03/09/2007 01:32:00   []
 Guerrier
70
Membre   22/09/2007 22:32:00 09/11/2007 23:24:01 []
Anaxia
 Guerrier
58
Reroll    12/09/2007 15:32:00   []
 Guerrier
14
Banque   28/08/2007 00:32:00 23/08/2007 13:53:42 []
 Guerrier
12
Vacancier   17/09/2007 20:32:00 15/07/2007 09:05:05 []
 Guerrier
7
Vacancier   04/09/2007 01:32:00 15/07/2007 19:37:13 []
 Guerrier
1
Banque   22/09/2007 17:32:00 22/09/2007 14:46:14 []
 Guerrier
1
Banque   22/09/2007 21:32:00 22/08/2007 12:01:45 []
 Guerrier
1
Banque   21/09/2007 02:32:00 31/07/2007 14:33:40 []
 Guerrier
1
Banque   28/08/2007 00:32:00 23/08/2007 13:59:02 []
 Guerrier
1
Banque   22/09/2007 20:32:00 28/10/2007 18:46:57 []

 Mage
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Mage
70
Reroll   22/09/2007 21:32:00 15/07/2007 15:07:54 []
 Mage
70
Reroll   22/09/2007 23:32:00 09/11/2007 21:17:14 []
 Mage
70
Membre   29/08/2007 22:32:00 23/08/2007 13:50:21 []
 Mage
70
Membre   22/09/2007 22:32:00 22/09/2007 21:29:20 []
Irpy
 Mage
64
Membre    18/09/2007 01:32:00   []
 Mage
2
Banque   07/09/2007 21:32:00 07/08/2007 22:36:38 []
Timamule
 Mage
1
Banque    23/08/2007 08:32:00   []

 Paladin
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Paladin
70
Reroll   22/09/2007 08:32:00 22/08/2007 12:06:17 []
 Paladin
70
Membre   22/09/2007 22:32:00 23/09/2007 08:26:27 []
 Paladin
70
Reroll   22/09/2007 22:32:00 15/07/2007 15:05:41 []
Diabolikk
 Paladin
60
Vacancier    10/05/2007 22:32:00   []
 Paladin
40
Banque   28/08/2007 00:32:00 23/08/2007 13:52:49 []
Mordredh
 Paladin
34
Reroll    31/08/2007 04:32:00   []
 Paladin
13
Banque   22/09/2007 19:32:00 26/10/2007 14:34:04 []
 Paladin
11
Reroll   08/09/2007 09:32:00 07/08/2007 14:04:24 []

 Prêtre
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Prêtre
70
Reroll   22/09/2007 22:32:00 22/09/2007 21:37:28 []
 Prêtre
70
Membre+   22/09/2007 14:32:00 31/07/2007 14:27:06 []
 Prêtre
70
Membre   22/09/2007 21:32:00 15/07/2007 15:12:06 []
 Prêtre
70
Reroll   22/09/2007 22:32:00 23/09/2007 22:24:07 []
Dîablotin
 Prêtre
54
Vacancier    08/05/2007 21:32:00   []
 Prêtre
42
Reroll   22/09/2007 22:32:00 04/11/2007 23:19:29 []
 Prêtre
40
Reroll   02/09/2007 02:32:00 05/07/2007 17:54:18 []
Plume
 Prêtre
32
Reroll    18/09/2007 08:32:00   []
 Prêtre
7
Banque   21/09/2007 06:32:00 16/07/2007 11:10:04 []
Apaspom
 Prêtre
6
Reroll    13/08/2007 03:32:00   []
 Prêtre
1
Banque   07/09/2007 21:32:00 07/08/2007 22:42:12 []
 Prêtre
1
Banque   19/09/2007 03:32:00 03/07/2007 18:16:46 []

 Voleur
Nom Classe Niveau Titre Métiers Dernière connexion Dernière mise à jour Note
 Voleur
70
Reroll   22/09/2007 23:32:00 22/09/2007 21:31:05 []
Solèfein
 Voleur
70
Vacancier    22/09/2007 11:32:00   []
Leths
 Voleur
60
Reroll    01/09/2007 08:32:00   []
Erévane
 Voleur
43
Vacancier    22/09/2007 05:32:00   []
 Voleur
38
Reroll   13/09/2007 02:32:00 15/07/2007 15:09:50 []
 Voleur
25
Reroll   09/09/2007 20:32:00 31/07/2007 12:38:08 []
 Voleur
10
Banque   14/08/2007 00:32:00 02/07/2007 20:06:24 []
 Voleur
1
Banque   21/09/2007 02:32:00 22/09/2007 21:32:39 []
 Voleur
1
Banque   22/09/2007 21:32:00 22/09/2007 18:53:49 []

Instructions de mise à jour.
Actualisation automatique recommandée:
  • Utiliser UniUploader
    Prérequis à l'utilisation d'UniUploader:Microsoft .NET Framework installé
    Pour les utilisateurs d'OS autres que Windows, utiliser JUniUploader qui vous permettra d'effectuer les mêmes opérations que UniUploader mais en mode Java.
Instructions pour actualiser le profil:
  1. Download Character Profiler
  2. Décompresser le fichier zip dans son propre répertoire dans le répertoire *WoW Directory*\Interface\Addons\.
  3. Démarrer WoW
  4. Ouvrir votre compte en banque, la fenêtre des quêtes, et la fenêtre des professions qui contient les recettes
  5. Se déconnecter ou quitter WoW.
    (Voir ci-dessus si vous disposez d'UniUploader pour automatiser l'envois des informations.)
  6. Aller sur la page d'actualisation
  7. Cliquer parcourir (browse) et télécharger les fichiers *.lua
Statistique PvP Optionnel:
  1. Télécharger PvPLog
  2. Décompresser le fichier zip dans son propre directory sous *WoW Directory*\Interface\Addons\ (PvPLog\) répertoire.
  3. Duel ou PvP
  4. Envoyer les informations PvPLog.lua (voir étape 7 de l'actualisation du profil).


WoWRoster v1.7.3

Props to Celandro, Paleblackness, Pytte, Rubricsinger, and Konkers for the original code used for this site.
WoWRoster home - www.wowroster.net
World of Warcraft and Blizzard Entertainment are trademarks or registered trademarks of Blizzard Entertainment, Inc. in the U.S. and/or other countries. All other trademarks are the property of their respective owners.
Additional Credits


Valid HTML 4.0 Transitional

This page was created in 0.27 seconds with 67 queries executed

SQL Queries
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis'
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 `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`note`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`level`, `members`.`guild_rank`, `members`.`guild_title`, `members`.`zone`, DATE_FORMAT( `members`.`last_online`, '%d/%m/%Y %H:%i:%s' ) AS 'last_online', `players`.`race`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`exp`, `players`.`server`, `players`.`clientLocale` , `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', `players`.`dateupdatedutc` AS 'last_update', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '1' ORDER BY `members`.`class` ASC, `members`.`level` DESC, `members`.`name` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '47' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '52' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '13' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '32' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '16' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '54' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '8' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '21' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '46' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '23' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '19' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '64' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '88' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '44' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '10' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '42' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '4' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '36' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '28' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '62' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '14' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '57' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '18' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '24' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '26' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '40' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '17' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '29' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '67' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '73' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '82' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '60' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '58' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '31' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '68' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '78' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '9' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '50' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '66' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '5' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '25' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '51' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '37' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '69' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '3' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '81' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '1' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '20' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '11' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '43' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '77' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '2' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '45' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '53' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '63' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '6' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '38' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '56' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '61' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '22' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '39' AND (`skill_type` = 'Métiers' OR `skill_type` = 'Compétences secondaires') ORDER BY `skill_order` ASC