
--
-- Table structure for table `factures_fournisseur`
--

CREATE TABLE `factures_fournisseur` (
  `id` int NOT NULL AUTO_INCREMENT,
  `numero` varchar(60) NOT NULL,
  `reference` varchar(80) NOT NULL DEFAULT '',
  `fournisseur_id` int DEFAULT NULL,
  `date_facture` date DEFAULT NULL,
  `date_echeance` date DEFAULT NULL,
  `date_paiement` date DEFAULT NULL,
  `montant_tvac` decimal(12,2) NOT NULL DEFAULT '0.00',
  `statut` enum('a_payer','payee') NOT NULL DEFAULT 'a_payer',
  `communication` varchar(160) NOT NULL DEFAULT '',
  `remarque` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_ff_numero` (`numero`),
  KEY `idx_ff_statut` (`statut`),
  KEY `fk_ff_fourn` (`fournisseur_id`),
  CONSTRAINT `fk_ff_fourn` FOREIGN KEY (`fournisseur_id`) REFERENCES `fournisseurs` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `factures_fournisseur`
--

INSERT INTO `factures_fournisseur` VALUES (1,'MEUBL/2026/0080','INV-DF-BEL-324355-90976-47',1,'2026-01-01','2026-02-01',NULL,50.00,'payee','',NULL,'2026-07-06 16:46:49'),(2,'MEUBL/2026/0001','FR74709193',2,'2026-01-01','2026-01-01',NULL,85.61,'a_payer','',NULL,'2026-07-06 16:46:49'),(3,'MEUBL/2026/0070','082300000001',3,'2026-01-02','2026-01-02',NULL,56.00,'payee','',NULL,'2026-07-06 16:46:49'),(4,'MEUBL/2026/0010','VFB1602089583',4,'2026-01-10','2026-01-10',NULL,12.95,'payee','',NULL,'2026-07-06 16:46:49'),(5,'MEUBL/2026/0017','FDRW1PYK-0004',5,'2026-01-03','2026-01-03',NULL,90.00,'payee','',NULL,'2026-07-06 16:46:49'),(6,'MEUBL/2026/0067','082300000004',3,'2026-01-06','2026-01-06',NULL,52.15,'payee','',NULL,'2026-07-06 16:46:49'),(7,'MEUBL/2026/0059','411220167456',6,'2026-01-01','2026-01-31',NULL,86.98,'payee','+++453/5259/20047+++',NULL,'2026-07-06 16:46:49'),(8,'MEUBL/2026/0058','822600265944',6,'2026-01-01','2026-01-31',NULL,85.91,'payee','+++461/8921/77525+++',NULL,'2026-07-06 16:46:49'),(9,'MEUBL/2026/0044','SO2025/7055489-1',7,'2026-01-12','2026-01-13',NULL,170.85,'payee','',NULL,'2026-07-06 16:46:49'),(10,'MEUBL/2026/0075','BE55VIEABEI',8,'2026-01-12','2025-12-30',NULL,140.63,'payee','',NULL,'2026-07-06 16:46:49'),(11,'MEUBL/2026/0048','7601377813',9,'2026-01-09','2026-01-09',NULL,62.99,'payee','+++760/1377/81370+++',NULL,'2026-07-06 16:46:49'),(12,'MEUBL/2026/0021','OIOIV1BI-0003',5,'2026-01-30','2026-01-30',NULL,22.04,'payee','',NULL,'2026-07-06 16:46:49'),(13,'MEUBL/2026/0012','VFB1602118339',4,'2026-02-05','2026-02-05',NULL,18.25,'payee','VFB1602118339',NULL,'2026-07-06 16:46:49'),(14,'MEUBL/2026/0011','VFB1602118340',4,'2026-02-05','2026-02-05',NULL,18.25,'payee','VFB1602118340',NULL,'2026-07-06 16:46:49'),(15,'MEUBL/2026/0042','2026/01/031724',7,'2026-01-31','2026-01-31',NULL,0.97,'payee','2026/01/031724',NULL,'2026-07-06 16:46:49'),(16,'MEUBL/2026/0040','2026/01/031725',7,'2026-01-31','2026-01-31',NULL,154.64,'payee','SO2025/7055489-2',NULL,'2026-07-06 16:46:49'),(17,'MEUBL/2026/0079','INV-DF-BEL-350878-29595-55',1,'2026-02-01','2026-03-01',NULL,50.00,'payee','',NULL,'2026-07-06 16:46:49'),(18,'MEUBL/2026/0032','5481924974',10,'2026-01-31','2026-01-31',NULL,0.02,'payee','',NULL,'2026-07-06 16:46:49'),(19,'MEUBL/2026/0013','VFB1602126095',4,'2026-02-10','2026-02-10',NULL,12.95,'payee','',NULL,'2026-07-06 16:46:49'),(20,'MEUBL/2026/0020','OIOIV1BI-0005',5,'2026-02-08','2026-02-08','2026-01-05',9.31,'payee','',NULL,'2026-07-06 16:46:49'),(21,'MEUBL/2026/0065','730052',11,'2026-02-09','2026-02-09',NULL,17.59,'payee','',NULL,'2026-07-06 16:46:49'),(22,'MEUBL/2026/0064','730049',11,'2026-02-09','2026-02-09',NULL,17.70,'payee','',NULL,'2026-07-06 16:46:49'),(23,'MEUBL/2026/0036','2026007920',12,'2026-02-02','2026-02-12',NULL,9.68,'payee','202600792057',NULL,'2026-07-06 16:46:49'),(24,'MEUBL/2026/0053','41-FP-024622',13,'2026-01-30','2026-02-14','2026-01-08',267.05,'payee','',NULL,'2026-07-06 16:46:49'),(25,'MEUBL/2026/0024','2600059764',14,'2026-01-30','2026-01-30',NULL,3.97,'a_payer','',NULL,'2026-07-06 16:46:49'),(26,'MEUBL/2026/0056','225010705372',15,'2026-01-30','2026-02-14',NULL,39.80,'payee','+++450/9328/82301+++',NULL,'2026-07-06 16:46:49'),(27,'MEUBL/2026/0016','ME0000064748',16,'2026-01-26','2026-02-10',NULL,15.54,'payee','037/8354/74840',NULL,'2026-07-06 16:46:49'),(28,'MEUBL/2026/0034','2601270001',17,'2026-01-27','2026-01-27','2026-01-27',26.00,'payee','2601270001',NULL,'2026-07-06 16:46:50'),(29,'MEUBL/2026/0063','724 667',11,'2026-01-19','2026-01-19',NULL,48.91,'payee','',NULL,'2026-07-06 16:46:50'),(30,'MEUBL/2026/0071','BE-TI2600027901',18,'2026-01-13','2026-01-13',NULL,14.87,'a_payer','G135169557',NULL,'2026-07-06 16:46:50'),(31,'MEUBL/2026/0035','2025328469',12,'2026-01-02','2026-01-12',NULL,9.68,'payee','202532846991',NULL,'2026-07-06 16:46:50'),(32,'MEUBL/2026/0050','7601903994',9,'2026-02-09','2026-02-26',NULL,66.49,'payee','760190399426',NULL,'2026-07-06 16:46:50'),(33,'MEUBL/2026/0072','BE-TI2600080495',18,'2026-02-13','2026-02-13',NULL,14.87,'a_payer','G140996908',NULL,'2026-07-06 16:46:50'),(34,'MEUBL/2026/0078','SANI-202600348',19,'2026-02-16','2026-02-16',NULL,41.73,'payee','',NULL,'2026-07-06 16:46:50'),(35,'MEUBL/2026/0047','20260047',20,'2026-02-17','2026-03-19',NULL,344.85,'payee','+++650/8910/04742+++',NULL,'2026-07-06 16:46:50'),(36,'MEUBL/2026/0003','9154776519',21,'2026-02-17','2026-02-17',NULL,28.70,'payee','9154776519',NULL,'2026-07-06 16:46:50'),(37,'MEUBL/2026/0077','V16117078',22,'2026-02-19','2026-02-19',NULL,73.08,'payee','300611707869',NULL,'2026-07-06 16:46:50'),(38,'MEUBL/2026/0076','0902639947',23,'2026-02-19','2026-02-19',NULL,44.77,'payee','090263994745',NULL,'2026-07-06 16:46:50'),(39,'MEUBL/2026/0062','7016752',24,'2026-02-19','2026-02-19',NULL,75.50,'payee','200/7016/75234',NULL,'2026-07-06 16:46:50'),(40,'MEUBL/2026/0026','446526003227',25,'2026-02-20','2026-02-20',NULL,151.93,'payee','',NULL,'2026-07-06 16:46:50'),(41,'MEUBL/2026/0014','VFB1602152758',4,'2026-03-05','2026-04-04',NULL,18.25,'payee','',NULL,'2026-07-06 16:46:50'),(42,'MEUBL/2026/0015','VFB1602152759',4,'2026-03-05','2026-04-04',NULL,18.25,'payee','',NULL,'2026-07-06 16:46:50'),(43,'MEUBL/2026/0066','082300000058',3,'2026-02-20','2026-02-20',NULL,65.23,'payee','',NULL,'2026-07-06 16:46:50'),(44,'MEUBL/2026/0002','2517102-11117558',21,'2026-02-24','2026-02-24',NULL,114.82,'payee','',NULL,'2026-07-06 16:46:50'),(45,'MEUBL/2026/0081','INV-DF-BEL-374788-24830-48',1,'2026-03-01','2026-04-01',NULL,50.00,'payee','',NULL,'2026-07-06 16:46:50'),(46,'MEUBL/2026/0028','04801-32093679',26,'2026-02-23','2026-02-23',NULL,12.00,'payee','',NULL,'2026-07-06 16:46:50'),(47,'MEUBL/2026/0074','298',27,'2026-02-23','2026-02-23',NULL,340.21,'payee','',NULL,'2026-07-06 16:46:50'),(48,'MEUBL/2026/0025','2600119514',14,'2026-02-27','2026-03-01',NULL,2.94,'payee','',NULL,'2026-07-06 16:46:50'),(49,'MEUBL/2026/0031','5513755988',10,'2026-02-28','2026-02-28',NULL,0.02,'payee','',NULL,'2026-07-06 16:46:50'),(50,'MEUBL/2026/0037','2026037146',12,'2026-03-02','2026-03-12',NULL,9.68,'payee','202603714686',NULL,'2026-07-06 16:46:50'),(51,'MEUBL/2026/0019','FDRW1PYK-0006',5,'2026-03-03','2026-03-03',NULL,90.00,'payee','',NULL,'2026-07-06 16:46:50'),(52,'MEUBL/2026/0069','082300000061',3,'2026-02-24','2026-02-24',NULL,48.55,'payee','',NULL,'2026-07-06 16:46:50'),(53,'MEUBL/2026/0041','2026/03/004654',7,'2026-03-05','2026-03-05',NULL,154.64,'payee','SO2025/7055489-3',NULL,'2026-07-06 16:46:50'),(54,'MEUBL/2026/0045','26000371',28,'2026-03-05','2026-03-05','2026-03-05',173.19,'payee','',NULL,'2026-07-06 16:46:50'),(55,'MEUBL/2026/0068','082300000068',3,'2026-03-03','2026-03-03',NULL,67.04,'payee','',NULL,'2026-07-06 16:46:50'),(56,'MEUBL/2026/0088','FINV/2026/1432',29,'2026-03-06','2026-03-06',NULL,165.00,'payee','',NULL,'2026-07-06 16:46:50'),(57,'MEUBL/2026/0043','2026/03/015917',7,'2026-03-16','2026-04-06',NULL,2.01,'payee','2026/03/015917',NULL,'2026-07-06 16:46:50'),(58,'MEUBL/2026/0039','F9A217C2-275370',30,'2026-03-17','2026-03-17',NULL,20.00,'payee','',NULL,'2026-07-06 16:46:50'),(59,'MEUBL/2026/0023','2096355',31,'2026-03-04','2026-03-20',NULL,309.02,'payee','+++260/4242/91207+++',NULL,'2026-07-06 16:46:51'),(60,'MEUBL/2026/0018','OIOIV1BI-0007',5,'2026-03-20','2026-03-20','2026-03-21',9.64,'payee','',NULL,'2026-07-06 16:46:51'),(61,'MEUBL/2026/0092','VFB1602184614',4,'2026-04-05','2026-05-04',NULL,18.25,'payee','',NULL,'2026-07-06 16:46:51'),(62,'MEUBL/2026/0091','VFB1602184615',4,'2026-04-05','2026-05-04',NULL,18.25,'payee','',NULL,'2026-07-06 16:46:51'),(63,'MEUBL/2026/0029','20260083',32,'2026-03-25','2026-04-09',NULL,290.40,'payee','005008311070',NULL,'2026-07-06 16:46:51'),(64,'MEUBL/2026/0027','04829-28486387',26,'2026-03-23','2026-03-23',NULL,12.00,'payee','',NULL,'2026-07-06 16:46:51'),(65,'MEUBL/2026/0007','IEE2026004998518',33,'2026-03-15','2026-03-15',NULL,19.15,'payee','',NULL,'2026-07-06 16:46:51'),(66,'MEUBL/2026/0005','IEE2026004058123',33,'2026-03-01','2026-03-01',NULL,21.84,'payee','',NULL,'2026-07-06 16:46:51'),(67,'MEUBL/2026/0008','IEE2026002993675',33,'2026-02-15','2026-02-15',NULL,19.15,'payee','',NULL,'2026-07-06 16:46:51'),(68,'MEUBL/2026/0004','IEE2026002063018',33,'2026-02-01','2026-02-01',NULL,21.84,'payee','',NULL,'2026-07-06 16:46:51'),(69,'MEUBL/2026/0009','IEE2026000974661',33,'2026-01-15','2026-01-15',NULL,19.15,'payee','',NULL,'2026-07-06 16:46:51'),(70,'MEUBL/2026/0006','IEE2026000053403',33,'2026-01-01','2026-01-01',NULL,21.84,'payee','',NULL,'2026-07-06 16:46:51'),(71,'MEUBL/2026/0115','INV-DF-BEL-399784-48503-54',1,'2026-04-01','2026-05-01',NULL,50.00,'payee','',NULL,'2026-07-06 16:46:51'),(72,'MEUBL/2026/0030','5542578455',10,'2026-03-31','2026-03-31',NULL,0.02,'payee','',NULL,'2026-07-06 16:46:51'),(73,'MEUBL/2026/0116','2026066505',12,'2026-04-01','2026-04-11',NULL,9.68,'payee','202606650554',NULL,'2026-07-06 16:46:51'),(74,'MEUBL/2026/0114','2026/04/000371',7,'2026-04-01','2026-04-01',NULL,156.09,'payee','SO2025/7055489-4',NULL,'2026-07-06 16:46:51'),(75,'MEUBL/2026/0054','41-FP-032453',13,'2026-03-31','2026-04-15',NULL,114.95,'a_payer','',NULL,'2026-07-06 16:46:51'),(76,'MEUBL/2026/0052','41-FP-031520',13,'2026-03-30','2026-04-14',NULL,267.05,'payee','',NULL,'2026-07-06 16:46:51'),(77,'MEUBL/2026/0049','ME0000069041',16,'2026-03-27','2026-04-11',NULL,15.78,'payee','037/8359/04165',NULL,'2026-07-06 16:46:51'),(78,'MEUBL/2026/0051','7602429844',9,'2026-03-09','2026-03-26',NULL,66.49,'payee','760242984439',NULL,'2026-07-06 16:46:51'),(79,'MEUBL/2026/0073','BE-TI2600130709',18,'2026-03-13','2026-03-13',NULL,14.87,'a_payer','G146727746',NULL,'2026-07-06 16:46:51'),(80,'MEUBL/2026/0057','411270171381',6,'2026-03-09','2026-03-27',NULL,98.01,'payee','453569704433',NULL,'2026-07-06 16:46:51'),(81,'MEUBL/2026/0060','822610043728',6,'2026-03-08','2026-03-08',NULL,85.91,'payee','+++462/9275/55222+++',NULL,'2026-07-06 16:46:51'),(82,'MEUBL/2026/0083','2600179299',14,'2026-03-31','2026-03-31',NULL,29.04,'payee','',NULL,'2026-07-06 16:46:51'),(83,'MEUBL/2026/0082','2600179300',14,'2026-03-31','2026-03-31',NULL,5.19,'payee','',NULL,'2026-07-06 16:46:51'),(84,'MEUBL/2026/0084','VFB1602191841',4,'2026-04-10','2026-04-10',NULL,12.95,'payee','',NULL,'2026-07-06 16:46:51'),(85,'MEUBL/2026/0085','FINV/2026/0098',29,'2026-01-05','2026-01-05',NULL,165.00,'payee','',NULL,'2026-07-06 16:46:51'),(86,'MEUBL/2026/0086','FINV/2026/0640',29,'2026-02-02','2026-02-02',NULL,165.00,'payee','',NULL,'2026-07-06 16:46:51'),(87,'MEUBL/2026/0113','822620050173',6,'2026-04-08','2026-04-26',NULL,85.91,'payee','+++461/9410/50266+++',NULL,'2026-07-06 16:46:51'),(88,'MEUBL/2026/0090','822630017502',6,'2026-02-01','2026-02-28',NULL,85.91,'payee','+++462/9122/70042+++',NULL,'2026-07-06 16:46:51'),(89,'MEUBL/2026/0089','411240177100',6,'2026-02-01','2026-02-28',NULL,100.79,'payee','+++453/5481/07280+++',NULL,'2026-07-06 16:46:51'),(90,'MEUBL/2026/0112','1260502515',34,'2026-02-24','2026-03-06',NULL,65.49,'payee','+++006/0502/51526+++',NULL,'2026-07-06 16:46:51'),(91,'MEUBL/2026/0111','1260247237',34,'2026-01-24','2026-02-03',NULL,55.49,'payee','+++006/0247/23752+++',NULL,'2026-07-06 16:46:51'),(92,'MEUBL/2026/0110','1260768435',34,'2026-03-24','2026-04-03','2026-04-22',55.49,'payee','+++006/0768/43569+++',NULL,'2026-07-06 16:46:51'),(93,'MEUBL/2026/0093','7BFDBOOB-0014',5,'2026-01-13','2026-01-13',NULL,18.16,'payee','',NULL,'2026-07-06 16:46:51'),(94,'MEUBL/2026/0094','7BFDBOOB-0015',5,'2026-02-13','2026-02-13',NULL,16.88,'payee','',NULL,'2026-07-06 16:46:51'),(95,'MEUBL/2026/0095','7BFDBOOB-0016',5,'2026-03-13','2026-03-13',NULL,17.38,'payee','',NULL,'2026-07-06 16:46:51'),(96,'MEUBL/2026/0096','FDRW1PYK-0007',5,'2026-04-03','2026-04-03',NULL,90.00,'payee','',NULL,'2026-07-06 16:46:51'),(97,'MEUBL/2026/0139','2026/04/010896',7,'2026-04-13','2026-05-04',NULL,1.84,'payee','SO2026/7610648',NULL,'2026-07-06 16:46:51'),(98,'MEUBL/2026/0097','747236',11,'2026-04-15','2026-04-15',NULL,9.00,'payee','',NULL,'2026-07-06 16:46:51'),(99,'MEUBL/2026/0098','747232',11,'2026-04-15','2026-04-15',NULL,84.45,'payee','',NULL,'2026-07-06 16:46:51'),(100,'MEUBL/2026/0186','BE-TI2600181666',18,'2026-04-13','2026-04-13',NULL,14.87,'a_payer','G152673779',NULL,'2026-07-06 16:46:51'),(101,'MEUBL/2026/0099','2026/04/010896',7,'2026-04-13','2026-05-04','2026-04-10',1.84,'payee','SO2026/7610648',NULL,'2026-07-06 16:46:51'),(102,'MEUBL/2026/0101','7602958951',9,'2026-04-09','2026-04-26',NULL,66.49,'payee','760295895111',NULL,'2026-07-06 16:46:51'),(103,'MEUBL/2026/0184','746073',11,'2026-04-10','2026-04-10',NULL,1336.07,'a_payer','',NULL,'2026-07-06 16:46:51'),(104,'MEUBL/2026/0100','411270173524',6,'2026-04-09','2026-04-27',NULL,86.16,'payee','453590753635',NULL,'2026-07-06 16:46:51'),(105,'MEUBL/2026/0109','F9A217C2-320052',30,'2026-04-17','2026-04-17',NULL,20.00,'payee','',NULL,'2026-07-06 16:46:51'),(106,'MEUBL/2026/0102','037835000',16,'2026-04-20','2026-05-05','2026-04-22',4.94,'payee','+++037/8352/10617+++',NULL,'2026-07-06 16:46:51'),(107,'MEUBL/2026/0189','41-FP-028548',13,'2026-02-27','2026-03-14',NULL,267.05,'payee','+++004/1028/54870+++',NULL,'2026-07-06 16:46:51'),(108,'MEUBL/2026/0107','INV-DF-BEL-426390-73511-35',1,'2026-05-01','2026-06-01',NULL,50.00,'payee','',NULL,'2026-07-06 16:46:51'),(109,'MEUBL/2026/0105','VFB1602224359',4,'2026-05-10','2026-05-10',NULL,12.95,'payee','',NULL,'2026-07-06 16:46:51'),(110,'MEUBL/2026/0104','VFB1602224316',4,'2026-05-05','2026-06-04',NULL,18.25,'payee','',NULL,'2026-07-06 16:46:51'),(111,'MEUBL/2026/0103','VFB1602224317',4,'2026-05-05','2026-06-04',NULL,18.25,'payee','',NULL,'2026-07-06 16:46:51'),(112,'MEUBL/2026/0108','Facture FR77366202',2,'2026-05-01','2026-05-01',NULL,91.08,'payee','',NULL,'2026-07-06 16:46:51'),(113,'MEUBL/2026/0106','2026/05/000940',7,'2026-05-02','2026-05-02',NULL,18.15,'payee','2026/05/000940',NULL,'2026-07-06 16:46:51'),(114,'MEUBL/2026/0185','de la facture 5568954614',10,'2026-04-30','2026-04-30',NULL,0.02,'payee','',NULL,'2026-07-06 16:46:51'),(115,'MEUBL/2026/0142','Facture FR77533799',2,'2026-05-01','2026-05-01',NULL,0.30,'payee','',NULL,'2026-07-06 16:46:51'),(116,'MEUBL/2026/0119','FDRW1PYK-0008',5,'2026-05-03','2026-05-03',NULL,90.00,'payee','',NULL,'2026-07-06 16:46:51'),(117,'MEUBL/2026/0120','FDRW1PYK-0008',5,'2026-05-03','2026-05-03','2026-04-12',90.00,'payee','',NULL,'2026-07-06 16:46:51'),(118,'MEUBL/2026/0138','411270173524',6,'2026-04-09','2026-04-30','2026-05-04',86.16,'payee','+++453/5907/53635+++',NULL,'2026-07-06 16:46:51'),(119,'MEUBL/2026/0128','223011733988',15,'2026-04-30','2026-05-15',NULL,39.80,'payee','+++401/6292/17392+++',NULL,'2026-07-06 16:46:51'),(120,'MEUBL/2026/0132','2026095729',12,'2026-05-04','2026-05-14',NULL,9.68,'payee','202609572981',NULL,'2026-07-06 16:46:51'),(121,'MEUBL/2026/0131','752120',11,'2026-05-04','2026-05-04',NULL,10.78,'payee','',NULL,'2026-07-06 16:46:51'),(122,'MEUBL/2026/0133','2600238948',14,'2026-04-30','2026-05-06',NULL,2.16,'payee','',NULL,'2026-07-06 16:46:51'),(123,'MEUBL/2026/0190','20260004449',35,'2026-04-30','2026-04-30',NULL,64.71,'payee','',NULL,'2026-07-06 16:46:51'),(124,'MEUBL/2026/0191','41-FP-034183',13,'2026-04-28','2026-05-13',NULL,139.55,'a_payer','',NULL,'2026-07-06 16:46:51'),(125,'MEUBL/2026/0129','2218150582',36,'2026-04-28','2026-05-05',NULL,25.19,'payee','',NULL,'2026-07-06 16:46:51'),(126,'MEUBL/2026/0126','2218150578',36,'2026-04-28','2026-05-05',NULL,63.69,'payee','',NULL,'2026-07-06 16:46:51'),(127,'MEUBL/2026/0127','2218147274',36,'2026-04-27','2026-05-04',NULL,135.04,'payee','',NULL,'2026-07-06 16:46:51'),(128,'MEUBL/2026/0130','446526007764',25,'2026-04-25','2026-04-25',NULL,109.72,'payee','',NULL,'2026-07-06 16:46:51'),(129,'MEUBL/2026/0123','1261029251',34,'2026-04-24','2026-05-12',NULL,65.49,'payee','+++006/1029/25152+++',NULL,'2026-07-06 16:46:51'),(130,'MEUBL/2026/0180','ME0000072106',16,'2026-04-20','2026-05-05',NULL,4.94,'payee','037/8352/10617',NULL,'2026-07-06 16:46:51'),(131,'MEUBL/2026/0124','2026/05/004974',7,'2026-05-06','2026-05-06',NULL,157.06,'payee','SO2025/7055489-5',NULL,'2026-07-06 16:46:51'),(132,'MEUBL/2026/0125','2260197338',34,'2026-05-06','2026-05-24',NULL,60.71,'payee','+++016/0197/33892+++',NULL,'2026-07-06 16:46:51'),(133,'MEUBL/2026/0135','822630049966',6,'2026-05-07','2026-05-25',NULL,85.91,'payee','+++462/9599/29778+++',NULL,'2026-07-06 16:46:51'),(134,'MEUBL/2026/0137','2260197338',34,'2026-05-06','2026-05-27','2026-05-08',60.71,'payee','+++016/0197/33892+++',NULL,'2026-07-06 16:46:51'),(135,'MEUBL/2026/0179','411220175780',6,'2026-05-08','2026-05-26',NULL,81.30,'payee','453611444846',NULL,'2026-07-06 16:46:51'),(136,'MEUBL/2026/0178','BE-TI2600232812',18,'2026-05-13','2026-05-13',NULL,14.87,'a_payer','G158684576',NULL,'2026-07-06 16:46:51'),(137,'MEUBL/2026/0175','7603481859',9,'2026-05-09','2026-05-26',NULL,66.49,'payee','760348185989',NULL,'2026-07-06 16:46:51'),(138,'MEUBL/2026/0141','FINV/2026/2800',29,'2026-05-12','2026-05-12',NULL,165.00,'payee','',NULL,'2026-07-06 16:46:51'),(139,'MEUBL/2026/0143','048200015495',37,'2026-05-18','2026-05-18',NULL,40.01,'payee','',NULL,'2026-07-06 16:46:51'),(140,'MEUBL/2026/0144','BE62BURABEI',8,'2026-05-17','2026-05-14',NULL,58.65,'payee','',NULL,'2026-07-06 16:46:51'),(141,'MEUBL/2026/0145','BE62325ABEI',8,'2026-05-03','2026-05-03',NULL,86.58,'payee','',NULL,'2026-07-06 16:46:51'),(142,'MEUBL/2026/0172','XX60001ML1WD9T',38,'2026-05-15','2026-05-15',NULL,45.37,'payee','',NULL,'2026-07-06 16:46:51'),(143,'MEUBL/2026/0171','DE609CR15DCKTI',39,'2026-03-16','2026-03-16',NULL,62.48,'payee','',NULL,'2026-07-06 16:46:51'),(144,'MEUBL/2026/0146','BE61U9PABEI',8,'2026-04-17','2026-04-17',NULL,53.75,'payee','',NULL,'2026-07-06 16:46:51'),(145,'MEUBL/2026/0147','BE622BZABEI',8,'2026-04-30','2026-04-30',NULL,22.49,'payee','',NULL,'2026-07-06 16:46:51'),(146,'MEUBL/2026/0173','FR6OWLQFAEUI',40,'2026-04-15','2026-04-14',NULL,63.26,'payee','',NULL,'2026-07-06 16:46:51'),(147,'MEUBL/2026/0148','BE61LRYABEI',8,'2026-04-02','2026-04-02',NULL,19.16,'payee','',NULL,'2026-07-06 16:46:51'),(148,'MEUBL/2026/0150','12001761662',41,'2026-05-20','2026-05-20',NULL,51.83,'payee','',NULL,'2026-07-06 16:46:51'),(149,'MEUBL/2026/0151','1261347333',34,'2026-05-24','2026-06-11',NULL,63.44,'payee','+++006/1347/33371+++',NULL,'2026-07-06 16:46:51'),(150,'MEUBL/2026/0170','41-FP-035929',13,'2026-05-28','2026-06-12',NULL,272.29,'a_payer','',NULL,'2026-07-06 16:46:51'),(151,'MEUBL/2026/0153','2026/05/025300',7,'2026-05-31','2026-05-31',NULL,157.06,'payee','SO2025/7055489-6',NULL,'2026-07-06 16:46:51'),(152,'MEUBL/2026/0156','2026124818',12,'2026-06-01','2026-06-11',NULL,9.68,'payee','202612481870',NULL,'2026-07-06 16:46:51'),(153,'MEUBL/2026/0155','FA2026074127',42,'2026-06-02','2026-06-02',NULL,14.40,'payee','',NULL,'2026-07-06 16:46:51'),(154,'MEUBL/2026/0176','2600297271',14,'2026-05-29','2026-06-02',NULL,2.78,'a_payer','',NULL,'2026-07-06 16:46:51'),(155,'MEUBL/2026/0177','260/7274/43586',31,'2026-06-02','2026-07-22',NULL,309.90,'a_payer','260/7274/43586',NULL,'2026-07-06 16:46:51'),(156,'MEUBL/2026/0158','822610094491',6,'2026-06-07','2026-06-25',NULL,85.91,'payee','+++461/9734/67767+++',NULL,'2026-07-06 16:46:51'),(157,'MEUBL/2026/0159','411281100540',6,'2026-06-08','2026-06-26',NULL,81.58,'payee','453631591746',NULL,'2026-07-06 16:46:51'),(158,'PISC/2026/0001','FV-2026-03915',43,'2026-06-09','2026-06-09',NULL,85.89,'payee','+++000/0186/94829+++',NULL,'2026-07-06 16:46:51'),(159,'PISC/2026/0002','FV-2026-03914',43,'2026-06-09','2026-06-09',NULL,143.76,'payee','+++000/0186/94627+++',NULL,'2026-07-06 16:46:51'),(160,'MEUBL/2026/0163','7604000970',9,'2026-06-09','2026-06-26',NULL,66.49,'payee','760400097056',NULL,'2026-07-06 16:46:51'),(161,'MEUBL/2026/0182','BE-TI2600285132',18,'2026-06-13','2026-06-13',NULL,14.87,'a_payer','G164978104',NULL,'2026-07-06 16:46:51'),(162,'MEUBL/2026/0162','VDI/2026/06/0028',44,'2026-06-15','2026-06-15',NULL,108.90,'payee','+++000/4407/02827+++',NULL,'2026-07-06 16:46:51'),(163,'MEUBL/2026/0164','BE62LQDABEI',8,'2026-05-31','2026-05-30',NULL,39.99,'payee','',NULL,'2026-07-06 16:46:51'),(164,'MEUBL/2026/0192','FR60003ZI3ZQ9I',40,'2026-06-14','2026-06-14',NULL,88.62,'payee','',NULL,'2026-07-06 16:46:51'),(165,'MEUBL/2026/0165','1261638381',34,'2026-06-24','2026-07-12',NULL,63.44,'payee','+++006/1638/38122+++',NULL,'2026-07-06 16:46:51'),(166,'MEUBL/2026/0167','2026/06/023803',7,'2026-06-28','2026-06-28',NULL,157.06,'payee','SO2025/7055489-7',NULL,'2026-07-06 16:46:51'),(167,'MEUBL/2026/0169','41-FP-039003',13,'2026-06-29','2026-07-14',NULL,272.19,'payee','',NULL,'2026-07-06 16:46:51'),(168,'MEUBL/2026/0174','20260236',32,'2026-06-30','2026-07-15',NULL,387.20,'payee','005023628784',NULL,'2026-07-06 16:46:51'),(169,'MEUBL/2026/0183','2026153843',12,'2026-07-01','2026-07-11','2026-04-13',9.68,'payee','202615384392',NULL,'2026-07-06 16:46:51'),(170,'MEUBL/2026/0118','2600357577',14,'2026-06-30','2026-07-02',NULL,2.17,'a_payer','',NULL,'2026-07-06 16:46:51'),(171,'MEUBL/2026/0168','2600357576',14,'2026-06-30','2026-07-02',NULL,29.04,'payee','',NULL,'2026-07-06 16:46:51'),(172,'MEUBL/2026/0193','',5,'2026-02-08','2026-07-03',NULL,8.53,'payee','',NULL,'2026-07-06 16:46:51'),(173,'MEUBL/2026/0194','',5,'2026-03-20','2026-07-03',NULL,8.86,'payee','',NULL,'2026-07-06 16:46:51'),(174,'MEUBL/2026/0033','5461613531',10,'2025-12-31','2025-12-31',NULL,0.02,'payee','',NULL,'2026-07-08 13:39:21'),(175,'MEUBL/2026/0187','VFC-03-22091901',13,'2025-03-31','2022-10-07',NULL,493.68,'a_payer','',NULL,'2026-07-08 13:39:21'),(176,'MEUBL/2026/0188','41-FP-004233',13,'2025-06-23','2025-07-08',NULL,125.97,'a_payer','+++004/1004/23305+++',NULL,'2026-07-08 13:39:21');

--
-- Table structure for table `fournisseurs`
--

CREATE TABLE `fournisseurs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(160) NOT NULL,
  `num_tva` varchar(20) NOT NULL DEFAULT '',
  `iban` varchar(34) NOT NULL DEFAULT '',
  `email` varchar(120) NOT NULL DEFAULT '',
  `telephone` varchar(30) NOT NULL DEFAULT '',
  `odoo_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_fourn_nom` (`nom`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fournisseurs`
--

INSERT INTO `fournisseurs` VALUES (1,'Starlink Internet Services Ltd','BE0768319479','','','',1232,'2026-07-06 16:46:49'),(2,'OVHcloud','FR22424761419','','','',1284,'2026-07-06 16:46:49'),(3,'DeBe Services (Total Bouge)','BE0849420783','','','+32 81 41 13 85',304,'2026-07-06 16:46:49'),(4,'Aftersalesnl B.V.','NL851739519B01','','lab9@aftersalesnl.nl','31737620630',1231,'2026-07-06 16:46:49'),(5,'Anthropic, PBC','EU372041333','','support@anthropic.com','+1 415-326-6303',1309,'2026-07-06 16:46:49'),(6,'VOO Business (Orange Belgium)','BE0456810810','','','0800 43 303',1388,'2026-07-06 16:46:49'),(7,'Odoo S.A.','BE0477472701','','info@odoo.com','+32 81 81 37 00',1233,'2026-07-06 16:46:49'),(8,'Amazon Business Eu SARL','BE0712664047','','','',2187,'2026-07-06 16:46:49'),(9,'Proximus','BE0202239951','','secretary.general@proximus.com','3222028241',1236,'2026-07-06 16:46:49'),(10,'GOOGLE CLOUD EMEA LIMITED','IE3668997OH','','','',1311,'2026-07-06 16:46:49'),(11,'Carlier Bois SA','BE0456910085','','michael.lechien@carlier.be','081 25 03 30',1396,'2026-07-06 16:46:49'),(12,'Isabel','BE0455530509','','info@isabel.eu','+32 2 545 17 11',2201,'2026-07-06 16:46:49'),(13,'Securitas Technology','BE0541717482','','billing.technology@securitas.be','+32 15 29 42 00',1312,'2026-07-06 16:46:49'),(14,'CBC Banque SA','BE0403211380','','namur@cbc.be','+ 32 81 20 88 30',1235,'2026-07-06 16:46:49'),(15,'Societe Wallonne des Eaux','BE0230132005','','officiel.pm_swde@swde.be','+32 87 34 28 11',1395,'2026-07-06 16:46:49'),(16,'Antargaz Belgium','BE0881334278','','info.be@antargaz.com','+3222460000',2210,'2026-07-06 16:46:49'),(17,'INTERMARCHE BOUGE BEEZ','BE1009099017','','','',1248,'2026-07-06 16:46:50'),(18,'Microsoft NV','BE0437910359','','','',2216,'2026-07-06 16:46:50'),(19,'Sanitech Chauffage Electricite','BE0635818766','','','+32 81 87 71 51',2217,'2026-07-06 16:46:50'),(20,'SEGHERS LUC','BE0855167539','','','',2218,'2026-07-06 16:46:50'),(21,'Action Belgium BVBA','BE0873975443','','','+31 (0)228 565 080',2219,'2026-07-06 16:46:50'),(22,'Lecot','BE0405350033','','info@lecot.be','+32 56 36 45 11',1397,'2026-07-06 16:46:50'),(23,'Van Marcke','BE0443336223','','info@vanmarcke.be','+3256237595',2220,'2026-07-06 16:46:50'),(24,'CIPAC','BE0445795568','','','',2221,'2026-07-06 16:46:50'),(25,'COLRUYT FOOD RETAIL NV','BE0716663615','','rolloutedi@colruytgroup.com','+ 32 2 363 55 45',2222,'2026-07-06 16:46:50'),(26,'Canva Pty Ltd','EU372042198','','','',1410,'2026-07-06 16:46:50'),(27,'ARSTORE DI RASPUGLI ANDREA','IT02572960413','','andrearaspugli@ar-store.it','+39072276750',2223,'2026-07-06 16:46:50'),(28,'PALL CENTER EXPLOITATION S.A.','LU18379409','','','',2227,'2026-07-06 16:46:50'),(29,'Honesty Exploitation','BE0730800473','','','+32 61 29 24 14',1414,'2026-07-06 16:46:50'),(30,'MAMMOUTH AI','FR38932983968','','contact@mammouth.ai','',2235,'2026-07-06 16:46:50'),(31,'Baloise Belgium','BE0400048883','','info@baloise.be','+32 3 247 21 11',1419,'2026-07-06 16:46:51'),(32,'Comfisgest','BE0860031395','','comfigest@skynet.be','+32 67 21 16 65',1240,'2026-07-06 16:46:51'),(33,'Adobe Ireland','IE6364992H','','','',1403,'2026-07-06 16:46:51'),(34,'Power Online','BE0535615192','','info@mega.be','+32 4 242 47 87',1413,'2026-07-06 16:46:51'),(35,'Servauto Belgium (SA)','BE0423097766','','inside-sales-service-retail@circlekeur.com','',2260,'2026-07-06 16:46:51'),(36,'BRICOWEP S.A.','BE0426460894','','BRICO.WEPION.INFO@BRICO.BE','08146 15 83',2261,'2026-07-06 16:46:51'),(37,'EG Retail (Belgium)','BE0406843239','','','',2265,'2026-07-06 16:46:51'),(38,'Fournisseurs divers','','','','',2278,'2026-07-06 16:46:51'),(39,'Amazon DE','','','','',2277,'2026-07-06 16:46:51'),(40,'Amazon FR','','','','',2279,'2026-07-06 16:46:51'),(41,'Kaffekapslen.DK Aps','BE0759499112','','','',2267,'2026-07-06 16:46:51'),(42,'A.M.P. Piscines','BE0419194804','','info@amppiscines.be','081 31 06 50',1400,'2026-07-06 16:46:51'),(43,'T.E.P.','BE0463183809','','','+32 10 24 39 29',1415,'2026-07-06 16:46:51'),(44,'WE ACCOMPAGNEMENT ET STRATEGIE','BE0881746727','','invoice@wallonie-entreprendre.be','+32(0)4 221 98 11',2274,'2026-07-06 16:46:51');

--
-- Table structure for table `objets_calculateur`
--

CREATE TABLE `objets_calculateur` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `ordre` int NOT NULL DEFAULT '0',
  `piece` varchar(10) NOT NULL DEFAULT '',
  `nom` varchar(60) NOT NULL,
  `image` varchar(40) NOT NULL DEFAULT '',
  `volume_dm3` int NOT NULL DEFAULT '0',
  `actif` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `objets_calculateur`
--

INSERT INTO `objets_calculateur` VALUES (1,1,'XXX','Test SGL','test',1,0),(2,3,'CUI','Frigo (petit) H50','frigo-petit',86,1),(3,1,'DIV','Carton moyen (55x35x33)','',62,1),(4,1,'BUA','Lessiveuse','lessiveuse',300,1),(5,2,'BUA','Sèche-linge','seche-linge',300,1),(6,1,'GAJ','Tondeuse','tondeuse',350,1),(7,3,'CHE','Bureau enfant','bureau-enfant',200,1),(8,1,'BUR','Ordinateur de bureau + écran','ordinateur',60,1),(9,5,'CUI','Poubelle de cuisine','poubelle-cuisine',50,1),(10,3,'BUR','Poubelle de bureau','poubelle-bureau',45,1),(11,4,'SDB','Bac à linge','bac-a-linge',90,1),(12,2,'CUI','Four micro-ondes','micro-ondes',60,1),(13,1,'CUI','Cuisinière','cuisiniere',240,1),(14,11,'CUI','frigo américain','',175,1),(15,4,'CUI','table ','',1,1),(16,1,'CUI','meuble haut','',84,1),(17,6,'CUI','chaises','',1,1),(18,7,'CUI','cartons petit électro','',2,1),(19,8,'CUI','10 cartons vaisselle','',2,1);

--
-- Table structure for table `parametres`
--

CREATE TABLE `parametres` (
  `cle` varchar(60) NOT NULL,
  `valeur` text NOT NULL,
  PRIMARY KEY (`cle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `parametres`
--

INSERT INTO `parametres` VALUES ('act365_url','https://www.act365.eu/Account/Login'),('backup_cle','Lol1r1ne-B4ckup-2026'),('devis_conditions','Durée minimale : 1 mois.\nCaution : 2 mois de loyer, à verser avant l\'entrée dans les lieux.\nFrais de dossier : 15 €, non remboursables.\nPaiement : à terme échu (le paiement intervient en fin de période de location).\nPréavis de départ : le client doit prévenir 15 jours avant la fin de la période en cours.\nAssurance : le locataire doit souscrire sa propre assurance couvrant le contenu entreposé et les risques liés à l\'occupation du box.\nAccès et usage : l\'espace loué est strictement réservé au stockage de biens licites et non dangereux.\nMontant indiqué : tous les montants sont TVAC (toutes taxes comprises).\nRenouvellement : tacite de mois en mois sauf préavis respecté.\nRestitution : le box doit être vidé et rendu propre à la fin de la location.\nValidité du devis : 30 jours à compter de sa date d\'émission.'),('facture_pied','Paiement à réception sur le compte ci-dessus en mentionnant la communication structurée. Merci de votre confiance.'),('fisc_bce','0650.891.279'),('fisc_comptable','Saïd El Harchi (COMFISGEST)'),('fisc_exercice_debut_jour','1'),('fisc_exercice_debut_mois','1'),('fisc_forme_juridique','SRL'),('fisc_nace',''),('fisc_pme','1'),('fisc_representant','Rodney Feron'),('fisc_seuil_pme','100000'),('fisc_taux_isoc','25'),('fisc_taux_pme','20'),('gerbeur_code','1994'),('horaire_dim','Fermé'),('horaire_jeu','09:00 – 18:00'),('horaire_lun','09:00 – 18:00'),('horaire_mar','09:00 – 18:00'),('horaire_mer','09:00 – 18:00'),('horaire_sam','10:00 – 16:00'),('horaire_ven','09:00 – 17:00'),('km_taux','0.4415'),('odoo_apikey','01c0eff7010c9ff6c2e301c64f843e373db44238'),('odoo_db','lolirine-lolirine-main-22475279'),('odoo_login','gardemeublelolirine@gmail.com'),('odoo_url','https://lolirine-lolirine.odoo.com'),('relance_auto_active','0'),('relance_cle','Lol1r1ne-Relance'),('relance_delai_1','7'),('relance_delai_2','14'),('relance_delai_3','30'),('reservation_email',''),('site_url','https://implantation.lolirineboxdisponible.be'),('societe_adresse','Rue de la Drève Boninas 2, 5021 Boninne (Namur)'),('societe_bic',''),('societe_cp','5021'),('societe_email','gardemeublelolirine@gmail.com'),('societe_iban','BE07732052080866'),('societe_iban_caution','BE82732053565168'),('societe_localite','Boninne'),('societe_nom','Lolirine SRL'),('societe_rue','Rue de la Drève Boninas 2'),('societe_tel','0497/44.41.46 – 0498/52.11.31'),('societe_tva','BE 0650.891.279'),('taux_tva_defaut','21'),('tva_periodicite','trimestrielle');

--
-- Table structure for table `photos`
--

CREATE TABLE `photos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fichier` varchar(120) NOT NULL,
  `legende` varchar(160) NOT NULL DEFAULT '',
  `ordre` int NOT NULL DEFAULT '0',
  `actif` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` VALUES (1,'640x480-100.png','',2,1),(2,'640x480-101.png','',0,1),(3,'640x480-102.png','',5,1),(4,'640x480-103.png','',0,1),(5,'640x480-104.png','',4,1),(6,'640x480-105.png','',0,1),(7,'640x480-106.png','',0,1),(8,'640x480-107.png','',3,1),(9,'640x480-108.png','',1,1),(10,'640x480-109.png','',3,1),(11,'640x480-110.png','',6,1),(12,'640x480-111.png','',0,1),(13,'640x480-112.png','',0,1),(14,'640x480-113.png','',0,1),(15,'640x480-114.png','',0,1),(16,'640x480-115.png','',0,1),(17,'640x480-116.png','',0,1),(18,'640x480-117.png','',0,1),(19,'640x480-118.png','',0,1),(20,'640x480-119.png','',2,1),(21,'640x480-120.png','',0,1),(22,'640x480-121.png','',0,1),(23,'640x480-122.png','',0,1),(24,'640x480-123.png','',0,1),(25,'640x480-124.png','',0,1),(26,'640x480-125.png','',7,1);

--
-- Table structure for table `rdv`
--

CREATE TABLE `rdv` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `date_rdv` date NOT NULL,
  `heure` time DEFAULT NULL,
  `objet` varchar(160) NOT NULL,
  `lieu` varchar(160) NOT NULL DEFAULT '',
  `client_id` int unsigned DEFAULT NULL,
  `note` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_date` (`date_rdv`),
  KEY `fk_rdv_client` (`client_id`),
  CONSTRAINT `fk_rdv_client` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rdv`
--


--
-- Table structure for table `relances_log`
--

CREATE TABLE `relances_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `facture_id` int NOT NULL,
  `niveau` tinyint NOT NULL,
  `destinataire` varchar(160) NOT NULL DEFAULT '',
  `succes` tinyint NOT NULL DEFAULT '0',
  `message` varchar(255) NOT NULL DEFAULT '',
  `envoye_le` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_rl_facture` (`facture_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `relances_log`
--


--
-- Table structure for table `seo_pages`
--

CREATE TABLE `seo_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `page` varchar(60) NOT NULL,
  `titre` varchar(180) NOT NULL DEFAULT '',
  `description` varchar(300) NOT NULL DEFAULT '',
  `mots_cles` varchar(255) NOT NULL DEFAULT '',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_seo_page` (`page`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `seo_pages`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `display_name` varchar(60) NOT NULL,
  `role` enum('admin','lecture') NOT NULL DEFAULT 'admin',
  `actif` tinyint(1) NOT NULL DEFAULT '1',
  `last_login` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'rodney','$2y$10$XeZXV5gVhbqj9mXcZ9LcteNxwvhZUae3FDAPqDUFQva/kwqgqeQk6','Rodney','admin',1,'2026-07-08 09:52:02','2026-07-03 18:05:53');

--
-- Table structure for table `villages`
--

CREATE TABLE `villages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `cp` varchar(4) NOT NULL,
  `localite` varchar(60) NOT NULL,
  `commune` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_cp` (`cp`),
  KEY `idx_localite` (`localite`)
) ENGINE=InnoDB AUTO_INCREMENT=4096 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `villages`
--

INSERT INTO `villages` VALUES (1,'4557','ABÉE','TINLOT'),(2,'4280','ABOLENS','HANNUT'),(3,'5590','ACHÊNE','CINEY'),(4,'5362','ACHET','HAMOIS'),(5,'4219','ACOSSE','WASSEIGES'),(6,'6280','ACOZ','GERPINNES'),(7,'4141','ADZEUX','SPRIMONT'),(8,'4760','AFST','BÜLLINGEN / BULLANGE'),(9,'5544','AGIMONT','HASTIÈRE'),(10,'5651','AHÉRÉE','WALCOURT'),(11,'4500','AHIN','HUY'),(12,'4317','AINEFFE','FAIMES'),(13,'7910','AINIÈRES','FRASNES-LEZ-ANVAING'),(14,'5310','AISCHE-EN-REFAIL','EGHEZÉE'),(15,'6250','AISEAU','AISEAU-PRESLES'),(16,'5070','AISEMONT','FOSSES-LA-VILLE'),(17,'6941','AISNE','DURBUY'),(18,'4980','AISOMONT','TROIS-PONTS'),(19,'6792','AIX-SUR-CLOIE','AUBANGE'),(20,'4791','ALDRINGEN','BURG-REULAND'),(21,'6662','ALHOUMONT','HOUFFALIZE'),(22,'5550','ALLE','VRESSE-SUR-SEMOIS'),(23,'4432','ALLEUR','ANS'),(24,'4540','AMAY','AMAY'),(25,'6680','AMBERLOUP','SAINTE-ODE'),(26,'6953','AMBLY','NASSOGNE'),(27,'4219','AMBRESIN','WASSEIGES'),(28,'4770','AMEL / AMBLÈVE','AMEL / AMBLÈVE'),(29,'6997','AMONINES','ÉREZÉE'),(30,'7750','AMOUGIES','MONT-DE-L\'ENCLUS'),(31,'4540','AMPSIN','AMAY'),(32,'5300','ANDENNE','ANDENNE'),(33,'1070','ANDERLECHT','ANDERLECHT'),(34,'6150','ANDERLUES','ANDERLUES'),(35,'4140','ANDOUMONT','SPRIMONT'),(36,'5100','ANDOY','NAMUR'),(37,'4987','ANDRIMONT','STOUMONT'),(38,'4821','ANDRIMONT','DISON'),(39,'4000','ANGLEUR','LIÈGE'),(40,'7387','ANGRE','HONNELLES'),(41,'7387','ANGREAU','HONNELLES'),(42,'5537','ANHÉE','ANHÉE'),(43,'6721','ANLIER','HABAY'),(44,'6890','ANLOY','LIBIN'),(45,'5537','ANNEVOIE-ROUILLON','ANHÉE'),(46,'4430','ANS','ANS'),(47,'6730','ANSART','TINTIGNY'),(48,'5500','ANSEREMME','DINANT'),(49,'7750','ANSEROEUL','MONT-DE-L\'ENCLUS'),(50,'5520','ANTHÉE','ONHAYE'),(51,'4520','ANTHEIT','WANZE'),(52,'4160','ANTHISNES','ANTHISNES'),(53,'7640','ANTOING','ANTOING'),(54,'7910','ANVAING','FRASNES-LEZ-ANVAING'),(55,'7811','ARBRE','ATH'),(56,'5170','ARBRE','PROFONDEVILLE'),(57,'4990','ARBREFONTAINE','LIERNEUX'),(58,'7910','ARC','FRASNES-LEZ-ANVAING'),(59,'1390','ARCHENNES','GREZ-DOICEAU'),(60,'4601','ARGENTEAU','VISÉ'),(61,'4960','ARIMONT','MALMEDY'),(62,'6700','ARLON','ARLON'),(63,'7181','ARQUENNES','SENEFFE'),(64,'5060','ARSIMONT','SAMBREVILLE'),(65,'6870','ARVILLE','SAINT-HUBERT'),(66,'7040','ASQUILLIES','QUÉVY'),(67,'6860','ASSENOIS','LÉGLISE'),(68,'6640','ASSENOIS','VAUX-SUR-SÛRE'),(69,'5330','ASSESSE','ASSESSE'),(70,'4711','ASTENET','LONTZEN'),(71,'7800','ATH','ATH'),(72,'7387','ATHIS','HONNELLES'),(73,'6791','ATHUS','AUBANGE'),(74,'4560','ATRIN','CLAVIER'),(75,'6717','ATTERT','ATTERT'),(76,'7941','ATTRE','BRUGELETTE'),(77,'6790','AUBANGE','AUBANGE'),(78,'7972','AUBECHIES','BELOEIL'),(79,'4880','AUBEL','AUBEL'),(80,'5660','AUBLAIN','COUVIN'),(81,'6880','AUBY-SUR-SEMOIS','BERTRIX'),(82,'1160','AUDERGHEM','AUDERGHEM'),(83,'7382','AUDREGNIES','QUIÉVRAIN'),(84,'4790','AUEL','BURG-REULAND'),(85,'7040','AULNOIS','QUÉVY'),(86,'6706','AUTELBAS','ARLON'),(87,'6706','AUTELHAUT','ARLON'),(88,'1367','AUTRE-ÉGLISE','RAMILLIES'),(89,'7802','AUTREPPE','ATH'),(90,'7387','AUTREPPE','HONNELLES'),(91,'5060','AUVELAIS','SAMBREVILLE'),(92,'4480','AUX HOUX','ENGIS'),(93,'5580','AVE-ET-AUFFE','ROCHEFORT'),(94,'4260','AVENNES','BRAIVES'),(95,'4280','AVERNAS-LE-BAUDUIN','HANNUT'),(96,'4280','AVIN','HANNUT'),(97,'5501','AWAGNE','DINANT'),(98,'4920','AWAN','AYWAILLE'),(99,'4340','AWANS','AWANS'),(100,'6870','AWENNE','SAINT-HUBERT'),(101,'4400','AWIRS','FLÉMALLE'),(102,'6900','AYE','MARCHE-EN-FAMENNE'),(103,'4630','AYENEUX','SOUMAGNE'),(104,'4920','AYWAILLE','AYWAILLE'),(105,'6674','BACLAIN','GOUVY'),(106,'4837','BAELEN','BAELEN'),(107,'5550','BAGIMONT','VRESSE-SUR-SEMOIS'),(108,'6464','BAILEUX','CHIMAY'),(109,'6460','BAILIÈVRE','CHIMAY'),(110,'5555','BAILLAMONT','BIÈVRE'),(111,'7730','BAILLEUL','ESTAIMPUIS'),(112,'5377','BAILLONVILLE','SOMME-LEUZE'),(113,'7380','BAISIEUX','QUIÉVRAIN'),(114,'1470','BAISY-THY','GENAPPE'),(115,'5190','BALÂTRE','JEMEPPE-SUR-SAMBRE'),(116,'5070','BAMBOIS','FOSSES-LA-VILLE'),(117,'6951','BANDE','NASSOGNE'),(118,'4141','BANNEUX','SPRIMONT'),(119,'6500','BARBENÇON','BEAUMONT'),(120,'4670','BARCHON','BLEGNY'),(121,'5570','BARONVILLE','BEAURAING'),(122,'6971','BARRIÈRE DE CHAMPLON','TENNEVILLE'),(123,'7534','BARRY','TOURNAI'),(124,'5370','BÂRSY','HAVELANGE'),(125,'6940','BARVAUX','DURBUY'),(126,'5370','BARVAUX-CONDROZ','HAVELANGE'),(127,'6924','BARZIN','WELLIN'),(128,'7970','BASÈCLES','BELOEIL'),(129,'4520','BAS-OHA','WANZE'),(130,'4870','BASSE FRAIPONT','TROOZ'),(131,'4983','BASSE-BODEUX','TROIS-PONTS'),(132,'4690','BASSENGE','BASSENGE'),(133,'7830','BASSILLY','SILLY'),(134,'6600','BASTOGNE','BASTOGNE'),(135,'7784','BAS-WARNETON / NEERWAASTEN','COMINES-WARNETON / KOMEN-'),(136,'4651','BATTICE','HERVE'),(137,'7130','BATTIGNIES','BINCHE'),(138,'6792','BATTINCOURT','AUBANGE'),(139,'7331','BAUDOUR','SAINT-GHISLAIN'),(140,'7870','BAUFFE','LENS'),(141,'7604','BAUGNIES','PÉRUWELZ'),(142,'1401','BAULERS','NIVELLES'),(143,'4052','BEAUFAYS','CHAUDFONTAINE'),(144,'6500','BEAUMONT','BEAUMONT'),(145,'4970','BEAUMONT','STAVELOT'),(146,'5570','BEAURAING','BEAURAING'),(147,'1490','BEAURIEU','COURT-SAINT-ÉTIENNE'),(148,'6980','BEAUSAINT','LA ROCHE-EN-ARDENNE'),(149,'5170','BEAU-VALLON','PROFONDEVILLE'),(150,'1320','BEAUVECHAIN','BEAUVECHAIN'),(151,'6594','BEAUWELZ','MOMIGNIES'),(152,'6782','BÉBANGE','MESSANCY'),(153,'4910','BECCO','THEUX'),(154,'6690','BÊCHE','VIELSALM'),(155,'7532','BECLERS','TOURNAI'),(156,'5000','BEEZ','NAMUR'),(157,'6987','BEFFE','RENDEUX'),(158,'6120','BEGNEE','HAM-SUR-HEURE-NALINNES'),(159,'6860','BEHÊME','LÉGLISE'),(160,'6672','BEHO','GOUVY'),(161,'5001','BELGRADE','NAMUR'),(162,'4610','BELLAIRE','BEYNE-HEUSAY'),(163,'4570','BELLE MAISON','MARCHIN'),(164,'7170','BELLECOURT','MANAGE'),(165,'5555','BELLEFONTAINE','BIÈVRE'),(166,'6730','BELLEFONTAINE','TINTIGNY'),(167,'6830','BELLEVAUX','BOUILLON'),(168,'4960','BELLEVAUX','MALMEDY'),(169,'4830','BELLEVEAU','LIMBOURG'),(170,'7970','BELOEIL','BELOEIL'),(171,'5580','BELVAUX','ROCHEFORT'),(172,'4500','BEN','HUY'),(173,'6941','BENDE','DURBUY'),(174,'6600','BENONCHAMPS','BASTOGNE'),(175,'1082','BERCHEM-SAINTE-AGATHE','BERCHEM-SAINTE-AGATHE'),(176,'6642','BERCHEUX','VAUX-SUR-SÛRE'),(177,'4750','BERG','BÜTGENBACH / BUTGENBACH'),(178,'4980','BERGEVAL','TROIS-PONTS'),(179,'4360','BERGILERS','OREYE'),(180,'6982','BÉRISMÉNIL','LA ROCHE-EN-ARDENNE'),(181,'4257','BERLOZ','BERLOZ'),(182,'4607','BERNEAU','DALHEM'),(183,'6860','BERNIMONT','LÉGLISE'),(184,'6800','BERNÎMONT','LIBRAMONT-CHEVIGNY'),(185,'7320','BERNISSART','BERNISSART'),(186,'4960','BERNISTER','MALMEDY'),(187,'6560','BERSILLIES-L\'ABBAYE','ERQUELINNES'),(188,'4760','BERTERATH','BÜLLINGEN / BULLANGE'),(189,'6687','BERTOGNE','BERTOGNE'),(190,'4280','BERTRÉE','HANNUT'),(191,'6880','BERTRIX','BERTRIX'),(192,'5651','BERZÉE','WALCOURT'),(193,'5170','BESINE','PROFONDEVILLE'),(194,'7100','BESONRIEU','LA LOUVIÈRE'),(195,'6852','BETH','PALISEUL'),(196,'4300','BETTINCOURT','WAREMME'),(197,'5030','BEUZET','GEMBLOUX'),(198,'4960','BEVERCÉ','MALMEDY'),(199,'4610','BEYNE-HEUSAY','BEYNE-HEUSAY'),(200,'6543','BIENNE-LEZ-HAPPART','LOBBES'),(201,'6533','BIERCÉE','THUIN'),(202,'1301','BIERGES','WAVRE'),(203,'1430','BIERGHES','REBECQ'),(204,'4460','BIERSET','GRÂCE-HOLLOGNE'),(205,'5380','BIERWART','FERNELMONT'),(206,'5640','BIESME','METTET'),(207,'5640','BIESMERÉE','METTET'),(208,'6531','BIESME-SOUS-THUIN','THUIN'),(209,'5555','BIÈVRE','BIÈVRE'),(210,'1390','BIEZ','GREZ-DOICEAU'),(211,'6690','BIHAIN','VIELSALM'),(212,'4831','BILSTAIN','LIMBOURG'),(213,'7130','BINCHE','BINCHE'),(214,'5537','BIOUL','ANHÉE'),(215,'6997','BÎRON','ÉREZÉE'),(216,'5542','BLAIMONT','HASTIÈRE'),(217,'7522','BLANDAIN','TOURNAI'),(218,'1450','BLANMONT','CHASTRE'),(219,'7040','BLAREGNIES','QUÉVY'),(220,'7321','BLATON','BERNISSART'),(221,'7370','BLAUGIES','DOUR'),(222,'4670','BLEGNY','BLEGNY'),(223,'7620','BLÉHARIES','BRUNEHAUT'),(224,'4280','BLEHEN','HANNUT'),(225,'6760','BLEID','VIRTON'),(226,'4300','BLERET','WAREMME'),(227,'7903','BLICQUY','LEUZE-EN-HAINAUT'),(228,'6997','BLIER','ÉREZÉE'),(229,'6637','BODANGE','FAUVILLERS'),(230,'4537','BODÈGNÉE','VERLAINE'),(231,'4250','BOËLHE','GEER'),(232,'6662','BOEUR','HOUFFALIZE'),(233,'5550','BOHAN','VRESSE-SUR-SEMOIS'),(234,'5140','BOIGNÉE','SOMBREFFE'),(235,'4690','BOIRS','BASSENGE'),(236,'4560','BOIS','CLAVIER'),(237,'7866','BOIS-DE-LESSINES','LESSINES'),(238,'5170','BOIS-DE-VILLERS','PROFONDEVILLE'),(239,'7170','BOIS-D\'HAINE','MANAGE'),(240,'5310','BOLINNE','EGHEZÉE'),(241,'4653','BOLLAND','HERVE'),(242,'1367','BOMAL','RAMILLIES'),(243,'6941','BOMAL-SUR-OURTHE','DURBUY'),(244,'4607','BOMBAYE','DALHEM'),(245,'4100','BONCELLES','SERAING'),(246,'5310','BONEFFE','EGHEZÉE'),(247,'5021','BONINNE','NAMUR'),(248,'1325','BONLEZ','CHAUMONT-GISTOUX'),(249,'6700','BONNERT','ARLON'),(250,'6663','BONNERU','HOUFFALIZE'),(251,'6800','BONNERUE','LIBRAMONT-CHEVIGNY'),(252,'5300','BONNEVILLE','ANDENNE'),(253,'7603','BON-SECOURS','PÉRUWELZ'),(254,'5377','BONSIN','SOMME-LEUZE'),(255,'4987','BORGOUMONT','STOUMONT'),(256,'4317','BORLEZ','FAIMES'),(257,'6941','BORLON','DURBUY'),(258,'4770','BORN','AMEL / AMBLÈVE'),(259,'1404','BORNIVAL','NIVELLES'),(260,'4560','BORSU','CLAVIER'),(261,'6980','BORZÉE','LA ROCHE-EN-ARDENNE'),(262,'4950','BÔSFAGNE','WAIMES / WEISMES'),(263,'5640','BOSSIÈRE','METTET'),(264,'5032','BOSSIÈRE','GEMBLOUX'),(265,'1390','BOSSUT-GOTTECHAIN','GREZ-DOICEAU'),(266,'6833','BOTASSART','BOUILLON'),(267,'5032','BOTHEY','GEMBLOUX'),(268,'6200','BOUFFIOULX','CHÂTELET'),(269,'5004','BOUGE','NAMUR'),(270,'7040','BOUGNIES','QUÉVY'),(271,'6800','BOUGNIMONT','LIBRAMONT-CHEVIGNY'),(272,'6830','BOUILLON','BOUILLON'),(273,'6600','BOURCY','BASTOGNE'),(274,'6990','BOURDON','HOTTON'),(275,'6464','BOURLERS','CHIMAY'),(276,'5575','BOURSEIGNE-NEUVE','GEDINNE'),(277,'5575','BOURSEIGNE-VIEILLE','GEDINNE'),(278,'7110','BOUSSOIT','LA LOUVIÈRE'),(279,'7300','BOUSSU','BOUSSU'),(280,'7300','BOUSSU-BOIS','BOUSSU'),(281,'5660','BOUSSU-EN-FAGNE','COUVIN'),(282,'6440','BOUSSU-LEZ-WALCOURT','FROIDCHAPELLE'),(283,'1470','BOUSVAL','GENAPPE'),(284,'6464','BOUTONVILLE','CHIMAY'),(285,'5500','BOUVIGNES-SUR-MEUSE','DINANT'),(286,'7803','BOUVIGNIES','ATH'),(287,'4300','BOVENISTIER','WAREMME'),(288,'5081','BOVESSE','LA BRUYÈRE'),(289,'6671','BOVIGNY','GOUVY'),(290,'4990','BRA','LIERNEUX'),(291,'4790','BRACHT','BURG-REULAND'),(292,'7604','BRAFFE','PÉRUWELZ'),(293,'5590','BRAIBANT','CINEY'),(294,'1420','BRAINE-L\'ALLEUD','BRAINE-L\'ALLEUD'),(295,'1440','BRAINE-LE-CHÂTEAU','BRAINE-LE-CHÂTEAU'),(296,'7090','BRAINE-LE-COMTE','BRAINE-LE-COMTE'),(297,'4260','BRAIVES','BRAIVES'),(298,'5310','BRANCHON','EGHEZÉE'),(299,'6800','BRAS','LIBRAMONT-CHEVIGNY'),(300,'6600','BRAS','BASTOGNE'),(301,'7604','BRASMENIL','PÉRUWELZ'),(302,'4791','BRAUNLAUF','BURG-REULAND'),(303,'7130','BRAY','BINCHE'),(304,'4020','BRESSOUX','LIÈGE'),(305,'6730','BREUVANE','TINTIGNY'),(306,'6673','BRISY','GOUVY'),(307,'4750','BRÜCKBERG','BÜTGENBACH / BUTGENBACH'),(308,'7940','BRUGELETTE','BRUGELETTE'),(309,'5660','BRÜLY','COUVIN'),(310,'5660','BRÛLY-DE-PESCHE','COUVIN'),(311,'4980','BRUME','TROIS-PONTS'),(312,'1000','BRUXELLES','BRUXELLES'),(313,'7641','BRUYELLE','ANTOING'),(314,'7050','BRUYÈRE DINCQ','JURBISE'),(315,'4950','BRUYÈRES','WAIMES / WEISMES'),(316,'6222','BRYE','FLEURUS'),(317,'4760','BUCHHOLZ','BÜLLINGEN / BULLANGE'),(318,'7911','BUISSENAL','FRASNES-LEZ-ANVAING'),(319,'6983','BUISSON','LA ROCHE-EN-ARDENNE'),(320,'5580','BUISSONVILLE','ROCHEFORT'),(321,'4760','BÜLLINGEN / BULLANGE','BÜLLINGEN / BULLANGE'),(322,'4210','BURDINNE','BURDINNE'),(323,'6927','BURE','TELLIN'),(324,'6662','BURET','HOUFFALIZE'),(325,'4960','BURNENVILLE','MALMEDY'),(326,'6637','BURNON','FAUVILLERS'),(327,'6690','BURTONVILLE','VIELSALM'),(328,'7602','BURY','PÉRUWELZ'),(329,'4710','BUSCH','LONTZEN'),(330,'4750','BÜTGENBACH / BUTGENBACH','BÜTGENBACH / BUTGENBACH'),(331,'7133','BUVRINNES','BINCHE'),(332,'6743','BUZENOL','ETALLE'),(333,'6230','BUZET','PONT-À-CELLES'),(334,'5150','BÛZET','FLOREFFE'),(335,'7604','CALLENELLE','PÉRUWELZ'),(336,'7642','CALONNE','ANTOING'),(337,'7940','CAMBRON-CASTEAU','BRUGELETTE'),(338,'7870','CAMBRON-SAINT-VINCENT','LENS'),(339,'6850','CARLSBOURG','PALISEUL'),(340,'7141','CARNIÈRES','MORLANWELZ'),(341,'7061','CASTEAU','SOIGNIES'),(342,'5650','CASTILLON','WALCOURT'),(343,'7760','CELLES','CELLES'),(344,'4317','CELLES','FAIMES'),(345,'5561','CELLES','HOUYET'),(346,'4632','CEREXHE-HEUSEUX','SOUMAGNE'),(347,'5630','CERFONTAINE','CERFONTAINE'),(348,'1341','CÉROUX-MOUSTY','OTTIGNIES-LOUVAIN-LA-NEUV'),(349,'6662','CÈTURU','HOUFFALIZE'),(350,'6661','CHÂBREHÉ','HOUFFALIZE'),(351,'4650','CHAINEUX','HERVE'),(352,'5550','CHAIRIÈRE','VRESSE-SUR-SEMOIS'),(353,'6200','CHAMBORGNEAU','CHÂTELET'),(354,'4950','CHAMPAGNE','WAIMES / WEISMES'),(355,'6960','CHAMP-DE-HARRE','MANHAY'),(356,'5004','CHAMPION','NAMUR'),(357,'6971','CHAMPLON','TENNEVILLE'),(358,'6900','CHAMPLON-FAMENNE','MARCHE-EN-FAMENNE'),(359,'6688','CHAMPS','BERTOGNE'),(360,'6921','CHANLY','WELLIN'),(361,'6742','CHANTEMELLE','ETALLE'),(362,'4140','CHANXHE','SPRIMONT'),(363,'7903','CHAPELLE-À-OIE','LEUZE-EN-HAINAUT'),(364,'7903','CHAPELLE-À-WATTINES','LEUZE-EN-HAINAUT'),(365,'7160','CHAPELLE-LEZ-HERLAIMONT','CHAPELLE-LEZ-HERLAIMONT'),(366,'5590','CHAPOIS','CINEY'),(367,'4537','CHAPON-SERAING','VERLAINE'),(368,'5377','CHARDENEU','SOMME-LEUZE'),(369,'6000','CHARLEROI','CHARLEROI'),(370,'6950','CHARNEU','NASSOGNE'),(371,'4654','CHARNEUX','HERVE'),(372,'4845','CHARNEUX','JALHAY'),(373,'6824','CHASSEPIERRE','FLORENVILLE'),(374,'1450','CHASTRE','CHASTRE'),(375,'5650','CHASTRÈS','WALCOURT'),(376,'6200','CHÂTELET','CHÂTELET'),(377,'6200','CHÂTELINEAU','CHÂTELET'),(378,'6747','CHÂTILLON','SAINT-LÉGER'),(379,'4050','CHAUDFONTAINE','CHAUDFONTAINE'),(380,'1325','CHAUMONT','CHAUMONT-GISTOUX'),(381,'6640','CHAUMONT','VAUX-SUR-SÛRE'),(382,'5620','CHAUMONT','FLORENNES'),(383,'7063','CHAUSSÉE-NOTRE-DAME','SOIGNIES'),(384,'4987','CHAUVEHEID','STOUMONT'),(385,'4671','CHEFNEUX','BLEGNY'),(386,'6860','CHÊNE','LÉGLISE'),(387,'6960','CHÊNE AL PIERRE','MANHAY'),(388,'4032','CHÊNÉE','LIÈGE'),(389,'4606','CHENESTRE','DALHEM'),(390,'6800','CHÊNET','LIBRAMONT-CHEVIGNY'),(391,'4987','CHENEUX','STOUMONT'),(392,'6640','CHENOGNE','VAUX-SUR-SÛRE'),(393,'6761','CHENOI','VIRTON'),(394,'6987','CHÉOUX','RENDEUX'),(395,'6673','CHERAIN','GOUVY'),(396,'4602','CHERATTE','VISÉ'),(397,'7521','CHERCQ','TOURNAI'),(398,'4987','CHESSION','STOUMONT'),(399,'5590','CHEVETOGNE','CINEY'),(400,'4987','CHEVRON','STOUMONT'),(401,'7950','CHIÈVRES','CHIÈVRES'),(402,'6460','CHIMAY','CHIMAY'),(403,'6810','CHINY','CHINY'),(404,'4960','CHÔDES','MALMEDY'),(405,'4400','CHOKIER','FLÉMALLE'),(406,'6980','CIELLE','LA ROCHE-EN-ARDENNE'),(407,'5560','CIERGNON','HOUYET'),(408,'6671','CIERREUX','GOUVY'),(409,'5590','CINEY','CINEY'),(410,'4260','CIPLET','BRAIVES'),(411,'7022','CIPLY','MONS'),(412,'7130','CITÉ DES CHARBONNAGES','BINCHE'),(413,'7134','CITÉ REINE ELISABETH','BINCHE'),(414,'1480','CLABECQ','TUBIZE'),(415,'4560','CLAVIER','CLAVIER'),(416,'4560','CLAVIER-STATION','CLAVIER'),(417,'6997','CLERHÉ','ÉREZÉE'),(418,'4890','CLERMONT','THIMISTER-CLERMONT'),(419,'5650','CLERMONT','WALCOURT'),(420,'4480','CLERMONT-SOUS-HUY','ENGIS'),(421,'6640','COBRÊVILLE','VAUX-SUR-SÛRE'),(422,'6600','COBRU','BASTOGNE'),(423,'5022','COGNELÉE','NAMUR'),(424,'4845','COKAIFAGNE','JALHAY'),(425,'4170','COMBLAIN-AU-PONT','COMBLAIN-AU-PONT'),(426,'4180','COMBLAIN-FAIRON','HAMOIR'),(427,'4180','COMBLAIN-LA-TOUR','HAMOIR'),(428,'7780','COMINES / KOMEN','COMINES-WARNETON / KOMEN-'),(429,'6690','COMMANSTER','VIELSALM'),(430,'6687','COMPOGNE','BERTOGNE'),(431,'5590','CONNEUX','CINEY'),(432,'4970','COO','STAVELOT'),(433,'1435','CORBAIS','MONT-SAINT-GUIBERT'),(434,'6838','CORBION','BOUILLON'),(435,'5590','CORBION','CINEY'),(436,'7910','CORDES','FRASNES-LEZ-ANVAING'),(437,'5620','CORENNE','FLORENNES'),(438,'4141','CORNÉMONT','SPRIMONT'),(439,'4860','CORNESSE','PEPINSTER'),(440,'5555','CORNIMONT','BIÈVRE'),(441,'5032','CORROY-LE-CHÂTEAU','GEMBLOUX'),(442,'1325','CORROY-LE-GRAND','CHAUMONT-GISTOUX'),(443,'1450','CORSAL','CHASTRE'),(444,'4257','CORSWAREM','BERLOZ'),(445,'1450','CORTIL-NOIRMONT','CHASTRE'),(446,'5380','CORTIL-WODON','FERNELMONT'),(447,'6010','COUILLET','CHARLEROI'),(448,'4987','COUR','STOUMONT'),(449,'6180','COURCELLES','COURCELLES'),(450,'5336','COURRIÈRE','ASSESSE'),(451,'6120','COUR-SUR-HEURE','HAM-SUR-HEURE-NALINNES'),(452,'6671','COURTIL','GOUVY'),(453,'1490','COURT-SAINT-ÉTIENNE','COURT-SAINT-ÉTIENNE'),(454,'6840','COUSTEUMONT','NEUFCHÂTEAU'),(455,'4218','COUTHUIN','HÉRON'),(456,'5300','COUTISSE','ANDENNE'),(457,'1380','COUTURE-SAINT-GERMAIN','LASNE'),(458,'5660','COUVIN','COUVIN'),(459,'6767','COUVREU','ROUVROY'),(460,'4280','CRAS-AVERNAS','HANNUT'),(461,'4280','CREHEN','HANNUT'),(462,'4900','CREPPE','SPA'),(463,'4367','CRISNÉE','CRISNÉE'),(464,'5650','CROIX MARTIN','WALCOURT'),(465,'7120','CROIX-LEZ-ROUVEROY','ESTINNES'),(466,'4784','CROMBACH','SANKT-VITH / SAINT-VITH'),(467,'5332','CRUPET','ASSESSE'),(468,'7033','CUESMES','MONS'),(469,'6880','CUGNON','BERTRIX'),(470,'5660','CUL-DES-SARTS','COUVIN'),(471,'6832','CURFOZ','BOUILLON'),(472,'5562','CUSTINNE','HOUYET'),(473,'4950','CWÈNE DE BWÈS','WAIMES / WEISMES'),(474,'5660','DAILLY','COUVIN'),(475,'4607','DALHEM','DALHEM'),(476,'6767','DAMPICOURT','ROUVROY'),(477,'6020','DAMPREMY','CHARLEROI'),(478,'4253','DARION','GEER'),(479,'5630','DAUSSOIS','CERFONTAINE'),(480,'5020','DAUSSOULX','NAMUR'),(481,'5100','DAVE','NAMUR'),(482,'6929','DAVERDISSE','DAVERDISSE'),(483,'4770','DEIDENBERG','AMEL / AMBLÈVE'),(484,'6672','DEIFFELT','GOUVY'),(485,'4920','DEIGNÉ','AYWAILLE'),(486,'5537','DENÉE','ANHÉE'),(487,'7912','DERGNEAU','FRASNES-LEZ-ANVAING'),(488,'4910','DESNIÉ','THEUX'),(489,'6990','DEÛLIN','HOTTON'),(490,'7864','DEUX-ACREN','LESSINES'),(491,'5640','DEVANT LES BOIS','METTET'),(492,'6987','DEVANTAVE','RENDEUX'),(493,'5310','DHUY','EGHEZÉE'),(494,'5500','DINANT','DINANT'),(495,'6661','DINEZ','HOUFFALIZE'),(496,'5570','DION','BEAURAING'),(497,'1325','DION-LE-MONT','CHAUMONT-GISTOUX'),(498,'1325','DION-LE-VAL','CHAUMONT-GISTOUX'),(499,'4820','DISON','DISON'),(500,'6960','DOCHAMPS','MANHAY'),(501,'6836','DOHAN','BOUILLON'),(502,'1390','DOICEAU','GREZ-DOICEAU'),(503,'5680','DOISCHE','DOISCHE'),(504,'4140','DOLEMBREUX','SPRIMONT'),(505,'4830','DOLHAIN','LIMBOURG'),(506,'4470','DOMMARTIN','SAINT-GEORGES-SUR-MEUSE'),(507,'4357','DONCEEL','DONCEEL'),(508,'1370','DONGELBERG','JODOIGNE'),(509,'6536','DONSTIENNES','THUIN'),(510,'5530','DORINNE','YVOIR'),(511,'7711','DOTTIGNIES / DOTTENIJS','MOUSCRON / MOESKROEN'),(512,'7370','DOUR','DOUR'),(513,'5670','DOURBES','VIROINVAL'),(514,'7331','DOUVRAIN','SAINT-GHISLAIN'),(515,'5500','DRÉHANCE','DINANT'),(516,'4860','DROLENVAL','PEPINSTER'),(517,'6940','DURBUY','DURBUY'),(518,'4790','DÜRLER','BURG-REULAND'),(519,'5530','DURNAL','YVOIR'),(520,'4690','EBEN-EMAEL','BASSENGE'),(521,'6860','EBLY','LÉGLISE'),(522,'7190','ECAUSSINNES-D\'ENGHIEN','ECAUSSINNES'),(523,'7190','ECAUSSINNES-LALAING','ECAUSSINNES'),(524,'5310','EGHEZÉE','EGHEZÉE'),(525,'4120','EHEIN','NEUPRÉ'),(526,'4770','EIBERTINGEN','AMEL / AMBLÈVE'),(527,'4760','EIMERSCHEID','BÜLLINGEN / BULLANGE'),(528,'4590','ELLEMELLE','OUFFET'),(529,'7890','ELLEZELLES','ELLEZELLES'),(530,'7910','ELLIGNIES-LEZ-FRASNES','FRASNES-LEZ-ANVAING'),(531,'7972','ELLIGNIES-SAINTE-ANNE','BELOEIL'),(532,'7370','ELOUGES','DOUR'),(533,'4890','ELSAUTE','THIMISTER-CLERMONT'),(534,'4750','ELSENBORN','BÜTGENBACH / BUTGENBACH'),(535,'4053','EMBOURG','CHAUDFONTAINE'),(536,'5080','ÉMINES','LA BRUYÈRE'),(537,'5363','EMPTINNE','HAMOIS'),(538,'7850','ENGHIEN / EDINGEN','ENGHIEN / EDINGEN'),(539,'4480','ENGIS','ENGIS'),(540,'6663','ENGREUX','HOUFFALIZE'),(541,'5590','ENHET','CINEY'),(542,'1350','ENINES','ORP-JAUCHE'),(543,'6698','ENNAL','VIELSALM'),(544,'4800','ENSIVAL','VERVIERS'),(545,'7134','ÉPINOIS','BINCHE'),(546,'5580','EPRAVE','ROCHEFORT'),(547,'7050','ERBAUT','JURBISE'),(548,'7050','ERBISOEUL','JURBISE'),(549,'7500','ERE','TOURNAI'),(550,'6997','ÉREZÉE','ÉREZÉE'),(551,'5644','ERMETON-SUR-BIERT','METTET'),(552,'5030','ERNAGE','GEMBLOUX'),(553,'6972','ERNEUVILLE','TENNEVILLE'),(554,'4920','ERNONHEID','AYWAILLE'),(555,'5101','ERPENT','NAMUR'),(556,'6997','ERPIGNY','ÉREZÉE'),(557,'6441','ERPION','FROIDCHAPELLE'),(558,'6560','ERQUELINNES','ERQUELINNES'),(559,'7387','ERQUENNES','HONNELLES'),(560,'7760','ESCANAFFLES','CELLES'),(561,'4130','ESNEUX','ESNEUX'),(562,'4791','ESPELER','BURG-REULAND'),(563,'7502','ESPLECHIN','TOURNAI'),(564,'7743','ESQUELMES','PECQ'),(565,'7730','ESTAIMBOURG','ESTAIMPUIS'),(566,'7730','ESTAIMPUIS','ESTAIMPUIS'),(567,'7120','ESTINNES-AU-MONT','ESTINNES'),(568,'7120','ESTINNES-AU-VAL','ESTINNES'),(569,'6740','ETALLE','ETALLE'),(570,'6760','ETHE','VIRTON'),(571,'1040','ETTERBEEK','ETTERBEEK'),(572,'7080','EUGIES','FRAMERIES'),(573,'4700','EUPEN','EUPEN'),(574,'4631','ÉVEGNÉE-TIGNÉE','SOUMAGNE'),(575,'5350','EVELETTE','OHEY'),(576,'1140','EVERE','EVERE'),(577,'4130','EVIEU','ESNEUX'),(578,'7730','EVREGNIES','ESTAIMPUIS'),(579,'5530','EVREHAILLES','YVOIR'),(580,'4987','EXBOMONT','STOUMONT'),(581,'4730','EYNATTEN','RAEREN'),(582,'4731','EYNATTERHEIDE','RAEREN'),(583,'5600','FAGNOLLE','PHILIPPEVILLE'),(584,'5370','FAILON','HAVELANGE'),(585,'4317','FAIMES','FAIMES'),(586,'5522','FALAËN','ONHAYE'),(587,'5060','FALISOLLE','SAMBREVILLE'),(588,'4260','FALLAIS','BRAIVES'),(589,'5500','FALMAGNE','DINANT'),(590,'5500','FALMIGNOUL','DINANT'),(591,'7181','FAMILLEUREUX','SENEFFE'),(592,'6997','FANZEL','ÉREZÉE'),(593,'6240','FARCIENNES','FARCIENNES'),(594,'5340','FAULX-LES-TOMBES','GESVES'),(595,'7120','FAUROEULX','ESTINNES'),(596,'6637','FAUVILLERS','FAUVILLERS'),(597,'1490','FAUX','COURT-SAINT-ÉTIENNE'),(598,'4950','FAYMONVILLE','WAIMES / WEISMES'),(599,'4910','FAYS','THEUX'),(600,'6920','FAYS FAMENNE','WELLIN'),(601,'6856','FAYS-LES-VENEURS','PALISEUL'),(602,'7387','FAYT-LE-FRANC','HONNELLES'),(603,'7170','FAYT-LEZ-MANAGE','MANAGE'),(604,'5570','FELENNE','BEAURAING'),(605,'7181','FELUY','SENEFFE'),(606,'4607','FENEUR','DALHEM'),(607,'4190','FERRIÈRES','FERRIÈRES'),(608,'5570','FESCHAUX','BEAURAING'),(609,'4347','FEXHE-LE-HAUT-CLOCHER','FEXHE-LE-HAUT-CLOCHER'),(610,'4458','FEXHE-SLINS','JUPRELLE'),(611,'4181','FILOT','HAMOIR'),(612,'6840','FINEUSE','NEUFCHÂTEAU'),(613,'5560','FINNEVAUX','HOUYET'),(614,'6997','FISENNE','ÉREZÉE'),(615,'4530','FIZE-FONTAINE','VILLERS-LE-BOUILLET'),(616,'4367','FIZE-LE-MARSAL','CRISNÉE'),(617,'6686','FLAMIERGE','BERTOGNE'),(618,'6688','FLAMISOUL','BERTOGNE'),(619,'5620','FLAVION','FLORENNES'),(620,'5020','FLAWINNE','NAMUR'),(621,'4400','FLÉMALLE','FLÉMALLE'),(622,'4400','FLÉMALLE-GRANDE','FLÉMALLE'),(623,'4400','FLÉMALLE-HAUTE','FLÉMALLE'),(624,'7011','FLÉNU','MONS'),(625,'4620','FLÉRON','FLÉRON'),(626,'6220','FLEURUS','FLEURUS'),(627,'7880','FLOBECQ / VLOESBERG','FLOBECQ / VLOESBERG'),(628,'6800','FLOHIMONT','LIBRAMONT-CHEVIGNY'),(629,'4540','FLÔNE','AMAY'),(630,'5334','FLORÉE','ASSESSE'),(631,'5150','FLOREFFE','FLOREFFE'),(632,'5620','FLORENNES','FLORENNES'),(633,'6820','FLORENVILLE','FLORENVILLE'),(634,'5150','FLORIFFOUX','FLOREFFE'),(635,'4140','FLORZE','SPRIMONT'),(636,'5370','FLOSTOY','HAVELANGE'),(637,'5572','FOCANT','BEAURAING'),(638,'1350','FOLX-LES-CAVES','ORP-JAUCHE'),(639,'6140','FONTAINE-L\'ÉVÊQUE','FONTAINE-L\'ÉVÊQUE'),(640,'6567','FONTAINE-VALMONT','MERBES-LE-CHÂTEAU'),(641,'6661','FONTENAILLE','HOUFFALIZE'),(642,'5650','FONTENELLE','WALCOURT'),(643,'6820','FONTENOILLE','FLORENVILLE'),(644,'7643','FONTENOY','ANTOING'),(645,'4130','FONTIN-LA-HÂZE','ESNEUX'),(646,'4340','FOOZ','AWANS'),(647,'6141','FORCHIES-LA-MARCHE','FONTAINE-L\'ÉVÊQUE'),(648,'7910','FOREST','FRASNES-LEZ-ANVAING'),(649,'1190','FOREST','FOREST'),(650,'4870','FORÊT','TROOZ'),(651,'6596','FORGE-PHILIPPE','MOMIGNIES'),(652,'6464','FORGES','CHIMAY'),(653,'6953','FORRIÈRES','NASSOGNE'),(654,'5380','FORVILLE','FERNELMONT'),(655,'5580','FORZÉE','ROCHEFORT'),(656,'4980','FOSSE','TROIS-PONTS'),(657,'5070','FOSSES-LA-VILLE','FOSSES-LA-VILLE'),(658,'6700','FOUCHES','ARLON'),(659,'7830','FOULENG','SILLY'),(660,'6440','FOURBECHIES','FROIDCHAPELLE'),(661,'4570','FOURNEAU','MARCHIN'),(662,'6600','FOY','BASTOGNE'),(663,'4845','FOYEURU','JALHAY'),(664,'5504','FOY-NOTRE-DAME','DINANT'),(665,'6830','FRAHAN','BOUILLON'),(666,'4550','FRAINEUX','NANDRIN'),(667,'4870','FRAIPONT','TROOZ'),(668,'5650','FRAIRE','WALCOURT'),(669,'4140','FRAITURE','SPRIMONT'),(670,'4557','FRAITURE','TINLOT'),(671,'6690','FRAITURE','VIELSALM'),(672,'7080','FRAMERIES','FRAMERIES'),(673,'6853','FRAMONT','PALISEUL'),(674,'4970','FRANCHEVILLE','STAVELOT'),(675,'5600','FRANCHIMONT','PHILIPPEVILLE'),(676,'4970','FRANCORCHAMPS','STAVELOT'),(677,'5380','FRANC-WARET','FERNELMONT'),(678,'5150','FRANIÈRE','FLOREFFE'),(679,'5660','FRASNES','COUVIN'),(680,'7910','FRASNES-LEZ-BUISSENAL','FRASNES-LEZ-ANVAING'),(681,'6210','FRASNES-LEZ-GOSSELIES','LES BONS VILLERS'),(682,'6740','FRATIN','ETALLE'),(683,'4347','FRELOUX','FEXHE-LE-HAUT-CLOCHER'),(684,'6852','FRÊNE','PALISEUL'),(685,'6813','FRENOIS','CHINY'),(686,'6800','FREUX','LIBRAMONT-CHEVIGNY'),(687,'6800','FREUX SUZERAIN','LIBRAMONT-CHEVIGNY'),(688,'6800','FREUX-MÈNIL','LIBRAMONT-CHEVIGNY'),(689,'6700','FREYLANGE','ARLON'),(690,'6960','FREYNEUX','MANHAY'),(691,'6440','FROIDCHAPELLE','FROIDCHAPELLE'),(692,'5576','FROIDFONTAINE','BEAURAING'),(693,'6920','FROIDLIEU','WELLIN'),(694,'7504','FROIDMONT','TOURNAI'),(695,'5190','FROIDMONT','JEMEPPE-SUR-SAMBRE'),(696,'4890','FROIDTHIER','THIMISTER-CLERMONT'),(697,'4987','FROIDVILLE','STOUMONT'),(698,'6280','FROMIÉE','GERPINNES'),(699,'6990','FRONVILLE','HOTTON'),(700,'7503','FROYENNES','TOURNAI'),(701,'4260','FUMAL','BRAIVES'),(702,'5500','FURFOOZ','DINANT'),(703,'5641','FURNAUX','METTET'),(704,'7943','GAGES','BRUGELETTE'),(705,'7906','GALLAIX','LEUZE-EN-HAINAUT'),(706,'1083','GANSHOREN','GANSHOREN'),(707,'7530','GAURAIN-RAMECROIX','TOURNAI'),(708,'5575','GEDINNE','GEDINNE'),(709,'4250','GEER','GEER'),(710,'1367','GEEST-GEROMPONT-PETIT-ROSIÈRE','RAMILLIES'),(711,'5024','GELBRESSÉE','NAMUR'),(712,'6929','GEMBES','DAVERDISSE'),(713,'5030','GEMBLOUX','GEMBLOUX'),(714,'5500','GÈMECHÈNE','DINANT'),(715,'4851','GEMMENICH','PLOMBIÈRES'),(716,'1470','GENAPPE','GENAPPE'),(717,'5561','GENDRON','HOUYET'),(718,'6987','GÊNES','RENDEUX'),(719,'7040','GENLY','QUÉVY'),(720,'6860','GENNEVAUX','LÉGLISE'),(721,'6750','GENNEVAUX','MUSSON'),(722,'1450','GENTINNES','CHASTRE'),(723,'1332','GENVAL','RIXENSART'),(724,'6680','GÉRIMONT','SAINTE-ODE'),(725,'5524','GERIN','ONHAYE'),(726,'6769','GÉROUVILLE','MEIX-DEVANT-VIRTON'),(727,'6280','GERPINNES','GERPINNES'),(728,'5340','GESVES','GESVES'),(729,'7021','GHISLAGE','MONS'),(730,'7822','GHISLENGHIEN','ATH'),(731,'7011','GHLIN','MONS'),(732,'7863','GHOY','LESSINES'),(733,'7823','GIBECQ','ATH'),(734,'6060','GILLY','CHARLEROI'),(735,'5680','GIMNÉE','DOISCHE'),(736,'1325','GISTOUX','CHAUMONT-GISTOUX'),(737,'4500','GIVES','HUY'),(738,'6686','GIVRI','BERTOGNE'),(739,'6686','GIVROULLE','BERTOGNE'),(740,'7041','GIVRY','QUÉVY'),(741,'1473','GLABAIS','GENAPPE'),(742,'4000','GLAIN','LIÈGE'),(743,'6890','GLAIREUSE','LIBIN'),(744,'4400','GLEIXHE','FLÉMALLE'),(745,'1315','GLIMES','INCOURT'),(746,'4690','GLONS','BASSENGE'),(747,'5680','GOCHENÉE','DOISCHE'),(748,'7160','GODARVILLE','CHAPELLE-LEZ-HERLAIMONT'),(749,'5530','GODINNE','YVOIR'),(750,'4834','GOÉ','LIMBOURG'),(751,'7040','GOEGNIES-CHAUSSÉE','QUÉVY'),(752,'5353','GOESNES','OHEY'),(753,'4860','GOFFONTAINE','PEPINSTER'),(754,'4960','GOHIMONT','MALMEDY'),(755,'6760','GOMERY','VIRTON'),(756,'4140','GOMZÉ','SPRIMONT'),(757,'7830','GONDREGNIES','SILLY'),(758,'5660','GONRIEUX','COUVIN'),(759,'6041','GOSSELIES','CHARLEROI'),(760,'7070','GOTTIGNIES','LE ROEULX'),(761,'6280','GOUGNIES','GERPINNES'),(762,'5651','GOURDINNE','WALCOURT'),(763,'6030','GOUTROUX','CHARLEROI'),(764,'6670','GOUVY','GOUVY'),(765,'6181','GOUY-LEZ-PIÉTON','COURCELLES'),(766,'6534','GOZÉE','THUIN'),(767,'4460','GRÂCE-BERLEUR','GRÂCE-HOLLOGNE'),(768,'4460','GRÂCE-HOLLOGNE','GRÂCE-HOLLOGNE'),(769,'5555','GRAIDE','BIÈVRE'),(770,'7890','GRAND MONCHAUT','ELLEZELLES'),(771,'4300','GRAND-AXHE','WAREMME'),(772,'6760','GRANDCOURT','VIRTON'),(773,'7973','GRANDGLISE','BELOEIL'),(774,'4280','GRAND-HALLET','HANNUT'),(775,'6698','GRAND-HALLEUX','VIELSALM'),(776,'6940','GRANDHAN','DURBUY'),(777,'5031','GRAND-LEEZ','GEMBLOUX'),(778,'5030','GRAND-MANIL','GEMBLOUX'),(779,'6960','GRANDMENIL','MANHAY'),(780,'7900','GRANDMETZ','LEUZE-EN-HAINAUT'),(781,'4650','GRAND-RECHAIN','HERVE'),(782,'6560','GRAND-RENG','ERQUELINNES'),(783,'6470','GRANDRIEU','SIVRY-RANCE'),(784,'1367','GRAND-ROSIÈRE-HOTTOMONT','RAMILLIES'),(785,'6640','GRANDRU','VAUX-SUR-SÛRE'),(786,'7141','GRANDS TRIEUX','MORLANWELZ'),(787,'4360','GRAND-VILLE','OREYE'),(788,'6840','GRANDVOIR','NEUFCHÂTEAU'),(789,'6840','GRAPFONTAINE','NEUFCHÂTEAU'),(790,'7830','GRATY','SILLY'),(791,'5640','GRAUX','METTET'),(792,'6717','GRENDEL','ATTERT'),(793,'1390','GREZ-DOICEAU','GREZ-DOICEAU'),(794,'6887','GRIBÔMONT','HERBEUMONT'),(795,'6900','GRIMBIÉMONT','MARCHE-EN-FAMENNE'),(796,'4030','GRIVEGNÉE','LIÈGE'),(797,'7950','GROSAGE','CHIÈVRES'),(798,'5555','GROS-FAYS','BIÈVRE'),(799,'4791','GRÜFFLINGEN','BURG-REULAND'),(800,'6952','GRUNE','NASSOGNE'),(801,'6927','GRUPONT','TELLIN'),(802,'6782','GUELFF','MESSANCY'),(803,'4950','GUEUZAINE','WAIMES / WEISMES'),(804,'7620','GUIGNIES','BRUNEHAUT'),(805,'6704','GUIRSCH','ARLON'),(806,'6860','HABARU','LÉGLISE'),(807,'6720','HABAY-LA-NEUVE','HABAY'),(808,'6723','HABAY-LA-VIEILLE','HABAY'),(809,'6782','HABERGY','MESSANCY'),(810,'4987','HABIÉMONT','STOUMONT'),(811,'4684','HACCOURT','OUPEYE'),(812,'6720','HACHY','HABAY'),(813,'7911','HACQUEGNIES','FRASNES-LEZ-ANVAING'),(814,'7100','HAIE DU ROEULX','LA LOUVIÈRE'),(815,'5351','HAILLOT','OHEY'),(816,'7100','HAINE-SAINT-PAUL','LA LOUVIÈRE'),(817,'7100','HAINE-SAINT-PIERRE','LA LOUVIÈRE'),(818,'7350','HAININ','HENSIES'),(819,'6792','HALANZY','AUBANGE'),(820,'4530','HALBÔSSART','VILLERS-LE-BOUILLET'),(821,'6671','HALCONREUX','GOUVY'),(822,'4684','HALEMBAYE','OUPEYE'),(823,'6986','HALLEUX','LA ROCHE-EN-ARDENNE'),(824,'6922','HALMA','WELLIN'),(825,'5590','HALOI','CINEY'),(826,'5340','HALTINNE','GESVES'),(827,'6840','HAMIPRÉ','NEUFCHÂTEAU'),(828,'1320','HAMME-MILLE','BEAUVECHAIN'),(829,'4180','HAMOIR','HAMOIR'),(830,'5360','HAMOIS','HAMOIS'),(831,'6990','HAMPTEAU','HOTTON'),(832,'6120','HAM-SUR-HEURE','HAM-SUR-HEURE-NALINNES'),(833,'5190','HAM-SUR-SAMBRE','JEMEPPE-SUR-SAMBRE'),(834,'6730','HAN','TINTIGNY'),(835,'4357','HANEFFE','DONCEEL'),(836,'4210','HANNÊCHE','BURDINNE'),(837,'1380','HANNONSART','LASNE'),(838,'4280','HANNUT','HANNUT'),(839,'5310','HANRET','EGHEZÉE'),(840,'5580','HAN-SUR-LESSE','ROCHEFORT'),(841,'6560','HANTES-WIHÉRIES','ERQUELINNES'),(842,'5621','HANZINELLE','FLORENNES'),(843,'5621','HANZINNE','FLORENNES'),(844,'7321','HARCHIES','BERNISSART'),(845,'6600','HARDIGNI','BASTOGNE'),(846,'6900','HARGIMONT','MARCHE-EN-FAMENNE'),(847,'7022','HARMIGNIES','MONS'),(848,'6767','HARNONCOURT','ROUVROY'),(849,'6960','HARRE','MANHAY'),(850,'6950','HARSIN','NASSOGNE'),(851,'7022','HARVENG','MONS'),(852,'4920','HARZÉ','AYWAILLE'),(853,'5540','HASTIÈRE-LAVAUX','HASTIÈRE'),(854,'5541','HASTIÈRE-PAR-DELÀ','HASTIÈRE'),(855,'6870','HATRIVAL','SAINT-HUBERT'),(856,'7120','HAULCHIN','ESTINNES'),(857,'4730','HAUSET','RAEREN'),(858,'5340','HAUT-BOIS','GESVES'),(859,'4983','HAUTE BODEUX','TROIS-PONTS'),(860,'6929','HAUT-FAYS','DAVERDISSE'),(861,'1461','HAUT-ITTRE','ITTRE'),(862,'5537','HAUT-LE-WASTIA','ANHÉE'),(863,'7334','HAUTRAGE','SAINT-GHISLAIN'),(864,'7333','HAUTRAGE-ETAT','SAINT-GHISLAIN'),(865,'7041','HAVAY','QUÉVY'),(866,'5370','HAVELANGE','HAVELANGE'),(867,'5590','HAVERSIN','CINEY'),(868,'7531','HAVINNES','TOURNAI'),(869,'7021','HAVRÉ','MONS'),(870,'5580','HAVRENNE','ROCHEFORT'),(871,'4140','HAYEN','SPRIMONT'),(872,'6997','HAZEILLES','ÉREZÉE'),(873,'6690','HÉBRONVAL','VIELSALM'),(874,'4960','HÉDÔMONT','MALMEDY'),(875,'5543','HEER','HASTIÈRE'),(876,'6700','HEIDEN','ARLON'),(877,'4987','HEILRIMONT','STOUMONT'),(878,'6700','HEINSCH','ARLON'),(879,'6717','HEINSTERT','ATTERT'),(880,'7830','HELLEBECQ','SILLY'),(881,'5380','HEMPTINNE','FERNELMONT'),(882,'5620','HEMPTINNE','FLORENNES'),(883,'7090','HENNUYÈRES','BRAINE-LE-COMTE'),(884,'4841','HENRI-CHAPELLE / HENDRIK-KAPEL','WELKENRAEDT'),(885,'7090','HENRIPONT','BRAINE-LE-COMTE'),(886,'7350','HENSIES','HENSIES'),(887,'4980','HÉNUMONT','TROIS-PONTS'),(888,'4771','HEPPENBACH','AMEL / AMBLÈVE'),(889,'6220','HEPPIGNIES','FLEURUS'),(890,'4771','HEPSCHEID','AMEL / AMBLÈVE'),(891,'4710','HERBESTHAL','LONTZEN'),(892,'6887','HERBEUMONT','HERBEUMONT'),(893,'4845','HERBIESTER','JALHAY'),(894,'7050','HERCHIES','JURBISE'),(895,'4728','HERGENRATH','KELMIS / LA CALAMINE'),(896,'7742','HÉRINNES','PECQ'),(897,'5550','HÉRISSON','VRESSE-SUR-SEMOIS'),(898,'6983','HERLINVAL','LA ROCHE-EN-ARDENNE'),(899,'4681','HERMALLE-SOUS-ARGENTEAU','OUPEYE'),(900,'4480','HERMALLE-SOUS-HUY','ENGIS'),(901,'4680','HERMÉE','OUPEYE'),(902,'5540','HERMETON-SUR-MEUSE','HASTIÈRE'),(903,'4217','HÉRON','HÉRON'),(904,'7911','HERQUEGIES','FRASNES-LEZ-ANVAING'),(905,'4770','HERRESBACH','AMEL / AMBLÈVE'),(906,'7712','HERSEAUX','MOUSCRON / MOESKROEN'),(907,'4040','HERSTAL','HERSTAL'),(908,'7522','HERTAIN','TOURNAI'),(909,'4650','HERVE','HERVE'),(910,'5377','HEURE','SOMME-LEUZE'),(911,'4682','HEURE-LE-ROMAIN','OUPEYE'),(912,'4800','HEUSY','VERVIERS'),(913,'1435','HEVILLERS','MONT-SAINT-GUIBERT'),(914,'4830','HEVREMONT','LIMBOURG'),(915,'6941','HEYD','DURBUY'),(916,'4880','HIMMERICH','AUBEL'),(917,'4784','HINDERHAUSEN','SANKT-VITH / SAINT-VITH'),(918,'5380','HINGEON','FERNELMONT'),(919,'6984','HIVES','LA ROCHE-EN-ARDENNE'),(920,'4970','HOCKAI','STAVELOT'),(921,'4910','HODBOMONT','THEUX'),(922,'4351','HODEIGE','REMICOURT'),(923,'4800','HODIMONT','VERVIERS'),(924,'6987','HODISTER','RENDEUX'),(925,'4162','HODY','ANTHISNES'),(926,'5377','HOGNE','SOMME-LEUZE'),(927,'4342','HOGNOUL','AWANS'),(928,'7620','HOLLAIN','BRUNEHAUT'),(929,'6637','HOLLANGE','FAUVILLERS'),(930,'6900','HOLLOGNE','MARCHE-EN-FAMENNE'),(931,'4460','HOLLOGNE-AUX-PIERRES','GRÂCE-HOLLOGNE'),(932,'4250','HOLLOGNE-SUR-GEER','GEER'),(933,'4760','HOLZHEIM','BÜLLINGEN / BULLANGE'),(934,'4852','HOMBOURG / HOMBURG','PLOMBIÈRES'),(935,'6640','HOMPRÉ','VAUX-SUR-SÛRE'),(936,'6780','HONDELANGE','MESSANCY'),(937,'5570','HONNAY','BEAURAING'),(938,'4760','HONSFELD','BÜLLINGEN / BULLANGE'),(939,'6671','HONVELEZ','GOUVY'),(940,'6637','HONVILLE','FAUVILLERS'),(941,'4130','HONY','ESNEUX'),(942,'4460','HORION','GRÂCE-HOLLOGNE'),(943,'7301','HORNU','BOUSSU'),(944,'7060','HORRUES','SOIGNIES'),(945,'6840','HOSSEUSE','NEUFCHÂTEAU'),(946,'6637','HOTTE','FAUVILLERS'),(947,'6990','HOTTON','HOTTON'),(948,'6724','HOUDEMONT','HABAY'),(949,'7110','HOUDENG-AIMERIES','LA LOUVIÈRE'),(950,'7110','HOUDENG-GOEGNIES','LA LOUVIÈRE'),(951,'5575','HOUDREMONT','GEDINNE'),(952,'6769','HOUDRIGNY','MEIX-DEVANT-VIRTON'),(953,'6660','HOUFFALIZE','HOUFFALIZE'),(954,'4890','HOULTEAU','THIMISTER-CLERMONT'),(955,'5563','HOUR','HOUYET'),(956,'4671','HOUSSE','BLEGNY'),(957,'5300','HOÛSSOI','ANDENNE'),(958,'4920','HOUSSONLOGE','AYWAILLE'),(959,'7812','HOUTAING','ATH'),(960,'1476','HOUTAIN-LE-VAL','GENAPPE'),(961,'4682','HOUTAIN-SAINT-SIMÉON','OUPEYE'),(962,'7781','HOUTHEM','COMINES-WARNETON / KOMEN-'),(963,'4970','HOUVEGNEZ','STAVELOT'),(964,'5530','HOUX','YVOIR'),(965,'5560','HOUYET','HOUYET'),(966,'7830','HOVES','SILLY'),(967,'7624','HOWARDRIES','BRUNEHAUT'),(968,'4170','HÔYEMONT','COMBLAIN-AU-PONT'),(969,'4460','HOZÉMONT','GRÂCE-HOLLOGNE'),(970,'6983','HUBERMONT','LA ROCHE-EN-ARDENNE'),(971,'4520','HUCCORGNE','WANZE'),(972,'7950','HUISSIGNIES','CHIÈVRES'),(973,'4760','HÜLLSCHEID','BÜLLINGEN / BULLANGE'),(974,'5560','HULSONNIAUX','HOUYET'),(975,'6900','HUMAIN','MARCHE-EN-FAMENNE'),(976,'4760','HÜNNINGEN','BÜLLINGEN / BULLANGE'),(977,'1367','HUPPAYE','RAMILLIES'),(978,'4500','HUY','HUY'),(979,'6280','HYMIÉE','GERPINNES'),(980,'7022','HYON','MONS'),(981,'1315','INCOURT','INCOURT'),(982,'7801','IRCHONWELZ','ATH'),(983,'7822','ISIÈRES','ATH'),(984,'5032','ISNES','GEMBLOUX'),(985,'1460','ITTRE','ITTRE'),(986,'4770','IVELDINGEN','AMEL / AMBLÈVE'),(987,'4400','IVOZ-RAMET','FLÉMALLE'),(988,'1050','IXELLES','IXELLES'),(989,'6810','IZEL','CHINY'),(990,'6941','IZIER','DURBUY'),(991,'4845','JALHAY','JALHAY'),(992,'5354','JALLET','OHEY'),(993,'5600','JAMAGNE','PHILIPPEVILLE'),(994,'5100','JAMBES','NAMUR'),(995,'5600','JAMIOLLE','PHILIPPEVILLE'),(996,'6120','JAMIOULX','HAM-SUR-HEURE-NALINNES'),(997,'6810','JAMOIGNE','CHINY'),(998,'1350','JANDRAIN','ORP-JAUCHE'),(999,'1350','JANDRENOUILLE','ORP-JAUCHE'),(1000,'1350','JAUCHE','ORP-JAUCHE'),(1001,'1370','JAUCHELETTE','JODOIGNE'),(1002,'5570','JAVINGUE-SÉVRY','BEAURAING'),(1003,'4910','JEHANSTER','THEUX'),(1004,'4540','JEHAY-BODEGNÉE','AMAY'),(1005,'6880','JEHONVILLE','BERTRIX'),(1006,'7000','JEMAPPES','MONS'),(1007,'5580','JEMELLE','ROCHEFORT'),(1008,'4101','JEMEPPE','SERAING'),(1009,'5190','JEMEPPE-SUR-SAMBRE','JEMEPPE-SUR-SAMBRE'),(1010,'4357','JENEFFE','DONCEEL'),(1011,'5370','JENEFFE','HAVELANGE'),(1012,'6941','JENNERET','DURBUY'),(1013,'6800','JENNEVILLE','LIBRAMONT-CHEVIGNY'),(1014,'1090','JETTE','JETTE'),(1015,'4990','JEVIGNÉ','LIERNEUX'),(1016,'4910','JEVOUMONT','THEUX'),(1017,'1370','JODOIGNE','JODOIGNE'),(1018,'1370','JODOIGNE-SOUVERAINE','JODOIGNE'),(1019,'7100','JOLIMONT','LA LOUVIÈRE'),(1020,'7620','JOLLAIN-MERLIN','BRUNEHAUT'),(1021,'6280','JONCRET','GERPINNES'),(1022,'4651','JOSÉ','HERVE'),(1023,'6690','JOUBIÉVAL','VIELSALM'),(1024,'6971','JOURNAL','TENNEVILLE'),(1025,'4650','JULÉMONT','HERVE'),(1026,'6040','JUMET','CHARLEROI'),(1027,'6987','JUPILLE','RENDEUX'),(1028,'4020','JUPILLE-SUR-MEUSE','LIÈGE'),(1029,'4450','JUPRELLE','JUPRELLE'),(1030,'7050','JURBISE','JURBISE'),(1031,'6642','JUSERET','VAUX-SUR-SÛRE'),(1032,'4910','JUSLENVILLE','THEUX'),(1033,'7540','KAIN','TOURNAI'),(1034,'4840','KAULEN','WELKENRAEDT'),(1035,'4720','KELMIS / LA CALAMINE','KELMIS / LA CALAMINE'),(1036,'4367','KEMEXHE','CRISNÉE'),(1037,'4700','KETTENIS','EUPEN'),(1038,'5060','KEUMIÉE','SAMBREVILLE'),(1039,'4920','KIN','AYWAILLE'),(1040,'1081','KOEKELBERG','KOEKELBERG'),(1041,'4760','KREWINKEL','BÜLLINGEN / BULLANGE'),(1042,'4761','KRINKELT','BÜLLINGEN / BULLANGE'),(1043,'4750','KÜCHELSCHEID','BÜTGENBACH / BUTGENBACH'),(1044,'7080','LA BOUVERIE','FRAMERIES'),(1045,'7034','LA BRISÉE','MONS'),(1046,'4870','LA BROUCK','TROOZ'),(1047,'1320','LA BRUYÈRE','BEAUVECHAIN'),(1048,'7973','LA BRUYÈRE','BELOEIL'),(1049,'4840','LA BRUYÈRE','WELKENRAEDT'),(1050,'7063','LA CÂGE','SOIGNIES'),(1051,'4990','LA CHAPELLE','LIERNEUX'),(1052,'4880','LA CLOUSE','AUBEL'),(1053,'6960','LA FANGE','MANHAY'),(1054,'6960','LA FOSSE','MANHAY'),(1055,'6180','LA GLACERIE','COURCELLES'),(1056,'7611','LA GLANERIE','RUMES'),(1057,'4987','LA GLEIZE','STOUMONT'),(1058,'6800','LA HAUTE BRAS','LIBRAMONT-CHEVIGNY'),(1059,'7170','LA HESTRE','MANAGE'),(1060,'1310','LA HULPE','LA HULPE'),(1061,'7100','LA LOUVIÈRE','LA LOUVIÈRE'),(1062,'4890','LA MINERIE','THIMISTER-CLERMONT'),(1063,'6220','LA POUDRIÈRE','FLEURUS'),(1064,'4910','LA REID','THEUX'),(1065,'1490','LA ROCHE','COURT-SAINT-ÉTIENNE'),(1066,'6980','LA ROCHE-EN-ARDENNE','LA ROCHE-EN-ARDENNE'),(1067,'4190','LA ROUGE MINIÈRE','FERRIÈRES'),(1068,'5060','LA SARTE','SAMBREVILLE'),(1069,'4500','LA SARTE À BEN','HUY'),(1070,'4500','LA SARTE À HUY','HUY'),(1071,'6200','LA SIBÉRIE','CHÂTELET'),(1072,'4980','LA VAUX','TROIS-PONTS'),(1073,'4987','LA VENNE','STOUMONT'),(1074,'7850','L\'ABLIAU','ENGHIEN / EDINGEN'),(1075,'6567','LABUISSIÈRE','MERBES-LE-CHÂTEAU'),(1076,'6821','LACUISINE','FLORENVILLE'),(1077,'7950','LADEUZE','CHIÈVRES'),(1078,'5550','LAFORÊT','VRESSE-SUR-SEMOIS'),(1079,'6997','LAFORGE','ÉREZÉE'),(1080,'6730','LAHAGE','TINTIGNY'),(1081,'7890','LAHAMAIDE','ELLEZELLES'),(1082,'6840','LAHÉRIE','NEUFCHÂTEAU'),(1083,'6150','L\'AIÛ','ANDERLUES'),(1084,'7522','LAMAIN','TOURNAI'),(1085,'4800','LAMBERMONT','VERVIERS'),(1086,'6220','LAMBUSART','FLEURUS'),(1087,'4350','LAMINE','REMICOURT'),(1088,'4960','LAMONRIVILLE','MALMEDY'),(1089,'4210','LAMONTZÉE','BURDINNE'),(1090,'6960','LAMÔRMENIL','MANHAY'),(1091,'6767','LAMORTEAU','ROUVROY'),(1092,'6800','LAMOULINE','LIBRAMONT-CHEVIGNY'),(1093,'4600','LANAYE','VISÉ'),(1094,'6111','LANDELIES','MONTIGNY-LE-TILLEUL'),(1095,'5300','LANDENNE','ANDENNE'),(1096,'5651','LANEFFE','WALCOURT'),(1097,'6800','LANEUVILLE','LIBRAMONT-CHEVIGNY'),(1098,'6970','LANEUVILLE AU BOIS','TENNEVILLE'),(1099,'6674','LANGLÎRE','GOUVY'),(1100,'7800','LANQUESAINT','ATH'),(1101,'4450','LANTIN','JUPRELLE'),(1102,'4300','LANTREMANGE','WAREMME'),(1103,'4840','LANTZENBERG','WELKENRAEDT'),(1104,'4760','LANZERATH','BÜLLINGEN / BULLANGE'),(1105,'7622','LAPLAIGNE','BRUNEHAUT'),(1106,'4790','LASCHEID','BURG-REULAND'),(1107,'1380','LASNE','LASNE'),(1108,'1380','LASNE-CHAPELLE-SAINT-LAMBERT','LASNE'),(1109,'1370','LATHUY','JODOIGNE'),(1110,'4261','LATINNE','BRAIVES'),(1111,'6761','LATOUR','VIRTON'),(1112,'6280','LAUSPRELLE','GERPINNES'),(1113,'6681','LAVACHERIE','SAINTE-ODE'),(1114,'6984','LAVAUX','LA ROCHE-EN-ARDENNE'),(1115,'5580','LAVAUX-SAINTE-ANNE','ROCHEFORT'),(1116,'4217','LAVOIR','HÉRON'),(1117,'7783','LE BIZET','COMINES-WARNETON / KOMEN-'),(1118,'6120','LE BULTIA','HAM-SUR-HEURE-NALINNES'),(1119,'7000','LE CASINO','MONS'),(1120,'6890','LE CONGO','LIBIN'),(1121,'6960','LE DEUX RIS','MANHAY'),(1122,'6960','LE FAYI','MANHAY'),(1123,'7332','LE HAPPART','SAINT-GHISLAIN'),(1124,'7130','LE LEVANT DE MONS','BINCHE'),(1125,'5670','LE MESNIL','VIROINVAL'),(1126,'5020','LE PIROI','NAMUR'),(1127,'7070','LE ROEULX','LE ROEULX'),(1128,'5070','LE ROUX','FOSSES-LA-VILLE'),(1129,'6880','LE SART','BERTRIX'),(1130,'6840','LE SART','NEUFCHÂTEAU'),(1131,'1320','L\'ÉCLUSE','BEAUVECHAIN'),(1132,'6142','LEERNES','FONTAINE-L\'ÉVÊQUE'),(1133,'6530','LEERS-ET-FOSTEAU','THUIN'),(1134,'7730','LEERS-NORD','ESTAIMPUIS'),(1135,'5500','LEFFE','DINANT'),(1136,'6860','LÉGLISE','LÉGLISE'),(1137,'5590','LEIGNON','CINEY'),(1138,'4790','LENGELER','BURG-REULAND'),(1139,'7870','LENS','LENS'),(1140,'4280','LENS-SAINT-REMY','HANNUT'),(1141,'4250','LENS-SAINT-SERVAIS','GEER'),(1142,'4360','LENS-SUR-GEER','OREYE'),(1143,'6880','LES ASSENOIS','BERTRIX'),(1144,'4560','LES AVINS','CLAVIER'),(1145,'7712','LES BALLONS','MOUSCRON / MOESKROEN'),(1146,'5590','LES BASSES','CINEY'),(1147,'6200','LES BINCHES','CHÂTELET'),(1148,'5190','LES BRULÉS','JEMEPPE-SUR-SAMBRE'),(1149,'7020','LES BRUYÈRES','MONS'),(1150,'4651','LES BRUYÈRES','HERVE'),(1151,'6811','LES BULLES','CHINY'),(1152,'4400','LES CAHOTTES','FLÉMALLE'),(1153,'5020','LES COMOGNES','NAMUR'),(1154,'4052','LES COURS','CHAUDFONTAINE'),(1155,'4870','LES CROISETTES','TROOZ'),(1156,'7970','LES ECACHERIES','BELOEIL'),(1157,'6280','LES FLACHES','GERPINNES'),(1158,'4987','LES FORGES','STOUMONT'),(1159,'6860','LES FOSSÉS','LÉGLISE'),(1160,'6830','LES HAYONS','BOUILLON'),(1161,'4140','LES HORNAIS','SPRIMONT'),(1162,'4400','LES TIERS','FLÉMALLE'),(1163,'4990','LES TROUS DE BRA','LIERNEUX'),(1164,'4990','LES VILLETTES','LIERNEUX'),(1165,'4317','LES WALEFFES','FAIMES'),(1166,'6464','L\'ESCAILLÈRE','CHIMAY'),(1167,'6642','LESCHERET','VAUX-SUR-SÛRE'),(1168,'7621','LESDAIN','BRUNEHAUT'),(1169,'7860','LESSINES','LESSINES'),(1170,'5580','LESSIVE','ROCHEFORT'),(1171,'6953','LESTERNY','NASSOGNE'),(1172,'5170','LESVE','PROFONDEVILLE'),(1173,'6500','LEUGNIES','BEAUMONT'),(1174,'5310','LEUZE','EGHEZÉE'),(1175,'7900','LEUZE-EN-HAINAUT','LEUZE-EN-HAINAUT'),(1176,'6500','LEVAL-CHAUDEVILLE','BEAUMONT'),(1177,'7134','LEVAL-TRAHEGNIES','BINCHE'),(1178,'4750','LEYKAUL','BÜTGENBACH / BUTGENBACH'),(1179,'6238','LIBERCHIES','PONT-À-CELLES'),(1180,'6890','LIBIN','LIBIN'),(1181,'5350','LIBOIS','OHEY'),(1182,'4950','LIBÔMONT','WAIMES / WEISMES'),(1183,'6800','LIBRAMONT','LIBRAMONT-CHEVIGNY'),(1184,'4000','LIÈGE','LIÈGE'),(1185,'4990','LIERNEUX','LIERNEUX'),(1186,'5310','LIERNU','EGHEZÉE'),(1187,'4042','LIERS','HERSTAL'),(1188,'4621','LIÉRY','FLÉRON'),(1189,'7812','LIGNE','ATH'),(1190,'4960','LIGNEUVILLE','MALMEDY'),(1191,'4254','LIGNEY','GEER'),(1192,'6900','LIGNIÈRES','MARCHE-EN-FAMENNE'),(1193,'5140','LIGNY','SOMBREFFE'),(1194,'1428','LILLOIS-WITTERZÉE','BRAINE-L\'ALLEUD'),(1195,'1300','LIMAL','WAVRE'),(1196,'4830','LIMBOURG','LIMBOURG'),(1197,'1342','LIMELETTE','OTTIGNIES-LOUVAIN-LA-NEUV'),(1198,'6670','LIMERLÉ','GOUVY'),(1199,'6769','LIMES','MEIX-DEVANT-VIRTON'),(1200,'4577','LIMET','MODAVE'),(1201,'4163','LIMONT','ANTHISNES'),(1202,'4357','LIMONT','DONCEEL'),(1203,'4140','LINCÉ','SPRIMONT'),(1204,'4287','LINCENT','LINCENT'),(1205,'4577','LINCHET','MODAVE'),(1206,'1357','LINSMEAU','HÉLÉCINE'),(1207,'6717','LISCHERT','ATTERT'),(1208,'5501','LISOGNE','DINANT'),(1209,'5563','LISSOIR','HOUYET'),(1210,'6600','LIVÂRCHAMPS','BASTOGNE'),(1211,'5101','LIVES-SUR-MEUSE','NAMUR'),(1212,'4600','LIXHE','VISÉ'),(1213,'6540','LOBBES','LOBBES'),(1214,'6042','LODELINSART','CHARLEROI'),(1215,'4600','LOËN','VISÉ'),(1216,'4980','LOGBIERMÉ','TROIS-PONTS'),(1217,'7870','LOMBISE','LENS'),(1218,'4780','LOMMERSWEILER','SANKT-VITH / SAINT-VITH'),(1219,'6463','LOMPRET','CHIMAY'),(1220,'6924','LOMPREZ','WELLIN'),(1221,'4431','LONCIN','ANS'),(1222,'6688','LONGCHAMPS','BERTOGNE'),(1223,'5310','LONGCHAMPS','EGHEZÉE'),(1224,'6780','LONGEAU','MESSANCY'),(1225,'4960','LONGFAYE','MALMEDY'),(1226,'6840','LONGLIER','NEUFCHÂTEAU'),(1227,'1325','LONGUEVILLE','CHAUMONT-GISTOUX'),(1228,'6600','LONGVILLY','BASTOGNE'),(1229,'4710','LONTZEN','LONTZEN'),(1230,'5030','LONZEE','GEMBLOUX'),(1231,'4987','LORCÉ','STOUMONT'),(1232,'6870','LORCY','SAINT-HUBERT'),(1233,'6717','LOTTERT','ATTERT'),(1234,'5575','LOUETTE-SAINT-DENIS','GEDINNE'),(1235,'5575','LOUETTE-SAINT-PIERRE','GEDINNE'),(1236,'6860','LOUFTEMONT','LÉGLISE'),(1237,'1471','LOUPOIGNE','GENAPPE'),(1238,'1348','LOUVAIN-LA-NEUVE','OTTIGNIES-LOUVAIN-LA-NEUV'),(1239,'4141','LOUVEIGNÉ','SPRIMONT'),(1240,'7063','LOUVIGNIES','SOIGNIES'),(1241,'6280','LOVERVAL','GERPINNES'),(1242,'5101','LOYERS','NAMUR'),(1243,'5501','LOYERS','DINANT'),(1244,'7700','LUINGNE','MOUSCRON / MOESKROEN'),(1245,'5651','LUMSONRY','WALCOURT'),(1246,'5170','LUSTIN','PROFONDEVILLE'),(1247,'6600','LUTREBOIS','BASTOGNE'),(1248,'6600','LUTREMANGE','BASTOGNE'),(1249,'6230','LUTTRE','PONT-À-CELLES'),(1250,'6982','MABOGE','LA ROCHE-EN-ARDENNE'),(1251,'6663','MABOMPRÉ','HOUFFALIZE'),(1252,'6591','MACON','MOMIGNIES'),(1253,'6593','MACQUENOISE','MOMIGNIES'),(1254,'5374','MAFFE','HAVELANGE'),(1255,'7810','MAFFLE','ATH'),(1256,'6600','MAGERET','BASTOGNE'),(1257,'4623','MAGNÉE','FLÉRON'),(1258,'6987','MAGOSTER','RENDEUX'),(1259,'5330','MAILLEN','ASSESSE'),(1260,'7812','MAINVAULT','ATH'),(1261,'7020','MAISIÈRES','MONS'),(1262,'5640','MAISON','METTET'),(1263,'6852','MAISSIN','PALISEUL'),(1264,'5300','MAIZERET','ANDENNE'),(1265,'4570','MÂLÂWÉ','MARCHIN'),(1266,'4791','MALDINGEN','BURG-REULAND'),(1267,'6960','MALEMPRÉ','MANHAY'),(1268,'1360','MALÈVES-SAINTE-MARIE-WASTINNE','PERWEZ'),(1269,'6637','MALMAISON','FAUVILLERS'),(1270,'4960','MALMEDY','MALMEDY'),(1271,'5020','MALONNE','NAMUR'),(1272,'4790','MALSCHEID','BURG-REULAND'),(1273,'5575','MALVOISIN','GEDINNE'),(1274,'7170','MANAGE','MANAGE'),(1275,'4651','MANAIHANT','HERVE'),(1276,'4760','MANDERFELD','BÜLLINGEN / BULLANGE'),(1277,'6688','MANDE-SAINT-ETIENNE','BERTOGNE'),(1278,'6960','MANHAY','MANHAY'),(1279,'1380','MARANSART','LASNE'),(1280,'1495','MARBAIS','VILLERS-LA-VILLE'),(1281,'6120','MARBAIX','HAM-SUR-HEURE-NALINNES'),(1282,'6840','MARBAY','NEUFCHÂTEAU'),(1283,'6724','MARBEHAN','HABAY'),(1284,'6900','MARCHE-EN-FAMENNE','MARCHE-EN-FAMENNE'),(1285,'5024','MARCHE-LES-DAMES','NAMUR'),(1286,'7190','MARCHE-LEZ-ECAUSSINNES','ECAUSSINNES'),(1287,'6030','MARCHIENNE-AU-PONT','CHARLEROI'),(1288,'4570','MARCHIN','MARCHIN'),(1289,'7387','MARCHIPONT','HONNELLES'),(1290,'5380','MARCHOVELETTE','FERNELMONT'),(1291,'6001','MARCINELLE','CHARLEROI'),(1292,'6987','MARCOURAY','RENDEUX'),(1293,'6987','MARCOURT','RENDEUX'),(1294,'7850','MARCQ / MARK','ENGHIEN / EDINGEN'),(1295,'6990','MARENNE','HOTTON'),(1296,'1350','MARET','ORP-JAUCHE'),(1297,'5660','MARIEMBOURG','COUVIN'),(1298,'1350','MARILLES','ORP-JAUCHE'),(1299,'6900','MARLOIE','MARCHE-EN-FAMENNE'),(1300,'4210','MARNEFFE','BURDINNE'),(1301,'7522','MARQUAIN','TOURNAI'),(1302,'6630','MARTELANGE','MARTELANGE'),(1303,'6887','MARTILLY','HERBEUMONT'),(1304,'4920','MARTINRIVE','AYWAILLE'),(1305,'5573','MARTOUZIN-NEUVILLE','BEAURAING'),(1306,'6600','MARVIE','BASTOGNE'),(1307,'6953','MASBOURG','NASSOGNE'),(1308,'7050','MASNUY-SAINT-JEAN','JURBISE'),(1309,'7050','MASNUY-SAINT-PIERRE','JURBISE'),(1310,'4791','MASPELT','BURG-REULAND'),(1311,'6840','MASSUL','NEUFCHÂTEAU'),(1312,'5680','MATAGNE-LA-GRANDE','DOISCHE'),(1313,'5680','MATAGNE-LA-PETITE','DOISCHE'),(1314,'7640','MAUBRAY','ANTOING'),(1315,'7534','MAULDE','TOURNAI'),(1316,'7110','MAURAGE','LA LOUVIÈRE'),(1317,'5670','MAZÉE','VIROINVAL'),(1318,'5032','MAZY','GEMBLOUX'),(1319,'5372','MÉAN','HAVELANGE'),(1320,'7387','MEAURIN','HONNELLES'),(1321,'4770','MEDELL','AMEL / AMBLÈVE'),(1322,'4760','MEDENDORF','BÜLLINGEN / BULLANGE'),(1323,'4219','MEEFFE','WASSEIGES'),(1324,'5310','MEHAIGNE','EGHEZÉE'),(1325,'6769','MEIX-DEVANT-VIRTON','MEIX-DEVANT-VIRTON'),(1326,'6747','MEIX-LE-TIGE','SAINT-LÉGER'),(1327,'4633','MELEN','SOUMAGNE'),(1328,'1370','MÉLIN','JODOIGNE'),(1329,'1495','MELLERY','VILLERS-LA-VILLE'),(1330,'7540','MELLES','TOURNAI'),(1331,'6210','MELLET','LES BONS VILLERS'),(1332,'6860','MELLIER','LÉGLISE'),(1333,'6990','MELREUX','HOTTON'),(1334,'4837','MEMBACH','BAELEN'),(1335,'5550','MEMBRE','VRESSE-SUR-SEMOIS'),(1336,'6990','MENIL-FAVAI','HOTTON'),(1337,'6637','MENUFONTAINE','FAUVILLERS'),(1338,'6567','MERBES-LE-CHÂTEAU','MERBES-LE-CHÂTEAU'),(1339,'6567','MERBES-SAINTE-MARIE','MERBES-LE-CHÂTEAU'),(1340,'4280','MERDORP','HANNUT'),(1341,'5600','MERLEMONT','PHILIPPEVILLE'),(1342,'7620','MERLIN','BRUNEHAUT'),(1343,'4760','MERLSCHEID','BÜLLINGEN / BULLANGE'),(1344,'6850','MERNY','PALISEUL'),(1345,'4130','MÉRY','ESNEUX'),(1346,'7822','MESLIN-L\'ÉVÊQUE','ATH'),(1347,'5560','MESNIL-ÉGLISE','HOUYET'),(1348,'5560','MESNIL-SAINT-BLAISE','HOUYET'),(1349,'6780','MESSANCY','MESSANCY'),(1350,'7022','MESVIN','MONS'),(1351,'5640','METTET','METTET'),(1352,'6717','METZERT','ATTERT'),(1353,'4987','MEUVILLE','STOUMONT'),(1354,'5081','MEUX','LA BRUYÈRE'),(1355,'7942','MÉVERGNIES-LEZ-LENS','BRUGELETTE'),(1356,'4770','MEYERODE / MEYRODE','AMEL / AMBLÈVE'),(1357,'6600','MICHAMPS','BASTOGNE'),(1358,'4630','MICHEROUX','SOUMAGNE'),(1359,'5376','MIÉCRET','HAVELANGE'),(1360,'6980','MIÈRCHAMPS','LA ROCHE-EN-ARDENNE'),(1361,'7070','MIGNAULT','LE ROEULX'),(1362,'4041','MILMORT','HERSTAL'),(1363,'4771','MIRFELD','AMEL / AMBLÈVE'),(1364,'6870','MIRWART','SAINT-HUBERT'),(1365,'4577','MODAVE','MODAVE'),(1366,'4771','MÖDERSCHEID','AMEL / AMBLÈVE'),(1367,'6833','MOGIMONT','BOUILLON'),(1368,'4520','MOHA','WANZE'),(1369,'5361','MOHIVILLE','HAMOIS'),(1370,'5060','MOIGNELÉE','SAMBREVILLE'),(1371,'6600','MOINET','BASTOGNE'),(1372,'6800','MOIRCY','LIBRAMONT-CHEVIGNY'),(1373,'1367','MOLEMBAIS-SAINT-PIERRE','RAMILLIES'),(1374,'7760','MOLENBAIX','CELLES'),(1375,'1080','MOLENBEEK-SAINT-JEAN','MOLENBEEK-SAINT-JEAN'),(1376,'6840','MOLINFAING','NEUFCHÂTEAU'),(1377,'4350','MOMALLE','REMICOURT'),(1378,'6590','MOMIGNIES','MOMIGNIES'),(1379,'6840','MON IDÉE','NEUFCHÂTEAU'),(1380,'7370','MONCEAU','DOUR'),(1381,'4987','MONCEAU','STOUMONT'),(1382,'5555','MONCEAU-EN-ARDENNE','BIÈVRE'),(1383,'6592','MONCEAU-IMBRECHIES','MOMIGNIES'),(1384,'6031','MONCEAU-SUR-SAMBRE','CHARLEROI'),(1385,'7000','MONS','MONS'),(1386,'4600','MONS','VISÉ'),(1387,'4400','MONS-LEZ-LIÈGE','FLÉMALLE'),(1388,'1400','MONSTREUX','NIVELLES'),(1389,'4170','MONT','COMBLAIN-AU-PONT'),(1390,'4910','MONT','THEUX'),(1391,'4820','MONT','DISON'),(1392,'4960','MONT','MALMEDY'),(1393,'6661','MONT','HOUFFALIZE'),(1394,'6470','MONTBLIART','SIVRY-RANCE'),(1395,'4420','MONTEGNÉE','SAINT-NICOLAS'),(1396,'4770','MONTENAU','AMEL / AMBLÈVE'),(1397,'5580','MONT-GAUTHIER','ROCHEFORT'),(1398,'5530','MONT-GODINNE','YVOIR'),(1399,'4987','MONTHOUET','STOUMONT'),(1400,'7870','MONTIGNIES-LEZ-LENS','LENS'),(1401,'6560','MONTIGNIES-SAINT-CHRISTOPHE','ERQUELINNES'),(1402,'7387','MONTIGNIES-SUR-ROC','HONNELLES'),(1403,'6061','MONTIGNIES-SUR-SAMBRE','CHARLEROI'),(1404,'6110','MONTIGNY-LE-TILLEUL','MONTIGNY-LE-TILLEUL'),(1405,'6674','MONTLEBAN','GOUVY'),(1406,'6840','MONTPLAINCHAMPS','NEUFCHÂTEAU'),(1407,'6767','MONTQUINTIN','ROUVROY'),(1408,'7911','MONTROEUL-AU-BOIS','FRASNES-LEZ-ANVAING'),(1409,'7350','MONTROEUL-SUR-HAINE','HENSIES'),(1410,'1367','MONT-SAINT-ANDRE','RAMILLIES'),(1411,'7542','MONT-SAINT-AUBERT','TOURNAI'),(1412,'7141','MONT-SAINTE-ALDEGONDE','MORLANWELZ'),(1413,'6540','MONT-SAINTE-GENEVIEVE','LOBBES'),(1414,'1435','MONT-SAINT-GUIBERT','MONT-SAINT-GUIBERT'),(1415,'6032','MONT-SUR-MARCHIENNE','CHARLEROI'),(1416,'4850','MONTZEN','PLOMBIÈRES'),(1417,'4850','MONTZEN-GARE','PLOMBIÈRES'),(1418,'6990','MONVILLE','HOTTON'),(1419,'4850','MORESNET','PLOMBIÈRES'),(1420,'4850','MORESNET-CHAPELLE','PLOMBIÈRES'),(1421,'6640','MORHET','VAUX-SUR-SÛRE'),(1422,'5621','MORIALMÉ','FLORENNES'),(1423,'7140','MORLANWELZ-MARIEMONT','MORLANWELZ'),(1424,'7640','MORLIES','ANTOING'),(1425,'6997','MORMONT','ÉREZÉE'),(1426,'5190','MORNIMONT','JEMEPPE-SUR-SAMBRE'),(1427,'6880','MORTEHAN','BERTRIX'),(1428,'4670','MORTIER','BLEGNY'),(1429,'6740','MORTINSART','ETALLE'),(1430,'4607','MORTROUX','DALHEM'),(1431,'5620','MORVILLE','FLORENNES'),(1432,'7812','MOULBAIX','ATH'),(1433,'4987','MOULIN DU RUY','STOUMONT'),(1434,'7543','MOURCOURT','TOURNAI'),(1435,'7700','MOUSCRON / MOESKROEN','MOUSCRON / MOESKROEN'),(1436,'7911','MOUSTIER','FRASNES-LEZ-ANVAING'),(1437,'5190','MOUSTIER','JEMEPPE-SUR-SAMBRE'),(1438,'1341','MOUSTY','OTTIGNIES-LOUVAIN-LA-NEUV'),(1439,'5550','MOUZAIVE','VRESSE-SUR-SEMOIS'),(1440,'4280','MOXHE','HANNUT'),(1441,'5340','MOZET','GESVES'),(1442,'6820','MUNO','FLORENVILLE'),(1443,'4760','MÜRRINGEN','BÜLLINGEN / BULLANGE'),(1444,'6750','MUSSON','MUSSON'),(1445,'6750','MUSSY-LA-VILLE','MUSSON'),(1446,'4190','MY','FERRIÈRES'),(1447,'7060','NAAST','SOIGNIES'),(1448,'6660','NADRIN','HOUFFALIZE'),(1449,'5550','NAFRAITURE','VRESSE-SUR-SEMOIS'),(1450,'6120','NALINNES','HAM-SUR-HEURE-NALINNES'),(1451,'5300','NAMÈCHE','ANDENNE'),(1452,'6840','NAMOUSSART','NEUFCHÂTEAU'),(1453,'5000','NAMUR','NAMUR'),(1454,'4550','NANDRIN','NANDRIN'),(1455,'5100','NANINNE','NAMUR'),(1456,'5555','NAOMÉ','BIÈVRE'),(1457,'6950','NASSOGNE','NASSOGNE'),(1458,'5360','NATOYE','HAMOIS'),(1459,'7730','NÉCHIN','ESTAIMPUIS'),(1460,'1357','NEERHEYLISSEM','HÉLÉCINE'),(1461,'5500','NEFFE','DINANT'),(1462,'4783','NEIDINGEN','SANKT-VITH / SAINT-VITH'),(1463,'4837','NERETH','BAELEN'),(1464,'4870','NESSONVAUX','TROOZ'),(1465,'1390','NETHEN','GREZ-DOICEAU'),(1466,'5377','NETTINNE','SOMME-LEUZE'),(1467,'4608','NEUFCHÂTEAU','DALHEM'),(1468,'6840','NEUFCHÂTEAU','NEUFCHÂTEAU'),(1469,'7332','NEUFMAISON','SAINT-GHISLAIN'),(1470,'7063','NEUFVILLES','SOIGNIES'),(1471,'4721','NEU-MORESNET','KELMIS / LA CALAMINE'),(1472,'4784','NEUNDORF','SANKT-VITH / SAINT-VITH'),(1473,'4120','NEUPRÉ','NEUPRÉ'),(1474,'4987','NEUVILLE','STOUMONT'),(1475,'4980','NEUVILLE','TROIS-PONTS'),(1476,'6690','NEUVILLE','VIELSALM'),(1477,'5600','NEUVILLE','PHILIPPEVILLE'),(1478,'4121','NEUVILLE-EN-CONDROZ','NEUPRÉ'),(1479,'6800','NEUVILLERS','LIBRAMONT-CHEVIGNY'),(1480,'4500','NEUVILLE-SOUS-HUY','HUY'),(1481,'5070','NÈVREMONT','FOSSES-LA-VILLE'),(1482,'4750','NIDRUM','BÜTGENBACH / BUTGENBACH'),(1483,'4784','NIEDER-EMMELS','SANKT-VITH / SAINT-VITH'),(1484,'1457','NIL-SAINT-VINCENT-SAINT-MARTIN','WALHAIN'),(1485,'6800','NIMBERMONT','LIBRAMONT-CHEVIGNY'),(1486,'7000','NIMY','MONS'),(1487,'4050','NINANE','CHAUDFONTAINE'),(1488,'5670','NISMES','VIROINVAL'),(1489,'6983','NISRAMONT','LA ROCHE-EN-ARDENNE'),(1490,'6860','NIVELET','LÉGLISE'),(1491,'1400','NIVELLES','NIVELLES'),(1492,'5680','NIVERLÉE','DOISCHE'),(1493,'6640','NIVES','VAUX-SUR-SÛRE'),(1494,'6717','NOBRESSART','ATTERT'),(1495,'1320','NODEBAIS','BEAUVECHAIN'),(1496,'1350','NODRENGE','ORP-JAUCHE'),(1497,'1350','NODUWEZ','ORP-JAUCHE'),(1498,'7080','NOIRCHAIN','FRAMERIES'),(1499,'6831','NOIREFONTAINE','BOUILLON'),(1500,'5377','NOISEUX','SOMME-LEUZE'),(1501,'6840','NOLINFAING','NEUFCHÂTEAU'),(1502,'6851','NOLLEVAUX','PALISEUL'),(1503,'4920','NONCEVEUX','AYWAILLE'),(1504,'6717','NOTHOMB','ATTERT'),(1505,'7022','NOUVELLES','MONS'),(1506,'4347','NOVILLE','FEXHE-LE-HAUT-CLOCHER'),(1507,'6600','NOVILLE','BASTOGNE'),(1508,'5380','NOVILLE-LES-BOIS','FERNELMONT'),(1509,'5310','NOVILLE-SUR-MÉHAIGNE','EGHEZÉE'),(1510,'6990','NY','HOTTON'),(1511,'6230','OBAIX','PONT-À-CELLES'),(1512,'4750','OBERWEYWERTZ','BÜTGENBACH / BUTGENBACH'),(1513,'7743','OBIGIES','PECQ'),(1514,'7000','OBOURG','MONS'),(1515,'4560','OCHAIN','CLAVIER'),(1516,'6890','OCHAMPS','LIBIN'),(1517,'4560','OCQUIER','CLAVIER'),(1518,'6960','ODEIGNE','MANHAY'),(1519,'4560','ODET','CLAVIER'),(1520,'4367','ODEUR','CRISNÉE'),(1521,'4990','ODRIMONT','LIERNEUX'),(1522,'7911','OEUDEGHIEN','FRASNES-LEZ-ANVAING'),(1523,'6850','OFFAGNE','PALISEUL'),(1524,'6840','OFFAING','NEUFCHÂTEAU'),(1525,'1367','OFFUS','RAMILLIES'),(1526,'7860','OGY','LESSINES'),(1527,'1380','OHAIN','LASNE'),(1528,'5350','OHEY','OHEY'),(1529,'6250','OIGNIES','AISEAU-PRESLES'),(1530,'5670','OIGNIES-EN-THIÉRACHE','VIROINVAL'),(1531,'1480','OISQUERCQ','TUBIZE'),(1532,'5555','OIZY','BIÈVRE'),(1533,'4300','OLEYE','WAREMME'),(1534,'7866','OLLIGNIES','LESSINES'),(1535,'5670','OLLOY-SUR-VIROIN','VIROINVAL'),(1536,'4877','OLNE','OLNE'),(1537,'4252','OMAL','GEER'),(1538,'4540','OMBRET-RAWSA','AMAY'),(1539,'5600','OMEZÉE','PHILIPPEVILLE'),(1540,'6900','ON','MARCHE-EN-FAMENNE'),(1541,'4950','ONDENVAL','WAIMES / WEISMES'),(1542,'4170','ONEUX','COMBLAIN-AU-PONT'),(1543,'4910','ONEUX','THEUX'),(1544,'6941','ONEUX','DURBUY'),(1545,'5520','ONHAYE','ONHAYE'),(1546,'7387','ONNEZIES','HONNELLES'),(1547,'5190','ONOZ','JEMEPPE-SUR-SAMBRE'),(1548,'1420','OPHAIN-BOIS-SEIGNEUR-ISAAC','BRAINE-L\'ALLEUD'),(1549,'1357','OPHEYLISSEM','HÉLÉCINE'),(1550,'6852','OPONT','PALISEUL'),(1551,'6940','OPPAGNE','DURBUY'),(1552,'1315','OPPREBAIS','INCOURT'),(1553,'1360','ORBAIS','PERWEZ'),(1554,'5550','ORCHIMONT','VRESSE-SUR-SEMOIS'),(1555,'7501','ORCQ','TOURNAI'),(1556,'5640','ORET','METTET'),(1557,'4360','OREYE','OREYE'),(1558,'6880','ORGEO','BERTRIX'),(1559,'7802','ORMEIGNIES','ATH'),(1560,'1350','ORP-JAUCHE','ORP-JAUCHE'),(1561,'1350','ORP-LE-GRAND','ORP-JAUCHE'),(1562,'7750','ORROIR','MONT-DE-L\'ENCLUS'),(1563,'6724','ORSINFAING','HABAY'),(1564,'6970','ORTHEUVILLE','TENNEVILLE'),(1565,'6983','ORTHO','LA ROCHE-EN-ARDENNE'),(1566,'5370','OSSOGNE','HAVELANGE'),(1567,'5521','OSTEMERÉE','ONHAYE'),(1568,'6960','OSTER','MANHAY'),(1569,'7804','OSTICHES','ATH'),(1570,'4210','OTEPPE','BURDINNE'),(1571,'4340','OTHÉE','AWANS'),(1572,'4360','OTRANGE','OREYE'),(1573,'1340','OTTIGNIES','OTTIGNIES-LOUVAIN-LA-NEUV'),(1574,'4821','OTTOMONT','DISON'),(1575,'6690','OTTRÉ','VIELSALM'),(1576,'6600','OÛBOURCI','BASTOGNE'),(1577,'4791','OUDLER','BURG-REULAND'),(1578,'4590','OUFFET','OUFFET'),(1579,'4987','OUFNY','STOUMONT'),(1580,'4102','OUGRÉE','SERAING'),(1581,'4680','OUPEYE','OUPEYE'),(1582,'6852','OÜR','PALISEUL'),(1583,'4790','OUREN','BURG-REULAND'),(1584,'6800','OURT','LIBRAMONT-CHEVIGNY'),(1585,'6672','OURTHE','GOUVY'),(1586,'4577','OUTRELOUXHE','MODAVE'),(1587,'4950','OUTREWARCHE','WAIMES / WEISMES'),(1588,'4950','OVIFAT','WAIMES / WEISMES'),(1589,'4452','PAIFVE','JUPRELLE'),(1590,'4560','PAILHE','CLAVIER'),(1591,'6940','PALENGE','DURBUY'),(1592,'6850','PALISEUL','PALISEUL'),(1593,'7861','PAPIGNIES','LESSINES'),(1594,'6717','PARETTE','ATTERT'),(1595,'5575','PATIGNIES','GEDINNE'),(1596,'7340','PÂTURAGES','COLFONTAINE'),(1597,'7740','PECQ','PECQ'),(1598,'7120','PEISSANT','ESTINNES'),(1599,'4287','PELLAINES','LINCENT'),(1600,'4860','PEPINSTER','PEPINSTER'),(1601,'1457','PÈRBAIS','WALHAIN'),(1602,'7134','PÉRONNES','BINCHE'),(1603,'7640','PÉRONNES','ANTOING'),(1604,'7600','PÉRUWELZ','PÉRUWELZ'),(1605,'1360','PERWEZ','PERWEZ'),(1606,'5352','PERWEZ','OHEY'),(1607,'5660','PESCHE','COUVIN'),(1608,'5590','PESSOUX','CINEY'),(1609,'4730','PETERGENSFELD','RAEREN'),(1610,'5660','PETIGNY','COUVIN'),(1611,'7380','PETIT BAISIEUX','QUIÉVRAIN'),(1612,'4163','PETIT BERLEU','ANTHISNES'),(1613,'7370','PETIT DOUR','DOUR'),(1614,'7300','PETIT HORNU','BOUSSU'),(1615,'4300','PETIT-AXHE','WAREMME'),(1616,'6666','PETITE MORMONT','HOUFFALIZE'),(1617,'6940','PETITE SOMME','DURBUY'),(1618,'5660','PETITE-CHAPELLE','COUVIN'),(1619,'7850','PETIT-ENGHIEN / LETTELINGEN','ENGHIEN / EDINGEN'),(1620,'5555','PETIT-FAYS','BIÈVRE'),(1621,'4280','PETIT-HALLET','HANNUT'),(1622,'6940','PETIT-HAN','DURBUY'),(1623,'4800','PETIT-RECHAIN','VERVIERS'),(1624,'7090','PETIT-ROEULX-LEZ-BRAINE','BRAINE-LE-COMTE'),(1625,'7181','PETIT-ROEULX-LEZ-NIVELLES','SENEFFE'),(1626,'1367','PETIT-ROSIÈRE','RAMILLIES'),(1627,'6692','PETIT-THIER','VIELSALM'),(1628,'6840','PETITVOIR','NEUFCHÂTEAU'),(1629,'5300','PETIT-WARET','ANDENNE'),(1630,'4730','PFAU','RAEREN'),(1631,'5600','PHILIPPEVILLE','PHILIPPEVILLE'),(1632,'7160','PIÉTON','CHAPELLE-LEZ-HERLAIMONT'),(1633,'1370','PIÉTRAIN','JODOIGNE'),(1634,'1315','PIÉTREBAIS','INCOURT'),(1635,'6810','PIN','CHINY'),(1636,'7904','PIPAIX','LEUZE-EN-HAINAUT'),(1637,'6240','PIRONCHAMPS','FARCIENNES'),(1638,'4122','PLAINEVAUX','NEUPRÉ'),(1639,'6851','PLAINEVAUX','PALISEUL'),(1640,'1380','PLANCENOIT','LASNE'),(1641,'4730','PLATZ','RAEREN'),(1642,'7782','PLOEGSTEERT','COMINES-WARNETON / KOMEN-'),(1643,'4850','PLOMBIÈRES','PLOMBIÈRES'),(1644,'6870','POIX SAINT-HUBERT','SAINT-HUBERT'),(1645,'4910','POLLEUR','THEUX'),(1646,'7322','POMMEROEUL','BERNISSART'),(1647,'6730','PONCEL','TINTIGNY'),(1648,'7811','PONCHAU','ATH'),(1649,'5574','PONDRÔME','BEAURAING'),(1650,'4960','PONT','MALMEDY'),(1651,'4577','PONT DE BONNE','MODAVE'),(1652,'6230','PONT-À-CELLES','PONT-À-CELLES'),(1653,'5640','PONTAURY','METTET'),(1654,'6250','PONT-DE-LOUP','AISEAU-PRESLES'),(1655,'5380','PONTILLAS','FERNELMONT'),(1656,'4040','PONTISSE','HERSTAL'),(1657,'7760','POPUELLES','CELLES'),(1658,'6929','PORCHERESSE','DAVERDISSE'),(1659,'5370','PORCHERESSE','HAVELANGE'),(1660,'6717','POST','ATTERT'),(1661,'7760','POTTES','CELLES'),(1662,'4280','POUCET','HANNUT'),(1663,'4171','POULSEUR','COMBLAIN-AU-PONT'),(1664,'6830','POUPEHAN','BOUILLON'),(1665,'4350','POUSSET','REMICOURT'),(1666,'4870','PRAYON','TROOZ'),(1667,'5660','PRÉSGAUX','COUVIN'),(1668,'6250','PRESLES','AISEAU-PRESLES'),(1669,'4140','PRÉSSEU','SPRIMONT'),(1670,'6800','PRESSEUX','LIBRAMONT-CHEVIGNY'),(1671,'6690','PRIESMONT','VIELSALM'),(1672,'5170','PROFONDEVILLE','PROFONDEVILLE'),(1673,'6810','PROUVY','CHINY'),(1674,'5650','PRY','WALCOURT'),(1675,'5530','PURNODE','YVOIR'),(1676,'5550','PUSSEMANGE','VRESSE-SUR-SEMOIS'),(1677,'7390','QUAREGNON','QUAREGNON'),(1678,'7540','QUARTES','TOURNAI'),(1679,'1430','QUENAST','REBECQ'),(1680,'4610','QUEUE-DU-BOIS','BEYNE-HEUSAY'),(1681,'7972','QUEVAUCAMPS','BELOEIL'),(1682,'7040','QUÉVY-LE-GRAND','QUÉVY'),(1683,'7040','QUÉVY-LE-PETIT','QUÉVY'),(1684,'7380','QUIÉVRAIN','QUIÉVRAIN'),(1685,'6600','RACHAMPS','BASTOGNE'),(1686,'6792','RACHECOURT','AUBANGE'),(1687,'4287','RACOUR','LINCENT'),(1688,'6630','RADELANGE','MARTELANGE'),(1689,'4730','RAEREN','RAEREN'),(1690,'6532','RAGNIES','THUIN'),(1691,'4987','RAHIER','STOUMONT'),(1692,'4910','RAINONFOSSE','THEUX'),(1693,'7971','RAMEGNIES','BELOEIL'),(1694,'7520','RAMEGNIES-CHIN','TOURNAI'),(1695,'4557','RAMELOT','TINLOT'),(1696,'1367','RAMILLIES-OFFUS','RAMILLIES'),(1697,'4400','RAMIOUL','FLÉMALLE'),(1698,'6470','RANCE','SIVRY-RANCE'),(1699,'6860','RANCIMONT','LÉGLISE'),(1700,'6043','RANSART','CHARLEROI'),(1701,'1380','RANSBÈCHE','LASNE'),(1702,'4577','RAWSÂ','MODAVE'),(1703,'7804','REBAIX','ATH'),(1704,'1430','REBECQ','REBECQ'),(1705,'4780','RECHT','SANKT-VITH / SAINT-VITH'),(1706,'6800','RECOGNE','LIBRAMONT-CHEVIGNY'),(1707,'6600','RECOGNE','BASTOGNE'),(1708,'6890','REDU','LIBIN'),(1709,'6690','RÈGNÉ','VIELSALM'),(1710,'6800','REMAGNE','LIBRAMONT-CHEVIGNY'),(1711,'6640','REMICHAMPAGNE','VAUX-SUR-SÛRE'),(1712,'4350','REMICOURT','REMICOURT'),(1713,'6640','REMIENCE','VAUX-SUR-SÛRE'),(1714,'6640','REMOIVILLE','VAUX-SUR-SÛRE'),(1715,'4950','REMONVAL','WAIMES / WEISMES'),(1716,'6800','RENAUMONT','LIBRAMONT-CHEVIGNY'),(1717,'6690','RENCHEUX','VIELSALM'),(1718,'6987','RENDEUX','RENDEUX'),(1719,'6987','RENDEUX-BAS','RENDEUX'),(1720,'6500','RENLIES','BEAUMONT'),(1721,'4821','RENOUPRÉ','DISON'),(1722,'6840','RESPELT','NEUFCHÂTEAU'),(1723,'7134','RESSAIX','BINCHE'),(1724,'6927','RESTEIGNE','TELLIN'),(1725,'4621','RETINNE','FLÉRON'),(1726,'6673','RETTIGNY','GOUVY'),(1727,'4790','REULAND','BURG-REULAND'),(1728,'6210','RÈVES','LES BONS VILLERS'),(1729,'5080','RHISNES','LA BRUYÈRE'),(1730,'4600','RICHELLE','VISÉ'),(1731,'5575','RIENNE','GEDINNE'),(1732,'4877','RIESSONSART','OLNE'),(1733,'6464','RIÈZES','CHIMAY'),(1734,'5170','RIVIÈRE','PROFONDEVILLE'),(1735,'1330','RIXENSART','RIXENSART'),(1736,'4987','ROANNE','STOUMONT'),(1737,'6460','ROBECHIES','CHIMAY'),(1738,'6769','ROBELMONT','MEIX-DEVANT-VIRTON'),(1739,'4950','ROBERTVILLE','WAIMES / WEISMES'),(1740,'6960','ROCHE À FRÊNE','MANHAY'),(1741,'5580','ROCHEFORT','ROCHEFORT'),(1742,'6830','ROCHEHAUT','BOUILLON'),(1743,'4980','ROCHELINVAL','TROIS-PONTS'),(1744,'4760','ROCHERATH','BÜLLINGEN / BULLANGE'),(1745,'4690','ROCLENGE-SUR-GEER','BASSENGE'),(1746,'4000','ROCOURT','LIÈGE'),(1747,'4784','RODT','SANKT-VITH / SAINT-VITH'),(1748,'1342','ROFFÈSSART','OTTIGNIES-LOUVAIN-LA-NEUV'),(1749,'6671','ROGERY','GOUVY'),(1750,'5651','ROGNÉE','WALCOURT'),(1751,'7387','ROISIN','HONNELLES'),(1752,'4347','ROLOUX','FEXHE-LE-HAUT-CLOCHER'),(1753,'5600','ROLY','PHILIPPEVILLE'),(1754,'5600','ROMEDENNE','PHILIPPEVILLE'),(1755,'5680','ROMERÉE','DOISCHE'),(1756,'4624','ROMSÉE','FLÉRON'),(1757,'6980','RONCHAMP','LA ROCHE-EN-ARDENNE'),(1758,'6980','RONCHAMPAI','LA ROCHE-EN-ARDENNE'),(1759,'6800','RONDU','LIBRAMONT-CHEVIGNY'),(1760,'7623','RONGY','BRUNEHAUT'),(1761,'7090','RONQUIÈRES','BRAINE-LE-COMTE'),(1762,'6987','RONZON','RENDEUX'),(1763,'5620','ROSÉE','FLORENNES'),(1764,'6250','ROSELIES','AISEAU-PRESLES'),(1765,'4122','ROSIÈRE','NEUPRÉ'),(1766,'1331','ROSIÈRES','RIXENSART'),(1767,'4257','ROSOUX-CRENWICK','BERLOZ'),(1768,'6880','ROSSART','BERTRIX'),(1769,'6230','ROSSEIGNIES','PONT-À-CELLES'),(1770,'6730','ROSSIGNOL','TINTIGNY'),(1771,'4120','ROTHEUX-RIMIÈRE','NEUPRÉ'),(1772,'7601','ROUCOURT','PÉRUWELZ'),(1773,'6686','ROUMONT','BERTOGNE'),(1774,'7120','ROUVEROY','ESTINNES'),(1775,'4140','ROUVREUX','SPRIMONT'),(1776,'6767','ROUVROY','ROUVROY'),(1777,'6044','ROUX','CHARLEROI'),(1778,'1315','ROUX-MIROIR','INCOURT'),(1779,'6900','ROY','MARCHE-EN-FAMENNE'),(1780,'6760','RUETTE','VIRTON'),(1781,'6724','RULLES','HABAY'),(1782,'7610','RUMES','RUMES'),(1783,'7540','RUMILLIES','TOURNAI'),(1784,'7750','RUSSEIGNIES','MONT-DE-L\'ENCLUS'),(1785,'4987','RUY','STOUMONT'),(1786,'6997','SADZOT','ÉREZÉE'),(1787,'6637','SAINLEZ','FAUVILLERS'),(1788,'6221','SAINT-AMAND','FLEURUS'),(1789,'4606','SAINT-ANDRÉ','DALHEM'),(1790,'5620','SAINT-AUBIN','FLORENNES'),(1791,'7034','SAINT-DENIS','MONS'),(1792,'5081','SAINT-DENIS','LA BRUYÈRE'),(1793,'4480','SAINTE-BARBE','ENGIS'),(1794,'6820','SAINTE-CÉCILE','FLORENVILLE'),(1795,'6740','SAINTE-MARIE','ETALLE'),(1796,'6800','SAINTE-MARIE-CHEVIGNY','LIBRAMONT-CHEVIGNY'),(1797,'1480','SAINTES','TUBIZE'),(1798,'4470','SAINT-GEORGES-SUR-MEUSE','SAINT-GEORGES-SUR-MEUSE'),(1799,'5640','SAINT-GÉRARD','METTET'),(1800,'5310','SAINT-GERMAIN','EGHEZÉE'),(1801,'1450','SAINT-GÉRY','CHASTRE'),(1802,'7330','SAINT-GHISLAIN','SAINT-GHISLAIN'),(1803,'1060','SAINT-GILLES','SAINT-GILLES'),(1804,'6870','SAINT-HUBERT','SAINT-HUBERT'),(1805,'4980','SAINT-JACQUES','TROIS-PONTS'),(1806,'1370','SAINT-JEAN-GEEST','JODOIGNE'),(1807,'4880','SAINT-JEAN-SART','AUBEL'),(1808,'1210','SAINT-JOSSE-TEN-NOODE','SAINT-JOSSE-TEN-NOODE'),(1809,'7730','SAINT-LÉGER','ESTAIMPUIS'),(1810,'6747','SAINT-LÉGER','SAINT-LÉGER'),(1811,'4500','SAINT-LÉONARD','HUY'),(1812,'5003','SAINT-MARC','NAMUR'),(1813,'6762','SAINT-MARD','VIRTON'),(1814,'5190','SAINT-MARTIN','JEMEPPE-SUR-SAMBRE'),(1815,'7500','SAINT-MAUR','TOURNAI'),(1816,'6887','SAINT-MEDARD','HERBEUMONT'),(1817,'4420','SAINT-NICOLAS','SAINT-NICOLAS'),(1818,'6800','SAINT-PIERRE','LIBRAMONT-CHEVIGNY'),(1819,'6460','SAINT-REMY','CHIMAY'),(1820,'4672','SAINT-REMY','BLEGNY'),(1821,'6760','SAINT-REMY','VIRTON'),(1822,'1370','SAINT-REMY-GEEST','JODOIGNE'),(1823,'7912','SAINT-SAUVEUR','FRASNES-LEZ-ANVAING'),(1824,'5002','SAINT-SERVAIS','NAMUR'),(1825,'4550','SAINT-SÉVERIN','NANDRIN'),(1826,'7030','SAINT-SYMPHORIEN','MONS'),(1827,'7100','SAINT-VAAST','LA LOUVIÈRE'),(1828,'6730','SAINT-VINCENT','TINTIGNY'),(1829,'4671','SAIVE','BLEGNY'),(1830,'4317','SAIVE','FAIMES'),(1831,'4671','SAIVELETTE','BLEGNY'),(1832,'5537','SALET','ANHÉE'),(1833,'6460','SALLES','CHIMAY'),(1834,'6690','SALM-CHÂTEAU','VIELSALM'),(1835,'5600','SAMART','PHILIPPEVILLE'),(1836,'6700','SAMPONT','ARLON'),(1837,'6982','SAMRÉE','LA ROCHE-EN-ARDENNE'),(1838,'4780','SANKT-VITH / SAINT-VITH','SANKT-VITH / SAINT-VITH'),(1839,'7080','SARS-LA-BRUYÈRE','FRAMERIES'),(1840,'6540','SARS-LA-BUISSIÈRE','LOBBES'),(1841,'4990','SART','LIERNEUX'),(1842,'5380','SART D\'AVRIL','FERNELMONT'),(1843,'6210','SART-A-RÈVES','LES BONS VILLERS'),(1844,'5330','SART-BERNARD','ASSESSE'),(1845,'5575','SART-CUSTINNE','GEDINNE'),(1846,'1495','SART-DAMES-AVELINES','VILLERS-LA-VILLE'),(1847,'5600','SART-EN-FAGNE','PHILIPPEVILLE'),(1848,'5070','SART-EUSTACHE','FOSSES-LA-VILLE'),(1849,'4845','SART-LEZ-SPA','JALHAY'),(1850,'1490','SART-MESSIRE-GUILLAUME','COURT-SAINT-ÉTIENNE'),(1851,'1315','SART-RISBART','INCOURT'),(1852,'5070','SART-SAINT-LAURENT','FOSSES-LA-VILLE'),(1853,'4000','SART-TILMAN','LIÈGE'),(1854,'6470','SAUTIN','SIVRY-RANCE'),(1855,'5600','SAUTOUR','PHILIPPEVILLE'),(1856,'5030','SAUVENIÈRE','GEMBLOUX'),(1857,'6800','SBERCHAMPS','LIBRAMONT-CHEVIGNY'),(1858,'6717','SCHADECK','ATTERT'),(1859,'1030','SCHAERBEEK','SCHAERBEEK'),(1860,'5364','SCHALTIN','HAMOIS'),(1861,'6717','SCHOCKVILLE','ATTERT'),(1862,'4782','SCHÖNBERG','SANKT-VITH / SAINT-VITH'),(1863,'4770','SCHOPPEN','AMEL / AMBLÈVE'),(1864,'4730','SCHOSSENT','RAEREN'),(1865,'5300','SCLAYN','ANDENNE'),(1866,'4000','SCLESSIN','LIÈGE'),(1867,'5640','SCRI','METTET'),(1868,'4557','SCRY','TINLOT'),(1869,'5361','SCY','HAMOIS'),(1870,'4800','SÈCHEVAL','VERVIERS'),(1871,'5300','SEILLES','ANDENNE'),(1872,'6781','SELANGE','MESSANCY'),(1873,'6596','SELOIGNES','MOMIGNIES'),(1874,'6840','SEMEL','NEUFCHÂTEAU'),(1875,'7180','SENEFFE','SENEFFE'),(1876,'6600','SENONCHAMPS','BASTOGNE'),(1877,'6832','SENSENRUTH','BOUILLON'),(1878,'4557','SENY','TINLOT'),(1879,'5630','SENZEILLES','CERFONTAINE'),(1880,'6940','SEPTON','DURBUY'),(1881,'4920','SEPTROUX','AYWAILLE'),(1882,'4100','SERAING','SERAING'),(1883,'4537','SERAING-LE-CHÂTEAU','VERLAINE'),(1884,'5590','SERINCHAMPS','CINEY'),(1885,'5380','SÈRON','FERNELMONT'),(1886,'5521','SERVILLE','ONHAYE'),(1887,'6700','SESSELICH','ARLON'),(1888,'6800','SEVISCOURT','LIBRAMONT-CHEVIGNY'),(1889,'6640','SIBRET','VAUX-SUR-SÛRE'),(1890,'6750','SIGNEULX','MUSSON'),(1891,'5630','SILENRIEUX','CERFONTAINE'),(1892,'7830','SILLY','SILLY'),(1893,'5377','SINSIN','SOMME-LEUZE'),(1894,'4851','SIPPENAEKEN','PLOMBIÈRES'),(1895,'7332','SIRAULT','SAINT-GHISLAIN'),(1896,'6470','SIVRY','SIVRY-RANCE'),(1897,'4450','SLINS','JUPRELLE'),(1898,'6890','SMUID','LIBIN'),(1899,'4557','SOHEIT-TINLOT','TINLOT'),(1900,'6920','SOHIER','WELLIN'),(1901,'7060','SOIGNIES','SOIGNIES'),(1902,'4861','SOIRON','PEPINSTER'),(1903,'4500','SOLIÈRES','HUY'),(1904,'6500','SOLRE-SAINT-GÉRY','BEAUMONT'),(1905,'6560','SOLRE-SUR-SAMBRE','ERQUELINNES'),(1906,'4845','SOLWASTER','JALHAY'),(1907,'5140','SOMBREFFE','SOMBREFFE'),(1908,'5377','SOMME-LEUZE','SOMME-LEUZE'),(1909,'6661','SOMMERAIN','HOUFFALIZE'),(1910,'6769','SOMMETHONNE','MEIX-DEVANT-VIRTON'),(1911,'5523','SOMMIÈRE','ONHAYE'),(1912,'5651','SOMZÉE','WALCOURT'),(1913,'5340','SORÉE','GESVES'),(1914,'5333','SORINNE-LA-LONGUE','ASSESSE'),(1915,'5503','SORINNES','DINANT'),(1916,'5537','SOSOYE','ANHÉE'),(1917,'4920','SOUGNÉ-REMOUCHAMPS','AYWAILLE'),(1918,'5680','SOULME','DOISCHE'),(1919,'4630','SOUMAGNE','SOUMAGNE'),(1920,'5630','SOUMOY','CERFONTAINE'),(1921,'4950','SOURBRODT','WAIMES / WEISMES'),(1922,'4130','SOUVERAIN-PRÉ','ESNEUX'),(1923,'6182','SOUVRET','COURCELLES'),(1924,'5590','SOVET','CINEY'),(1925,'5150','SOVIMONT','FLOREFFE'),(1926,'6997','SOY','ÉREZÉE'),(1927,'5150','SOYE','FLOREFFE'),(1928,'4900','SPA','SPA'),(1929,'7032','SPIENNES','MONS'),(1930,'4980','SPINEUX','TROIS-PONTS'),(1931,'4910','SPIXHE','THEUX'),(1932,'5530','SPONTIN','YVOIR'),(1933,'4140','SPRIMONT','SPRIMONT'),(1934,'5190','SPY','JEMEPPE-SUR-SAMBRE'),(1935,'7973','STAMBRUGES','BELOEIL'),(1936,'5646','STAVE','METTET'),(1937,'4970','STAVELOT','STAVELOT'),(1938,'7090','STEENKERQUE','BRAINE-LE-COMTE'),(1939,'4790','STEFFESHAUSEN','BURG-REULAND'),(1940,'4950','STEINBACH','WAIMES / WEISMES'),(1941,'6670','STEINBACH','GOUVY'),(1942,'4800','STEMBERT','VERVIERS'),(1943,'4970','STER','STAVELOT'),(1944,'6700','STERPENICH','ARLON'),(1945,'6673','STERPIGNY','GOUVY'),(1946,'4470','STOCKAY','SAINT-GEORGES-SUR-MEUSE'),(1947,'6700','STOCKEM','ARLON'),(1948,'4987','STOUMONT','STOUMONT'),(1949,'6887','STRAIMONT','HERBEUMONT'),(1950,'6637','STRAINCHAMPS','FAUVILLERS'),(1951,'6511','STRÉE','BEAUMONT'),(1952,'4577','STRÉE','MODAVE'),(1953,'7110','STREPY','LA LOUVIÈRE'),(1954,'7110','STRÉPY-BRACQUEGNIES','LA LOUVIÈRE'),(1955,'5340','STRUD','GESVES'),(1956,'4790','STUBACH','BURG-REULAND'),(1957,'5020','SUARLÉE','NAMUR'),(1958,'5550','SUGNY','VRESSE-SUR-SEMOIS'),(1959,'4130','SUR-CORTIL','ESNEUX'),(1960,'6640','SÛRE','VAUX-SUR-SÛRE'),(1961,'5600','SURICE','PHILIPPEVILLE'),(1962,'4845','SURISTER','JALHAY'),(1963,'4470','SUR-LES-BOIS','SAINT-GEORGES-SUR-MEUSE'),(1964,'6812','SUXY','CHINY'),(1965,'4190','SY','FERRIÈRES'),(1966,'6661','TAILLES','HOUFFALIZE'),(1967,'7618','TAINTIGNIES','RUMES'),(1968,'5060','TAMINES','SAMBREVILLE'),(1969,'5651','TARCIENNE','WALCOURT'),(1970,'4987','TÂRGNON','STOUMONT'),(1971,'6661','TAVERNEU','HOUFFALIZE'),(1972,'4163','TAVIER','ANTHISNES'),(1973,'5310','TAVIERS','EGHEZÉE'),(1974,'6662','TAVIGNY','HOUFFALIZE'),(1975,'6927','TELLIN','TELLIN'),(1976,'7520','TEMPLEUVE','TOURNAI'),(1977,'5020','TEMPLOUX','NAMUR'),(1978,'6970','TENNEVILLE','TENNEVILLE'),(1979,'6813','TERMES','CHINY'),(1980,'4317','TERMOGNE','FAIMES'),(1981,'7333','TERTRE','SAINT-GHISLAIN'),(1982,'4560','TERWAGNE','CLAVIER'),(1983,'4910','THEUX','THEUX'),(1984,'6717','THIAUMONT','ATTERT'),(1985,'6860','THIBÊSSART','LÉGLISE'),(1986,'7070','THIEU','LE ROEULX'),(1987,'7901','THIEULAIN','LEUZE-EN-HAINAUT'),(1988,'7061','THIEUSIES','SOIGNIES'),(1989,'6230','THIMÉON','PONT-À-CELLES'),(1990,'4890','THIMISTER','THIMISTER-CLERMONT'),(1991,'7533','THIMOUGIES','TOURNAI'),(1992,'1402','THINES','NIVELLES'),(1993,'6500','THIRIMONT','BEAUMONT'),(1994,'4280','THISNES','HANNUT'),(1995,'4791','THOMMEN','BURG-REULAND'),(1996,'5300','THON','ANDENNE'),(1997,'1360','THOREMBAIS-LES-BÉGUINES','PERWEZ'),(1998,'1360','THOREMBAIS-SAINT-TROND','PERWEZ'),(1999,'7830','THORICOURT','SILLY'),(2000,'6536','THUILLIES','THUIN'),(2001,'6530','THUIN','THUIN'),(2002,'7350','THULIN','HENSIES'),(2003,'7971','THUMAIDE','BELOEIL'),(2004,'5621','THY-LE-BAUDUIN','FLORENNES'),(2005,'5651','THY-LE-CHÂTEAU','WALCOURT'),(2006,'5502','THYNES','DINANT'),(2007,'4367','THYS','CRISNÉE'),(2008,'4845','TIÈGE','JALHAY'),(2009,'6698','TIGONVILLE','VIELSALM'),(2010,'4500','TIHANGE','HUY'),(2011,'4130','TILFF','ESNEUX'),(2012,'4458','TILICE','JUPRELLE'),(2013,'6680','TILLET','SAINTE-ODE'),(2014,'4420','TILLEUR','SAINT-NICOLAS'),(2015,'5380','TILLIER','FERNELMONT'),(2016,'1495','TILLY','VILLERS-LA-VILLE'),(2017,'4557','TINLOT','TINLOT'),(2018,'6637','TINTANGE','FAUVILLERS'),(2019,'6730','TINTIGNY','TINTIGNY'),(2020,'4950','TIRIMONT','WAIMES / WEISMES'),(2021,'4731','TODLEGER','RAEREN'),(2022,'6700','TOERNICH','ARLON'),(2023,'6941','TOHOGNE','DURBUY'),(2024,'7951','TONGRE-NOTRE-DAME','CHIÈVRES'),(2025,'7950','TONGRE-SAINT-MARTIN','CHIÈVRES'),(2026,'5140','TONGRINNE','SOMBREFFE'),(2027,'6717','TONTELANGE','ATTERT'),(2028,'6767','TORGNY','ROUVROY'),(2029,'4263','TOURINNE','BRAIVES'),(2030,'1320','TOURINNES-LA-GROSSE','BEAUVECHAIN'),(2031,'1457','TOURINNES-SAINT-LAMBERT','WALHAIN'),(2032,'7500','TOURNAI','TOURNAI'),(2033,'6840','TOURNAY','NEUFCHÂTEAU'),(2034,'7904','TOURPES','LEUZE-EN-HAINAUT'),(2035,'7134','TRAHEGNIES','BINCHE'),(2036,'6860','TRAIMONT','LÉGLISE'),(2037,'6890','TRANSINNE','LIBIN'),(2038,'4910','TRANSVAAL','THEUX'),(2039,'6183','TRAZEGNIES','COURCELLES'),(2040,'5670','TREIGNES','VIROINVAL'),(2041,'4670','TREMBLEUR','BLEGNY'),(2042,'5336','TRIEU','ASSESSE'),(2043,'6987','TRINAL','RENDEUX'),(2044,'7100','TRIVIÈRES','LA LOUVIÈRE'),(2045,'4280','TROGNÉE','HANNUT'),(2046,'4980','TROIS-PONTS','TROIS-PONTS'),(2047,'6840','TRONQUOY','NEUFCHÂTEAU'),(2048,'1480','TUBIZE','TUBIZE'),(2049,'1180','UCCLE','UCCLE'),(2050,'6833','UCIMONT','BOUILLON'),(2051,'6700','UDANGE','ARLON'),(2052,'5310','UPIGNY','EGHEZÉE'),(2053,'6810','VALANSART','CHINY'),(2054,'4771','VALENDER','AMEL / AMBLÈVE'),(2055,'4100','VAL-SAINT-LAMBERT','SERAING'),(2056,'6741','VANCE','ETALLE'),(2057,'5680','VAUCELLES','DOISCHE'),(2058,'7950','VAUDIGNIES','CHIÈVRES'),(2059,'6462','VAULX','CHIMAY'),(2060,'7536','VAULX','TOURNAI'),(2061,'6600','VAUX','BASTOGNE'),(2062,'6673','VAUX','GOUVY'),(2063,'6960','VAUX-CHAVANNE','MANHAY'),(2064,'4530','VAUX-ET-BORSET','VILLERS-LE-BOUILLET'),(2065,'6640','VAUX-LEZ-ROSIÈRES','VAUX-SUR-SÛRE'),(2066,'4051','VAUX-SOUS-CHÈVREMONT','CHAUDFONTAINE'),(2067,'6640','VAUX-SUR-SÛRE','VAUX-SUR-SÛRE'),(2068,'5020','VEDRIN','NAMUR'),(2069,'5060','VELAINE','SAMBREVILLE'),(2070,'5300','VÈLAINE','ANDENNE'),(2071,'7760','VELAINES','CELLES'),(2072,'7120','VELLEREILLE-LES-BRAYEUX','ESTINNES'),(2073,'7120','VELLEREILLE-LE-SEC','ESTINNES'),(2074,'4460','VELROUX','GRÂCE-HOLLOGNE'),(2075,'5575','VENCIMONT','GEDINNE'),(2076,'5560','VER','HOUYET'),(2077,'6900','VERDENNE','MARCHE-EN-FAMENNE'),(2078,'6440','VERGNIES','FROIDCHAPELLE'),(2079,'4537','VERLAINE','VERLAINE'),(2080,'6840','VERLAINE','NEUFCHÂTEAU'),(2081,'6941','VERLAINE-SUR-OURTHE','DURBUY'),(2082,'5370','VERLÉE','HAVELANGE'),(2083,'4990','VERLEUMONT','LIERNEUX'),(2084,'4800','VERVIERS','VERVIERS'),(2085,'6870','VESQUEVILLE','SAINT-HUBERT'),(2086,'5300','VEZIN','ANDENNE'),(2087,'7538','VEZON','TOURNAI'),(2088,'7640','VEZONCHEAU','ANTOING'),(2089,'6690','VIELSALM','VIELSALM'),(2090,'4317','VIEMME','FAIMES'),(2091,'4160','VIEN','ANTHISNES'),(2092,'4577','VIERSET-BARSE','MODAVE'),(2093,'5670','VIERVES-SUR-VIROIN','VIROINVAL'),(2094,'6230','VIESVILLE','PONT-À-CELLES'),(2095,'1472','VIEUX-GENAPPE','GENAPPE'),(2096,'7900','VIEUX-LEUZE','LEUZE-EN-HAINAUT'),(2097,'4190','VIEUXVILLE','FERRIÈRES'),(2098,'4530','VIEUX-WALEFFE','VILLERS-LE-BOUILLET'),(2099,'6890','VILLANCE','LIBIN'),(2100,'6690','VILLE DU BOIS','VIELSALM'),(2101,'4260','VILLE-EN-HESBAYE','BRAIVES'),(2102,'7322','VILLE-POMMEROEUL','BERNISSART'),(2103,'7334','VILLEROT','SAINT-GHISLAIN'),(2104,'1450','VILLEROUX','CHASTRE'),(2105,'4161','VILLERS-AUX-TOURS','ANTHISNES'),(2106,'5630','VILLERS-DEUX-ÉGLISES','CERFONTAINE'),(2107,'6823','VILLERS-DEVANT-ORVAL','FLORENVILLE'),(2108,'5600','VILLERS-EN-FAGNE','PHILIPPEVILLE'),(2109,'6600','VILLERS-LA-BONNE-EAU','BASTOGNE'),(2110,'6769','VILLERS-LA-LOUE','MEIX-DEVANT-VIRTON'),(2111,'6460','VILLERS-LA-TOUR','CHIMAY'),(2112,'1495','VILLERS-LA-VILLE','VILLERS-LA-VILLE'),(2113,'4530','VILLERS-LE-BOUILLET','VILLERS-LE-BOUILLET'),(2114,'5600','VILLERS-LE-GAMBON','PHILIPPEVILLE'),(2115,'4280','VILLERS-LE-PEUPLIER','HANNUT'),(2116,'4550','VILLERS-LE-TEMPLE','NANDRIN'),(2117,'4340','VILLERS-L\'ÉVÊQUE','AWANS'),(2118,'5080','VILLERS-LEZ-HEEST','LA BRUYÈRE'),(2119,'7812','VILLERS-NOTRE-DAME','ATH'),(2120,'6210','VILLERS-PERWIN','LES BONS VILLERS'),(2121,'6280','VILLERS-POTERIE','GERPINNES'),(2122,'7812','VILLERS-SAINT-AMAND','ATH'),(2123,'6941','VILLERS-SAINTE-GERTRUDE','DURBUY'),(2124,'7031','VILLERS-SAINT-GHISLAIN','MONS'),(2125,'4453','VILLERS-SAINT-SIMÉON','JUPRELLE'),(2126,'5580','VILLERS-SUR-LESSE','ROCHEFORT'),(2127,'6740','VILLERS-SUR-SEMOIS','ETALLE'),(2128,'7070','VILLE-SUR-HAINE','LE ROEULX'),(2129,'4520','VINALMONT','WANZE'),(2130,'6461','VIRELLES','CHIMAY'),(2131,'1460','VIRGINAL-SAMME','ITTRE'),(2132,'6760','VIRTON','VIRTON'),(2133,'4600','VISÉ','VISÉ'),(2134,'4210','VISSOUL','BURDINNE'),(2135,'6662','VISSOÛLE','HOUFFALIZE'),(2136,'5070','VITRIVAL','FOSSES-LA-VILLE'),(2137,'4683','VIVEGNIS','OUPEYE'),(2138,'4630','VIVIER','SOUMAGNE'),(2139,'6700','VIVILLE','ARLON'),(2140,'6833','VIVY','BOUILLON'),(2141,'6860','VLÈSSART','LÉGLISE'),(2142,'5600','VODECÉE','PHILIPPEVILLE'),(2143,'5680','VODELÉE','DOISCHE'),(2144,'5650','VOGENÉE','WALCOURT'),(2145,'6860','VOLAIVILLE','LÉGLISE'),(2146,'4851','VÖLKERICH','PLOMBIÈRES'),(2147,'5570','VONÊCHE','BEAURAING'),(2148,'4347','VOROUX-GOREUX','FEXHE-LE-HAUT-CLOCHER'),(2149,'4451','VOROUX-LEZ-LIERS','JUPRELLE'),(2150,'4041','VOTTEM','HERSTAL'),(2151,'5550','VRESSE','VRESSE-SUR-SEMOIS'),(2152,'4570','VYLE-ET-THAROUL','MARCHIN'),(2153,'7971','WADELINCOURT','BELOEIL'),(2154,'6223','WAGNELÉE','FLEURUS'),(2155,'6900','WAHA','MARCHE-EN-FAMENNE'),(2156,'6987','WAHARDAI','RENDEUX'),(2157,'5377','WAILLET','SOMME-LEUZE'),(2158,'4950','WAIMES / WEISMES','WAIMES / WEISMES'),(2159,'5650','WALCOURT','WALCOURT'),(2160,'1457','WALHAIN-SAINT-PAUL','WALHAIN'),(2161,'4711','WALHORN','LONTZEN'),(2162,'4950','WALK','WAIMES / WEISMES'),(2163,'4770','WALLERODE','AMEL / AMBLÈVE'),(2164,'5570','WANCENNES','BEAURAING'),(2165,'4020','WANDRE','LIÈGE'),(2166,'6224','WANFERCÉE-BAULET','FLEURUS'),(2167,'6220','WANGENIES','FLEURUS'),(2168,'5564','WANLIN','HOUYET'),(2169,'4980','WANNE','TROIS-PONTS'),(2170,'7861','WANNEBECQ','LESSINES'),(2171,'4980','WANNERANVAL','TROIS-PONTS'),(2172,'4280','WANSIN','HANNUT'),(2173,'4520','WANSOULE','WANZE'),(2174,'4520','WANZE','WANZE'),(2175,'7548','WARCHIN','TOURNAI'),(2176,'7740','WARCOING','PECQ'),(2177,'6600','WARDIN','BASTOGNE'),(2178,'4300','WAREMME','WAREMME'),(2179,'6983','WAREMPAGE','LA ROCHE-EN-ARDENNE'),(2180,'5310','WÂRET-LA-CHAUSSÉE','EGHEZÉE'),(2181,'4217','WARET-L\'ÉVÊQUE','HÉRON'),(2182,'5080','WARISOULX','LA BRUYÈRE'),(2183,'6987','WARISY','RENDEUX'),(2184,'6840','WARMIFONTAINE','NEUFCHÂTEAU'),(2185,'6637','WARNACH','FAUVILLERS'),(2186,'5537','WARNANT','ANHÉE'),(2187,'4530','WARNANT-DREYE','VILLERS-LE-BOUILLET'),(2188,'7784','WARNETON / WAASTEN','COMINES-WARNETON / KOMEN-'),(2189,'7340','WARQUIGNIES','COLFONTAINE'),(2190,'6941','WÂRRE','DURBUY'),(2191,'4608','WARSAGE','DALHEM'),(2192,'4590','WARZÉE','OUFFET'),(2193,'7340','WASMES','COLFONTAINE'),(2194,'7604','WASMES-AUDEMEZ-BRIFFOEIL','PÉRUWELZ'),(2195,'7390','WASMUEL','QUAREGNON'),(2196,'4219','WASSEIGES','WASSEIGES'),(2197,'1410','WATERLOO','WATERLOO'),(2198,'1170','WATERMAEL-BOITSFORT','WATERMAEL-BOITSFORT'),(2199,'6672','WATTERMAL','GOUVY'),(2200,'7910','WATTRIPONT','FRASNES-LEZ-ANVAING'),(2201,'7131','WAUDREZ','BINCHE'),(2202,'5540','WAULSORT','HASTIÈRE'),(2203,'1440','WAUTHIER-BRAINE','BRAINE-LE-CHÂTEAU'),(2204,'1300','WAVRE','WAVRE'),(2205,'5580','WAVREILLE','ROCHEFORT'),(2206,'6210','WAYAUX','LES BONS VILLERS'),(2207,'1474','WAYS','GENAPPE'),(2208,'4760','WECKERATH','BÜLLINGEN / BULLANGE'),(2209,'4860','WEGNEZ','PEPINSTER'),(2210,'5523','WEILLEN','ONHAYE'),(2211,'4791','WEISTEN','BURG-REULAND'),(2212,'4840','WELKENRAEDT','WELKENRAEDT'),(2213,'6920','WELLIN','WELLIN'),(2214,'5100','WÉPION','NAMUR'),(2215,'4190','WERBOMONT','FERRIÈRES'),(2216,'4771','WERETH','AMEL / AMBLÈVE'),(2217,'4630','WERGIFOSSE','SOUMAGNE'),(2218,'6940','WÉRIS','DURBUY'),(2219,'6990','WERPIN','HOTTON'),(2220,'6142','WESPES','FONTAINE-L\'ÉVÊQUE'),(2221,'4790','WEVELER','BURG-REULAND'),(2222,'6706','WEYLER','ARLON'),(2223,'4750','WEYWERTZ','BÜTGENBACH / BUTGENBACH'),(2224,'7620','WEZ-VELVAIN','BRUNEHAUT'),(2225,'6666','WIBRIN','HOUFFALIZE'),(2226,'6600','WICOURT','BASTOGNE'),(2227,'6800','WIDEUMONT GARE','LIBRAMONT-CHEVIGNY'),(2228,'6800','WIDEUMONT VILLAGE','LIBRAMONT-CHEVIGNY'),(2229,'5100','WIERDE','NAMUR'),(2230,'7604','WIERS','PÉRUWELZ'),(2231,'5571','WIESME','BEAURAING'),(2232,'7370','WIHÉRIES','DOUR'),(2233,'4452','WIHOGNE','JUPRELLE'),(2234,'6750','WILLANCOURT','MUSSON'),(2235,'7904','WILLAUPUIS','LEUZE-EN-HAINAUT'),(2236,'7506','WILLEMEAU','TOURNAI'),(2237,'5575','WILLERZIE','GEDINNE'),(2238,'5570','WINENNE','BEAURAING'),(2239,'6860','WINVILLE','LÉGLISE'),(2240,'4761','WIRTZFELD','BÜLLINGEN / BULLANGE'),(2241,'1430','WISBECQ','REBECQ'),(2242,'6637','WISEMBACH','FAUVILLERS'),(2243,'6688','WITHIMONT','BERTOGNE'),(2244,'6860','WITRY','LÉGLISE'),(2245,'6860','WITTIMONT','LÉGLISE'),(2246,'7890','WODECQ','ELLEZELLES'),(2247,'6780','WOLKRANGE','MESSANCY'),(2248,'1200','WOLUWE-SAINT-LAMBERT','WOLUWE-SAINT-LAMBERT'),(2249,'1150','WOLUWE-SAINT-PIERRE','WOLUWE-SAINT-PIERRE'),(2250,'4690','WONCK','BASSENGE'),(2251,'4652','XHENDELESSE','HERVE'),(2252,'4432','XHENDREMAEL','ANS'),(2253,'4987','XHIERFOMONT','STOUMONT'),(2254,'4960','XHOFFRAIX','MALMEDY'),(2255,'4190','XHORIS','FERRIÈRES'),(2256,'4550','YERNÉE-FRAINEUX','NANDRIN'),(2257,'5650','YVES-GOMEZÉE','WALCOURT'),(2258,'5530','YVOIR','YVOIR'),(2259,'1370','ZÉTRUD-LUMAY','JODOIGNE'),(2260,'5660','BRÛLY-DE-COUVIN','COUVIN');


