-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mar. 22 juil. 2025 à 09:37
-- Version du serveur : 9.1.0
-- Version de PHP : 8.3.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `nemesis`
--

-- --------------------------------------------------------

--
-- Structure de la table `adesion`
--

DROP TABLE IF EXISTS `adesion`;
CREATE TABLE IF NOT EXISTS `adesion` (
  `Id_adesion` int NOT NULL AUTO_INCREMENT,
  `date_adesion` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Id_utilisateur` int DEFAULT NULL,
  PRIMARY KEY (`Id_adesion`),
  KEY `Id_utilisateur` (`Id_utilisateur`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `assemble_general`
--

DROP TABLE IF EXISTS `assemble_general`;
CREATE TABLE IF NOT EXISTS `assemble_general` (
  `Id_assemble_general` int NOT NULL AUTO_INCREMENT,
  `date_ag` date DEFAULT NULL,
  PRIMARY KEY (`Id_assemble_general`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `exclusion`
--

DROP TABLE IF EXISTS `exclusion`;
CREATE TABLE IF NOT EXISTS `exclusion` (
  `Id_exclusion` int NOT NULL AUTO_INCREMENT,
  `date_exclusion` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Id_utilisateur` int NOT NULL,
  PRIMARY KEY (`Id_exclusion`),
  KEY `Id_utilisateur` (`Id_utilisateur`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `ouvrage`
--

DROP TABLE IF EXISTS `ouvrage`;
CREATE TABLE IF NOT EXISTS `ouvrage` (
  `Id_ouvrage` int NOT NULL AUTO_INCREMENT,
  `numero` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `titre` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `etat` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `img` text COLLATE utf8mb4_general_ci,
  `collection` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Id_type` int DEFAULT NULL,
  `code_barre` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`Id_ouvrage`),
  KEY `Id_type` (`Id_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2023 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `ouvrage`
--

INSERT INTO `ouvrage` (`Id_ouvrage`, `numero`, `titre`, `etat`, `img`, `collection`, `Id_type`, `code_barre`) VALUES
(1012, '1558063749', '10 MILLIONS WAYS TO DIE', NULL, NULL, 'AUTRE', NULL, NULL),
(1013, '9782910000000', '3 16 Carnage dans les etoiles', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1014, '2911103629', '7 éme Mer   Eissen', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1015, '2911103785', '7 éme Mer   Ussura', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1016, 'AEG7301', '7 éme Mer   V2  The Pirate nation', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1017, 'SUPPLÉMENT GRATUIT', '7 ème Mer   Compendium', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1018, 'PAS DISBN', '7 ème Mer  V2   Longue vie au prince', NULL, NULL, '', NULL, NULL),
(1019, '2911103645', '7éme Mer   Castille', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1020, '9782920000000', '7eme mer   nation pirates', NULL, NULL, 'CAPE ET DÉPÉE', NULL, NULL),
(1021, '2911103823', '7ème Mer   Vendel Vesten', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1022, '3770000000000', '7eme mer V2 kit du meuneur écran   livret V2  18 cartes de continents', NULL, NULL, 'Cape et epee', NULL, NULL),
(1023, '9782920000000', '7eme mer V2 livre de base', NULL, NULL, 'CAPE ET DÉPÉE', NULL, NULL),
(1024, '9780000000000', '7eme mer  Le prix de larrogance ', NULL, NULL, 'Cape et épée', NULL, NULL),
(1025, 'AEG7002', '7th seas Game master guide', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1026, 'AEG7001', '7th seas Player guide', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1027, '880383275', 'ADD   Oriental adventures  night of the seven sword', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1028, '880383933', 'ADD   Oriental adventures  Ochino the spirit warrior', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1029, '1560768584', 'ADD   The crusades anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1030, '880388382', 'ADD 2em ed  The complete wizards handbook', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1031, '', 'Adventure Guidebook II', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1032, '', 'Aftermath', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1033, '2844760880', 'Agone  A drama in the twilight Realms', NULL, NULL, '', NULL, NULL),
(1034, '02334A', 'Almanach arcadien T1', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1035, '2351120302', 'Almanach arcadien T2', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1036, '2740800770', 'Ambre', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1037, '220724630', 'AMBRE  L univers dAmbre', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1038, '2915496137', 'AmnesYa 2k51   ecran   livret', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1039, '', 'Anima   écran', NULL, NULL, '', NULL, NULL),
(1040, '9788420000000', 'Anima   kit du meneur de jeu', NULL, NULL, '', NULL, NULL),
(1041, '9788420000000', 'Anima   seconde edition core exxet', NULL, NULL, '', NULL, NULL),
(1042, '9788500000000', 'Anima Beyond Fantasy', NULL, NULL, 'AUTRE', NULL, NULL),
(1043, '9788500000000', 'Anima Genesis Visual Art Book', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1044, '9788500000000', 'Anima  Dominus expert', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1045, '2351120132', 'Anoë boite cantique de Karsan', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1046, '2351120094', 'Anoë lâge des reofs', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1047, '2740802307', 'Appel de cthulhu D20', NULL, NULL, 'HORREUR', NULL, NULL),
(1048, '2740800509', 'Appel de Cthulhu Edition 5', NULL, NULL, 'HORREUR', NULL, NULL),
(1049, '2740802072', 'Appel de Cthulhu Edition 5 5', NULL, NULL, 'HORREUR', NULL, NULL),
(1050, '', 'Appel de Cthulhu Edition 6', NULL, NULL, 'HORREUR', NULL, NULL),
(1051, 'PAS DE CODE ISBN', 'Appel de Cthulhu Premiére édition', NULL, NULL, 'HORREUR', NULL, NULL),
(1052, '086989300X', 'Appel de cthulhu Third edition', NULL, NULL, 'HORREUR', NULL, NULL),
(1053, '2914536143', 'Archipels   carnet de voyage', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1054, '291453602X', 'Archipels   La guerre des ombres x2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1055, '2914536232', 'Archipels   Les Brumes de Fulmine', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1056, '2914536216', 'Archipels   Les fievres daberrande', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1057, '', 'Archipels Ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1058, '2914536178', 'Archipels  la taverne qui tangue', NULL, NULL, '', NULL, NULL),
(1059, '291556602X', 'Arkeos   les cendres du Dragon', NULL, NULL, 'AUTRE', NULL, NULL),
(1060, '9782350000000', 'Ars magica   5éme edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1061, '2740801068', 'Ars Magica   La crete des brumes', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1062, '2740800940', 'Ars Magica   La tempête', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1063, '2740800894', 'Ars Magica   le Songe dune nuit dété', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1064, '274080069X', 'Ars Magica   Les alliances', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1065, '2740801130', 'Ars Magica   un conte dhiver', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1066, '2740800878', 'Ars magica  le grimoire du mage', NULL, NULL, '', NULL, NULL),
(1067, '9782350000000', 'Ars Magica  le grimoire du mage', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1068, '9800000000000', 'Athanatos   les immortels', NULL, NULL, '', NULL, NULL),
(1069, '', 'Au seuils dabysses trésanciens', NULL, NULL, 'Horreur', NULL, NULL),
(1070, 'PAS DISBN', 'Avancées Donjons et Dragons   Guide du Maitre', NULL, NULL, '', NULL, NULL),
(1071, 'PAS DISBN', 'Avancées Donjons et Dragons   Manuel des joueurs', NULL, NULL, 'AVENTURE', NULL, NULL),
(1072, '9788420000000', 'aventure en terre du milie   5 edition guide du joueur', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1073, '9788420000000', 'aventure en terre du milieu   5 edition guide du gardien', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1074, '9790000000000', 'Aventure en terre du milieu   guide du gardien des légendes', NULL, NULL, 'MediEVAL FANTAS', NULL, NULL),
(1075, '9788420000000', 'Aventure en terre du milieu   Guide du joueur', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1076, '9782950000000', 'Aventures dans le monde interieur', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1077, '9791100000000', 'Barbarians of lemuria', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1078, '9791100000000', 'Barbarians of Lemuria   Chronique lémurienne', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1079, '', 'Barbarians of lemuria ECRAN et Carte', NULL, NULL, '', NULL, NULL),
(1080, '', 'Batlletech Boite', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1081, '', 'Battletech reccord sheet upgrades dans la boite', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1082, '1894525450', 'Big Eyes  Small Mouth BESM', NULL, NULL, 'AUTRE', NULL, NULL),
(1083, '1558062939', 'Black Ops rolemaster', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1084, '9782375645', 'Blacksad', NULL, NULL, 'POLICIER', NULL, NULL),
(1085, '', 'Bloodlust  Seconde edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1086, '2908765381', 'Bloodlust  Contes et légendes', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1087, '2908765187', 'Bloodlust boite', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1088, '2911103076', 'Bloodlust  Chroniques sanglantes', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1089, '2908765500', 'Bloodlust  L es fréres de la nuit', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1090, '2908765233', 'Bloodlust  Poussiére danges', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1091, '1894525299', 'Blue Dragon  White tiger', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1092, '2952536600', 'Brain Soda', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1093, '9 782491 139575', 'Brancalonia kit de découverte', NULL, NULL, 'hEROIC FANTASY', NULL, NULL),
(1094, '9780000000000', 'Brancalonia Livre de base', NULL, NULL, 'Med fan', NULL, NULL),
(1095, '9782920000000', 'Brigade Chimerique', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1096, '9782920000000', 'Brigade chimerique  Ecran  livret', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1097, 'PAS DE CODE ISBN', 'Bushido', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1098, '6802', 'Bushido   Valley of the mists', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1099, '2915556350', 'Cadwallon   Manuel des Joueurs', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1100, '2915556431', 'Cadwallon   Secrets de Cadwallon Vol 1', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1101, '2915556458', 'Cadwallon   Secrets de Cadwallon Vol 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1102, '3661120000000', 'Cadwallon Ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1103, '2914892462', 'Capharnaüm', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1104, '2914892629', 'Capharnaum   Les arcanes de laventure', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1105, '2914892462', 'Capharnaüm  Ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1106, '9782360000000', 'Capitaine Vaudou 2eme edition', NULL, NULL, 'AuTRE', NULL, NULL),
(1107, '', 'Caste and crusades   amazing aventure anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1108, '3760000000000', 'Casus Belli Hors Série  Kit du Meneur de Jeu', NULL, NULL, '', NULL, NULL),
(1109, '9782920000000', 'Cats', NULL, NULL, 'AUTRE', NULL, NULL),
(1110, 'PAS DE CODE ISBN', 'Cendres', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1111, '1558061665', 'Champions  The super RPG', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1112, '1558060553', 'Champions   C.L.O.W.N.', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1113, '1558061010', 'Champions   Day of the destroyer', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1114, '1890305146', 'Champions   Denizen of San Angelo', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1115, '9781590000000', 'Changeling  The Lost', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1116, 'PAS DE CODE ISBN', 'Chateau du buflle', NULL, NULL, '', NULL, NULL),
(1117, '', 'Cheap Tales', NULL, NULL, 'pulp', NULL, NULL),
(1118, '9791090000000', 'Chiaroscuro   umbrae', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1119, 'PAS DE CODE', 'Chiaroscuro ecran', NULL, NULL, '', NULL, NULL),
(1120, '9791090000000', 'Chiaroscuro Imperium livre de base', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1121, '', 'Chill', NULL, NULL, 'HORREUR', NULL, NULL),
(1122, 'PAS DE CODE ISBN', 'Chill   Abominations surgies de linconnu', NULL, NULL, 'HORREUR', NULL, NULL),
(1123, '', 'Chill Ecran du MJ', NULL, NULL, 'HORREUR', NULL, NULL),
(1124, '2906897485', 'Chill Seconde edition  Boite', NULL, NULL, 'HORREUR', NULL, NULL),
(1125, '2906897620', 'Chill  Lycanthropes', NULL, NULL, 'HORREUR', NULL, NULL),
(1126, '2906897523', 'CHILL D e chair et de sang', NULL, NULL, 'HORREUR', NULL, NULL),
(1127, '2909934179', 'Chimere  Anteros recceuil de contes pour chimere', NULL, NULL, 'HORREUR', NULL, NULL),
(1128, '', 'Chimére  Jeu de linitié carte', NULL, NULL, 'HORREUR', NULL, NULL),
(1129, '2909934152', 'Chimére  livert  ParDonnezouns nos offenses', NULL, NULL, 'HORREUR', NULL, NULL),
(1130, '2909934136', 'Chimères', NULL, NULL, 'HORREUR', NULL, NULL),
(1131, '2909934276', 'CHIMERES   A La croisée des chemins', NULL, NULL, 'HORREUR', NULL, NULL),
(1132, '', 'Chimères  Ecran', NULL, NULL, 'HORREUR', NULL, NULL),
(1133, '295033881X', 'Chouans et Vendeens', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1134, '', 'Chroique oubliées boite de jeu', NULL, NULL, '', NULL, NULL),
(1135, '1887911928', 'Chtulhu Live   Shade of Gray', NULL, NULL, 'HORREUR', NULL, NULL),
(1136, '', 'Chtulhu  Secrets de New York', NULL, NULL, 'HORREUR', NULL, NULL),
(1137, '2915566062', 'Cirkus', NULL, NULL, 'Pulp', NULL, NULL),
(1138, '9782360000000', 'City Hall', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1139, '9782360000000', 'City Hall   Missions extraordinaires et suppléments x2', NULL, NULL, 'AVENTURE', NULL, NULL),
(1140, 'PAS DE CODE ISBN', 'City Hall Ecran', NULL, NULL, '', NULL, NULL),
(1141, '', 'Coeurs vaillants', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1142, '', 'Coeurs vaillants  Aventures', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1143, '', 'Coeurs vaillants  Compagnon 1', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1144, '', 'Coeurs vaillants  Compagnon 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1145, '9781910000000', 'Conan seconde edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1146, '2914849036', 'COPS', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1147, '2914849133', 'COPS  S1 Janvierfevrier 2031 Gangsta Paradise', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1148, '2914849044', 'COPS  S1 Juillet 2030 Amities de Los Angeles', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1149, '2914849168', 'COPS  S1 Mars  avril 2031Hitek Lotek', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1150, '2914849214', 'COPS  S2 Juillet  Aout 2031 1099', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1151, '2914849273', 'COPS  S2 Mars  Avril  Mai 2032 OSS 666', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1152, '2914849230', 'COPS  S2 Septembre  Octobre novembre 2031 15 Minutes', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1153, '291484932X', 'COPS  S3 Decembre 2032  Aout 2033 Horizons Lointains', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1154, '2914849338', 'COPS  S3 Septembre 2033  Mai 2034 DesUnion', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1155, '', 'COSMIC PATROL', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1156, '290478389X', 'Creatures des contrées du rêve dans boite contré du rêve', NULL, NULL, 'HORREUR', NULL, NULL),
(1157, '3420000000000', 'Critical Fondation  Saison 1', NULL, NULL, 'autre', NULL, NULL),
(1158, '3420000000000', 'Critical sanctuaire  saison 1', NULL, NULL, 'autre', NULL, NULL),
(1159, '9782920000000', 'Cthlhu   Au coeur des années 20', NULL, NULL, 'HORREUR', NULL, NULL),
(1160, '9782920000000', 'Cthlhu   Byzances An 800', NULL, NULL, 'HORREUR', NULL, NULL),
(1161, '2740801866', 'Cthlhu   Delta Green', NULL, NULL, 'HORREUR', NULL, NULL),
(1162, '9782970000000', 'Cthlhu   Delta Green seconde éditon', NULL, NULL, 'HORREUR', NULL, NULL),
(1163, '9782920000000', 'Cthlhu   Forensic  profiling et serial killer', NULL, NULL, 'HORREUR', NULL, NULL),
(1164, '2740801688', 'Cthlhu   Laube dorée', NULL, NULL, 'HORREUR', NULL, NULL),
(1165, '9782920000000', 'Cthlhu   Luniversité Miskatonic', NULL, NULL, 'HORREUR', NULL, NULL),
(1166, '2904783466', 'Cthlhu   La terreur venue des étoiles x2', NULL, NULL, 'HORREUR', NULL, NULL),
(1167, '2740801289', 'Cthlhu   Le guide du Caire X2', NULL, NULL, 'HORREUR', NULL, NULL),
(1168, '2904783539', 'Cthlhu   Le Rejeton dAzathoth', NULL, NULL, 'HORREUR', NULL, NULL),
(1169, 'PAS DE CODE ISBN', 'Cthlhu   Les Années Folles', NULL, NULL, 'HORREUR', NULL, NULL),
(1170, '274080072X', 'Cthlhu   Les astres sont propices', NULL, NULL, 'HORREUR', NULL, NULL),
(1171, '2904783547', 'Cthlhu   Les contrées du rêve', NULL, NULL, 'HORREUR', NULL, NULL),
(1172, '2740801874', 'Cthlhu   Les contrées du rêve Revisitées', NULL, NULL, 'HORREUR', NULL, NULL),
(1173, '2740800002', 'Cthlhu   Les grands Anciens', NULL, NULL, 'HORREUR', NULL, NULL),
(1174, '2904783167', 'Cthlhu   Les Masques de Nyarlathotep', NULL, NULL, 'HORREUR', NULL, NULL),
(1175, '2904783903', 'Cthlhu   Les oeufs de Karlatt', NULL, NULL, 'HORREUR', NULL, NULL),
(1176, '2904783040', 'Cthlhu   Les ombres de Yog Sothoth', NULL, NULL, 'HORREUR', NULL, NULL),
(1177, '9782920000000', 'Cthlhu   Les Oripeaux du Roi', NULL, NULL, 'HORREUR', NULL, NULL),
(1178, '9782920000000', 'Cthlhu   Les secrets de la Nouvelle Orléans', NULL, NULL, 'HORREUR', NULL, NULL),
(1179, '9782920000000', 'Cthlhu   Les Secrets de Marakech', NULL, NULL, 'HORREUR', NULL, NULL),
(1180, '978*2917994153', 'Cthlhu   Les secrets de San Francisco', NULL, NULL, 'HORREUR', NULL, NULL),
(1181, '9782920000000', 'Cthlhu   Les secrets du Kenya', NULL, NULL, 'HORREUR', NULL, NULL),
(1182, '9782920000000', 'Cthlhu   Les terres de Lovecraft  Arkham', NULL, NULL, 'HORREUR', NULL, NULL),
(1183, '9782920000000', 'Cthlhu   Malleus Monstrorum', NULL, NULL, 'HORREUR', NULL, NULL),
(1184, '2740800541', 'Cthlhu   Nightmare Agency', NULL, NULL, 'HORREUR', NULL, NULL),
(1185, '9782920000000', 'Cthlhu   Par delà les montagnes hallucinées', NULL, NULL, 'HORREUR', NULL, NULL),
(1186, '9782920000000', 'Cthlhu   Target of Opportunity', NULL, NULL, 'HORREUR', NULL, NULL),
(1187, '2740800681', 'Cthlhu   Terreur sur lOrientExpress', NULL, NULL, 'HORREUR', NULL, NULL),
(1188, '9782920000000', 'Cthlhu   Terreurs de laudelà', NULL, NULL, 'HORREUR', NULL, NULL),
(1189, '2740801599', 'Cthlhu   Utatti Asfet  loeil du mal', NULL, NULL, 'HORREUR', NULL, NULL),
(1190, '2740800673', 'Cthlhu  Contes de la vallée du Miskatonic', NULL, NULL, 'HORREUR', NULL, NULL),
(1191, '2740800282', 'Cthlhu  Expériences Fatales', NULL, NULL, 'HORREUR', NULL, NULL),
(1192, '2914892497', 'Cthulhu 2007', NULL, NULL, 'HORREUR', NULL, NULL),
(1193, '2904783520', 'Cthulhu by Gaslight', NULL, NULL, 'HORREUR', NULL, NULL),
(1194, '', 'Cthulhu Edition 6 Ecran', NULL, NULL, 'HORREUR', NULL, NULL),
(1195, '2740800444', 'Cthulhu Kingsport Cité des brumes', NULL, NULL, 'HORREUR', NULL, NULL),
(1196, '978236000000', 'Cthulhu Tech', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1197, '2914536577', 'Cyberpunk 3.0', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1198, '2914356569', 'Cyberpunk 3.0 flashpack', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1199, '', 'Cyberpunk 3.0  Ecran', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1200, '2906897639', 'Cyberpunk Arasaka Brainworm', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1201, '290689771X', 'Cyberpunk Chrome 3', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1202, '2906897558', 'Cyberpunk Corpo Book 1', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1203, '2906897566', 'Cyberpunk Eurotour', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1204, '2906897949', 'Cyberpunk Firestorm  shockwave', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1205, '2906897868', 'Cyberpunk Firestorm  stormfront', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1206, '2906897418', 'Cyberpunk Les enfants de la nuit', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1207, '2906897299', 'Cyberpunk Night City', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1208, '2906897663', 'Cyberpunk Wildside', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1209, '290689740 X', 'Cyberpunk  Protect and serve', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1210, '1558060456', 'Cyberspace', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1211, '', 'Cyborg commando', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1212, '1932442324', 'D20 system Artefacts of the Ages  Rings', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1213, '19324402014', 'D20 system Artefacts of the Ages  sword and staves', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1214, '1932442030', 'D20 system Bow and blade  a guidebook to the wood elves', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1215, '2914536356', 'D20 system Encyclopedia arcana  Chaomanciens', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1216, '2914536348', 'D20 system Encyclopedia arcana  Demonologistes', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1217, '2914536305', 'D20 system Encyclopedia arcana  Elementaristes', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1218, '2914536321', 'D20 system Encyclopedia arcana  Necromanciens', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1219, '0 970239785', 'D20 system  Dzeebagd  under dark and misty ground', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1220, '1904577210', 'D20 system  Encyclopaedia Arcane   Blood magic', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1221, '97014898', 'd20 system  Jade dragons and Hungry ghosts  monsters from the east', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1222, '2844761259', 'D20 system  Legends  et Lairs   Traps and treachery', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1223, '2914536291', 'D20 system  Liber bestiarius', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1224, '1887953582', 'D20 system  Mercenaries', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1225, '1887801960', 'D20 system  Penimbra  In the belly of the beast', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1226, '97809425', 'D20 system  The treasures of ElBard', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1227, '0970980945X', 'D20 system  Tsar rising', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1228, '9782920000000', 'D20 Systeme Dawnforge  le berceau des legendes X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1229, '2915496153', 'D20 Systeme Royaumes dacier  Guide des personnages', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1230, '1887953868', 'D20 systeme  7èmeSea Cathay jewel of the east', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1231, '1932442006', 'D20 systhem  Mindshadows', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1232, '2912979234', 'D20system  Odyssee  Akrasia  la voleuse dinstants', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1233, '2914536151', 'D20system  Odyssee  Merveilles des anciens', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1234, '8495949806', 'Danse Macabre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1235, '1558781250', 'Dark conspiracy  PC booster kit', NULL, NULL, '', NULL, NULL),
(1236, '2909934543', 'Dark Earth', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1237, '9782920000000', 'Dawnforge', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1238, '9782920000000', 'Dawnforge sous le regne de lombre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1239, '2844760481', 'DEAD LANDS   Grisaille City', NULL, NULL, 'FAR WEST FANTAS', NULL, NULL),
(1240, '1889546046', 'DEAD LANDS   Smith and robards', NULL, NULL, 'FAR WEST FANTAS', NULL, NULL),
(1241, '1930855338', 'Deadlands', NULL, NULL, 'FAR WEST FANTAS', NULL, NULL),
(1242, '9782360000000', 'DEADLANDS RELOADED', NULL, NULL, 'FAR WEST FANTAS', NULL, NULL),
(1243, '9782360000000', 'Deathwatch', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1244, '9782490000000', 'Demon la damnation Livre de base', NULL, NULL, 'Monde des ténébres', NULL, NULL),
(1245, '', 'Demonworld   Isthak', NULL, NULL, 'MeDIEVAL FANTAS', NULL, NULL),
(1246, '9780000000000', 'Demonworld   régle du jeux', NULL, NULL, 'MeDIEVAL FANTAS', NULL, NULL),
(1247, '9788500000000', 'Disque Monde X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1248, '9782920000000', 'Donjon  et Cie', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1249, '', 'Donjon et dragon 4  Manuel du joueur', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1250, '9782360000000', 'Dragon age  Le jeu de rôle  livre de base', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1251, '', 'DRAGON Ecran', NULL, NULL, 'Med fan', NULL, NULL),
(1252, '284785046', 'Dragonlance  Univers', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1253, '9780000000000', 'DRAGONS 1 Aventuriers', NULL, NULL, 'Med fan', NULL, NULL),
(1254, '9780000000000', 'DRAGONS 2 Grimoire', NULL, NULL, 'Med fan', NULL, NULL),
(1255, '2841881709', 'Du Droit des Princes', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1256, '9782920000000', 'Dungeon crawl classics 1', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1257, '9782920000000', 'Dungeon crawl classics 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1258, '9782920000000', 'Dungeon crawl classics 3', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1259, '', 'Dungeon et dragon 4   Ecran du maitre du donjon', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1260, '786920157', 'Dungeon et dragon Oriental Adventure', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1261, '1889182508', 'Dungeons  etDragons  Kingdoms of Kalamar anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1262, '2847850090', 'Dungeons et dragons   Atlas de Greyhawk', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1263, '2847850015', 'Dungeons et dragons   De chair et dacier VF  VO sword and fist', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1264, '9782357830011 0786918292', 'Dungeons et Dragons   Guide du maitre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1265, '786916478', 'Dungeons et dragons   Hero builders Guidebook', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1266, '2847850600', 'Dungeons et dragons   Le bastion des damnees', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1267, '2847850171', 'Dungeons et dragons   Les maitres de la nature', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1268, '2847850686', 'Dungeons et dragons   Manuel des montres 4', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1269, '2847850058', 'Dungeons et dragons   Manuel des psioniques', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1270, '786937025', 'Dungeons et dragons   Spell compendium anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1271, '786916400', 'Dungeons et dragons   The sunless citadel', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1272, '2847850082', 'Dungeons et dragons  Dombres et de lumiere', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1273, '078691551X', 'Dungeons et dragons 3   Dungeon masters guide II anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1274, '2847850163', 'Dungeons et dragons 3   Manuel des monstres', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1275, '786932813', 'Dungeons et dragons 3   Miniature Handbook anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1276, '786928867', 'Dungeons et dragons 3 5  Players handbook anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1277, '2847850341', 'Dungeons et dragons 3.5   Manuel des monstres', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1278, '9782360000000', 'Dungeons et dragons 4   Bestiaire fantastique français  anglais', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1279, '9782360000000', 'Dungeons et dragons 4   Bestiaire fantastique 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1280, '9782360000000', 'Dungeons et dragons 4   Encyclopedie des Royaumes Oublies', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1281, '9782360000000', 'Dungeons et dragons 4   La pyramide des ombres', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1282, '9782360000000', 'Dungeons et dragons 4   La tour du sceptre Gardesort', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1283, '9782360000000', 'Dungeons et dragons 4   Le comptoir de laventure', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1284, '9782360000000', 'Dungeons et dragons 4   Manuel des joueurs 1 x3   1 angl', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1285, '9782360000000', 'Dungeons et dragons 4   Manuel des joueurs 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1286, '9782360000000', 'Dungeons et dragons 4   Manuel des plans', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1287, '9782360000000', 'Dungeons et dragons 4   Outretombe le secret des mort vivants', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1288, '9782360000000', 'Dungeons et dragons 4 Guide des joueurs des Royaumes oubliés', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1289, '9782360000000', 'Dungeons et dragons 4 Le fort de Gisombre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1290, '9781950000000', 'Dungeons et dragons 5   Kit dinitiation', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1291, '9780790000000', 'Dungeons et dragons 5   Lessentiel', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1292, '9781950000000', 'Dungeons et dragons 5   manuel des joueurs', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1293, '284785066X', 'Dungeons et dragons Eberron   letreinte de la griffe demeraude', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1294, '2847850635', 'Dungeons et dragons Eberron   les murmures de lepee vampire', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1295, '786934344', 'Dungeons et dragons Eberron  Sharn city of towers', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1296, '1889182540', 'Dungeons et dragons Kingdoms of Kalamar   Harvest of darkness', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1297, '1889182532', 'Dungeons et dragons Kingdoms of Kalamar  Coins end', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1298, '1889182524', 'Dungeons et dragons Kingdoms of Kalamar  Forging darkness', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1299, '1889182974', 'Dungeons et dragons Kingdoms of Kalamar  Garden of the plantmaster', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1300, '1889182591', 'Dungeons et dragons Kingdoms of Kalamar  Lands of mystery', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1301, '1889182559', 'Dungeons et dragons Kingdoms of Kalamar  Midnight terror', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1302, '1889182664', 'Dungeons et dragons Kingdoms of Kalamar  Strength and honor', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1303, '1889182567', 'Dungeons et dragonsKingdoms of Kalamar  Aldrivs revenge', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1304, '2914536399', 'Dying Earth  La vieille terre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1305, '2914536410', 'Dyning earth  Compendium des avantages indispensables de Cugel', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1306, '2914536445', 'Dyning earth  Le florilege du jet prismatique excellent T1', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1307, '291453647X', 'Dyning earth  Le florilege du jet prismatique excellent T2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1308, '274080184X', 'Earth dawn  Trame brisée', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1309, '2740801246', 'Earth dawn 2 editions', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1310, '2740801882', 'Earth dawn créatures de barsaive fr et angl', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1311, '2740801785', 'Earth dawn  aventures a parlainth', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1312, '2740801548', 'Earth dawn  corrompue', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1313, '2740801246', 'Earth dawn  Ecran', NULL, NULL, '', NULL, NULL),
(1314, 'PAS ISBN', 'Earth dawn  les accesores du maitre de jeu', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1315, '2740801378', 'Earth dawn  les brumes de la trahison fr   angl', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1316, '2740801971', 'Earth dawn  les dagues de cara fahd', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1317, '274080167X', 'Earth dawn  parlainth la cité oubliée', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1318, '1555602134', 'Earthdawn   1er edition', NULL, NULL, '', NULL, NULL),
(1319, '2740801424', 'Earthdawn   Barsaive', NULL, NULL, 'MeDIEVAL FANTAS', NULL, NULL),
(1320, '1555602592', 'Earthdawn   Horrors', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1321, '155560218', 'Earthdawn   Mist of betrayal', NULL, NULL, '', NULL, NULL),
(1322, '2740802064', 'Earthdawn   The theran empire', NULL, NULL, 'MediEVAL FANTAS', NULL, NULL),
(1323, '2740801440', 'Earthdawn  Compagnion', NULL, NULL, 'MeDIEVAL FANTAS', NULL, NULL),
(1324, '274080167X', 'Eathdawn   Parlainth la cité oublié x2', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1325, '2915496145', 'Ecran AmnesYa 2k51', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1326, '9782920000000', 'Ecryme   boite', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1327, '2914536135', 'Elric', NULL, NULL, 'ELMEDIEVAL FANT', NULL, NULL),
(1328, '2906897671', 'Elric   Les bannis', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1329, '290689754X', 'Elric   Melniboné', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1330, '2912979196', 'Elric  Crises Vilmiriennes', NULL, NULL, '', NULL, NULL),
(1331, 'PAS DE CODE ISBN', 'ELRIC  Ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1332, '2906897728', 'Elric  Est inconnu', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1333, '2906897590', 'Elric  La nef des fous', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1334, '2906897906', 'Elric  Les mers du destin', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1335, '2906897647', 'Elric  Versets impies', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1336, '2914892411', 'Esoterroristes', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1337, '1565046234', 'Exalted', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1338, '9781590000000', 'Exalted   Glories of the most high', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1339, '9781590000000', 'EXALTED   Graceful wicked masques', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1340, '1588466884', 'Exalted   Manual of the exalted power  Dragon blooded', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1341, '9781590000000', 'Exalted   Manual of the exalted power  Lunars', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1342, '9781590000000', 'Exalted   Manual of the exalted power  siderals', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1343, 'PAS DE CODE ISBN', 'Exalted   Storytellers screen ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1344, '1588466841', 'Exalted Second edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1345, '9781590000000', 'Exalted  The white and black treatises The book of sorcery vol II', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1346, '2915496048', 'Exil', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1347, '2844761089', 'Fading Suns  La geste du futur', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1348, '2915496005', 'Fading Suns   Les enfants des dieux', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1349, '2915496013', 'Fading Suns   Les fiefs décados', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1350, '', 'Faith the scifi RPG', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1351, '9791090000000', 'FATE BOITE A OUTILS', NULL, NULL, '', NULL, NULL),
(1352, '97910900000000', 'FATE SYSTEME DE BASE', NULL, NULL, 'AUTRE', NULL, NULL),
(1353, '29114536100', 'FENG SHUI   ... dans ta face ', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1354, '291297920X', 'FENG SHUI   Ascenseur pour ailleurs', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1355, '291453616X', 'FENG SHUI   Burning Shaolin', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1356, '2914536224', 'FENG SHUI   Lannee du demon', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1357, '2914536011', 'FENG SHUI   Lombre de la roue', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1358, '2914536054', 'FENG SHUI   Mange ça...', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1359, '2912979226', 'FENG SHUI   Quatre batards', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1360, '2912979072', 'FENG SHUI x2', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1361, '1887801766', 'FENG SHUI ACTION MOVIE ROLEPLAYING', NULL, NULL, '', NULL, NULL),
(1362, '', 'Feng Shui Quickstart roles  HONG KONG TASK FORCE', NULL, NULL, 'pulp', NULL, NULL),
(1363, '291453650X', 'Feng shui  Amis du dragon', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1364, '2912979102', 'FENG SHUI  La nouvelle chair', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1365, '2914536534', 'FENG SHUI  LES ÉPINES DU LOTUS', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1366, '1887801804', 'Feng shuiGolden comeback', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1367, '', 'Fragged empire livre de base   aide de jeux', NULL, NULL, '', NULL, NULL),
(1368, '9791030000000', 'Freaks squeele', NULL, NULL, 'PULP', NULL, NULL),
(1369, '', 'Freaks squeele écran de maître', NULL, NULL, 'PULP', NULL, NULL),
(1370, '9791030000000', 'Freaks squeele livre du 2éme semestre', NULL, NULL, 'PULP', NULL, NULL),
(1371, '9782370000000', 'Friponnes   livre de base', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1372, '9782370000000', 'Friponnes aide MJ', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1373, '9782370000000', 'Friponnes écran mj et jeu de carte', NULL, NULL, '', NULL, NULL),
(1374, '9781590000000', 'Geist  The sin eaters', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1375, 'Manquant', 'Gobelins et compagnie', NULL, NULL, 'Pulp', NULL, NULL),
(1376, 'Pas dISBN renseigné', 'Guildes  La quéte des origines', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1377, '2909934411', 'Guildes   Maisons 1  les venndys dans la boite', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1378, '2844760023', 'Guildes  Maisons 2  Les Kheyza dans la boite', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1379, '2908765373', 'GURPS  Magie', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1380, '1556343973', 'GURPS lite   ecran', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1381, '920711510', 'Harn master religion   Libram of the pantheon', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1382, '920711472', 'Harn master religion   Second edition', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1383, '', 'Harn player   A player guide to Harnworld', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1384, '920711006', 'Hârnworld   A real fantaisy world', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1385, '9780000000000', 'Hârnworld   Castles of Harn', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1386, '920711227', 'Hârnworld   Pilots dAlmanac', NULL, NULL, 'MedIEVAL FANTAS', NULL, NULL),
(1387, '1558066020', 'HARP', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1388, 'PAS DE CODE ISBN', 'Hawkmonn ecran du Mj', NULL, NULL, '', NULL, NULL),
(1389, '2906897310', 'Hawkmoon   Lempire ténébreux', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1390, '2914536119', 'Hawkmoon Atlas Germanique', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1391, '2914536259', 'Hawkmoon Atlas Scandin', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1392, 'PAS DE CODE ISBN', 'Hawkmoon Boite', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1393, '2906897582', 'Hawkmoon chair et metal', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1394, '2914536194', 'Hawkmoon chroniques germaniques', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1395, '2912979048', 'Hawkmoon fils de Granbretanne', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1396, '2906897965', 'Hawkmoon lespanyia', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1397, '2906897272', 'Hawkmoon la Kamarg', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1398, '2906897450', 'Hawkmoon les portes du paradis', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1399, '2906897825', 'Hawkmoon les seig eur des SansMasques', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1400, '', 'Hawkmoon premiere edition  Ecran', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1401, '2906897752', 'Hawkmoon seconde edition x2', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1402, '', 'Hawkmoon seconde edition  Ecran', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1403, 'PAS DE CODE ISBN', 'Heavy Metal Livret 1 et 2', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1404, '2911103270', 'Heel on Wheels', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1405, '916211053', 'Heroes Unlimited Revised', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1406, '9782920000000', 'Hollow Earth Expedition', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1407, '9782920000000', 'HOLLOW EARTH EXPEDITION   Les Mysteres de la Terre Creuse', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1408, '9782920000000', 'HOLLOW EARTH EXPEDITION   Les SECRETS de la surface', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1409, 'VU', 'Hollow Earth  Ecran', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1410, 'EHP1001', 'Hong Kong action Theatre Film festival 1', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1411, 'KS660448149', 'Hong Kong Action theatre', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1412, '1894525078', 'Hot Rods  et Gun Bunnies', NULL, NULL, 'AUTRE', NULL, NULL),
(1413, '1565047354', 'Hunter  the Reckoning', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1414, '9781590000000', 'Hunter  The Vigil', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1415, '', 'Hunter  The VigilFree rules and adventures', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1416, '2841881067', 'Hunter   lexterminateur  Vengeur', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1417, '1565047419', 'Hunter   The walking dead', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1418, '1565047400', 'Hunter book  Defender', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1419, '1565047435', 'Hunter book  Judge', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1420, '9781590000000', 'Hunter  Contact and Conspiracies', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1421, '11596465', 'Hurlelune', NULL, NULL, '', NULL, NULL),
(1422, '', 'Hypersensible Ecran pour Exil', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1423, '2915496129', 'HYPERSENSIBLES', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1424, '9780000000000', 'Hypertelluriens', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1425, '2910899047', 'HYSTOIRE DE FOU   DES RECETTES DE LA FOLIE', NULL, NULL, 'AUTRE', NULL, NULL),
(1426, '2914846109', 'In Nomine Satanis  Magna Veritas edition reviseTe', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1427, '2914846109', 'In Nomine Satanis  Magna Veritas Quatriéme edition', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1428, '289902', 'Infinity', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1429, '9782910000000', 'INSMV troisieme edition  Ecran', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1430, '', 'Insectopia   ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1431, 'PAS ISBN', 'Insectopia   livre de base', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1432, '9782360000000', 'Insignium Astartes', NULL, NULL, '', NULL, NULL),
(1433, '9780000000000', 'Iron kingdom Requiem', NULL, NULL, 'Med fan', NULL, NULL),
(1434, '3760000000000', 'Iron kingdom Requiem  écran', NULL, NULL, 'Med fan', NULL, NULL),
(1435, '2904783644', 'James Bond 007', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1436, '2740800371', 'James Bond 007 Suplément Adversaires', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1437, '9782950000000', 'Jouer des parties de jeu de rôle x2', NULL, NULL, 'AUTRE', NULL, NULL),
(1438, '', 'Kit Initiation Nephilim Quatrieme edition', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1439, '9791090000000', 'Knight   La bataille de Pingyao', NULL, NULL, 'hoRREUR', NULL, NULL),
(1440, '9791090000000', 'Knight aide de jeu', NULL, NULL, 'hoRREUR', NULL, NULL),
(1441, '9791090000000', 'Knight au coeur des ténèbres', NULL, NULL, 'HORREUR', NULL, NULL),
(1442, '9782490000000', 'Knight supplement bestiaire', NULL, NULL, 'HORREUR', NULL, NULL),
(1443, '97824907O3180', 'Knight supplément Nodachi', NULL, NULL, 'HORREUR', NULL, NULL),
(1444, '9781940000000', 'Koboltds ate my Baby  fiches plastifier x8', NULL, NULL, 'poLICIER', NULL, NULL),
(1445, '2914892152', 'Kult   Inferno', NULL, NULL, 'HORREUR', NULL, NULL),
(1446, '2910839001', 'Kult   La mort nest que le commencement...', NULL, NULL, 'HORREUR', NULL, NULL),
(1447, '2910839011', 'KULT SUPPLÉMENT N°1', NULL, NULL, 'HORREUR', NULL, NULL),
(1448, '291489225X', 'Kult  La madone noire', NULL, NULL, 'HORREUR', NULL, NULL),
(1449, '2910839001', 'Kult  La mort nest que le commencement', NULL, NULL, 'HORREUR', NULL, NULL),
(1450, '2910839051', 'Kult  Metropolis', NULL, NULL, 'HORREUR', NULL, NULL),
(1451, '291489242X', 'Kuro livre de base et écranrangé dans un classeur', NULL, NULL, 'ANTICIPATION', NULL, NULL),
(1452, '9782960000000', 'Lagence nom de codes ARES', NULL, NULL, 'POLICIER', NULL, NULL),
(1453, '9782370000000', 'Lempire des cerisiers   livret  écran', NULL, NULL, 'jAPONAIS FANTAS', NULL, NULL),
(1454, '', 'Loeil Noir boite dinitiation', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1455, '2909934462', 'Lunireve', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1456, '', 'La compagnie des glaces', NULL, NULL, 'Science fiction', NULL, NULL),
(1457, '2904783458', 'La table ronde', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1458, '290 8352001', 'La Terre Creuse', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1459, '', 'La Terre Creuse  Ecran', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1460, '9782920000000', 'Labyrinth', NULL, NULL, 'HORREUR', NULL, NULL),
(1461, '9782950000000', 'Le dernier bastion   le recueil du meneur', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1462, '9782950000000', 'Le dernier bastion   manuel des braves', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1463, '', 'Le guide de lalliance rebelle', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1464, '290835201X', 'Le guide de limperium X2', NULL, NULL, 'AUTRE', NULL, NULL),
(1465, 'PAS DE CODE ISBN', 'Le Jeu de rôle des Terres du Milieu BOITE', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1466, '2911103343', 'Le Livre des Cinq Anneaux   La voie de la licorne', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1467, '291110336X', 'Le Livre des Cinq Anneaux   la voie du Crabe', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1468, '2911103319', 'Le Livre des Cinq Anneaux   La voie du Dragon', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1469, '9788500000000', 'Le livre des cinq anneaux V4 livre de base', NULL, NULL, 'L5R', NULL, NULL),
(1470, '', 'Le livre des cinq anneaux  fanmade esprit de famille', NULL, NULL, 'L5R', NULL, NULL),
(1471, '1588464768', 'Le monde des ténébres X3', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1472, '2841881660', 'Le seigneur des anneaux   guide de la communauté de lanneau', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1473, '9781840000000', 'Le Seigneur des Anneaux   La guerre de lanneau', NULL, NULL, '', NULL, NULL),
(1474, '2841881393', 'Le seigneur des anneaux   le livre de règles', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1475, 'PAS DE CODE ISBN', 'Le seigneur des Anneaux   Moria la cité des nains rolemaster X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1476, '9788500000000', 'LE TRôNE DE FER', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1477, '729220000000', 'Legend of the five rings   Bearers of jade', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1478, '729220000000', 'Legend of the five rings   City of lies boite', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1479, '729220000000', 'Legend of the five rings   Code of bushido', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1480, '729220000000', 'Legend of the five rings   GMs survival guide', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1481, '729220000000', 'Legend of the five Rings   Honor veil', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1482, '729220000000', 'Legend of the five rings   Legacy of the forge', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1483, '729220000000', 'Legend of the five rings   Midnight blood', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1484, '729220000000', 'Legend of the five rings   Mimura the village of promises', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1485, '729220000000', 'Legend of the five rings   Otosan uchi Boite', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1486, '291110398X', 'Legend of the Five rings   Rokugan x2', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1487, '729220000000', 'Legend of the Five Rings   The book of shadowlands', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1488, '729220000000', 'Legend of the five rings   The merchants guide to rokugan', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1489, '729220000000', 'Legend of the five rings   The tomb of iuchiban boite', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1490, '1887953345', 'Legend of the five rings   Time of the void', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1491, '8495830663', 'Legend of the five rings   troisième édition', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1492, '729220000000', 'Legend of the Five rings   Twilight horror', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1493, '729220000000', 'Legend of the five rings   Unexpected allies', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1494, '729220000000', 'Legend of the five rings   Void in the heaven', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1495, '729220000000', 'Legend of the five rings   Walking the way', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1496, '1887953132', 'Legend of the five rings   Way of shinsei', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1497, '729220000000', 'Legend of the five rings   Way of the crab', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1498, '729200000000', 'Legend of the five rings   Way of the crane', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1499, '729220000000', 'Legend of the five rings   Way of the dragon', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1500, '729220000000', 'Legend of the five rings   Way of the lion', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1501, '729220000000', 'Legend of the five rings   Way of the minor clans', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1502, '729220000000', 'Legend of the five rings   Way of the naga x2', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1503, '729220000000', 'Legend of the five rings   Way of the phoenix', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1504, '1887953302', 'Legend of the five rings   Way of the ratling', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1505, '1887953485', 'Legend of the five rings   Way of the samurai', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1506, 'PAS DE CODE ISBN', 'Legend of the five rings   Way of the scorpion', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1507, '729220000000', 'Legend of the five rings   Way of the shadow', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1508, '1887953264', 'Legend of the five rings   Way of the shadowland', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1509, '729220000000', 'Legend of the five rings   Way of the unicorn', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1510, '1887953116', 'Legend of the five rings   Way of the wolf', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1511, '729220000000', 'Legend of the five rings   Winter court', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1512, '1887953000', 'Legend of the five rings premiere edition', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1513, '2911103920', 'Legend of the five rings seconde édition   Guide du joueur x2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1514, '2911103947', 'Legend of the five rings seconde édition   Guide du Maître x2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1515, 'OK', 'Legend of the five rings  Ecran   livret V1', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1516, '729220000000', 'Legend of the five rings  Winter court kuyden asako', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1517, 'OK', 'Legende des cinqs anneaux Ecran V2 V4', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1518, '', 'Legende des contrées oubliees  le grimoire', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1519, '284055092X', 'Légendes des contrées oubliées', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1520, '9781000000000', 'Légendes des éléments', NULL, NULL, 'AUTRE', NULL, NULL),
(1521, 'PAS DE CODE ISBN', 'Les cinq cerisiers', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1522, '', 'Les divisions de lombre', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1523, '2841881962', 'Les Exaltés   Guide des Joueurs', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1524, '284188144X', 'Les exaltés   Guide du conteur et ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1525, '2841881857', 'les exaltés   Jeux de la divinite', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1526, '2841881601', 'Les exaltés   Le livre des 3 cercles', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1527, '2841881520', 'Les exaltés   Les enfants du seuil', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1528, 'PAS DE CODE ISBN', 'les exaltés  Ecran', NULL, NULL, '', NULL, NULL),
(1529, '2841881776', 'les exaltés  Une époque tumultueuse', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1530, '2915953015', 'Les Fables Ludiques   Toutes Griffes Dehors', NULL, NULL, 'MediEVAL FANTAS', NULL, NULL),
(1531, '', 'Les Héritiers de Kadesh', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL);
INSERT INTO `ouvrage` (`Id_ouvrage`, `numero`, `titre`, `etat`, `img`, `collection`, `Id_type`, `code_barre`) VALUES
(1532, 'PAS ISBN', 'Les héritiers de palesh', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1533, '9782920000000', 'Les lames du cardinal boite', NULL, NULL, 'CAPE ET DÉPÉE', NULL, NULL),
(1534, 'PAS DE CODE ISBN', 'Les maitres mondes', NULL, NULL, 'AUTRE', NULL, NULL),
(1535, '9782920000000', 'Les ombres desteren Prologue x2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1536, '9782920000000', 'Les ombres desteren Univers', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1537, '9782920000000', 'Les ombres desteren Voyages', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1538, 'PAS DE CODE', 'les ombres desteren  Ecran', NULL, NULL, '', NULL, NULL),
(1539, 'PAS DE CODE ISBN', 'Les terres du milieu   La tour de Cirith Ungol et lantre de Shelob', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1540, 'Ref  00303', 'Les terres du milieu   Les créatures', NULL, NULL, '', NULL, NULL),
(1541, '2841880117', 'Les terres du milieu   Moria la cité des Nains', NULL, NULL, '', NULL, NULL),
(1542, 'PAS DE CODE ISBN', 'Les terres du millieu   Rangers du nord', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1543, '', 'lesTerres Balafrées   Ecran', NULL, NULL, 'meDIEVAL FANTAS', NULL, NULL),
(1544, '9791090000000', 'Libreté', NULL, NULL, 'HORREUR', NULL, NULL),
(1545, '1904577474', 'Lone Wolf', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1546, '1904854613', 'Lone wolf   Magic of magnamund', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1547, '1904577539', 'Lone Wolf  The darklands', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1548, '915795264', 'Lords of middle earth', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1549, '915795329', 'Lords of middle earth 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1550, '1558060529', 'Lords of middle earth 3 X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1551, '2841881539', 'Loup garou   le guide du Conteur', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1552, '', 'Loup Garou Les Déchus', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1553, '2841880095', 'Loup garou  Rage sur New York', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1554, '2951420870', 'Loup Solitaire  Encyclopédie du monde', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1555, '9782950000000', 'Loup Solitaire  le grimoire de Magnamund', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1556, '9782920000000', 'Loup Solitaire  livre daventure', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1557, '9782920000000', 'Loup Solitaire  Livre de regles', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1558, 'PAS DE CODE ISBN', 'loup solitaire  Ecran', NULL, NULL, '', NULL, NULL),
(1559, '2841880265', 'Loupgarou  Apocalyspe  Caerns Lieux de Pouvoir', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1560, '9 782372 550093', 'LoupGarou  lApocaylse 20 émé anniversaire', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1561, '2841880729', 'Loups Garous l Age des ténébres', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1562, '1904577334', 'Macho Woman With Gun', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1563, '1588464180', 'Mage  The Awakening', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1564, '284188032X', 'Mage  Toile Numérique', NULL, NULL, 'Monde des ténébres', NULL, NULL),
(1565, '2904783555', 'Maléfices   Bestiaire', NULL, NULL, 'HORREUR', NULL, NULL),
(1566, '2952483515', 'Maléfices   catéschisme   carte', NULL, NULL, 'HORREUR', NULL, NULL),
(1567, 'PAS DE CODE ISBN', 'Maléfices boite', NULL, NULL, 'HORREUR', NULL, NULL),
(1568, '2952483507', 'Maléfices Troisieme edition x2 et x1 ecran', NULL, NULL, 'HORREUR', NULL, NULL),
(1569, '2904788366X', 'Maléfices  Coeur Cruel 10 x2', NULL, NULL, 'HORREUR', NULL, NULL),
(1570, '2853950549', 'Maléfices  Danse Macabre 12 x2', NULL, NULL, 'HORREUR', NULL, NULL),
(1571, '2904783393', 'Maléfices  Enchères sous pavillon noir 6', NULL, NULL, 'HORREUR', NULL, NULL),
(1572, '2904783628', 'Maléfices  Folies Viennoises 9', NULL, NULL, 'HORREUR', NULL, NULL),
(1573, '2904783210', 'Maléfices  Lénigmatique carnet du capitaine Pop Plinn 2', NULL, NULL, 'HORREUR', NULL, NULL),
(1574, '2853950581', 'Maléfices  La cornemuse du vieux Jeremiah 13 X2', NULL, NULL, 'HORREUR', NULL, NULL),
(1575, 'PAS DE CODE ISBN', 'Maléfices  La malédiction de Fontevrault 1', NULL, NULL, 'HORREUR', NULL, NULL),
(1576, '2904783423', 'Maléfices  La musique adoucit les meutres 7', NULL, NULL, 'HORREUR', NULL, NULL),
(1577, '2904783385', 'Maléfices  Le dompteur de volcans 5', NULL, NULL, 'HORREUR', NULL, NULL),
(1578, '2904783326', 'Maléfices  Le montreur dombres 8', NULL, NULL, 'HORREUR', NULL, NULL),
(1579, '2904783248', 'Maléfices  Les brasiers ne séteignent jamais 3', NULL, NULL, 'HORREUR', NULL, NULL),
(1580, '5800120000000', 'Mantra', NULL, NULL, 'HORREUR', NULL, NULL),
(1581, '286 989 027 3', 'MARVEL SUPER HEROS   Le dernier recours', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1582, '2869890257', 'MARVEL SUPER HEROS   Le tonnerre de Thor', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1583, '', 'Mega', NULL, NULL, 'Space OPERA', NULL, NULL),
(1584, '9782950000000', 'MENER DES PARTIES DE JEU DE ROLE', NULL, NULL, 'AUTRE', NULL, NULL),
(1585, '2908994003', 'Mercenaires', NULL, NULL, '', NULL, NULL),
(1586, '9782920000000', 'Metal Adventures dossier de personnage x4', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1587, '9782920000000', 'Metal Adventures ecran du meneur', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1588, '9782920000000', 'Metal Adventures guide du Joueur', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1589, '9782920000000', 'Metal Adventures guide du meneur', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1590, '9782920000000', 'Metal Adventures La belle  et la bête', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1591, '97882900000000', 'Metal Adventures La guerre  et la désolation', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1592, '9782920000000', 'Metal Adventures La prise  et le profit', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1593, '9782920000000', 'Metal Adventures Le fer  et le sang', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1594, '9782920000000', 'Metal Adventures Le roi  et Le peuple', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1595, '9782920000000', 'Metal Adventures Les pirates de lespace', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1596, '9782920000000', 'Metal Adventures les sciences  et linfini', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1597, '', 'Metal Adventures  Ecran', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1598, '9782920000000', 'Meute x2', NULL, NULL, 'AUTRE', NULL, NULL),
(1599, '', 'Meute  Ecran de jeux X2', NULL, NULL, 'Autre', NULL, NULL),
(1600, '915795051', 'Middle Earth   2eme édition', NULL, NULL, '', NULL, NULL),
(1601, '915795345', 'Middle earth   Combat screen', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1602, '1558062246', 'Middle earth   Dol Guldur', NULL, NULL, '', NULL, NULL),
(1603, '1558062181', 'Middle earth   Elves', NULL, NULL, '', NULL, NULL),
(1604, '1558062297', 'Middle earth   Laketown', NULL, NULL, '', NULL, NULL),
(1605, '915795426', 'Middle earth   Lorien', NULL, NULL, '', NULL, NULL),
(1606, '1558061991', 'Middle earth   Minas tirith', NULL, NULL, '', NULL, NULL),
(1607, '1558062467', 'Middle earth   Mirkwood', NULL, NULL, '', NULL, NULL),
(1608, '1558062963', 'Middle earth   the northern waste', NULL, NULL, '', NULL, NULL),
(1609, '1558062556', 'Middle earth  Southern Gondor  the people', NULL, NULL, '', NULL, NULL),
(1610, '915765183', 'Middle Earth RPG', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1611, '1558061347', 'Middle earth  Angus McBrides Characters of MiddleEarth', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1612, '1558060782', 'Middleearth   adventure guidebook 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1613, '1558060014', 'MiddleEarth   Cities of middle earth   Minas Tirith', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1614, '1558060480', 'MiddleEarth   Treasures of middle earth X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1615, '2915847037', 'Midnight   Adversaires de Lombre', NULL, NULL, '', NULL, NULL),
(1616, '2915847061', 'Midnight   Créatures de lombre', NULL, NULL, '', NULL, NULL),
(1617, '2915847096', 'Midnight   La cite de lombre X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1618, '2915847045', 'Midnight   La couronne de lombre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1619, '2915847134', 'Midnight   La forge de lombre', NULL, NULL, '', NULL, NULL),
(1620, '291584707X', 'Midnight   Ombre et magie X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1621, '9782920000000', 'Midnight   Sous le règne de lombre', NULL, NULL, '', NULL, NULL),
(1622, '2915847118', 'Midnight  la colere de lombre X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1623, '2915847010', 'Midnigthaventure fantastiques dans un âge de tenebres', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1624, '2911099001', 'Miles Christi', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1625, '291109901X', 'Miles christi   Al Muntaqim le Vengeur', NULL, NULL, 'MediEVAL FANTAS', NULL, NULL),
(1626, '', 'Miles Christi  Ecran', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1627, '2911099028', 'miles Christi  La richesse de lEmir', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1628, '2911099036', 'Miles christi  Locus Palmarum', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1629, '1565045084', 'Minds Eye Theater  Law of the Wild', NULL, NULL, 'AUTRE', NULL, NULL),
(1630, '1565047303', 'Minds Eye Theatre   Laws of the East', NULL, NULL, 'AUTRE', NULL, NULL),
(1631, '1565045076', 'Minds eye theatre   The book of Ghouls', NULL, NULL, 'AUTRE', NULL, NULL),
(1632, '1565045009', 'MINDS EYE THEATRE   THE BOOK OF PROPS', NULL, NULL, 'AUTRE', NULL, NULL),
(1633, '1565045092', 'Minds Eye Theatre   The Long Night', NULL, NULL, 'AUTRE', NULL, NULL),
(1634, '1565047338', 'Minds Eye Theatre  Laws of the Wild Changing Breeds', NULL, NULL, 'AUTRE', NULL, NULL),
(1635, '1565045033', 'Minds eye theatre The Elders Revenge Character book X2', NULL, NULL, '', NULL, NULL),
(1636, '1565045033', 'Minds eye theatre The Elders Revenge PLAYBOOK X2', NULL, NULL, 'AUTRE', NULL, NULL),
(1637, '9780000000000', 'Mon créateur de table aléatoire  Fantaisy', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1638, '2841882020', 'Monde des tenebres Antagonistes', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1639, '1588464865', 'Monde des tenebres  Armory', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1640, '', 'monde des tenebres  France', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1641, '2910839301', 'Monde des ténébres  France', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1642, '2841881024', 'monde des ténébres  La longue Route', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1643, 'PAS', 'Monsterhearts 2', NULL, NULL, 'AUTRE', NULL, NULL),
(1644, '9791090000000', 'MOURNBLADE', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1645, '2740800975', 'Mutant chronicles   Imperial', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1646, '9782380000000', 'Mutants and Mastermind  Manuel du Héro', NULL, NULL, 'Super héro', NULL, NULL),
(1647, '9782380000000', 'Mutants and Masterminds', NULL, NULL, 'Super héro', NULL, NULL),
(1648, '9782360000000', 'My little pony   Tails of equestria', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1649, 'PAS DISBN', 'Mythologika', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1650, '2909934004', 'Nephilim', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1651, '2909934292', 'Nephilim   LES ARCHIVES SECRETES du duc de stAmand', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1652, '284476004X', 'Nephilim   Testament', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1653, '2915496064', 'NEPHILIM INITIATION', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1654, '2909934063', 'Nephilim le souffle du dragon', NULL, NULL, '', NULL, NULL),
(1655, '2844760988', 'Nephilim Révélations  Guide du joueur', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1656, '28447760996', 'Nephilim Révélations  Guide du Maitre', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1657, '290993439X>', 'Nephilim Seconde edition', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1658, '', 'Nephilim Troisieme edition  Ecran', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1659, 'PAS DE CODE ISBN', 'Nephilim  Hermes Trimegiste', NULL, NULL, 'AUTRE', NULL, NULL),
(1660, '290993411X', 'Nephilim  LATALANTE FUGITIVE', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1661, '2909934020', 'Nephilim  LES TEMPLIERS', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1662, '2911103025', 'Night Rowler', NULL, NULL, 'Night Rowler', NULL, NULL),
(1663, '2970031426', 'Nigth prowler seconde edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1664, '1558060952', 'Ninja Hero', NULL, NULL, 'SUPER SLIPS', NULL, NULL),
(1665, '297003140X', 'Nobilis', NULL, NULL, 'AUTRE', NULL, NULL),
(1666, '9782360000000', 'Numenera', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1667, '', 'Numénéra   Amour et sexe dans le neuvième monde', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1668, '', 'Numénéra   Au dela des mondes', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1669, '', 'Numénéra   carte', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1670, 'PAS DE CODE ISBN', 'Numenéra   Echine du Diable L', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1671, '', 'Numénéra   injecter de létrange', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1672, '', 'Numénéra  conseil narratif et etrange epoques', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1673, '', 'Numenera  Ecran', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1674, '2351120094', 'Oikouménè', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1675, '9782920000000', 'ON MIGHTY THEWS', NULL, NULL, 'AUTRE', NULL, NULL),
(1676, '2841881954', 'Orpheus   tons de gris', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1677, 'PAS DE CODE AG2000', 'Over the Edge', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1678, '2952536619', 'Palimpeste Les terres suspendues', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1679, '916211584', 'Palladium   Africa', NULL, NULL, '', NULL, NULL),
(1680, '916211185', 'Palladium   Beyond the supernatural', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1681, '091621141X', 'Palladium   Boxed nightmares', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1682, '916211916', 'Palladium   Fantasy Roleplaying games second edition anglais', NULL, NULL, '', NULL, NULL),
(1683, '916211002', 'Palladium   The arms of NargashTor', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1684, '916211398', 'Palladium RPG Adventures in the Northern wilderness', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1685, '916211045', 'Palladium  Roleplaying Game', NULL, NULL, '', NULL, NULL),
(1686, '9781910000000', 'Paranoia  troubleshooter', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1687, '', 'Paranoïa 2017', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1688, '', 'Paranoïa V1', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1689, '', 'Parlainth la cité oubliée', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1690, '9781640000000', 'Pathfinder   Advanced players Guide X2 VF et VO 2editions', NULL, NULL, '', NULL, NULL),
(1691, '9782360000000', 'Pathfinder   Armes et Equipements', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1692, '9782920000000', 'Pathfinder   Bestiaire', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1693, '9782360000000', 'Pathfinder   Bestiaire 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1694, '9781600000000', 'Pathfinder   Curse of the crimson throne', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1695, '9782360000000', 'Pathfinder   Guide du Maitre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1696, '9782360000000', 'Pathfinder   Lart de la guerre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1697, '9782920000000', 'Pathfinder   Manuel des joueurs', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1698, '9782360000000', 'Pathfinder   Manuel des joueurs regles avancees', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1699, '9781640000000', 'Pathfinder   Secrets of magic 2editions', NULL, NULL, '', NULL, NULL),
(1700, '9782360000000', 'Pathfinder Univers   Cadre de campagne  La mer intérieure', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1701, '9782360000000', 'Pathfinder Univers   Guide du Katapesh', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1702, '9782920000000', 'Pathfinder  Les septs epees du peche', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1703, '2915847002', 'Pavillon Noir  La revolte', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1704, '2915847029', 'Pavillon noir   A feu et à sang', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1705, '', 'Pavillon noir  Ecran', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1706, '2906897655', 'Pendragon   Audelà du mur', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1707, '2906897388', 'Pendragon   Chevalier aventureux', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1708, '2914536186', 'Pendragon   Chevaliers', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1709, '1928999115', 'Pendragon   king Arthur book of knights', NULL, NULL, 'AVENTURE', NULL, NULL),
(1710, '93535591', 'Pendragon   King Arthur Epic RpG', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1711, '2906897930', 'Pendragon   La foret perilleuse', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1712, 'PAS DISBN', 'Pendragon   le roi oublié', NULL, NULL, '', NULL, NULL),
(1713, '2906897736', 'Pendragon   Montagnes Sauvages', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1714, '2906897345', 'Pendragon troisieme edition x2', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1715, '2705020382', 'Pendragon  boite x2', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1716, 'OK VU LE 040317', 'Pendragon  Ecran', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1717, '9782920000000', 'Polaris', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1718, '2910529347', 'Polaris Kit de survie', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1719, '291052942B', 'Polaris supplément scénarios', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1720, '2910529444', 'Polaris Surface   le dossier personnage', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1721, '97829200000000', 'Polaris Univers', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1722, '', 'Polaris  Ecran', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1723, '2910529312', 'Polaris  Equinox', NULL, NULL, 'science fiction', NULL, NULL),
(1724, '2910529401', 'Polaris  Gaïa', NULL, NULL, 'science fiction', NULL, NULL),
(1725, '2910529436', 'Polaris  Hégémonie', NULL, NULL, 'science fiction', NULL, NULL),
(1726, '2910529347', 'Polaris  kit de survie', NULL, NULL, 'science fiction', NULL, NULL),
(1727, '2910529231', 'Polaris  le guide des profondeurs', NULL, NULL, 'science fiction', NULL, NULL),
(1728, '2910529258', 'Polaris  Pirates', NULL, NULL, 'science fiction', NULL, NULL),
(1729, '2910529444', 'Polaris  Surface', NULL, NULL, 'science fiction', NULL, NULL),
(1730, '2910529169', 'Polaris un jeux de roles X2', NULL, NULL, 'science fiction', NULL, NULL),
(1731, '9780000000000', 'Portes  Monstres  et Trésors   règles de base', NULL, NULL, 'AUTRE', NULL, NULL),
(1732, '9780000000000', 'Portes  Monstres  et trésors cadres de jeu   Chaosmos', NULL, NULL, 'AUTRE', NULL, NULL),
(1733, '2914536542', 'Post mortem   Thanatos Prime', NULL, NULL, 'ScienCEFICTION', NULL, NULL),
(1734, '2914536542', 'Postmortem   il y a un jeu après la mort x2', NULL, NULL, '', NULL, NULL),
(1735, '2914536526', 'Postmortem   slipville', NULL, NULL, 'AUTRE', NULL, NULL),
(1736, '2914536488', 'Postmorten   gothgrad', NULL, NULL, '', NULL, NULL),
(1737, '2914536496', 'Postmorten   yomishiro', NULL, NULL, 'AUTRE', NULL, NULL),
(1738, '2914536097', 'Princes Dragons', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1739, '2914536208', 'Princes dragons  Esclaves du destin', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1740, '', 'Prometheans  the created ecran', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1741, 'PAS ISBN', 'Prophecy   les compagnons de khy', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1742, 'PAS ISBN', 'Prophecy   les écailles de brorne', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1743, 'PAS ISBN', 'Prophecy   les enfants de heyra', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1744, 'PAS ISBN', 'Prophecy   les forges de kezyr', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1745, '2910529495', 'Prophecy   les foudres de kroyn', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1746, '', 'Prophecy   Les grands dragons', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1747, 'PAS ISBN', 'Prophecy   les orphelins de szyl', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1748, '2910529649', 'Prophecy   les secrets de kalimsshar', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1749, 'PAS ISBN', 'Prophecy   les verset dozyr', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1750, '2910529509', 'Prophecy   les voiles de nenya', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1751, 'PAS ISBN', 'Prophecy 1er edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1752, '', 'Prophecy Ecran premiere edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1753, '2910529479', 'Prophecy Ecran seconde edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1754, '', 'Prophecy seconde edition', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1755, 'PAS ISBN', 'Prophecy  supplément secret du monde et scénario', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1756, '2910529487', 'Prophecy  supplément secret du monde et scénario 772', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1757, '2914892365', 'Qin   Lart de la guerre', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1758, '2914892284', 'Qin   le Royaumes combattants', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1759, '2914892330', 'Qin   Mythes et animaux fabuleux', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1760, '9782910000000', 'QIN   Tian Xia Tout sous le ciel', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1761, '29114892373', 'Qin   Tian Xia Xianyang', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1762, '2914892306', 'Qin le livret et lecran X2', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(1763, '9780000000000', 'Rétro FUTUR  Jeu de role', NULL, NULL, 'Science fiction', NULL, NULL),
(1764, '2909934683', 'Rêve de dragon', NULL, NULL, 'AVENTURE', NULL, NULL),
(1765, '2909934683', 'Reve de dragon  lunirêves', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1766, '916211886', 'Rifts Japan', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1767, '913211509', 'Rifts x2', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1768, 'REF  00701', 'Rolemaster  ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1769, '1558062149', 'Rolemaster   Arms law', NULL, NULL, '', NULL, NULL),
(1770, '2841880281', 'Rolemaster   Le compagnon du combattant', NULL, NULL, '', NULL, NULL),
(1771, '2841880346', 'Rolemaster   le compagnon du mage', NULL, NULL, '', NULL, NULL),
(1772, '2841880001', 'Rolemaster   Manuel des personnages et de campagnes X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1773, '15558061614', 'Rolemaster Alchemy Companion', NULL, NULL, '', NULL, NULL),
(1774, '915795000', 'Rolemaster Arms law and claw law', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1775, '1558060936', 'Rolemaster Character law et campaign law X2  VF et VO', NULL, NULL, '', NULL, NULL),
(1776, '1558061371', 'Rolemaster Character records', NULL, NULL, '', NULL, NULL),
(1777, '915795124', 'Rolemaster Companion', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1778, '915795973', 'Rolemaster Companion II X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1779, '1558060502', 'Rolemaster Companion III X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1780, '1555601274', 'Rolemaster Companion IV', NULL, NULL, '', NULL, NULL),
(1781, '1558061274', 'Rolemaster Companion IV', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1782, '1558061452', 'Rolemaster Companion V', NULL, NULL, '', NULL, NULL),
(1783, '1558061649', 'Rolemaster Companion VI', NULL, NULL, '', NULL, NULL),
(1784, '915795302', 'Rolemaster Creatures et treasures 2 X4', NULL, NULL, '', NULL, NULL),
(1785, '1558060766', 'Rolemaster Elemental Companion', NULL, NULL, '', NULL, NULL),
(1786, '155806141X', 'Rolemaster Heroes and Rogues', NULL, NULL, '', NULL, NULL),
(1787, '2841880397', 'Rolemaster le compagnon VII', NULL, NULL, '', NULL, NULL),
(1788, '1558062025²', 'Rolemaster Sea Law', NULL, NULL, '', NULL, NULL),
(1789, '1558063382', 'Rolemaster Shades of darkness', NULL, NULL, '', NULL, NULL),
(1790, '1558060901', 'Rolemaster  Arms law and claw law 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1791, '284188001X', 'Rolemaster  Manuel des combats X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1792, '2841880028', 'Rolemaster  Manuel des sorts X2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1793, '1558060928', 'Rolemaster  Spell law', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1794, '1558061754', 'Rolmaster  Oriental companion   fr X2', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1795, '2906897698', 'RuneQuest   Dorastor', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1796, '290689706X', 'RuneQuest   Les Dieux de Glorantha', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1797, '2906897116', 'RuneQuest   Les monts arc en ciel', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1798, '2906897515', 'RuneQuest   Sous le signe du chaos', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1799, '2906897337', 'RuneQuest x2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1800, '9782950000000', 'Ryuu tama', NULL, NULL, 'MANGA', NULL, NULL),
(1801, '', 'Ryuu tama   ecran', NULL, NULL, 'MANGA', NULL, NULL),
(1802, '9782950000000', 'Ryuu tama   traversées livret de lécran', NULL, NULL, 'MANGA', NULL, NULL),
(1803, '9782360000000', 'Savage world V1', NULL, NULL, 'AUTRE', NULL, NULL),
(1804, '9782360000000', 'Scion  Demi Dieu', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1805, '9782360000000', 'Scion  Dieu', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1806, '9782920000000', 'SCION  Heros', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1807, '9782920000000', 'Scion Ecran du conteur', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1808, '', 'Secrets de Cadwallon Vol 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1809, '2915953007', 'Secretum templi   La marque dOrient X2', NULL, NULL, 'MeDIEVAL FANTAS', NULL, NULL),
(1810, '291052924X', 'Shaan   les humains', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1811, '9791090000000', 'Shaan Renaissance', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1812, '', 'Shaan renaissance Ecran', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1813, '2351120213', 'Shade', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1814, '', 'Shadow World', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1815, '1558061266', 'Shadow World   Emer and Master Atlas Addendum', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1816, '1555603270', 'Shadowrun   High tech and low life', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1817, '2740802218', 'Shadowrun   Premier Run', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1818, '9782360000000', 'Shadowrun 5eme édition', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1819, '', 'Shadowrun ecran', NULL, NULL, '', NULL, NULL),
(1820, '2740801475', 'Shadowrun France', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1821, '3289880000000', 'Shadowrun les métacréatures', NULL, NULL, '', NULL, NULL),
(1822, '2740802218', 'Shadowrun Premier Run', NULL, NULL, 'POST APOCALYPSE', NULL, NULL),
(1823, '2915847142', 'Shadowrun Quatrieme edition', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1824, '2740800487', 'Shadowrun Seconde Edition x2', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1825, '', 'Shadowrun Troisieme edition  écran', NULL, NULL, 'CYBERPUNK', NULL, NULL),
(1826, 'PAS ISBN', 'Skyrealms of Jorune', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1827, '2911099052', 'Soirée enquete   Cadavres à la Une', NULL, NULL, 'MURDER', NULL, NULL),
(1828, '9780000000000', 'Sonja et Conan contre les Ninjas', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1829, '', 'Space Master compagnion 2', NULL, NULL, 'science fiction', NULL, NULL),
(1830, '1558061355', 'Space Master Companion I x2', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1831, '1558061460', 'Space master  Aliens and Artefact X2', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1832, '155806172X', 'SpaceMaster', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1833, '671040014', 'Star Trek Next generation  Narrators tool kit', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1834, '9788420000000', 'Star Wars   Aux confins de Lempire', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1835, 'PAS DE CODE ISBN', 'Star Wars   Chasse à lhomme sur tatooine', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1836, '2904783776', 'Star Wars   Commando Shantipole x2', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1837, '2740800630', 'Star Wars   Crise dans la cite des nuages x2', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1838, '', 'Star wars   force et destinée kit dinitiation', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1839, '2740801238', 'Star Wars   Fragment de la bordure extérieure', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1840, '2740800983', 'Star Wars   Lenlévement X2', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1841, '274080041X', 'Star Wars   Le domaine du mal', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1842, '2740800584', 'Star Wars   Les coordonnées disis', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1843, '2740800274', 'Star Wars   Les recuperateurs', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1844, '2740800398', 'Star Wars   Manuel dinstruction du general cracken', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1845, 'PAS DE CODE ISBN', 'Star wars   Matériel de campagne', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1846, '2740800746', 'Star Wars   Meurtre dans la cite des profondeurs', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1847, '2740801203', 'Star Wars   Nouvelle republique  eclaireurs', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1848, '2740801505', 'Star Wars   Nouvelle republique  la bataille des jedi', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1849, '2740800096', 'Star Wars   Outrespace', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1850, '2740800266', 'Star wars   Pluis détoile', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1851, '2740801041', 'Star Wars   Supernova', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1852, '2740800207', 'Star Wars le guide de lalliance rebelle', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1853, '290478357X', 'Star Wars premiere edition', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1854, '', 'Star wars seconde édition', NULL, NULL, '', NULL, NULL),
(1855, '', 'star wars  Ecran', NULL, NULL, '', NULL, NULL),
(1856, '2740801327', 'Star wars  Les étoiles jumelles de kira X2', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1857, '1887953957', 'Stargate SG1 RpG', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1858, '2906897019', 'Storbringer   Demons et Magie', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1859, '2906897035', 'Storbringer   Loctogone du chaos', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1860, '2906897000', 'Storbringer   loeil de straasha x2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1861, '2906897140', 'Storbringer   Le loup blanc', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1862, 'PAS DE CODE ISBN', 'Storbringer   livre du maitre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1863, '', 'Stormbringer', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1864, '', 'Stormbringer  Démons et Magie x2', NULL, NULL, '', NULL, NULL),
(1865, '', 'Stormbringer  Ecran', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1866, '9782350000000', 'SubAbysse   écran', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1867, '', 'Subabysse 30eme anniversaire', NULL, NULL, 'inCLASSABLE', NULL, NULL),
(1868, '1588460657', 'Sword Sorcery   Arcana unearthed', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1869, '1588461513', 'Sword Sorcery   Bards Gate', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1870, '1588461777', 'Sword Sorcery   Beyond all reason', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1871, '1588461114', 'Sword Sorcery   Creature collection Revised', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1872, '2841880893', 'Sword Sorcery   Encyclopedie monstrueuse', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1873, '1588469999', 'Sword Sorcery   Everquest II  players guide', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1874, '158846976X', 'Sword Sorcery   Everquest RpG  plane of hate', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1875, 'PAS DE CODE ISBN', 'Sword Sorcery   Livre des secrets du maitre', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1876, '2841881083', 'Sword Sorcery   Mithril la cite du golem', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1877, '1588461718', 'Sword Sorcery   Natures Fury', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1878, '1588460967', 'Sword Sorcery   Raise the dead', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1879, '1588461572', 'Sword Sorcery   Rappan Athuk 2', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1880, '1588461653', 'Sword Sorcery   The divine and the defeated', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1881, '1588461750', 'Sword Sorcery   The giant skull', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1882, '1588469670', 'Sword Sorcery Book of hallowed migth II Portents and visions', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1883, '785 331 2EHP', 'Swords of the midle kingdom', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1884, '1560380608', 'TALES FROM The cosmic paternity suit', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1885, '1560380322', 'Tales from the floating vagabond', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1886, '2351120019', 'Talislanta', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1887, 'PAS DE CODE', 'Talislanta   aide de jeu dans la pochette chat', NULL, NULL, '', NULL, NULL),
(1888, '9782350000000', 'Talislanta   Diable des mers', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1889, '973724935', 'Talislanta   the weigth of the water', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1890, '97823500000000', 'Talislanta Chroniques lunaires Vol II Zar  le declin du ponant', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1891, '23511200350', 'Talislanta  Chroniques lunaires vol I Phandir  ainsi parlait Shaladin', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1892, '9782350000000', 'Talislanta  Terres de louest', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1893, '23511200430', 'Talislanta   Le Guide des Spheres', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1894, '9780000000000', 'Tenga', NULL, NULL, 'JAPONAIS FANTAS', NULL, NULL),
(1895, '9782950000000', 'Teocali', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1896, '978296000000', 'Teocali Livret initiation', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1897, '9780000000000', 'Terre 2  Livre de base', NULL, NULL, 'Science fiction', NULL, NULL),
(1898, '2904783635', 'Terror Australis', NULL, NULL, 'HORREUR', NULL, NULL),
(1899, '973692812', 'The chronicle of Talislanta', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1900, '158236950X', 'The lords of the Rings BOITE', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1901, '786919965', 'The wheel of time', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1902, '786926643', 'The wheel of time  prophecies of the dragons', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1903, '1588464857', 'the World of Darkness  Mysterious Places s', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1904, '2970031434', 'Thoan  Ecran', NULL, NULL, 'INCLASSABLE', NULL, NULL),
(1905, 'CODEISBN C 20', 'TIGRES VOLANTS', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1906, '2910529002', 'Toon', NULL, NULL, 'AUTRE', NULL, NULL),
(1907, 'PAS DE CODE INBN', 'Tous pour un  régime diabolique tome 1', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(1908, '1556344597', 'Tranchons et traquons', NULL, NULL, 'HEROIC FANTASY', NULL, NULL),
(1909, '155634709X', 'Transhuman   Fifth wave', NULL, NULL, 'ScIENCEFICTION', NULL, NULL),
(1910, '1556344821', 'Transhuman   High Frontier', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1911, '155634726X', 'Transhuman   In the well', NULL, NULL, 'ScIENCEFICTION', NULL, NULL),
(1912, '155634726X', 'Transhuman   Space livre de base', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1913, '1556346786', 'Transhuman   Toxic memes', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1914, '1556345860', 'Transhuman   Under pressure', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1915, '2907393006', 'Transhuman Deep beyond', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1916, '1558781579', 'Trauma', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1917, '1578281849', 'Traveller   Fire  fusion and steel', NULL, NULL, 'ScIENCEFICTION', NULL, NULL),
(1918, '', 'Traveller   Imperial squadrons', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1919, '9781580000000', 'Traveller   In the well', NULL, NULL, 'ScIENCEFICTION', NULL, NULL),
(1920, '1578283744', 'Traveller   Naval Architects manuel', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1921, '9781580000000', 'Traveller   Pocket empires', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1922, '1578281008', 'Traveller   Psionic Institutes', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1923, '', 'Traveller   Traveller', NULL, NULL, 'ScIENCEFICTION', NULL, NULL),
(1924, '1565047516', 'Traveller  Milieu 0', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1925, '1578283132', 'Travellers   Aliens archive', NULL, NULL, 'ScIENCEFICTION', NULL, NULL),
(1926, '', 'Travellers   Catalog', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1927, '1578283507', 'Travellers  Emperor Arsenal', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1928, '2845659253', 'Trinity  Descent into darkness', NULL, NULL, 'SCIENCEFICTION', NULL, NULL),
(1929, '2841881717', 'Troy   Encyclopedie anarchique du monde de troy', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1930, '2845650159', 'Troy   Jeu daventures de Lanfeust et du monde de Troy', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1931, '9781590000000', 'VAMPIRE   Coteries', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1932, '2841882098', 'VAMPIRE   Daeva Kiss of the succubus', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1933, '2841881946', 'VAMPIRE   Goules', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1934, '2841882071', 'VAMPIRE   Lancea Sanctum', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1935, '2841880168', 'VAMPIRE   Lignées  les occultes', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1936, '2841881997', 'VAMPIRE   Milwaukee by night', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1937, '9782920000000', 'VAMPIRE   Nomades', NULL, NULL, 'CONTEMPORAIN', NULL, NULL),
(1938, '9781590000000', 'Vampire   récolte la tempête', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1939, '', 'VAMPIRE   Requiem for Rome', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1940, '9791090000000', 'vampire 2 éme edition Ecran', NULL, NULL, '', NULL, NULL),
(1941, '2841880540', 'VAMPIRE CITY', NULL, NULL, 'AUTRE', NULL, NULL),
(1942, '2841882012', 'VAMPIRE ERE VICTORIENNE LONDON BY NIGHT', NULL, NULL, 'AUTRE', NULL, NULL),
(1943, '1565045033', 'Vampire La Mascarade', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1944, '9782370000000', 'Vampire La Mascarade   Elders revenge   Character book', NULL, NULL, 'monDE DES TENEB', NULL, NULL),
(1945, 'AG2917', 'Vampire la mascarade Vingtieme anniversaire', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1946, '284188189X', 'Vampire la mascarade  Blood nativity', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1947, '9782920000000', 'Vampire le Requiem', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1948, '1565042409', 'Vampire le requiem 2 éme édition', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1949, '1565042328', 'Vampire le requiem  Ecran du conteur', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1950, '1565042077', 'Vampire the masquerade   A world of Darkness second edition x2', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1951, '9781590000000', 'Vampire the requiem  New wave requiem', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1952, '9781590000000', 'Vampire the requiem  Mekhet Shadow in the dark', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1953, '', 'Vampire  Dharma book  Bone Flowers', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1954, '1565042239', 'Vampire  Kindred of the East', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1955, '284188113X', 'Vampire  Kindred of the East  companion', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1956, '2841881121', 'Vampire  Les peches du Sang', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1957, '9780000000000', 'Vampire  Les trois Piliers', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1958, '9780960000000', 'Vermine  Kit de survie', NULL, NULL, 'Horreur', NULL, NULL),
(1959, '9781910000000', 'Victoriana   faulkners chapellerie et miscellanea', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1960, '9781910000000', 'Victoriana ecran', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1961, '9780860000000', 'Victoriana faces in the smoke volume one  the secret master', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1962, '9781910000000', 'Victoriana faces in the smoke volume two  shadow ans steel', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1963, '9780960000000', 'Victoriana jewel of the empire', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1964, '9780860000000', 'Victoriana livre de base', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1965, '9780860000000', 'Victoriana marvels of science and steampunk', NULL, NULL, 'STEAMPUNK', NULL, NULL),
(1966, '9780960000000', 'Victoriana the havering adventures', NULL, NULL, 'STEAM PUNK', NULL, NULL),
(1967, '9780860000000', 'Victoriana the marylebone mummy', NULL, NULL, 'STEAM PUNK', NULL, NULL),
(1968, '', 'Victoriana the smoke', NULL, NULL, 'STEAM PUNK', NULL, NULL),
(1969, '9782920000000', 'Warhammer', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1970, '2951420854', 'Warhammer   La campagne imperiale', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1971, '978292000000', 'Warhammer   Le duche des damnes', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1972, '9782920000000', 'Warhammer   Le grimoire du chaosLes terres du nord', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1973, '2740800088', 'Warhammer   Le tome de la corruption', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1974, '9782920000000', 'Warhammer   Le tome de la redemption', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1975, '9782920000000', 'Warhammer   Les royaumes de la sorcellerie', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1976, '79782900000000', 'Warhammer   Les royaumes renegats', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1977, '1560251719', 'Warhammer   Repose sans paix', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1978, '1841544698', 'Warhammer   Terreur a Talabheim', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1979, '', 'Warhammer 40000', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1980, '', 'Warhammer 40000  Dark Hérésy  Le sang des martyrs', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1981, '9782920000000', 'Warhammer 40000  Dark Heresy', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1982, '978916000000', 'Warhammer 40000  Dark Heresy Traité inquisitorial', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1983, '', 'Warhammer 40000  Dark hérésy  Inquisiteurs et radicaux', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1984, '', 'warhammer 40000  Lappel des etendues', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1985, 'PAS DE CODE ISBN', 'warhammer 40000  Rogue trader', NULL, NULL, 'SPACE OPERA', NULL, NULL),
(1986, 'Pas de code ISBN', 'Warhammer Ecran V1', NULL, NULL, '', NULL, NULL),
(1987, '2952172854', 'Warhammer V2   Bestiaire du vieux monde', NULL, NULL, 'MediEVAL FANTAS', NULL, NULL),
(1988, '9788420000000', 'Warhammer V3   un jour trop tard  une pistole trop court', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1989, '', 'warhammer V3  boite Le compagnion du maitre de jeu', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1990, '', 'warhammer V3  boite Le compagnon du bestiaire', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1991, '9788420000000', 'warhammer V3  boite Le compagnon du joueur', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1992, '9788420000000', 'Warhammer V3  Le bestiaire', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1993, '9780000000000', 'Warhammer V3  le Guide du joueur', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1994, '', 'Warhammer V3  le guide du maitre de jeu', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1995, '971064261', 'Warhammer V4', NULL, NULL, 'medieVAL FANTAS', NULL, NULL),
(1996, '9780000000000', 'Warhammer v4  Zoo Impérial Le', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1997, '1560251719', 'Warhammer  The world of warhammer', NULL, NULL, 'MEDIEVAL FANTAS', NULL, NULL),
(1998, '9781590000000', 'Werewolf  Wild West', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(1999, '9781590000000', 'WEREWOLF   Signs of the moon', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2000, '1565043413', 'WEREWOLF   Storytellers screenF rontier Secret Ecran Werewolf wildwest', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2001, '1588463303', 'WEREWOLF   Tribes of the moon', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2002, '1565043324', 'WEREWOLF  Stargazers  tribebook', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2003, '1588467183', 'WEREWOLF THE FORSAKEN   LODGES THE FAITHFUL', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2004, '', 'WEREWOLF the forsaken   Storytellers screen', NULL, NULL, '', NULL, NULL),
(2005, '1565043081', 'WEREWOLF THE FORSAKEN   THE RACE', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2006, '', 'WEREWOLF the wild west  Storytellers screen', NULL, NULL, '', NULL, NULL),
(2007, '9782360000000', 'Werewolf  Kinfolk  Unsung Heroes', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2008, '1565046331', 'Within', NULL, NULL, 'HORREUR', NULL, NULL),
(2009, '9782360000000', 'World of Darkness  Tokyo', NULL, NULL, 'MONDE DES TENEB', NULL, NULL),
(2010, '1588467848', 'World of warcraft', NULL, NULL, '', NULL, NULL),
(2011, '9781590000000', 'World of warcraft   Lands of mystery', NULL, NULL, '', NULL, NULL),
(2012, '9782920000000', 'WORLDS  et WONDER Litographie', NULL, NULL, '', NULL, NULL),
(2013, '9782920000000', 'Wurm', NULL, NULL, 'AUTRE', NULL, NULL),
(2014, '9782920000000', 'Wurm   la voix des ancètres n°2', NULL, NULL, '', NULL, NULL),
(2015, '9782360000000', 'Wurm la voix des ancètres n°1', NULL, NULL, '', NULL, NULL),
(2016, '973961104', 'Wurm v2', NULL, NULL, 'AUTRE', NULL, NULL),
(2017, '2914892650', 'Wuxia', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(2018, '9710644288', 'WUXIA   Weapons of the gods', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(2019, '1565043405', 'WUXIA   Weapons of the gods   Companion', NULL, NULL, 'ORIENTALMANGA', NULL, NULL),
(2020, '29148992728', 'Yggdrasill', NULL, NULL, 'HISTORIQUE', NULL, NULL),
(2021, 'PAS DE CODE', 'ZCorps', NULL, NULL, 'HORREUR', NULL, NULL),
(2022, '', 'Zombies pour des soirées mortelles', NULL, NULL, 'HORREUR', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `reponse`
--

DROP TABLE IF EXISTS `reponse`;
CREATE TABLE IF NOT EXISTS `reponse` (
  `Id_reponse` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Id_utilisateur` int NOT NULL,
  `Id_sondage` int NOT NULL,
  PRIMARY KEY (`Id_reponse`),
  KEY `Id_utilisateur` (`Id_utilisateur`),
  KEY `Id_sondage` (`Id_sondage`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `reponse`
--

INSERT INTO `reponse` (`Id_reponse`, `libelle`, `Id_utilisateur`, `Id_sondage`) VALUES
(1, 'oui', 1, 1),
(2, 'non', 1, 1),
(3, 'non', 1, 1),
(5, 'oui', 1, 1),
(6, 'oui', 1, 1),
(7, 'oui', 1, 1),
(8, 'non', 1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `rolle`
--

DROP TABLE IF EXISTS `rolle`;
CREATE TABLE IF NOT EXISTS `rolle` (
  `Id_rolle` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`Id_rolle`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `rolle`
--

INSERT INTO `rolle` (`Id_rolle`, `libelle`) VALUES
(1, 'admin'),
(2, 'menbre'),
(3, 'ca'),
(4, 'bureau');

-- --------------------------------------------------------

--
-- Structure de la table `sondage`
--

DROP TABLE IF EXISTS `sondage`;
CREATE TABLE IF NOT EXISTS `sondage` (
  `Id_sondage` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `vote_visible` tinyint(1) DEFAULT NULL,
  `exclusif` int DEFAULT NULL,
  `vote_multiple` int DEFAULT NULL,
  `ddd` date DEFAULT NULL,
  `ddf` date DEFAULT NULL,
  `Id_utilisateur` int NOT NULL,
  PRIMARY KEY (`Id_sondage`),
  KEY `Id_utilisateur` (`Id_utilisateur`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `sondage`
--

INSERT INTO `sondage` (`Id_sondage`, `titre`, `description`, `vote_visible`, `exclusif`, `vote_multiple`, `ddd`, `ddf`, `Id_utilisateur`) VALUES
(1, 'test', 'cest un test', 1, 1, 0, '2024-06-10', '2031-06-19', 1);

-- --------------------------------------------------------

--
-- Structure de la table `type`
--

DROP TABLE IF EXISTS `type`;
CREATE TABLE IF NOT EXISTS `type` (
  `Id_type` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`Id_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `type`
--

INSERT INTO `type` (`Id_type`, `libelle`) VALUES
(1, 'livre');

-- --------------------------------------------------------

--
-- Structure de la table `utilisateur`
--

DROP TABLE IF EXISTS `utilisateur`;
CREATE TABLE IF NOT EXISTS `utilisateur` (
  `Id_utilisateur` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `prenom` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `num_tel` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ddn` date NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `pass` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `actif` tinyint(1) DEFAULT NULL,
  `honeur` tinyint(1) DEFAULT NULL,
  `optinmail` tinyint(1) DEFAULT NULL,
  `Id_rolle` int NOT NULL,
  `mailparrent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `numparrent` int DEFAULT NULL,
  PRIMARY KEY (`Id_utilisateur`),
  KEY `Id_rolle` (`Id_rolle`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `utilisateur`
--

INSERT INTO `utilisateur` (`Id_utilisateur`, `nom`, `prenom`, `num_tel`, `ddn`, `email`, `pass`, `actif`, `honeur`, `optinmail`, `Id_rolle`, `mailparrent`, `numparrent`) VALUES
(1, 'lanciaux', 'donovan', '0760839355', '1996-01-23', 'donovan63@live.fr', '$2y$12$vrxgVoUrQPZcAp6n//pyJ.HUoCo1ooneS.BiG46ra/Vneh/P8726.', 1, 0, 1, 1, NULL, NULL);

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `adesion`
--
ALTER TABLE `adesion`
  ADD CONSTRAINT `adesion_ibfk_1` FOREIGN KEY (`Id_utilisateur`) REFERENCES `utilisateur` (`Id_utilisateur`);

--
-- Contraintes pour la table `exclusion`
--
ALTER TABLE `exclusion`
  ADD CONSTRAINT `exclusion_ibfk_1` FOREIGN KEY (`Id_utilisateur`) REFERENCES `utilisateur` (`Id_utilisateur`);

--
-- Contraintes pour la table `ouvrage`
--
ALTER TABLE `ouvrage`
  ADD CONSTRAINT `ouvrage_ibfk_1` FOREIGN KEY (`Id_type`) REFERENCES `type` (`Id_type`);

--
-- Contraintes pour la table `reponse`
--
ALTER TABLE `reponse`
  ADD CONSTRAINT `reponse_ibfk_1` FOREIGN KEY (`Id_utilisateur`) REFERENCES `utilisateur` (`Id_utilisateur`),
  ADD CONSTRAINT `reponse_ibfk_2` FOREIGN KEY (`Id_sondage`) REFERENCES `sondage` (`Id_sondage`);

--
-- Contraintes pour la table `sondage`
--
ALTER TABLE `sondage`
  ADD CONSTRAINT `sondage_ibfk_1` FOREIGN KEY (`Id_utilisateur`) REFERENCES `utilisateur` (`Id_utilisateur`);

--
-- Contraintes pour la table `utilisateur`
--
ALTER TABLE `utilisateur`
  ADD CONSTRAINT `Utilisateur_ibfk_1` FOREIGN KEY (`Id_rolle`) REFERENCES `rolle` (`Id_rolle`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
