Yes, sure. Version : Query Tool 22.0.455 PROD+3713
Script
Creation script with some data below.
Script
-- --------------------------------------------------------
-- Host: 172.22.50.1
-- Server version: 5.1.39-community - MySQL Community Server (GPL)
-- Server OS: Win32
-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping database structure for ecat
CREATE DATABASE IF NOT EXISTS `ecat` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ecat`;
-- Dumping structure for table ecat.tbllog
CREATE TABLE IF NOT EXISTS `tbllog` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`BeginVerbruik` int(11) DEFAULT '0',
`EindVerbruik` int(11) DEFAULT '0',
`GastID` int(11) DEFAULT '0',
`LocatieID` int(11) DEFAULT '0',
`KaartNummer` int(11) DEFAULT '0',
`Result` int(11) DEFAULT '0',
`BeginDatumTijd` datetime DEFAULT NULL,
`EindDatumTijd` datetime DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `GastID` (`GastID`),
KEY `LocatieID` (`LocatieID`),
KEY `Result` (`Result`)
) ENGINE=InnoDB AUTO_INCREMENT=1493828 DEFAULT CHARSET=utf8;
-- Dumping data for table ecat.tbllog: ~385 536 rows (approximately)
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(658, 0, 3, 0, 0, 0, 0, NULL, '2014-03-27 10:21:50'),
(660, 0, 5, 0, 0, 0, 0, NULL, '2014-03-27 10:26:59'),
(662, 0, 7, 0, 0, 0, 0, NULL, '2014-03-27 10:40:44'),
(664, 0, 8, 0, 0, 0, 0, NULL, '2014-03-27 11:20:47'),
(667, 0, 6, 0, 0, 0, 0, NULL, '2014-03-27 11:27:27'),
(673, 0, 10479, 0, 0, 0, 0, NULL, '2014-03-27 12:05:13'),
(682, 0, 20, 0, 0, 0, 0, NULL, '2014-03-27 15:26:24'),
(686, 0, 749, 0, 0, 0, 0, NULL, '2014-03-28 09:03:27'),
(690, 0, 679, 0, 0, 0, 0, NULL, '2014-03-28 11:02:05'),
(697, 0, 1006, 0, 0, 0, 0, NULL, '2014-03-28 11:47:08'),
(698, 0, 22, 0, 0, 0, 0, NULL, '2014-03-28 11:48:36'),
(701, 0, 6, 0, 0, 0, 0, NULL, '2014-03-28 12:26:46'),
(714, 0, 1, 0, 0, 0, 0, NULL, '2014-03-28 16:04:54'),
(716, 0, 1, 0, 0, 0, 0, NULL, '2014-03-28 16:07:31'),
(719, 0, 327, 0, 0, 0, 0, NULL, '2014-03-28 19:01:56'),
(720, 0, 10015, 0, 0, 0, 0, NULL, '2014-03-29 09:38:53'),
(723, 0, 1757, 0, 0, 0, 0, NULL, '2014-03-29 09:56:32'),
(727, 0, 1769, 0, 0, 0, 0, NULL, '2014-03-29 09:59:03'),
(729, 0, 1780, 0, 0, 0, 0, NULL, '2014-03-29 10:01:28'),
(731, 0, 36890, 0, 0, 0, 0, NULL, '2014-03-29 11:12:17'),
(734, 0, 7617, 0, 0, 0, 0, NULL, '2014-03-29 11:45:51'),
(748, 0, 1, 0, 0, 0, 0, NULL, '2014-03-29 16:22:27'),
(749, 0, 42, 0, 0, 0, 0, NULL, '2014-03-29 16:27:38'),
(751, 0, 36890, 0, 0, 0, 0, NULL, '2014-03-29 17:05:23'),
(765, 0, 9, 0, 0, 0, 0, NULL, '2014-03-29 18:42:41'),
(769, 0, 9, 0, 0, 0, 0, NULL, '2014-03-29 18:52:06'),
(772, 0, 169217, 0, 0, 0, 0, NULL, '2014-03-30 10:13:33'),
(773, 0, 620, 0, 0, 0, 0, NULL, '2014-03-30 10:43:58'),
(774, 0, 14039, 0, 0, 0, 0, NULL, '2014-03-30 10:59:05'),
(775, 0, 1030, 0, 0, 0, 0, NULL, '2014-03-30 11:34:13'),
(776, 0, 0, 0, 0, 0, 0, NULL, '2014-03-30 11:36:19'),
(777, 0, 30889, 0, 0, 0, 0, NULL, '2014-03-30 12:30:28'),
(781, 0, 397, 0, 0, 0, 0, NULL, '2014-03-30 13:07:11'),
(784, 0, 4408, 0, 0, 0, 0, NULL, '2014-03-30 13:24:38'),
(788, 0, 10291, 0, 0, 0, 0, NULL, '2014-03-30 14:36:09'),
(793, 0, 23645, 0, 0, 0, 0, NULL, '2014-03-30 15:16:14'),
(795, 0, 18836, 0, 0, 0, 0, NULL, '2014-03-30 16:31:36'),
(807, 0, 7005, 0, 0, 0, 0, NULL, '2014-03-30 17:36:25'),
(810, 0, 7686, 0, 0, 0, 0, NULL, '2014-03-31 10:33:04'),
(814, 0, 6, 0, 0, 0, 0, NULL, '2014-03-31 13:38:12'),
(819, 0, 12, 0, 0, 0, 0, NULL, '2014-03-31 15:38:20'),
(823, 0, 183873, 0, 0, 0, 0, NULL, '2014-03-31 18:06:07'),
(830, 0, 4190, 0, 0, 0, 0, NULL, '2014-04-01 15:53:38'),
(864, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:05:33'),
(868, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:24:25'),
(871, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:26:20'),
(873, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:28:36'),
(875, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:29:50'),
(893, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 14:19:53'),
(899, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 15:02:21'),
(904, 0, 254, 0, 0, 0, 0, NULL, '2014-04-02 16:06:52'),
(909, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 18:16:59'),
(910, 0, 1059, 0, 0, 0, 0, NULL, '2014-04-02 18:32:58'),
(911, 0, 890, 0, 0, 0, 0, NULL, '2014-04-02 19:08:44'),
(914, 0, 3, 0, 0, 0, 0, NULL, '2014-04-03 10:25:05'),
(921, 0, 7732, 0, 0, 0, 0, NULL, '2014-04-03 14:26:06'),
(922, 0, 17928, 0, 0, 0, 0, NULL, '2014-04-03 14:58:55'),
(928, 0, 18562, 0, 0, 0, 0, NULL, '2014-04-03 15:48:49'),
(930, 0, 7757, 0, 0, 0, 0, NULL, '2014-04-03 16:11:25'),
(931, 0, 18910, 0, 0, 0, 0, NULL, '2014-04-03 16:17:39'),
(933, 0, 19567, 0, 0, 0, 0, NULL, '2014-04-03 16:57:47'),
(936, 0, 1971, 0, 0, 0, 0, NULL, '2014-04-03 17:06:14'),
(939, 0, 7056, 0, 0, 0, 0, NULL, '2014-04-03 17:57:20'),
(947, 0, 4408, 0, 0, 0, 0, NULL, '2014-04-04 12:06:00'),
(949, 0, 4413, 0, 0, 0, 0, NULL, '2014-04-04 12:14:17'),
(955, 0, 17, 0, 0, 0, 0, NULL, '2014-04-04 12:58:37'),
(957, 0, 4414, 0, 0, 0, 0, NULL, '2014-04-04 13:24:31'),
(963, 0, 25105, 0, 0, 0, 0, NULL, '2014-04-04 15:05:02'),
(968, 0, 1, 0, 0, 0, 0, NULL, '2014-04-04 15:52:34'),
(972, 0, 1, 0, 0, 0, 0, NULL, '2014-04-04 16:07:17'),
(974, 0, 30696, 0, 0, 0, 0, NULL, '2014-04-04 17:03:20'),
(976, 0, 4752, 0, 0, 0, 0, NULL, '2014-04-04 17:42:00'),
(982, 0, 3, 0, 0, 0, 0, NULL, '2014-04-05 10:23:39'),
(984, 0, 3, 0, 0, 0, 0, NULL, '2014-04-05 10:27:02'),
(986, 0, 8951, 0, 0, 0, 0, NULL, '2014-04-05 11:10:19');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(987, 0, 2872, 0, 0, 0, 0, NULL, '2014-04-05 11:17:55'),
(988, 0, 15392, 0, 0, 0, 0, NULL, '2014-04-05 11:20:41'),
(989, 0, 31152, 0, 0, 0, 0, NULL, '2014-04-05 11:28:47'),
(993, 0, 9334, 0, 0, 0, 0, NULL, '2014-04-05 12:12:30'),
(995, 0, 9, 0, 0, 0, 0, NULL, '2014-04-05 12:15:14'),
(999, 0, 10, 0, 0, 0, 0, NULL, '2014-04-05 12:17:20'),
(1001, 0, 10, 0, 0, 0, 0, NULL, '2014-04-05 12:18:44'),
(1004, 0, 434, 0, 0, 0, 0, NULL, '2014-04-05 13:10:17'),
(1005, 0, 5530, 0, 0, 0, 0, NULL, '2014-04-05 13:15:40'),
(1006, 0, 2557, 0, 0, 0, 0, NULL, '2014-04-05 13:24:57'),
(1011, 0, 294, 0, 0, 0, 0, NULL, '2014-04-05 14:40:51'),
(1012, 0, 6677, 0, 0, 0, 0, NULL, '2014-04-05 15:01:50'),
(1014, 0, 7676, 0, 0, 0, 0, NULL, '2014-04-05 15:12:50'),
(1016, 0, 2, 0, 0, 0, 0, NULL, '2014-04-05 15:14:37'),
(1019, 0, 2, 0, 0, 0, 0, NULL, '2014-04-05 15:16:44'),
(1026, 0, 824, 0, 0, 0, 0, NULL, '2014-04-05 15:21:01'),
(1027, 0, 1761, 0, 0, 0, 0, NULL, '2014-04-05 15:34:39'),
(1032, 0, 777, 0, 0, 0, 0, NULL, '2014-04-05 18:51:59'),
(1034, 0, 4713, 0, 0, 0, 0, NULL, '2014-04-06 11:29:03'),
(1035, 0, 224354, 0, 0, 0, 0, NULL, '2014-04-06 11:39:15'),
(1037, 0, 54955, 0, 0, 0, 0, NULL, '2014-04-06 11:48:11'),
(1038, 0, 2042, 0, 0, 0, 0, NULL, '2014-04-06 12:02:07'),
(1043, 0, 407, 0, 0, 0, 0, NULL, '2014-04-06 14:38:43'),
(1048, 0, 5110, 0, 0, 0, 0, NULL, '2014-04-06 15:07:12'),
(1051, 0, 785, 0, 0, 0, 0, NULL, '2014-04-06 15:20:19'),
(1054, 0, 17238, 0, 0, 0, 0, NULL, '2014-04-06 15:35:38'),
(1055, 0, 254, 0, 0, 0, 0, NULL, '2014-04-06 15:36:07'),
(1067, 0, 55, 0, 0, 0, 0, NULL, '2014-04-06 17:08:06'),
(1075, 0, 2, 0, 0, 0, 0, NULL, '2014-04-06 17:36:59'),
(1077, 0, 54978, 0, 0, 0, 0, NULL, '2014-04-06 17:46:58'),
(1078, 0, 586, 0, 0, 0, 0, NULL, '2014-04-06 18:26:52'),
(1088, 0, 33989, 0, 0, 0, 0, NULL, '2014-04-08 15:40:13'),
(1092, 0, 11944, 0, 0, 0, 0, NULL, '2014-04-09 11:08:12'),
(1094, 0, 5015, 0, 0, 0, 0, NULL, '2014-04-09 11:47:43'),
(1100, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:10:51'),
(1102, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:14:32'),
(1104, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:18:16'),
(1106, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:29:48'),
(1113, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:35:53'),
(1115, 0, 1, 0, 0, 0, 0, NULL, '2014-04-09 12:40:06'),
(1126, 0, 1900, 0, 0, 0, 0, NULL, '2014-04-09 16:29:44'),
(1130, 0, 97, 0, 0, 0, 0, NULL, '2014-04-09 20:02:50'),
(1131, 0, 6220, 0, 0, 0, 0, NULL, '2014-04-10 08:45:26'),
(1134, 0, 15365, 0, 0, 0, 0, NULL, '2014-04-10 11:26:28'),
(1135, 0, 3469, 0, 0, 0, 0, NULL, '2014-04-10 11:30:51'),
(1136, 0, 260018, 0, 0, 0, 0, NULL, '2014-04-10 11:41:27'),
(1138, 0, 19883, 0, 0, 0, 0, NULL, '2014-04-10 13:13:54'),
(1142, 0, 3626, 0, 0, 0, 0, NULL, '2014-04-10 15:34:39'),
(1143, 0, 8785, 0, 0, 0, 0, NULL, '2014-04-10 20:38:36'),
(1147, 0, 8785, 0, 0, 0, 0, NULL, '2014-04-11 09:18:51'),
(1150, 0, 8785, 0, 0, 0, 0, NULL, '2014-04-11 09:23:42'),
(1163, 0, 9588, 0, 0, 0, 0, NULL, '2014-04-11 14:16:35'),
(1164, 0, 19446, 0, 0, 0, 0, NULL, '2014-04-11 14:33:45'),
(1167, 0, 21442, 0, 0, 0, 0, NULL, '2014-04-11 15:25:42'),
(1170, 0, 61784, 0, 0, 0, 0, NULL, '2014-04-11 15:37:07'),
(1173, 0, 8263, 0, 0, 0, 0, NULL, '2014-04-11 16:21:10'),
(1178, 0, 9604, 0, 0, 0, 0, NULL, '2014-04-11 16:59:23'),
(1181, 0, 14228, 0, 0, 0, 0, NULL, '2014-04-11 18:19:39'),
(1183, 0, 10047, 0, 0, 0, 0, NULL, '2014-04-12 08:41:53'),
(1186, 0, 3, 0, 0, 0, 0, NULL, '2014-04-12 09:52:34'),
(1192, 0, 56620, 0, 0, 0, 0, NULL, '2014-04-12 10:46:20'),
(1195, 0, 7142, 0, 0, 0, 0, NULL, '2014-04-12 10:52:00'),
(1198, 0, 3877, 0, 0, 0, 0, NULL, '2014-04-12 11:13:36'),
(1199, 0, 5323, 0, 0, 0, 0, NULL, '2014-04-12 11:26:19'),
(1200, 0, 2033, 0, 0, 0, 0, NULL, '2014-04-12 11:35:51'),
(1202, 0, 4842, 0, 0, 0, 0, NULL, '2014-04-12 12:01:11'),
(1204, 0, 480, 0, 0, 0, 0, NULL, '2014-04-12 12:42:38'),
(1212, 0, 1354, 0, 0, 0, 0, NULL, '2014-04-12 13:21:36'),
(1214, 0, 16846, 0, 0, 0, 0, NULL, '2014-04-12 13:29:21'),
(1216, 0, 3979, 0, 0, 0, 0, NULL, '2014-04-12 13:37:39'),
(1227, 0, 2622, 0, 0, 0, 0, NULL, '2014-04-12 14:40:04'),
(1228, 0, 10374, 0, 0, 0, 0, NULL, '2014-04-12 14:44:09'),
(1233, 0, 475, 0, 0, 0, 0, NULL, '2014-04-12 15:12:50'),
(1238, 0, 2522, 0, 0, 0, 0, NULL, '2014-04-12 15:33:11');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(1242, 0, 3817, 0, 0, 0, 0, NULL, '2014-04-12 16:01:18'),
(1256, 0, 15856, 0, 0, 0, 0, NULL, '2014-04-13 11:27:32'),
(1265, 0, 4936, 0, 0, 0, 0, NULL, '2014-04-13 13:04:20'),
(1267, 0, 23980, 0, 0, 0, 0, NULL, '2014-04-13 13:16:04'),
(1278, 0, 55, 0, 0, 0, 0, NULL, '2014-04-13 13:46:19'),
(1279, 0, 3, 0, 0, 0, 0, NULL, '2014-04-13 13:48:01'),
(1294, 0, 170, 0, 0, 0, 0, NULL, '2014-04-13 16:00:46'),
(1296, 0, 498, 0, 0, 0, 0, NULL, '2014-04-13 16:20:38'),
(1299, 0, 3817, 0, 0, 0, 0, NULL, '2014-04-14 12:22:36'),
(1305, 0, 11533, 0, 0, 0, 0, NULL, '2014-04-15 15:14:43'),
(1306, 0, 301519, 0, 0, 0, 0, NULL, '2014-04-15 18:17:15'),
(1312, 0, 28137, 0, 0, 0, 0, NULL, '2014-04-16 10:09:50'),
(1314, 0, 1, 0, 0, 0, 0, NULL, '2014-04-16 10:33:18'),
(1316, 0, 15325, 0, 0, 0, 0, NULL, '2014-04-16 10:56:05'),
(1319, 0, 4687, 0, 0, 0, 0, NULL, '2014-04-16 11:22:01'),
(1320, 0, 16960, 0, 0, 0, 0, NULL, '2014-04-16 11:42:27'),
(1326, 0, 2, 0, 0, 0, 0, NULL, '2014-04-16 13:44:55'),
(1327, 0, 190, 0, 0, 0, 0, NULL, '2014-04-16 13:53:40'),
(1331, 0, 1348, 0, 0, 0, 0, NULL, '2014-04-16 14:12:25'),
(1333, 0, 1348, 0, 0, 0, 0, NULL, '2014-04-16 14:19:32'),
(1335, 0, 1350, 0, 0, 0, 0, NULL, '2014-04-16 14:23:30'),
(1337, 0, 1351, 0, 0, 0, 0, NULL, '2014-04-16 14:25:13'),
(1340, 0, 288, 0, 0, 0, 0, NULL, '2014-04-16 14:26:38'),
(1343, 0, 15220, 0, 0, 0, 0, NULL, '2014-04-16 16:29:58'),
(1345, 0, 2393, 0, 0, 0, 0, NULL, '2014-04-16 17:42:57'),
(1347, 0, 22083, 0, 0, 0, 0, NULL, '2014-04-16 18:41:29'),
(1348, 0, 6848, 0, 0, 0, 0, NULL, '2014-04-16 18:42:51'),
(1349, 0, 4552, 0, 0, 0, 0, NULL, '2014-04-16 18:42:54'),
(1350, 0, 3686, 0, 0, 0, 0, NULL, '2014-04-16 18:43:28'),
(1351, 0, 7248, 0, 0, 0, 0, NULL, '2014-04-16 18:44:11'),
(1352, 0, 6440, 0, 0, 0, 0, NULL, '2014-04-16 18:46:54'),
(1353, 0, 12017, 0, 0, 0, 0, NULL, '2014-04-16 18:50:49'),
(1354, 0, 13247, 0, 0, 0, 0, NULL, '2014-04-16 18:59:33'),
(1355, 0, 311629, 0, 0, 0, 0, NULL, '2014-04-16 19:06:15'),
(1363, 0, 22101, 0, 0, 0, 0, NULL, '2014-04-17 09:13:39'),
(1366, 0, 7686, 0, 0, 0, 0, NULL, '2014-04-17 09:51:53'),
(1368, 0, 7686, 0, 0, 0, 0, NULL, '2014-04-17 09:52:49'),
(1370, 0, 7686, 0, 0, 0, 0, NULL, '2014-04-17 09:54:37'),
(1373, 0, 6635, 0, 0, 0, 0, NULL, '2014-04-17 09:57:11'),
(1388, 0, 29779, 0, 0, 0, 0, NULL, '2014-04-17 10:32:54'),
(1391, 0, 2144, 0, 0, 0, 0, NULL, '2014-04-17 10:37:43'),
(1405, 0, 29779, 0, 0, 0, 0, NULL, '2014-04-17 11:16:41'),
(1418, 0, 4, 0, 0, 0, 0, NULL, '2014-04-17 11:42:16'),
(1426, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:24:59'),
(1430, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:26:46'),
(1432, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:28:33'),
(1434, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:33:46'),
(1458, 0, 1317, 0, 0, 0, 0, NULL, '2014-04-17 13:53:08'),
(1459, 0, 179, 0, 0, 0, 0, NULL, '2014-04-17 13:53:30'),
(1463, 0, 22992, 0, 0, 0, 0, NULL, '2014-04-17 14:05:22'),
(1470, 0, 65923, 0, 0, 0, 0, NULL, '2014-04-17 14:26:20'),
(1473, 0, 8589, 0, 0, 0, 0, NULL, '2014-04-17 14:30:42'),
(1475, 0, 325, 0, 0, 0, 0, NULL, '2014-04-17 15:45:44'),
(1478, 0, 3234, 0, 0, 0, 0, NULL, '2014-04-17 17:18:15'),
(1479, 0, 44170, 0, 0, 0, 0, NULL, '2014-04-17 18:07:44'),
(1485, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 22:09:58'),
(1486, 0, 7224, 0, 0, 0, 0, NULL, '2014-04-17 22:18:39'),
(1487, 0, 7950, 0, 0, 0, 0, NULL, '2014-04-17 22:18:51'),
(1489, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 22:22:34'),
(1493, 0, 1, 0, 0, 0, 0, NULL, '2014-04-18 09:11:09'),
(1495, 0, 1, 0, 0, 0, 0, NULL, '2014-04-18 09:32:55'),
(1500, 0, 27359, 0, 0, 0, 0, NULL, '2014-04-18 11:08:16'),
(1503, 0, 772, 0, 0, 0, 0, NULL, '2014-04-18 12:20:34'),
(1506, 0, 6601, 0, 0, 0, 0, NULL, '2014-04-18 12:49:31'),
(1523, 0, 8204, 0, 0, 0, 0, NULL, '2014-04-18 21:31:55'),
(1524, 0, 29106, 0, 0, 0, 0, NULL, '2014-04-19 09:20:39'),
(1526, 0, 2811, 0, 0, 0, 0, NULL, '2014-04-19 10:13:46'),
(1527, 0, 4783, 0, 0, 0, 0, NULL, '2014-04-19 10:41:19'),
(1528, 0, 5961, 0, 0, 0, 0, NULL, '2014-04-19 10:49:40'),
(1529, 0, 10123, 0, 0, 0, 0, NULL, '2014-04-19 11:04:55'),
(1530, 0, 9703, 0, 0, 0, 0, NULL, '2014-04-19 11:09:01'),
(1531, 0, 2296, 0, 0, 0, 0, NULL, '2014-04-19 11:09:08'),
(1533, 0, 10199, 0, 0, 0, 0, NULL, '2014-04-19 11:19:46'),
(1535, 0, 6321, 0, 0, 0, 0, NULL, '2014-04-19 11:37:58');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(1537, 0, 1, 0, 0, 0, 0, NULL, '2014-04-19 11:39:24'),
(1538, 0, 20146, 0, 0, 0, 0, NULL, '2014-04-19 11:40:48'),
(1539, 0, 15330, 0, 0, 0, 0, NULL, '2014-04-19 11:43:13'),
(1541, 0, 8834, 0, 0, 0, 0, NULL, '2014-04-19 11:47:33'),
(1543, 0, 18532, 0, 0, 0, 0, NULL, '2014-04-19 12:20:26'),
(1545, 0, 12151, 0, 0, 0, 0, NULL, '2014-04-19 12:23:26'),
(1546, 0, 49557, 0, 0, 0, 0, NULL, '2014-04-19 12:34:09'),
(1547, 0, 9909, 0, 0, 0, 0, NULL, '2014-04-19 12:49:47'),
(1549, 0, 20173, 0, 0, 0, 0, NULL, '2014-04-19 13:13:10'),
(1551, 0, 23118, 0, 0, 0, 0, NULL, '2014-04-19 13:14:45'),
(1552, 0, 1, 0, 0, 0, 0, NULL, '2014-04-19 13:15:54'),
(1553, 0, 17384, 0, 0, 0, 0, NULL, '2014-04-19 13:23:32'),
(1555, 0, 11525, 0, 0, 0, 0, NULL, '2014-04-19 13:55:06'),
(1557, 0, 6623, 0, 0, 0, 0, NULL, '2014-04-19 14:33:38'),
(1560, 0, 7667, 0, 0, 0, 0, NULL, '2014-04-19 14:55:42'),
(1561, 0, 4845, 0, 0, 0, 0, NULL, '2014-04-19 15:15:26'),
(1565, 0, 10617, 0, 0, 0, 0, NULL, '2014-04-19 15:40:59'),
(1569, 0, 1816, 0, 0, 0, 0, NULL, '2014-04-19 17:33:41'),
(1570, 0, 12494, 0, 0, 0, 0, NULL, '2014-04-19 17:47:04'),
(1578, 0, 19, 0, 0, 0, 0, NULL, '2014-04-20 09:36:53'),
(1580, 0, 10903, 0, 0, 0, 0, NULL, '2014-04-20 09:59:02'),
(1581, 0, 3159, 0, 0, 0, 0, NULL, '2014-04-20 10:25:26'),
(1582, 0, 16693, 0, 0, 0, 0, NULL, '2014-04-20 10:30:57'),
(1585, 0, 5866, 0, 0, 0, 0, NULL, '2014-04-20 11:14:28'),
(1586, 0, 118, 0, 0, 0, 0, NULL, '2014-04-20 11:28:12'),
(1587, 0, 5199, 0, 0, 0, 0, NULL, '2014-04-20 11:28:36'),
(1589, 0, 13392, 0, 0, 0, 0, NULL, '2014-04-20 11:55:24'),
(1590, 0, 8649, 0, 0, 0, 0, NULL, '2014-04-20 12:12:08'),
(1591, 0, 4797, 0, 0, 0, 0, NULL, '2014-04-20 12:40:37'),
(1594, 0, 15198, 0, 0, 0, 0, NULL, '2014-04-20 13:54:33'),
(1598, 0, 2580, 0, 0, 0, 0, NULL, '2014-04-20 14:34:40'),
(1600, 0, 300, 0, 0, 0, 0, NULL, '2014-04-20 15:03:31'),
(1601, 0, 15497, 0, 0, 0, 0, NULL, '2014-04-20 15:05:53'),
(1602, 0, 21166, 0, 0, 0, 0, NULL, '2014-04-20 15:12:45'),
(1614, 0, 20065, 0, 0, 0, 0, NULL, '2014-04-20 18:05:53'),
(1615, 0, 8274, 0, 0, 0, 0, NULL, '2014-04-20 18:28:56'),
(1617, 0, 571, 0, 0, 0, 0, NULL, '2014-04-20 20:02:12'),
(1619, 0, 14445, 0, 0, 0, 0, NULL, '2014-04-21 09:30:37'),
(1621, 0, 35391, 0, 0, 0, 0, NULL, '2014-04-21 10:43:34'),
(1642, 0, 15166, 0, 0, 0, 0, NULL, '2014-04-21 17:08:22'),
(1645, 0, 4083, 0, 0, 0, 0, NULL, '2014-04-22 10:49:54'),
(1649, 0, 22783, 0, 0, 0, 0, NULL, '2014-04-22 12:16:30'),
(1662, 0, 27432, 0, 0, 0, 0, NULL, '2014-04-23 08:09:37'),
(1670, 0, 6076, 0, 0, 0, 0, NULL, '2014-04-23 10:38:01'),
(1671, 0, 79252, 0, 0, 0, 0, NULL, '2014-04-23 10:46:03'),
(1680, 0, 787, 0, 0, 0, 0, NULL, '2014-04-23 12:36:53'),
(1684, 0, 6025, 0, 0, 0, 0, NULL, '2014-04-23 15:17:26'),
(1705, 0, 7842, 0, 0, 0, 0, NULL, '2014-04-23 18:31:29'),
(1706, 0, 100703, 0, 0, 0, 0, NULL, '2014-04-23 18:36:22'),
(1707, 0, 12355, 0, 0, 0, 0, NULL, '2014-04-23 18:37:47'),
(1708, 0, 8836, 0, 0, 0, 0, NULL, '2014-04-23 18:41:27'),
(1709, 0, 30365, 0, 0, 0, 0, NULL, '2014-04-23 18:42:08'),
(1710, 0, 8198, 0, 0, 0, 0, NULL, '2014-04-23 18:43:48'),
(1711, 0, 8093, 0, 0, 0, 0, NULL, '2014-04-23 18:50:39'),
(1712, 0, 111150, 0, 0, 0, 0, NULL, '2014-04-23 18:56:56'),
(1713, 0, 13123, 0, 0, 0, 0, NULL, '2014-04-23 18:58:32'),
(1714, 0, 15937, 0, 0, 0, 0, NULL, '2014-04-23 18:58:51'),
(1715, 0, 349711, 0, 0, 0, 0, NULL, '2014-04-23 18:59:35'),
(1716, 0, 19420, 0, 0, 0, 0, NULL, '2014-04-23 19:03:26'),
(1717, 0, 3686, 0, 0, 0, 0, NULL, '2014-04-23 19:08:31'),
(1723, 0, 2719, 0, 0, 0, 0, NULL, '2014-04-23 22:01:01'),
(1731, 0, 8201, 0, 0, 0, 0, NULL, '2014-04-23 22:08:36'),
(1745, 0, 100730, 0, 0, 0, 0, NULL, '2014-04-23 22:29:54'),
(1767, 0, 8363, 0, 0, 0, 0, NULL, '2014-04-24 13:57:27'),
(1778, 0, 2120, 0, 0, 0, 0, NULL, '2014-04-24 16:32:46'),
(1781, 0, 386, 0, 0, 0, 0, NULL, '2014-04-24 17:58:05'),
(1783, 0, 76746, 0, 0, 0, 0, NULL, '2014-04-25 06:03:22'),
(1784, 0, 26917, 0, 0, 0, 0, NULL, '2014-04-25 09:40:56'),
(1787, 0, 12071, 0, 0, 0, 0, NULL, '2014-04-25 11:17:06'),
(1792, 0, 21294, 0, 0, 0, 0, NULL, '2014-04-25 13:18:44'),
(1793, 0, 660, 0, 0, 0, 0, NULL, '2014-04-25 13:49:29'),
(1797, 0, 12648, 0, 0, 0, 0, NULL, '2014-04-25 14:10:22'),
(1798, 0, 2623, 0, 0, 0, 0, NULL, '2014-04-25 14:17:39');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(1799, 0, 12115, 0, 0, 0, 0, NULL, '2014-04-25 14:20:31'),
(1802, 0, 5286, 0, 0, 0, 0, NULL, '2014-04-25 14:40:27'),
(1816, 0, 3283, 0, 0, 0, 0, NULL, '2014-04-25 17:01:45'),
(1828, 0, 14973, 0, 0, 0, 0, NULL, '2014-04-26 08:22:26'),
(1830, 0, 33184, 0, 0, 0, 0, NULL, '2014-04-26 09:17:23'),
(1831, 0, 3830, 0, 0, 0, 0, NULL, '2014-04-26 09:23:10'),
(1834, 0, 14830, 0, 0, 0, 0, NULL, '2014-04-26 10:20:10'),
(1838, 0, 39653, 0, 0, 0, 0, NULL, '2014-04-26 10:41:47'),
(1839, 0, 6685, 0, 0, 0, 0, NULL, '2014-04-26 10:43:53'),
(1845, 0, 24881, 0, 0, 0, 0, NULL, '2014-04-26 10:58:57'),
(1846, 0, 70942, 0, 0, 0, 0, NULL, '2014-04-26 11:02:55'),
(1847, 0, 1936, 0, 0, 0, 0, NULL, '2014-04-26 11:31:10'),
(1851, 0, 6173, 0, 0, 0, 0, NULL, '2014-04-26 11:34:09'),
(1852, 0, 13487, 0, 0, 0, 0, NULL, '2014-04-26 11:37:54'),
(1855, 0, 289, 0, 0, 0, 0, NULL, '2014-04-26 12:05:34'),
(1856, 0, 5015, 0, 0, 0, 0, NULL, '2014-04-26 12:17:25'),
(1857, 0, 49009, 0, 0, 0, 0, NULL, '2014-04-26 12:20:58'),
(1863, 0, 15772, 0, 0, 0, 0, NULL, '2014-04-26 12:23:10'),
(1864, 0, 7837, 0, 0, 0, 0, NULL, '2014-04-26 12:24:51'),
(1870, 0, 189, 0, 0, 0, 0, NULL, '2014-04-26 12:37:07'),
(1874, 0, 32854, 0, 0, 0, 0, NULL, '2014-04-26 12:50:28'),
(1877, 0, 7495, 0, 0, 0, 0, NULL, '2014-04-26 12:54:31'),
(1880, 0, 6686, 0, 0, 0, 0, NULL, '2014-04-26 13:20:47'),
(1893, 0, 6688, 0, 0, 0, 0, NULL, '2014-04-26 13:54:22'),
(1901, 0, 6689, 0, 0, 0, 0, NULL, '2014-04-26 13:57:52'),
(1911, 0, 22778, 0, 0, 0, 0, NULL, '2014-04-26 14:33:49'),
(1912, 0, 386, 0, 0, 0, 0, NULL, '2014-04-26 14:47:01'),
(1938, 0, 1, 0, 0, 0, 0, NULL, '2014-04-26 16:18:47'),
(1969, 0, 21150, 0, 0, 0, 0, NULL, '2014-04-27 09:36:07'),
(1970, 0, 7179, 0, 0, 0, 0, NULL, '2014-04-27 10:32:29'),
(1980, 0, 2, 0, 0, 0, 0, NULL, '2014-04-27 14:29:49'),
(2006, 0, 9606, 0, 0, 0, 0, NULL, '2014-04-27 15:54:33'),
(2014, 0, 7239, 0, 0, 0, 0, NULL, '2014-04-27 16:33:26'),
(2021, 0, 14769, 0, 0, 0, 0, NULL, '2014-04-27 17:45:18'),
(2024, 0, 7409, 0, 0, 0, 0, NULL, '2014-04-27 17:56:27'),
(2037, 0, 2843, 0, 0, 0, 0, NULL, '2014-04-27 19:08:41'),
(2142, 0, 20436, 0, 0, 0, 0, NULL, '2014-04-28 10:01:27'),
(2143, 0, 27904, 0, 0, 0, 0, NULL, '2014-04-28 11:46:58'),
(2146, 0, 5752, 0, 0, 0, 0, NULL, '2014-04-28 13:14:52'),
(2147, 0, 1872, 0, 0, 0, 0, NULL, '2014-04-28 13:55:21'),
(2157, 0, 23113, 0, 0, 0, 0, NULL, '2014-04-28 14:35:33'),
(2158, 0, 24842, 0, 0, 0, 0, NULL, '2014-04-28 14:50:37'),
(2159, 0, 43912, 0, 0, 0, 0, NULL, '2014-04-28 15:19:26'),
(2160, 0, 631, 0, 0, 0, 0, NULL, '2014-04-28 15:50:52'),
(2178, 0, 376620, 0, 0, 0, 0, NULL, '2014-04-28 18:14:08'),
(2184, 0, 12137, 0, 0, 0, 0, NULL, '2014-04-29 11:19:31'),
(2185, 0, 32415, 0, 0, 0, 0, NULL, '2014-04-29 11:43:57'),
(2188, 0, 2673, 0, 0, 0, 0, NULL, '2014-04-29 15:36:29'),
(2210, 0, 12450, 0, 0, 0, 0, NULL, '2014-04-30 12:18:14'),
(2211, 0, 722, 0, 0, 0, 0, NULL, '2014-04-30 13:14:45'),
(2214, 0, 3284, 0, 0, 0, 0, NULL, '2014-04-30 15:19:20'),
(2225, 0, 3286, 0, 0, 0, 0, NULL, '2014-04-30 16:22:26'),
(2228, 0, 3287, 0, 0, 0, 0, NULL, '2014-04-30 16:42:09'),
(2240, 0, 4678, 0, 0, 0, 0, NULL, '2014-04-30 18:28:38'),
(2242, 0, 11091, 0, 0, 0, 0, NULL, '2014-04-30 18:32:07'),
(2243, 0, 31541, 0, 0, 0, 0, NULL, '2014-04-30 18:35:34'),
(2244, 0, 9505, 0, 0, 0, 0, NULL, '2014-04-30 18:36:38'),
(2245, 0, 8537, 0, 0, 0, 0, NULL, '2014-04-30 18:36:55'),
(2246, 0, 14576, 0, 0, 0, 0, NULL, '2014-04-30 18:45:23'),
(2247, 0, 16110, 0, 0, 0, 0, NULL, '2014-04-30 18:56:28'),
(2248, 0, 35344, 0, 0, 0, 0, NULL, '2014-04-30 18:58:16'),
(2249, 0, 1, 0, 0, 0, 0, NULL, '2014-04-30 19:00:31'),
(2250, 0, 395450, 0, 0, 0, 0, NULL, '2014-04-30 19:01:39'),
(2277, 0, 9, 0, 0, 0, 0, NULL, '2014-05-01 09:04:17'),
(2281, 0, 13, 0, 0, 0, 0, NULL, '2014-05-01 09:06:42'),
(2285, 0, 16, 0, 0, 0, 0, NULL, '2014-05-01 09:08:37'),
(2289, 0, 16, 0, 0, 0, 0, NULL, '2014-05-01 09:11:19'),
(2293, 0, 16, 0, 0, 0, 0, NULL, '2014-05-01 09:19:25'),
(2298, 0, 55133, 0, 0, 0, 0, NULL, '2014-05-01 10:47:23'),
(2299, 0, 54736, 0, 0, 0, 0, NULL, '2014-05-01 10:49:06'),
(2300, 0, 16414, 0, 0, 0, 0, NULL, '2014-05-01 10:57:50'),
(2303, 0, 16414, 0, 0, 0, 0, NULL, '2014-05-01 11:05:49'),
(2307, 0, 8330, 0, 0, 0, 0, NULL, '2014-05-01 11:08:08'),
(2308, 0, 12587, 0, 0, 0, 0, NULL, '2014-05-01 11:08:32');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(2309, 0, 5151, 0, 0, 0, 0, NULL, '2014-05-01 12:21:15'),
(2319, 0, 29687, 0, 0, 0, 0, NULL, '2014-05-01 13:34:40'),
(2321, 0, 7522, 0, 0, 0, 0, NULL, '2014-05-01 14:04:30'),
(2322, 0, 150, 0, 0, 0, 0, NULL, '2014-05-01 15:08:46'),
(2342, 0, 962, 0, 0, 0, 0, NULL, '2014-05-01 18:19:19'),
(2354, 0, 48460, 0, 0, 0, 0, NULL, '2014-05-01 19:09:14'),
(2363, 0, 1, 0, 0, 0, 0, NULL, '2014-05-01 20:13:21'),
(2368, 0, 33242, 0, 0, 0, 0, NULL, '2014-05-02 09:28:04'),
(2369, 0, 36954, 0, 0, 0, 0, NULL, '2014-05-02 10:21:38'),
(2415, 0, 3606, 0, 0, 0, 0, NULL, '2014-05-02 15:35:15'),
(2442, 0, 52652, 0, 0, 0, 0, NULL, '2014-05-02 16:51:24'),
(2450, 0, 7584, 0, 0, 0, 0, NULL, '2014-05-02 18:00:16'),
(2454, 0, 19909, 0, 0, 0, 0, NULL, '2014-05-02 19:32:33'),
(2457, 0, 12653, 0, 0, 0, 0, NULL, '2014-05-02 19:56:07'),
(2491, 0, 11325, 0, 0, 0, 0, NULL, '2014-05-03 07:11:29'),
(2492, 0, 6318, 0, 0, 0, 0, NULL, '2014-05-03 08:36:39'),
(2496, 0, 5, 0, 0, 0, 0, NULL, '2014-05-03 09:17:28'),
(2502, 0, 7389, 0, 0, 0, 0, NULL, '2014-05-03 09:40:20'),
(2514, 0, 103338, 0, 0, 0, 0, NULL, '2014-05-03 10:16:17'),
(2518, 0, 28682, 0, 0, 0, 0, NULL, '2014-05-03 10:56:31'),
(2519, 0, 6492, 0, 0, 0, 0, NULL, '2014-05-03 11:06:01'),
(2526, 0, 568, 0, 0, 0, 0, NULL, '2014-05-03 12:11:51'),
(2527, 0, 7229, 0, 0, 0, 0, NULL, '2014-05-03 12:13:08'),
(2528, 0, 31577, 0, 0, 0, 0, NULL, '2014-05-03 12:17:15'),
(2535, 0, 15852, 0, 0, 0, 0, NULL, '2014-05-03 12:25:41'),
(2536, 0, 2495, 0, 0, 0, 0, NULL, '2014-05-03 13:02:34'),
(2538, 0, 1381, 0, 0, 0, 0, NULL, '2014-05-03 13:17:27'),
(2539, 0, 91906, 0, 0, 0, 0, NULL, '2014-05-03 13:25:05'),
(2554, 0, 656, 0, 0, 0, 0, NULL, '2014-05-03 14:29:31'),
(2566, 0, 3945, 0, 0, 0, 0, NULL, '2014-05-03 14:54:07'),
(2569, 0, 8009, 0, 0, 0, 0, NULL, '2014-05-03 15:19:33'),
(2577, 0, 1134, 0, 0, 0, 0, NULL, '2014-05-03 15:54:09'),
(2603, 0, 20181, 0, 0, 0, 0, NULL, '2014-05-03 17:15:13'),
(2610, 0, 1011, 0, 0, 0, 0, NULL, '2014-05-03 18:43:32'),
(2628, 0, 3125, 0, 0, 0, 0, NULL, '2014-05-04 10:41:32'),
(2630, 0, 61614, 0, 0, 0, 0, NULL, '2014-05-04 11:08:37'),
(2631, 0, 8603, 0, 0, 0, 0, NULL, '2014-05-04 11:30:17'),
(2634, 0, 1202, 0, 0, 0, 0, NULL, '2014-05-04 11:36:26'),
(2644, 0, 12536, 0, 0, 0, 0, NULL, '2014-05-04 13:11:14'),
(2649, 0, 1936, 0, 0, 0, 0, NULL, '2014-05-04 13:27:37'),
(2682, 0, 50013, 0, 0, 0, 0, NULL, '2014-05-04 16:11:24'),
(2683, 0, 3787, 0, 0, 0, 0, NULL, '2014-05-04 16:11:56'),
(2702, 0, 1, 0, 0, 0, 0, NULL, '2014-05-04 16:22:36'),
(2703, 0, 3787, 0, 0, 0, 0, NULL, '2014-05-04 16:22:55'),
(2712, 0, 13949, 0, 0, 0, 0, NULL, '2014-05-04 17:23:01'),
(2721, 0, 31800, 0, 0, 0, 0, NULL, '2014-05-04 18:00:53'),
(2723, 0, 3393, 0, 0, 0, 0, NULL, '2014-05-04 18:13:51'),
(2749, 0, 4276, 0, 0, 0, 0, NULL, '2014-05-05 09:10:21'),
(2755, 0, 6138, 0, 0, 0, 0, NULL, '2014-05-05 10:06:44'),
(2762, 0, 2, 0, 0, 0, 0, NULL, '2014-05-05 10:57:09'),
(2765, 0, 5262, 0, 0, 0, 0, NULL, '2014-05-05 11:36:21'),
(2767, 0, 10215, 0, 0, 0, 0, NULL, '2014-05-05 11:44:35'),
(2769, 0, 729, 0, 0, 0, 0, NULL, '2014-05-05 12:43:38'),
(2775, 0, 6098, 0, 0, 0, 0, NULL, '2014-05-05 13:48:41'),
(2783, 0, 202884, 0, 0, 0, 0, NULL, '2014-05-05 14:01:11'),
(2789, 0, 4851, 0, 0, 0, 0, NULL, '2014-05-05 15:17:55'),
(2793, 0, 3287, 0, 0, 0, 0, NULL, '2014-05-05 15:59:40'),
(2796, 0, 3287, 0, 0, 0, 0, NULL, '2014-05-05 16:03:07'),
(2809, 0, 3306, 0, 0, 0, 0, NULL, '2014-05-05 17:10:14'),
(2810, 0, 10227, 0, 0, 0, 0, NULL, '2014-05-05 17:11:42'),
(2821, 0, 420390, 0, 0, 0, 0, NULL, '2014-05-05 17:59:46'),
(2849, 0, 1095, 0, 0, 0, 0, NULL, '2014-05-06 12:49:08'),
(2855, 0, 47740, 0, 0, 0, 0, NULL, '2014-05-06 14:39:17'),
(2870, 0, 22661, 0, 0, 0, 0, NULL, '2014-05-07 09:01:57'),
(2882, 0, 6417, 0, 0, 0, 0, NULL, '2014-05-07 16:09:32'),
(2890, 0, 9, 0, 0, 0, 0, NULL, '2014-05-07 16:41:26'),
(2894, 0, 9240, 0, 0, 0, 0, NULL, '2014-05-07 18:25:32'),
(2895, 0, 435728, 0, 0, 0, 0, NULL, '2014-05-07 18:34:54'),
(2896, 0, 15549, 0, 0, 0, 0, NULL, '2014-05-07 18:37:21'),
(2897, 0, 10246, 0, 0, 0, 0, NULL, '2014-05-07 18:39:49'),
(2898, 0, 18284, 0, 0, 0, 0, NULL, '2014-05-07 18:42:43'),
(2899, 0, 1715, 0, 0, 0, 0, NULL, '2014-05-07 18:48:23'),
(2900, 0, 64622, 0, 0, 0, 0, NULL, '2014-05-07 18:49:08'),
(2901, 0, 16619, 0, 0, 0, 0, NULL, '2014-05-07 18:50:26');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
(2902, 0, 7545, 0, 0, 0, 0, NULL, '2014-05-07 18:53:55'),
(2903, 0, 8187, 0, 0, 0, 0, NULL, '2014-05-07 18:56:55'),
(2904, 0, 13222, 0, 0, 0, 0, NULL, '2014-05-07 18:58:04'),
(2905, 0, 27707, 0, 0, 0, 0, NULL, '2014-05-07 19:03:11'),
(2906, 0, 7985, 0, 0, 0, 0, NULL, '2014-05-07 19:09:43'),
(2936, 0, 116109, 0, 0, 0, 0, NULL, '2014-05-08 08:41:17'),
(2941, 0, 13177, 0, 0, 0, 0, NULL, '2014-05-08 14:40:45'),
(2952, 0, 14696, 0, 0, 0, 0, NULL, '2014-05-09 11:39:12'),
(2968, 0, 6220, 0, 0, 0, 0, NULL, '2014-05-09 13:48:55'),
(2976, 0, 27589, 0, 0, 0, 0, NULL, '2014-05-09 14:56:29'),
(2986, 0, 15887, 0, 0, 0, 0, NULL, '2014-05-09 20:15:05'),
(2995, 0, 1202, 0, 0, 0, 0, NULL, '2014-05-09 22:11:48'),
(2998, 0, 1210, 0, 0, 0, 0, NULL, '2014-05-09 22:45:42'),
(3001, 0, 1219, 0, 0, 0, 0, NULL, '2014-05-10 00:03:54'),
(3007, 0, 1229, 0, 0, 0, 0, NULL, '2014-05-10 00:06:38'),
(3010, 0, 7142, 0, 0, 0, 0, NULL, '2014-05-10 10:05:31'),
(3011, 0, 31255, 0, 0, 0, 0, NULL, '2014-05-10 10:53:54'),
(3024, 0, 208, 0, 0, 0, 0, NULL, '2014-05-10 14:39:52'),
(3030, 0, 208, 0, 0, 0, 0, NULL, '2014-05-10 14:43:44'),
(3033, 0, 208, 0, 0, 0, 0, NULL, '2014-05-10 14:47:03'),
(3039, 0, 27595, 0, 0, 0, 0, NULL, '2014-05-10 16:13:41'),
(3049, 0, 2330, 0, 0, 0, 0, NULL, '2014-05-11 12:06:45'),
(3070, 0, 7911, 0, 0, 0, 0, NULL, '2014-05-12 14:44:11'),
(3076, 0, 6946, 0, 0, 0, 0, NULL, '2014-05-13 08:21:27'),
(3077, 0, 9973, 0, 0, 0, 0, NULL, '2014-05-13 09:53:35'),
(3078, 0, 80229, 0, 0, 0, 0, NULL, '2014-05-13 10:35:36'),
(3079, 0, 12264, 0, 0, 0, 0, NULL, '2014-05-13 11:41:25'),
(3080, 0, 28872, 0, 0, 0, 0, NULL, '2014-05-13 11:56:44'),
(3090, 0, 10720, 0, 0, 0, 0, NULL, '2014-05-13 14:07:04'),
(3093, 0, 28890, 0, 0, 0, 0, NULL, '2014-05-13 15:14:06'),
(3097, 0, 28907, 0, 0, 0, 0, NULL, '2014-05-13 15:20:00'),
(3103, 0, 28909, 0, 0, 0, 0, NULL, '2014-05-13 15:31:06'),
(3106, 0, 28911, 0, 0, 0, 0, NULL, '2014-05-13 15:33:16'),
(3109, 0, 28911, 0, 0, 0, 0, NULL, '2014-05-13 15:35:36'),
(3110, 0, 5482, 0, 0, 0, 0, NULL, '2014-05-13 15:54:58'),
(3119, 0, 470764, 0, 0, 0, 0, NULL, '2014-05-13 17:20:21'),
(3120, 0, 11688, 0, 0, 0, 0, NULL, '2014-05-13 17:30:48'),
(3133, 0, 2144, 0, 0, 0, 0, NULL, '2014-05-14 11:36:16'),
(3148, 0, 76888, 0, 0, 0, 0, NULL, '2014-05-14 16:07:56'),
(3151, 0, 17702, 0, 0, 0, 0, NULL, '2014-05-14 17:53:17'),
(3155, 0, 19891, 0, 0, 0, 0, NULL, '2014-05-14 18:34:18'),
(3156, 0, 15181, 0, 0, 0, 0, NULL, '2014-05-14 18:36:57'),
(3157, 0, 24521, 0, 0, 0, 0, NULL, '2014-05-14 18:37:40'),
(3158, 0, 11566, 0, 0, 0, 0, NULL, '2014-05-14 18:41:24'),
(3159, 0, 9490, 0, 0, 0, 0, NULL, '2014-05-14 18:49:17'),
(3160, 0, 18908, 0, 0, 0, 0, NULL, '2014-05-14 18:51:42'),
(3161, 0, 481195, 0, 0, 0, 0, NULL, '2014-05-14 18:54:07'),
(3162, 0, 11879, 0, 0, 0, 0, NULL, '2014-05-14 18:55:42'),
(3163, 0, 22798, 0, 0, 0, 0, NULL, '2014-05-14 18:58:31'),
(3164, 0, 36323, 0, 0, 0, 0, NULL, '2014-05-14 18:59:39'),
(3165, 0, 11319, 0, 0, 0, 0, NULL, '2014-05-14 19:00:29'),
(3166, 0, 28745, 0, 0, 0, 0, NULL, '2014-05-14 19:06:58'),
(3196, 0, 120569, 0, 0, 0, 0, NULL, '2014-05-15 10:16:03'),
(3197, 0, 8289, 0, 0, 0, 0, NULL, '2014-05-15 10:32:20'),
(3198, 0, 8189, 0, 0, 0, 0, NULL, '2014-05-15 11:00:22'),
(3373, 0, 5482, 0, 0, 0, 0, NULL, '2014-05-15 14:10:42'),
(3494, 0, 4347, 0, 0, 0, 0, NULL, '2014-05-15 15:51:50'),
(3619, 0, 8293, 0, 0, 0, 0, NULL, '2014-05-15 18:18:36'),
(3632, 0, 45452, 0, 0, 0, 0, NULL, '2014-05-16 10:47:39'),
(3635, 0, 2495, 0, 0, 0, 0, NULL, '2014-05-16 11:12:26'),
(3636, 0, 5862, 0, 0, 0, 0, NULL, '2014-05-16 11:27:02'),
(3640, 0, 47118, 0, 0, 0, 0, NULL, '2014-05-16 12:22:12'),
(3641, 0, 19718, 0, 0, 0, 0, NULL, '2014-05-16 12:22:24'),
(3645, 0, 7229, 0, 0, 0, 0, NULL, '2014-05-16 13:10:43'),
(3648, 0, 13482, 0, 0, 0, 0, NULL, '2014-05-16 13:49:54'),
(3661, 0, 62265, 0, 0, 0, 0, NULL, '2014-05-16 14:53:30'),
(3662, 0, 32238, 0, 0, 0, 0, NULL, '2014-05-16 15:02:33'),
(3693, 0, 2330, 0, 0, 0, 0, NULL, '2014-05-16 20:20:51'),
(3705, 0, 67145, 0, 0, 0, 0, NULL, '2014-05-17 08:22:21'),
(3706, 0, 1586, 0, 0, 0, 0, NULL, '2014-05-17 08:25:23'),
(3707, 0, 505739, 0, 0, 0, 0, NULL, '2014-05-17 08:33:25'),
(3708, 0, 14172, 0, 0, 0, 0, NULL, '2014-05-17 08:35:30'),
(3709, 0, 7811, 0, 0, 0, 0, NULL, '2014-05-17 08:51:30');
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;