Sql No Pass smartmob.be leak

[frog]

smartmob.be leak

date: 2024-09-05
format: sql

sample:

INSERT INTO `sm_addresses` VALUES 
(1,10,'users','LIDL Ben Ahin',NULL,4500,'BEN AHIN','avenue du bosquet',NULL,NULL,'LIEN SOCIAL',NULL,50.5252437,5.204475,1,NULL,'2020-03-09 11:19:01'),
(2,12,'users','T1','',4500,'HUY','Rue du Long Thier','','','LIEN SOCIAL','Coiffeuse',50.5175183,5.2563461,1,NULL,'2020-01-29 09:18:43'),
(3,19,'users','Administration Communale',NULL,4577,'VIERSET','Place Hubin','1',NULL,NULL,NULL,50.4828866,5.2981836,1,NULL,'2021-05-07 07:30:16'),
(4,25,'users','T1','',4500,'Tihange','Grand route','','','MEDICAL','La pommeraie',50.5294258,5.2603895,1,NULL,'2020-01-29 09:18:44'),
(5,31,'users','Fleuriste',NULL,4550,'NANDRIN','Rue de la Gendarmerie, 45',NULL,NULL,'LIEN SOCIAL',NULL,50.5061635,5.4090963,1,NULL,'2020-06-24 10:19:26'),
(6,34,'users','T1','',4500,'BEN AHIN','Avenue du bosquet','','','LIEN SOCIAL','lidl',50.5252437,5.204475,1,NULL,'2020-01-29 09:18:44'),
(7,41,'users','T1','',4163,'TAVIER','Rue de la Magrée 22','','','LIEN SOCIAL','',50.49667609999999,5.4710871,1,NULL,'2020-01-29 09:18:45'),
(8,42,'users','T1','',4100,'SERAING','Rue laplace','','','LIEN SOCIAL','Bois de l\'Abbaye',50.5799422,5.4920908,1,NULL,'2020-01-29 09:18:45'),
(9,49,'users','T1','',4500,'HUY','Batta','','','EMPLOI ISP','',50.5190825,5.2351863,1,NULL,'2020-01-29 09:18:45'),
(10,54,'users','T1','',4500,'HUY','Rue des Crépalles 21','','','LIEN SOCIAL','Home St Joseph',50.5199893,5.2459159,1,NULL,'2020-01-29 09:18:45'),
(11,61,'users','T1','',4557,'SENY','Grand Route de l\'Etat','','','LIEN SOCIAL','',50.4578967,5.4045158,1,NULL,'2020-01-29 09:18:45'),
(12,62,'users','T1','',4557,'TINLOT','Rue du Centre','','','LIEN SOCIAL','Senorie',50.4749033,5.3773329,1,NULL,'2020-01-29 09:18:45'),


(3665,1932,'users','Rue de Poperinghe 75, 4051 Chaudfontaine','Belgique',4051,'Chaudfontaine','Rue de Poperinghe','75',NULL,NULL,NULL,50.5948952,5.630239100000001,1,'2022-03-29 17:21:59','2022-03-29 17:21:59'),
(3666,1933,'users','Avenue Reine Astrid & Le Stockis, 4910 Theux','Belgique',4910,'Theux','Avenue Reine Astrid,','28',NULL,NULL,NULL,50.5304008,5.8126405,1,'2022-03-29 17:26:01','2022-03-29 17:26:01'),
(3667,1934,'users','Avenue Eugène Ysaye, 4053 Chaudfontaine','Belgique',4053,'Chaudfontaine - Embourg','Avenue Eugène Ysaye','34B','106',NULL,NULL,50.59325,5.6210117,1,'2022-03-29 17:30:20','2022-03-29 17:30:20'),
(3668,1935,'users','Rue Croix Henrard  4140 Sprimont','Belgique',4140,'Sprimont','Rue Croix Henrard','51',NULL,NULL,NULL,50.5527653,5.702852099999999,1,'2022-03-29 17:32:51','2022-03-29 17:34:03'),
(3669,1882,'users','Arrêt de bus Eglise Saint Remy','Belgique',4500,'Huy','Avenue du Hoyoux',NULL,NULL,NULL,NULL,50.5149633,5.2388165,1,'2022-03-30 11:50:27','2022-03-30 11:50:27'),
(3670,1936,'users','Domicile','Belgique',4570,'Marchin','Rue Régissa','24','1',NULL,NULL,50.4889284,5.2566283,1,'2022-03-30 12:41:26','2022-03-30 12:41:26'),
(3671,1385,'users','Proxy Delhaize','Belgique',4577,'Modave','Route de Strée','46',NULL,NULL,NULL,50.4930056,5.319770399999999,1,'2022-03-30 13:22:49','2022-03-30 13:22:49'),
(3672,1938,'users','Werbeucommune 1, 4180 Hamoir','Belgique',4180,'Hamoir','Werbeucommune','1',NULL,NULL,NULL,50.42674230000001,5.5381515,1,'2022-03-31 09:51:26','2022-03-31 09:51:26'),
(3673,1939,'users','Quai du Batty, 4180 Hamoir','Belgique',4180,'Hamoir','Quai du Batty','5',NULL,NULL,NULL,50.4250622,5.5351046,1,'2022-03-31 09:54:46','2022-03-31 09:54:46'),
(3674,1940,'users','Rue des Fawes, 4141 Sprimont','Belgique',4141,'Sprimont/Banneux','Rue des Fawes','58',NULL,NULL,'CHC Fawes - Home de la Vierge des Pauvres',50.53463980000001,5.7333522,1,'2022-03-31 09:58:20','2022-03-31 09:58:20'),


(1,33,'NINANE','',1,'',NULL,'Virginie','Madame','1987-02-18','','',4560,' CLAVIER (Ocquier)','Grand\' Rue 16','','','','0478/582517','','','','','',NULL,'','IDESS : oui',0,5,NULL,'8/23/2010',1,NULL,NULL,'',NULL,'2019-07-30 13:08:03',NULL,NULL,NULL,NULL),
(2,34,'FROIDBISE','',2,'',NULL,'Léonie','Madame','1917-01-18','','',4590,'OUFFET','Rue Haïre 12','','','086/366761','','','','','','',NULL,'','IDESS : a completer',0,5,NULL,'9/14/2010',1,NULL,NULL,'',NULL,'2022-10-18 12:18:09',NULL,1033,'2022-10-18 10:18:09','4'),
(3,35,'JACQUES','melissa-jacques@hotmail.com',3,NULL,NULL,'Mélissa','Madame','1985-04-20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0485/311382',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'IDESS : à compléter',0,5,NULL,'9/15/2010',1,NULL,NULL,'',NULL,'2022-10-18 12:33:07',NULL,NULL,NULL,NULL),
(4,36,'DELDERENNE','',4,'',NULL,'Henri','Monsieur','1975-03-19','','',4020,'LIEGE','Rue Saint Remacle 5','','','','0494/234638','','','','','',NULL,'','IDESS : oui',0,5,NULL,'9/15/2010',1,NULL,NULL,'',NULL,'2019-07-30 13:08:03',NULL,NULL,NULL,NULL),
(5,37,'CASTELAIN','',5,'',NULL,'Pierre','Monsieur','1932-12-02','','',4570,'MARCHIN','Rue Joseph Wauters 17','','','085/232950','','','','','','',NULL,'','IDESS : oui',0,5,NULL,'9/17/2010',1,NULL,NULL,'',NULL,'2019-07-30 13:08:03',NULL,NULL,NULL,NULL),
(6,38,'GILLET','',6,'',NULL,'Madeleine','Madame','1931-03-02','','',4570,'MARCHIN','Rue Joseph Wauters 17','','','085/232950','','','','','','',NULL,'','IDESS : oui',0,5,NULL,'9/17/2010',1,NULL,NULL,'',NULL,'2019-07-30 13:08:03',NULL,NULL,NULL,NULL),
(7,39,'BAURET','angelique.bauret@hotmail.com',7,NULL,NULL,'Angélique','Madame','1985-11-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0499/221200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'IDESS : à compléter',0,5,NULL,'9/20/2010',1,NULL,NULL,'',NULL,'2022-10-18 13:31:54',NULL,NULL,NULL,NULL),
(8,40,'DESSY',NULL,8,NULL,NULL,'Wendy','Madame','1987-02-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0499/373658',NULL,NULL,NULL,'Num de tel non attribué (18/10/22)',NULL,NULL,NULL,'IDESS : à compléter',0,5,NULL,'9/20/2010',1,NULL,NULL,'',NULL,'2023-08-04 12:25:50',NULL,1033,'2023-08-04 10:25:50','1'),


INSERT INTO `sm_addresses` VALUES 
(1,10,'users','LIDL Ben Ahin',NULL,4500,'BEN AHIN','avenue du bosquet',NULL,NULL,'LIEN SOCIAL',NULL,50.5252437,5.204475,1,NULL,'2020-03-09 11:19:01'),
(2,12,'users','T1','',4500,'HUY','Rue du Long Thier','','','LIEN SOCIAL','Coiffeuse',50.5175183,5.2563461,1,NULL,'2020-01-29 09:18:43'),
(3,19,'users','Administration Communale',NULL,4577,'VIERSET','Place Hubin','1',NULL,NULL,NULL,50.4828866,5.2981836,1,NULL,'2021-05-07 07:30:16'),
(4,25,'users','T1','',4500,'Tihange','Grand route','','','MEDICAL','La pommeraie',50.5294258,5.2603895,1,NULL,'2020-01-29 09:18:44'),
(5,31,'users','Fleuriste',NULL,4550,'NANDRIN','Rue de la Gendarmerie, 45',NULL,NULL,'LIEN SOCIAL',NULL,50.5061635,5.4090963,1,NULL,'2020-06-24 10:19:26'),
(6,34,'users','T1','',4500,'BEN AHIN','Avenue du bosquet','','','LIEN SOCIAL','lidl',50.5252437,5.204475,1,NULL,'2020-01-29 09:18:44'),
(7,41,'users','T1','',4163,'TAVIER','Rue de la Magrée 22','','','LIEN SOCIAL','',50.49667609999999,5.4710871,1,NULL,'2020-01-29 09:18:45'),
(8,42,'users','T1','',4100,'SERAING','Rue laplace','','','LIEN SOCIAL','Bois de l\'Abbaye',50.5799422,5.4920908,1,NULL,'2020-01-29 09:18:45'),
(9,49,'users','T1','',4500,'HUY','Batta','','','EMPLOI ISP','',50.5190825,5.2351863,1,NULL,'2020-01-29 09:18:45'),
(10,54,'users','T1','',4500,'HUY','Rue des Crépalles 21','','','LIEN SOCIAL','Home St Joseph',50.5199893,5.2459159,1,NULL,'2020-01-29 09:18:45'),
(11,61,'users','T1','',4557,'SENY','Grand Route de l\'Etat','','','LIEN SOCIAL','',50.4578967,5.4045158,1,NULL,'2020-01-29 09:18:45'),
(12,62,'users','T1','',4557,'TINLOT','Rue du Centre','','','LIEN SOCIAL','Senorie',50.4749033,5.3773329,1,NULL,'2020-01-29 09:18:45'),