select bb.inschrijfnr_kvk sKvknr , bb.volgnr_kvk sKvkvolgnr , bb.lrrorg sMsnr , cc.type oType , cc.rechtsvorm oRechtsvorm , cc.ind_economisch_actief oIndEcAct , cc.peildatum_werkzame_personen oPeilDat , cc.klasse_werkzame_personen oKlWerkPers , cc.ind_surseance oIndSur , cc.ind_faillissement oIndFaill , cc.ind_beeindiging oIndBeeind , cc.aanvang oAanvang , cc.voortzetting oVoortzet , cc.datum_upload oMutatie , dd.naam hNaamVest , ee.type vType , ee.ind_economisch_actief vIndEcAct , ee.ind_nomail vIndNomail , ee.klasse_werkzame_personen vKlWerkPers , ee.werkzame_personen vWerkPers , ee.werkzame_personen_fulltime vWerkPersFt , ee.aanvang vAanvang , ee.voortzetting vVoortzet , ee.datum_upload vMutatie , ee.cwi_code_district cCwiCdDistrict , ee.cwi_code_cwi cCwiCdCwi , ff.url wUrlKvk , gg.url wUrlMs , hh.email eMailMs , ii.code bHoofdcd , jj.code bNevencd1 , kk.code bNevencd2 , concat(ifnull(ll.netnr,''), ifnull(ll.abonneenr,'')) cKvkTel , concat(ifnull(mm.netnr,''), ifnull(mm.abonneenr,'')) cKvkMob , concat(ifnull(nn.netnr,''), ifnull(nn.abonneenr,'')) cMsTel , concat(ifnull(oo.netnr,''), ifnull(oo.abonneenr,'')) cMsFax , pp.postcode aVestKvkPostcd , pp.huisnr aVestKvkHuisnr , pp.huisnrtoevoeging aVestKvkHuisnrToev , pp.straat aVestKvkStraat , pp.woonplaats aVestKvkPlaats , pp.code_gemeente aVestKvkCdGemeente , pp.code_land_kvk aVestKvkCdLand , qq.huisnr aCorrKvkHuisnr , qq.huisnrtoevoeging aCorrKvkHuisnrToev , qq.postcode aCorrKvkPostcd , qq.straat aCorrKvkStraat , qq.woonplaats aCorrKvkPlaats , qq.code_gemeente aCorrKvkCdGemeente , qq.code_land_kvk aCorrKvkCdLand , rr.huisnr aVestMsHuisnr , rr.huisnrtoevoeging aVestMsHuisnrToev , rr.postcode aVestMsPostcd , rr.straat aVestMsStraat , rr.woonplaats aVestMsPlaats , rr.code_gemeente aVestMsCdGemeente , rr.code_land_kvk aVestMsCdLand , ss.huisnr aCorrMsHuisnr , ss.huisnrtoevoeging aCorrMsHuisnrToev , ss.postcode aCorrMsPostcd , ss.straat aCorrMsStraat , ss.woonplaats aCorrMsPlaats , ss.code_gemeente aCorrMsCdGemeente , ss.code_land_kvk aCorrMsCdLand , tt.code_geslacht pPersKvkSexe , tt.titels_voor pPersKvkTitelsVoor , tt.datum_creatie pPersKvkDatCreatie , tt.voorletters pPersKvkVoorletters , tt.voorvoegsel pPersKvkVoorvoegsel , tt.achternaam pPersKvkNaam , tt.titels_achter pPersKvkTitelsAchter , tt.code_functie pPersKvkCdFunctie from sbrquery.v_vestiging ee left join bbr.sleutel bb on (bb.bkwi_id = ee.bkwi_id and bb.bkwi_volgnr = ee.bkwi_volgnr) join sbrquery.v_onderneming cc on (ee.bkwi_id = cc.bkwi_id) left join bbr.handelsnaam dd on (dd.bkwi_id = ee.bkwi_id and dd.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_webadres_kvk ff on (ff.bkwi_id = ee.bkwi_id and ff.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_webadres_ms gg on (gg.bkwi_id = ee.bkwi_id and gg.bkwi_volgnr = ee.bkwi_volgnr) left join bbr.email hh on (hh.bkwi_id = ee.bkwi_id and hh.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_economische_activiteit_hoofd ii on (ii.bkwi_id = ee.bkwi_id and ii.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_economische_activiteit_neven1 jj on (jj.bkwi_id = ee.bkwi_id and jj.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_economische_activiteit_neven2 kk on (kk.bkwi_id = ee.bkwi_id and kk.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_contactnr_kvk_tel ll on (ll.bkwi_id = ee.bkwi_id and ll.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_contactnr_kvk_mob mm on (mm.bkwi_id = ee.bkwi_id and mm.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_contactnr_ms_tel nn on (nn.bkwi_id = ee.bkwi_id and nn.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_contactnr_ms_fax oo on (oo.bkwi_id = ee.bkwi_id and oo.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_adres_kvk_b pp on (pp.bkwi_id = ee.bkwi_id and pp.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_adres_kvk_c qq on (qq.bkwi_id = ee.bkwi_id and qq.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_adres_ms_b rr on (rr.bkwi_id = ee.bkwi_id and rr.bkwi_volgnr = ee.bkwi_volgnr) left join sbrquery.v_adres_ms_c ss on (ss.bkwi_id = ee.bkwi_id and ss.bkwi_volgnr = ee.bkwi_volgnr) left join bbr.contactpersoon_kvk tt on (tt.bkwi_id = ee.bkwi_id and tt.bkwi_volgnr = ee.bkwi_volgnr) join ( select bkwi_id, bkwi_volgnr from sbrquery.v_adres_kvk_b where code_gemeente in ('0390','1320','0517','0518','0787','0666','0519','1321','0669','0670','0671','1326','0796','0054','1680','1000','0738','0358','1001','0197','0648','1002','0739','0359','0481','0305','1003','1004','1301','1302','0059','1005','1303','1304','0001','0002','1006','0360','0482','0613','0477','1007','0483','0361','0141','0034','0740','1008','0484','1723','0741','1009','0142','1010','1011','1679','1012','1013','0883','0485','0060','0306','0307','0486','0198','0362','0884','0363','0742','0364','0199','1014','0105','0366','0200','0201','0003','0885','0487','0649','0202','0488','0106','0367','0743','0368','0143','0650','0061','1015','0651','0744','0308','0886','0004','0745','1016','1246','0489','0203','0062','0369','1017','0204','1018','0144','0005','0887','0888','1247','0746','0370','0747','0006','0205','0889','0371','0107','0890','0007','1019','0891','0206','0372','0309','1305','0490','0491','1724','0893','0373','0748','0892','0749','0207','0208','0750','0492','0493','0751','1859','1306','0494','0374','0752','1721','0568','1020','0753','1021','0209','0210','0375','1307','0008','0652','1308','1022','1309','0894','0585','1728','0754','0145','0376','0495','1262','0496','0377','0378','0146','0055','0895','0497','0755','1023','0064','1025','0057','0211','0108','1681','0896','1026','0897','0147','0654','1254','1027','0499','0379','0756','0757','0212','0500','0758','0194','0655','0311','1028','1029','0501','1030','0898','0380','1031','1032','1876','0656','0657','0213','0899','0759','1033','1034','0998','0900','0312','0313','0214','1035','0381','0215','1310','0901','0658','0382','1036','0502','0383','0997','0760','1037','1311','0659','0109','1038','0314','1706','0611','1039','1684','0761','0216','0110','0148','0065','1312','0310','0217','1040','0503','0010','0552','1663','1345','1024','0768','0149','0159','0400','1404','0440','0736','0762','1041','1042','1385','0150','1392','1222','0135','1690','0218','1043','0384','0151','0152','0763','0111','1774','0764','1044','0219','0504','0220','0221','0222','0066','0660','1045','0766','0058','0067','0315','0223','1046','0505','1313','0498','1047','0224','1048','0316','0506','1248','0661','1719','1049','1263','0303','0767','0225','0507','1314','0662','0226','1050','1051','0769','1264','0112','0902','0227','1711','1315','0385','0228','1052','0113','0317','1651','0011','0770','0771','1255','0357','0386','0387','0229','0905','0772','0230','1053','1054','0663','0903','0231','1055','0114','1056','0773','0774','0388','0153','0232','0233','0775','0776','1057','0234','1316','1251','0777','0508','0235','0904','0012','0068','1722','0778','0013','0069','0070','0071','0653','1058','1317','1059','0115','0779','0509','0780','0236','0781','1771','0906','0782','1652','1060','0237','0238','0154','0907','1318','1061','0908','0783','0510','1063','0689','1062','0116','0155','0784','1064','0511','0664','1319','0785','0156','0512','0239','0513','0514','0515','0516','0693','0665','1065','0389','0365','0157','0909','0786','0910','0016','1067','0667','1322','0240','0241','1323','0014','0911','0520','0391','0015','1066','1324','0912','0913','1729','0242','0158','1068','0788','0392','1325','0393','0394','1069','0521','0914','0522','1655','0789','0790','0160','0243','1070','0523','0017','0395','0072','0318','0073','0161','0244','0117','0524','0245','1071','1937','0915','0396','0397','0525','0916','0246','0074','0247','0398','0526','0917','1327','0791','1072','0792','0793','1658','0019','0527','1073','0399','0528','0672','0162','1074','1075','0918','0163','0530','0794','0795','0075','1260','1076','0531','0248','0164','1077','0076','0401','1078','1079','1080','0919','0249','0250','0063','0251','0533','0252','0797','0920','1081','0534','0798','0402','0077','1328','0673','0674','0319','0921','0253','0799','1082','1735','1329','0165','0675','0676','0535','0801','0802','0800','1330','0118','1331','1332','1083','0018','0403','1084','0320','1333','1085','0404','0405','0536','0922','0254','0923','1507','0321','1086','1087','0803','1088','0255','0406','0924','0677','0256','0925','1089','0078','0102','0195','1230','0191','0353','0730','1231','0407','0926','1090','1091','0927','0645','0408','0322','1334','0323','1335','1336','0166','1092','0020','0678','1093','1094','0679','0537','0409','0538','0928','1095','0257','0929','0258','1096','1337','0539','1338','1339','0930','0680','0021','0804','0324','0410','0681','0079','0411','0588','1097','0682','1256','0540','1098','0684','1099','0541','0542','0413','0685','0167','0414','1340','1100','1659','1685','0882','0415','0325','0416','0543','1101','0417','0259','0022','0805','0023','0544','0545','0326','0080','0081','0546','0547','0548','1916','0549','0550','0995','0082','0327','0551','0260','1673','0806','0261','1102','0807','0694','0931','0418','1103','0733','1705','0932','0328','0553','0808','1104','0103','0140','0262','0329','1341','1105','1106','0809','0330','1107','0331','0024','0168','0810','0811','0332','0333','1342','1108','0334','0933','0934','0554','1671','0263','1109','0555','1110','0556','0935','1665','0812','0936','0686','0169','0419','0025','0264','0420','0026','1343','0557','0937','0993','0938','1111','1265','0813','0941','0939','1112','1113','0083','1987','0119','0940','1114','0942','0687','1344','0559','0421','0027','1842','1731','0688','1697','0028','0422','0814','0336','0564','0815','1259','0265','1709','0816','0647','0560','0561','0423','0562','1955','0335','0943','0944','0563','0424','0945','0029','0565','0425','1346','1740','1115','0426','0643','1347','0946','0266','0947','0304','1116','0427','0412','0566','0356','1120','0948','1121','0428','1117','0030','1249','1122','0567','0031','1119','0817','1118','0569','1123','0570','1348','0571','0170','0032','0572','0949','0573','1349','0690','0818','0337','0104','0121','0267','0268','0691','0819','0950','1695','1126','1127','0574','1699','0529','1128','0171','1350','1124','1125','1129','0575','0576','0577','0120','0820','0821','0578','1130','0302','0951','0952','0429','1131','0122','0822','0579','1132','0953','1150','0954','0823','0824','0269','0035','0036','0172','0173','0174','1773','0175','0000','0999','0881','1250','1351','1133','0825','1352','0692','0084','1134','1135','0033','0123','0826','1136','0580','0430','1137','1353','0085','0581','0431','0176','0270','0827','0432','0433','0086','0828','0829','1138','0434','0955','0582','0583','0584','1142','1356','1509','0695','0830','0435','0586','0436','0831','1139','1144','0038','0437','0644','0587','1143','0589','1145','1357','1146','0438','1147','1140','0696','1141','1355','1358','1148','0271','1734','1149','0697','0698','0272','1151','0590','0124','0765','1152','1153','1154','0699','0591','0594','1926','1155','0338','0592','0700','1359','0956','1156','0832','0439','0833','0273','0593','0177','0834','1157','0087','0835','1158','0595','1661','0703','1159','0274','0339','0701','0836','1667','0275','0340','1360','0596','0597','0837','1160','1361','1165','0646','0601','0602','0196','1672','0841','1166','1362','1258','0178','1742','0603','0842','1161','0702','1162','1163','0598','0125','1669','0957','0958','1670','0126','1674','0838','0959','0839','0276','0599','1363','0600','0277','0840','1364','0127','0128','0278','1164','1167','1365','1168','0604','0704','0960','0441','0843','1169','1366','0139','1367','0039','1368','0442','0605','0458','0443','0705','0279','1170','0606','0088','0844','0961','0962','1171','0963','0607','1369','1370','0706','0129','0608','0609','0444','1172','1173','1174','1676','1371','1175','1176','0964','0447','1261','0965','0708','1702','1372','0966','1178','1179','0445','0711','0845','0967','0846','0446','0712','1180','0968','1883','0051','0130','0969','0610','0040','0089','1181','1182','1714','0713','1698','0090','0131','0091','0341','1183','0342','0847','1184','0848','1185','1374','1186','0970','1375','0612','1187','0849','1177','1691','0709','1373','1188','1189','0179','1190','1191','1192','0037','1193','0850','0180','0714','1257','0092','0532','0041','0851','1376','0280','0181','1708','0182','0971','1194','1195','1377','0972','1196','0615','1197','1198','1378','0343','0973','1199','0616','1380','0617','1381','1201','1200','0974','0975','1382','0976','1383','0009','0480','0853','0042','0715','0093','0854','0448','1525','0716','0977','0281','1202','0618','0094','0855','1203','0183','1204','1205','1700','0449','1730','0737','0978','0282','0856','0857','0450','0451','0043','0044','0979','0045','0184','0980','0452','0046','0095','0344','1581','0981','0283','1252','0619','0994','0982','0720','0858','0284','0859','0047','0345','1384','0717','0860','0861','1206','1207','1208','0453','0454','0983','0984','1386','0862','1209','0620','0863','0621','1387','0346','0622','1210','0048','0132','1211','0347','0096','1212','1388','0864','0718','0623','0985','0986','0719','0185','0624','0625','0626','0285','0286','1213','0348','0133','0186','1390','1215','1216','1391','1214','0865','0287','0866','0867','0721','0288','1217','0627','1218','0289','0290','0187','0868','0987','0455','0049','0456','0628','0291','0869','0629','1219','0630','0852','0722','1393','1220','0188','0988','0457','1221','0292','0723','0870','1223','0459','0989','1394','1224','0097','0724','0134','0871','0558','0725','1701','0293','0726','1783','0631','0668','1395','0098','0614','0460','0461','1396','0189','0462','0463','0464','0296','1696','0469','0470','0190','1229','0352','0876','0991','0992','0634','1225','0872','0349','1226','0350','1227','1397','0465','0052','0053','0294','0295','1253','0727','0990','0873','1228','0632','0466','0728','0099','0100','0467','0880','0468','0633','0351','0874','0875','1398','0710','0101','0683','0729','0731','0471','0472','0479','1232','0297','0473','0707','0877','1233','0478','0050','0354','1234','0355','0298','1235','0299','0878','1399','0635','0636','1666','0732','0476','0300','0637','0638','1236','1237','1400','0639','1240','1402','0734','0996','0474','0056','0640','0136','1401','1241','1238','1239','1403','0137','0735','1242','1243','0879','0301','0475','1244','0641','1896','0192','0138','0642','0193','1245') UNION -- distinct select bkwi_id, bkwi_volgnr from sbrquery.v_adres_ms_b where code_gemeente in ('0390','1320','0517','0518','0787','0666','0519','1321','0669','0670','0671','1326','0796','0054','1680','1000','0738','0358','1001','0197','0648','1002','0739','0359','0481','0305','1003','1004','1301','1302','0059','1005','1303','1304','0001','0002','1006','0360','0482','0613','0477','1007','0483','0361','0141','0034','0740','1008','0484','1723','0741','1009','0142','1010','1011','1679','1012','1013','0883','0485','0060','0306','0307','0486','0198','0362','0884','0363','0742','0364','0199','1014','0105','0366','0200','0201','0003','0885','0487','0649','0202','0488','0106','0367','0743','0368','0143','0650','0061','1015','0651','0744','0308','0886','0004','0745','1016','1246','0489','0203','0062','0369','1017','0204','1018','0144','0005','0887','0888','1247','0746','0370','0747','0006','0205','0889','0371','0107','0890','0007','1019','0891','0206','0372','0309','1305','0490','0491','1724','0893','0373','0748','0892','0749','0207','0208','0750','0492','0493','0751','1859','1306','0494','0374','0752','1721','0568','1020','0753','1021','0209','0210','0375','1307','0008','0652','1308','1022','1309','0894','0585','1728','0754','0145','0376','0495','1262','0496','0377','0378','0146','0055','0895','0497','0755','1023','0064','1025','0057','0211','0108','1681','0896','1026','0897','0147','0654','1254','1027','0499','0379','0756','0757','0212','0500','0758','0194','0655','0311','1028','1029','0501','1030','0898','0380','1031','1032','1876','0656','0657','0213','0899','0759','1033','1034','0998','0900','0312','0313','0214','1035','0381','0215','1310','0901','0658','0382','1036','0502','0383','0997','0760','1037','1311','0659','0109','1038','0314','1706','0611','1039','1684','0761','0216','0110','0148','0065','1312','0310','0217','1040','0503','0010','0552','1663','1345','1024','0768','0149','0159','0400','1404','0440','0736','0762','1041','1042','1385','0150','1392','1222','0135','1690','0218','1043','0384','0151','0152','0763','0111','1774','0764','1044','0219','0504','0220','0221','0222','0066','0660','1045','0766','0058','0067','0315','0223','1046','0505','1313','0498','1047','0224','1048','0316','0506','1248','0661','1719','1049','1263','0303','0767','0225','0507','1314','0662','0226','1050','1051','0769','1264','0112','0902','0227','1711','1315','0385','0228','1052','0113','0317','1651','0011','0770','0771','1255','0357','0386','0387','0229','0905','0772','0230','1053','1054','0663','0903','0231','1055','0114','1056','0773','0774','0388','0153','0232','0233','0775','0776','1057','0234','1316','1251','0777','0508','0235','0904','0012','0068','1722','0778','0013','0069','0070','0071','0653','1058','1317','1059','0115','0779','0509','0780','0236','0781','1771','0906','0782','1652','1060','0237','0238','0154','0907','1318','1061','0908','0783','0510','1063','0689','1062','0116','0155','0784','1064','0511','0664','1319','0785','0156','0512','0239','0513','0514','0515','0516','0693','0665','1065','0389','0365','0157','0909','0786','0910','0016','1067','0667','1322','0240','0241','1323','0014','0911','0520','0391','0015','1066','1324','0912','0913','1729','0242','0158','1068','0788','0392','1325','0393','0394','1069','0521','0914','0522','1655','0789','0790','0160','0243','1070','0523','0017','0395','0072','0318','0073','0161','0244','0117','0524','0245','1071','1937','0915','0396','0397','0525','0916','0246','0074','0247','0398','0526','0917','1327','0791','1072','0792','0793','1658','0019','0527','1073','0399','0528','0672','0162','1074','1075','0918','0163','0530','0794','0795','0075','1260','1076','0531','0248','0164','1077','0076','0401','1078','1079','1080','0919','0249','0250','0063','0251','0533','0252','0797','0920','1081','0534','0798','0402','0077','1328','0673','0674','0319','0921','0253','0799','1082','1735','1329','0165','0675','0676','0535','0801','0802','0800','1330','0118','1331','1332','1083','0018','0403','1084','0320','1333','1085','0404','0405','0536','0922','0254','0923','1507','0321','1086','1087','0803','1088','0255','0406','0924','0677','0256','0925','1089','0078','0102','0195','1230','0191','0353','0730','1231','0407','0926','1090','1091','0927','0645','0408','0322','1334','0323','1335','1336','0166','1092','0020','0678','1093','1094','0679','0537','0409','0538','0928','1095','0257','0929','0258','1096','1337','0539','1338','1339','0930','0680','0021','0804','0324','0410','0681','0079','0411','0588','1097','0682','1256','0540','1098','0684','1099','0541','0542','0413','0685','0167','0414','1340','1100','1659','1685','0882','0415','0325','0416','0543','1101','0417','0259','0022','0805','0023','0544','0545','0326','0080','0081','0546','0547','0548','1916','0549','0550','0995','0082','0327','0551','0260','1673','0806','0261','1102','0807','0694','0931','0418','1103','0733','1705','0932','0328','0553','0808','1104','0103','0140','0262','0329','1341','1105','1106','0809','0330','1107','0331','0024','0168','0810','0811','0332','0333','1342','1108','0334','0933','0934','0554','1671','0263','1109','0555','1110','0556','0935','1665','0812','0936','0686','0169','0419','0025','0264','0420','0026','1343','0557','0937','0993','0938','1111','1265','0813','0941','0939','1112','1113','0083','1987','0119','0940','1114','0942','0687','1344','0559','0421','0027','1842','1731','0688','1697','0028','0422','0814','0336','0564','0815','1259','0265','1709','0816','0647','0560','0561','0423','0562','1955','0335','0943','0944','0563','0424','0945','0029','0565','0425','1346','1740','1115','0426','0643','1347','0946','0266','0947','0304','1116','0427','0412','0566','0356','1120','0948','1121','0428','1117','0030','1249','1122','0567','0031','1119','0817','1118','0569','1123','0570','1348','0571','0170','0032','0572','0949','0573','1349','0690','0818','0337','0104','0121','0267','0268','0691','0819','0950','1695','1126','1127','0574','1699','0529','1128','0171','1350','1124','1125','1129','0575','0576','0577','0120','0820','0821','0578','1130','0302','0951','0952','0429','1131','0122','0822','0579','1132','0953','1150','0954','0823','0824','0269','0035','0036','0172','0173','0174','1773','0175','0000','0999','0881','1250','1351','1133','0825','1352','0692','0084','1134','1135','0033','0123','0826','1136','0580','0430','1137','1353','0085','0581','0431','0176','0270','0827','0432','0433','0086','0828','0829','1138','0434','0955','0582','0583','0584','1142','1356','1509','0695','0830','0435','0586','0436','0831','1139','1144','0038','0437','0644','0587','1143','0589','1145','1357','1146','0438','1147','1140','0696','1141','1355','1358','1148','0271','1734','1149','0697','0698','0272','1151','0590','0124','0765','1152','1153','1154','0699','0591','0594','1926','1155','0338','0592','0700','1359','0956','1156','0832','0439','0833','0273','0593','0177','0834','1157','0087','0835','1158','0595','1661','0703','1159','0274','0339','0701','0836','1667','0275','0340','1360','0596','0597','0837','1160','1361','1165','0646','0601','0602','0196','1672','0841','1166','1362','1258','0178','1742','0603','0842','1161','0702','1162','1163','0598','0125','1669','0957','0958','1670','0126','1674','0838','0959','0839','0276','0599','1363','0600','0277','0840','1364','0127','0128','0278','1164','1167','1365','1168','0604','0704','0960','0441','0843','1169','1366','0139','1367','0039','1368','0442','0605','0458','0443','0705','0279','1170','0606','0088','0844','0961','0962','1171','0963','0607','1369','1370','0706','0129','0608','0609','0444','1172','1173','1174','1676','1371','1175','1176','0964','0447','1261','0965','0708','1702','1372','0966','1178','1179','0445','0711','0845','0967','0846','0446','0712','1180','0968','1883','0051','0130','0969','0610','0040','0089','1181','1182','1714','0713','1698','0090','0131','0091','0341','1183','0342','0847','1184','0848','1185','1374','1186','0970','1375','0612','1187','0849','1177','1691','0709','1373','1188','1189','0179','1190','1191','1192','0037','1193','0850','0180','0714','1257','0092','0532','0041','0851','1376','0280','0181','1708','0182','0971','1194','1195','1377','0972','1196','0615','1197','1198','1378','0343','0973','1199','0616','1380','0617','1381','1201','1200','0974','0975','1382','0976','1383','0009','0480','0853','0042','0715','0093','0854','0448','1525','0716','0977','0281','1202','0618','0094','0855','1203','0183','1204','1205','1700','0449','1730','0737','0978','0282','0856','0857','0450','0451','0043','0044','0979','0045','0184','0980','0452','0046','0095','0344','1581','0981','0283','1252','0619','0994','0982','0720','0858','0284','0859','0047','0345','1384','0717','0860','0861','1206','1207','1208','0453','0454','0983','0984','1386','0862','1209','0620','0863','0621','1387','0346','0622','1210','0048','0132','1211','0347','0096','1212','1388','0864','0718','0623','0985','0986','0719','0185','0624','0625','0626','0285','0286','1213','0348','0133','0186','1390','1215','1216','1391','1214','0865','0287','0866','0867','0721','0288','1217','0627','1218','0289','0290','0187','0868','0987','0455','0049','0456','0628','0291','0869','0629','1219','0630','0852','0722','1393','1220','0188','0988','0457','1221','0292','0723','0870','1223','0459','0989','1394','1224','0097','0724','0134','0871','0558','0725','1701','0293','0726','1783','0631','0668','1395','0098','0614','0460','0461','1396','0189','0462','0463','0464','0296','1696','0469','0470','0190','1229','0352','0876','0991','0992','0634','1225','0872','0349','1226','0350','1227','1397','0465','0052','0053','0294','0295','1253','0727','0990','0873','1228','0632','0466','0728','0099','0100','0467','0880','0468','0633','0351','0874','0875','1398','0710','0101','0683','0729','0731','0471','0472','0479','1232','0297','0473','0707','0877','1233','0478','0050','0354','1234','0355','0298','1235','0299','0878','1399','0635','0636','1666','0732','0476','0300','0637','0638','1236','1237','1400','0639','1240','1402','0734','0996','0474','0056','0640','0136','1401','1241','1238','1239','1403','0137','0735','1242','1243','0879','0301','0475','1244','0641','1896','0192','0138','0642','0193','1245') ) uu on (uu.bkwi_id = ee.bkwi_id and uu.bkwi_volgnr = ee.bkwi_volgnr) where cc.klasse_werkzame_personen in ('01','02','03','04','05','06','07','08','09','10','11','12','99') and cc.type in ('O','R','S','V','X') and cc.rechtsvorm in ('0','10','100','101','102','103','104','105','106','110','111','112','113','114','115','116','120','130','140','150','160','161','162','170','171','172','180','190','191','192','20','200','201','202','21','22','23','30','31','40','41','42','43','50','60','61','62','70','71','72','80','90','91','92','980','990') and ee.cwi_code_district in ('15000','11000','14000','12000','13000','16000') and ee.cwi_code_cwi in ('13030','14010','12010','15010','15020','15030','14020','14030','14040','14060','14070','14090','14100','12020','12030','12040','11020','12050','16010','13010','16020','11010','15040','11030','12200','14121','15050','15060','15070','15080','14120','12060','12070','11040','16040','11140','15140','12080','13040','13210','11050','12090','16050','11060','16060','15110','11080','11070','13050','14130','12100','12110','11090','13060','16080','12130','15100','16110','11100','11110','14110','16030','13080','13020','11120','15120','15200','15130','13100','13090','14150','15090','15160','16180','12140','12120','11130','15170','12150','12180','16201','16100','13070','16070','12220','13110','16120','16140','16160','16170','16130','16150','14180','13120','11150','15180','16190','11160','12160','16200','16062','12170','13130','12190','15190','15210','13150','11180','15220','13160','13170','13180','15051','13190','16090','14170','13200','14160','15150','11190','11031','14190','12171','15230','16061','15240','12210') and ee.klasse_werkzame_personen in ('01','02','03','04','05','06','07','08','09','10','11','12','99') and ee.type in ('1','2') and ee.code_provincie in ('D','X','B','G','A','K','P','L','E','M','S','H') order by ee.bkwi_id, ee.bkwi_volgnr