Calculate the Total Time worked and Total Distance Travelled

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

CREATE TABLE #VehicleLogs
    ([LogId] int, [GeoLocation] [geography], [AssetId] int, [DriverId] int, [EventCode] int, [LogDateTime] datetime)
;
    
INSERT INTO #VehicleLogs
    ([LogId], [GeoLocation], [AssetId], [DriverId], [EventCode], [LogDateTime])
VALUES
    (2503852, 0xE6100000010C0EA72787AA73384038899C1958914840, 2, 7, 41, '2016-06-30 21:00:25'),
    (2503853, 0xE6100000010C57B439CE6D743840B3F2261AFF914840, 2, 7, 41, '2016-06-30 21:02:20'),
    (2504130, 0xE6100000010CE9FCCA396774384072DF6A9DB8924840, 2, 7, 41, '2016-06-30 21:04:03'),
    (2504132, 0xE6100000010C346EC5596C7438409A52A8B8BB924840, 2, 7, 41, '2016-06-30 21:04:08'),
    (2504134, 0xE6100000010C3A99130F837438403DBB7CEBC3924840, 2, 7, 41, '2016-06-30 21:04:26'),
    (2504136, 0xE6100000010CAF61E17F8674384061C5A9D6C2924840, 2, 7, 41, '2016-06-30 21:04:29'),
    (2504138, 0xE6100000010C4FC939B18774384020668A94C1924840, 2, 7, 41, '2016-06-30 21:04:31'),
    (2504140, 0xE6100000010C3E4ADBAE86743840092AF40BC0924840, 2, 7, 41, '2016-06-30 21:04:33'),
    (2504142, 0xE6100000010CFB79AE4A7D7438405F82AED8BA924840, 2, 7, 41, '2016-06-30 21:04:41'),
    (2504252, 0xE6100000010CB01C210379743840A18BE145BA924840, 2, 7, 41, '2016-06-30 21:06:41'),
    (2504386, 0xE6100000010C742909E46D743840FA60191BBA924840, 2, 7, 41, '2016-06-30 21:11:03'),
    (2504388, 0xE6100000010CE5EFDE5163743840FB24D291B7924840, 2, 7, 41, '2016-06-30 21:11:11'),
    (2504391, 0xE6100000010C870783216174384085984BAAB6924840, 2, 7, 41, '2016-06-30 21:11:14'),
    (2504459, 0xE6100000010CBF1880FC5B74384097E71C97CC914840, 2, 7, 41, '2016-06-30 21:13:14'),
    (2504468, 0xE6100000010C972595849F733840E4C3471F4E914840, 2, 7, 41, '2016-06-30 21:14:41'),
    (2504469, 0xE6100000010C693DD7529B7338403D997FF44D914840, 2, 7, 41, '2016-06-30 21:14:43'),
    (2504470, 0xE6100000010C0023C38597733840E938C8354F914840, 2, 7, 41, '2016-06-30 21:14:45'),
    (2504473, 0xE6100000010C4F84C3C194733840709A99F452914840, 2, 7, 41, '2016-06-30 21:14:48'),
    (2504598, 0xE6100000010C041DAD6A49733840543B1E8E09924840, 2, 7, 41, '2016-06-30 21:16:49'),
    (2504634, 0xE6100000010C02A32655367338402C0FD253E4924840, 2, 7, 41, '2016-06-30 21:18:24'),
    (2504649, 0xE6100000010CD0B8702024733840F579D67FE7924840, 2, 7, 41, '2016-06-30 21:18:29'),
    (2504778, 0xE6100000010CB7989F1B9A723840B78EBB52E0924840, 2, 7, 41, '2016-06-30 21:19:04'),
    (2504779, 0xE6100000010C08967E1D9372384072361D01DC924840, 2, 7, 41, '2016-06-30 21:19:08'),
    (2504780, 0xE6100000010C70CFF3A78D723840E5284014CC924840, 2, 7, 41, '2016-06-30 21:19:27'),
    (2504781, 0xE6100000010C8B749A6093723840CCA9AE8DC2924840, 2, 7, 41, '2016-06-30 21:19:38'),
    (2504789, 0xE6100000010C991A57128F7238405EEC0786BD924840, 2, 7, 2, '2016-06-30 21:21:06'),
    (2505229, 0xE6100000010C991A57128F7238405EEC0786BD924840, 2, 7, 41, '2016-06-30 21:35:02'),
    (2505224, 0xE6100000010C991A57128F7238405EEC0786BD924840, 2, 7, 1, '2016-06-30 21:35:11'),
    (2505364, 0xE6100000010CA859FB96947238409DF7FF71C2924840, 2, 7, 41, '2016-06-30 21:35:42'),
    (2505366, 0xE6100000010C4424F90093723840050CDCCBC7924840, 2, 7, 41, '2016-06-30 21:35:47'),
    (2505369, 0xE6100000010C573F36C98F723840B93BC670D0924840, 2, 7, 41, '2016-06-30 21:35:57'),
    (2505370, 0xE6100000010CA4C519C39C723840466348A9DF924840, 2, 7, 41, '2016-06-30 21:36:15'),
    (2505372, 0xE6100000010C0DFD135CAC7238402C29779FE3924840, 2, 7, 41, '2016-06-30 21:36:22'),
    (2505373, 0xE6100000010C9B24F14D2E733840D28F8653E6924840, 2, 7, 41, '2016-06-30 21:36:55'),
    (2505374, 0xE6100000010C9FF29EB93D7338402E07D561E0924840, 2, 7, 41, '2016-06-30 21:37:02'),
    (2505375, 0xE6100000010C7788DA9145733840A5D8D138D4924840, 2, 7, 41, '2016-06-30 21:37:08'),
    (2505389, 0xE6100000010CDC8B1EAE8B7338409285F93C90914840, 2, 7, 41, '2016-06-30 21:39:09'),
    (2505506, 0xE6100000010C0863FA14B673384023884E2A75904840, 2, 7, 41, '2016-06-30 21:40:31'),
    (2505507, 0xE6100000010CED702A08D4733840B0FF3A376D904840, 2, 7, 41, '2016-06-30 21:40:35'),
    (2505509, 0xE6100000010CE20BEE62F574384029FE391625904840, 2, 7, 41, '2016-06-30 21:41:16'),
    (2505596, 0xE6100000010CF9C08EFF027738405BEF9293E48E4840, 2, 7, 41, '2016-06-30 21:43:17'),
    (2505597, 0xE6100000010CD7F9B7CB7E773840C03DCF9F368E4840, 2, 7, 41, '2016-06-30 21:44:14'),
    (2505617, 0xE6100000010C2DB0C7444A7738400C152D8A688D4840, 2, 7, 41, '2016-06-30 21:45:17'),
    (2505704, 0xE6100000010CBA85AE44A0763840D8F2CAF5B68C4840, 2, 7, 41, '2016-06-30 21:46:32'),
    (2505705, 0xE6100000010CB7A1180FA57638404EE6690AAE8C4840, 2, 7, 41, '2016-06-30 21:46:37'),
    (2505706, 0xE6100000010C6765FB90B776384059857247A48C4840, 2, 7, 41, '2016-06-30 21:46:43'),
    (2505772, 0xE6100000010CE1AB6752547938401348895DDB8B4840, 2, 7, 41, '2016-06-30 21:48:43'),
    (2505778, 0xE6100000010CC861307F857A3840A6E5513B0D8B4840, 2, 7, 41, '2016-06-30 21:50:18'),
    (2505899, 0xE6100000010CD59700570D7F3840473B6EF8DD8A4840, 2, 7, 41, '2016-06-30 21:52:18'),
    (2505896, 0xE6100000010CD542C9E4D4823840AC2EF191DE8A4840, 2, 7, 8, '2016-06-30 21:53:21'),
    (2505902, 0xE6100000010C0FE0E30286873840FD4003FBF98A4840, 2, 7, 41, '2016-06-30 21:54:37'),
    (2505960, 0xE6100000010C3280A6142A8C3840974DCAEE138B4840, 2, 7, 41, '2016-06-30 21:55:51'),
    (2505961, 0xE6100000010C39645EA2D590384056C9117C1D8B4840, 2, 7, 41, '2016-06-30 21:57:06'),
    (2506052, 0xE6100000010C138832AF7E9538402E76FBAC328B4840, 2, 7, 41, '2016-06-30 21:58:19'),
    (2506053, 0xE6100000010CF8CC48731A9A3840E8EAD852518B4840, 2, 7, 41, '2016-06-30 21:59:33'),
    (2506054, 0xE6100000010CD1FB1065B99E38402716F88A6E8B4840, 2, 7, 41, '2016-06-30 22:00:45'),
    (2506156, 0xE6100000010CF2CEA10C55A338403B1E8E098C8B4840, 2, 7, 41, '2016-06-30 22:01:57'),
    (2506157, 0xE6100000010C5FEB5223F4A73840C795C4A39E8B4840, 2, 7, 41, '2016-06-30 22:03:11'),
    (2506154, 0xE6100000010C2508B2F913AC3840080B8222718B4840, 2, 7, 8, '2016-06-30 22:04:42'),
    (2506162, 0xE6100000010CFD169D2CB5B0384009E5D8D53F8B4840, 2, 7, 41, '2016-06-30 22:05:52'),
    (2506299, 0xE6100000010CA7295D5551B53840AB5AD2510E8B4840, 2, 7, 41, '2016-06-30 22:07:04'),
    (2506300, 0xE6100000010C07335CD372B83840705B5B785E8B4840, 2, 7, 41, '2016-06-30 22:07:51'),
    (2506301, 0xE6100000010C9FE5797077BC38402C75DA649E8C4840, 2, 7, 41, '2016-06-30 22:09:00'),
    (2506302, 0xE6100000010C5490FA46CFC038405A3A30CA7D8D4840, 2, 7, 41, '2016-06-30 22:10:07'),
    (2506310, 0xE6100000010CB7312C3531C5384001B221495A8E4840, 2, 7, 41, '2016-06-30 22:11:17'),
    (2506375, 0xE6100000010C66C9D23DA1C9384095568D6F398F4840, 2, 7, 41, '2016-06-30 22:12:32'),
    (2506376, 0xE6100000010C3F70952710CE3840D09B8A5418904840, 2, 7, 41, '2016-06-30 22:13:46'),
    (2506455, 0xE6100000010CF913950D6BD23840B0B4E78DEE904840, 2, 7, 41, '2016-06-30 22:14:59'),
    (2506456, 0xE6100000010C0EF62686E4D63840D881734694914840, 2, 7, 41, '2016-06-30 22:16:10'),
    (2506499, 0xE6100000010CBAFCE2AD4EDB3840A699EE7552924840, 2, 7, 41, '2016-06-30 22:17:23'),
    (2506500, 0xE6100000010C2C21698187DF38401652D90B60934840, 2, 7, 41, '2016-06-30 22:18:34'),
    (2506624, 0xE6100000010CFB41B85DC3E33840A2B5A2CD71944840, 2, 7, 41, '2016-06-30 22:19:43'),
    (2506626, 0xE6100000010CADE4BE30F4E738406B99B10D81954840, 2, 7, 41, '2016-06-30 22:20:51'),
    (2506628, 0xE6100000010CA2DC6C6237EC3840E329F57695964840, 2, 7, 41, '2016-06-30 22:22:06'),
    (2506726, 0xE6100000010C306FC44950F03840EAA8B40FC3974840, 2, 7, 41, '2016-06-30 22:23:16'),
    (2506728, 0xE6100000010C41DC30653BF43840E695EB6D33994840, 2, 7, 41, '2016-06-30 22:24:24'),
    (2506729, 0xE6100000010CBF36D19D16F838403260240F9F9A4840, 2, 7, 41, '2016-06-30 22:25:33'),
    (2506762, 0xE6100000010C089854C8F0FB3840134C906C099C4840, 2, 7, 41, '2016-06-30 22:26:45'),
    (2506807, 0xE6100000010C219221C7D6FF38404850FC18739D4840, 2, 7, 41, '2016-06-30 22:27:58'),
    (2506808, 0xE6100000010C08C89750C1033940EE76627BD29E4840, 2, 7, 41, '2016-06-30 22:29:06'),
    (2506852, 0xE6100000010C02F96DE3AA07394034DD465E31A04840, 2, 7, 41, '2016-06-30 22:30:17'),
    (2506864, 0xE6100000010C17A7107E980B3940679EB70C93A14840, 2, 7, 41, '2016-06-30 22:31:29'),
    (2507058, 0xE6100000010CB4609802880F39405471E316F3A24840, 2, 7, 41, '2016-06-30 22:32:46'),
    (2507052, 0xE6100000010C9A7F4F070D1039405ABC581822A34840, 2, 7, 8, '2016-06-30 22:32:55'),
    (2507059, 0xE6100000010C59B21996F51339403965C97784A44840, 2, 7, 41, '2016-06-30 22:34:04'),
    (2507060, 0xE6100000010C55C7855EDA1739405BA7DB23E5A54840, 2, 7, 41, '2016-06-30 22:35:15'),
    (2507061, 0xE6100000010CFB3DB14E951B39402A768FC767A74840, 2, 7, 41, '2016-06-30 22:36:24'),
    (2507062, 0xE6100000010C3112352CA11E394083F11D4652A94840, 2, 7, 41, '2016-06-30 22:37:33'),
    (2507065, 0xE6100000010C8F77A27FDD203940FA97A432C5AA4840, 2, 7, 41, '2016-06-30 22:39:33'),
    (2507067, 0xE6100000010C65B03D0EDE203940779FE3A3C5AA4840, 2, 7, 41, '2016-06-30 22:39:45'),
    (2507119, 0xE6100000010CD9791B9B1D233940DA2D138FD5AB4840, 2, 7, 8, '2016-06-30 22:40:48'),
    (2507123, 0xE6100000010CEB3BBF28412739408D0A9C6C03AD4840, 2, 7, 41, '2016-06-30 22:41:56'),
    (2507172, 0xE6100000010CC7A3AF7B862B39400483B57B03AE4840, 2, 7, 41, '2016-06-30 22:43:09'),
    (2507173, 0xE6100000010CDBC58F8C30303940B295E1896AAE4840, 2, 7, 41, '2016-06-30 22:44:35'),
    (2507174, 0xE6100000010CC6072C6FFD303940769A160676AE4840, 2, 7, 8, '2016-06-30 22:44:48'),
    (2507222, 0xE6100000010C9EEE3CF19C3339400473F4F8BDAE4840, 2, 7, 41, '2016-06-30 22:46:11'),
    (2507243, 0xE6100000010CD01731A2A3333940694CD246BFAE4840, 2, 7, 41, '2016-06-30 22:48:11'),
    (2507244, 0xE6100000010CA5C05D51A5333940510A044BBFAE4840, 2, 7, 41, '2016-06-30 22:48:59'),
    (2507260, 0xE6100000010CDFC90281293839407C9BFEEC47AF4840, 2, 7, 41, '2016-06-30 22:50:31'),
    (2507259, 0xE6100000010C576B1789BF3839404ADAE8F758AF4840, 2, 7, 8, '2016-06-30 22:50:40'),
    (2507308, 0xE6100000010CD2191879593D3940F5503640C4AF4840, 2, 7, 41, '2016-06-30 22:51:56'),
    (2507305, 0xE6100000010C4B091C64ED403940061445A396AF4840, 2, 7, 8, '2016-06-30 22:52:56'),
    (2507343, 0xE6100000010CA5E2B5018E4539403C4B901150AF4840, 2, 7, 41, '2016-06-30 22:54:17'),
    (2507344, 0xE6100000010CB78196091A4A3940354580D3BBAF4840, 2, 7, 41, '2016-06-30 22:55:37'),
    (2507346, 0xE6100000010CF7F53240584A39404FD08140C2AF4840, 2, 7, 8, '2016-06-30 22:55:40'),
    (2507387, 0xE6100000010C93E92BA3EC4E39408754AC753DB04840, 2, 7, 41, '2016-06-30 22:56:56'),
    (2507385, 0xE6100000010CD418631690523940C78157CB9DB04840, 2, 7, 8, '2016-06-30 22:57:57'),
    (2507413, 0xE6100000010CB5E8F8C32A573940D5B0DF13EBB04840, 2, 7, 41, '2016-06-30 22:59:16'),
    (2507415, 0xE6100000010C7A443B5DCC5B39406043CB1539B14840, 2, 7, 41, '2016-06-30 23:00:40'),
    (2507545, 0xE6100000010CCD0C761E70603940A88DEA7420B14840, 2, 7, 41, '2016-06-30 23:02:03'),
    (2507546, 0xE6100000010C6254ADE0126539402ECC9DF419B14840, 2, 7, 41, '2016-06-30 23:03:26'),
    (2507547, 0xE6100000010CD33A600D06693940A5FED53E78B24840, 2, 7, 41, '2016-06-30 23:04:47'),
    (2507548, 0xE6100000010C1338C8DA956C3940A32996B613B34840, 2, 7, 41, '2016-06-30 23:05:52'),
    (2507549, 0xE6100000010C072C144438713940E162A0C618B34840, 2, 7, 41, '2016-06-30 23:07:15'),
    (2507550, 0xE6100000010C78F01307D075394046A863DF5FB34840, 2, 7, 41, '2016-06-30 23:08:39'),
    (2507551, 0xE6100000010C98C51FA0567A3940693C6C7DECB34840, 2, 7, 41, '2016-06-30 23:10:02'),
    (2507593, 0xE6100000010C075DC2A1B77E3940A44ADE4AC0B44840, 2, 7, 41, '2016-06-30 23:11:37'),
    (2507603, 0xE6100000010C7E0BA139A18239406700B90E1FB64840, 2, 7, 41, '2016-06-30 23:13:09'),
    (2507645, 0xE6100000010C8CFE863F79863940C3F5285C8FB74840, 2, 7, 41, '2016-06-30 23:14:38'),
    (2507702, 0xE6100000010CCDC82077118A39407B2DE8BD31B94840, 2, 7, 41, '2016-06-30 23:16:11'),
    (2507703, 0xE6100000010C65613E0FA48D39400B4856D9D2BA4840, 2, 7, 41, '2016-06-30 23:17:49'),
    (2507716, 0xE6100000010CD0F23CB83B8F3940FC5987FE64BB4840, 2, 7, 41, '2016-06-30 23:19:49'),
    (2507788, 0xE6100000010C9C8A54185B9039402F6B6281AFBB4840, 2, 7, 8, '2016-06-30 23:20:08'),
    (2507882, 0xE6100000010CAC0727FD18943940EDD79DEE3CBD4840, 2, 7, 41, '2016-06-30 23:21:26'),
    (2507894, 0xE6100000010C8D45D3D9C99639400DC7F31950BF4840, 2, 7, 41, '2016-06-30 23:22:47'),
    (2507943, 0xE6100000010C1C9F24B8EC993940300DC347C4C04840, 2, 7, 41, '2016-06-30 23:23:58'),
    (2507947, 0xE6100000010C33219C05909E394068AF3E1EFAC04840, 2, 7, 41, '2016-06-30 23:25:29'),
    (2507995, 0xE6100000010C5940571124A33940192202695AC14840, 2, 7, 41, '2016-06-30 23:26:53'),
    (2508003, 0xE6100000010C7D2BC885B9A73940F61E78C608C14840, 2, 7, 41, '2016-06-30 23:28:20'),
    (2508061, 0xE6100000010CAF850FDBCCAB39405C21ACC612C14840, 2, 7, 41, '2016-06-30 23:29:39'),
    (2508063, 0xE6100000010C2CFEA5FBEFAB3940CBAEC5B82CC14840, 2, 7, 41, '2016-06-30 23:29:55'),
    (2508135, 0xE6100000010C3B996EC8F5AB39403D6AA7412CC14840, 2, 7, 41, '2016-06-30 23:31:55'),
    (2508136, 0xE6100000010CCDEA7827FAAB394043E55FCB2BC14840, 2, 7, 41, '2016-06-30 23:33:32'),
    (2508137, 0xE6100000010C26CEE561FCAB394001C287122DC14840, 2, 7, 41, '2016-06-30 23:33:34'),
    (2508138, 0xE6100000010CB55ABB48FCAB39400531D0B52FC14840, 2, 7, 41, '2016-06-30 23:33:37'),
    (2508139, 0xE6100000010C2C1B8CC7FBAB3940B65906E632C14840, 2, 7, 41, '2016-06-30 23:33:41'),
    (2508140, 0xE6100000010C13D38558FDAB394045847F1134C14840, 2, 7, 41, '2016-06-30 23:33:43'),
    (2508141, 0xE6100000010C7DD92C4D00AC3940F7425C9434C14840, 2, 7, 41, '2016-06-30 23:33:45'),
    (2508132, 0xE6100000010C09F2FD1E06AC394074081C0934C14840, 2, 7, 2, '2016-06-30 23:34:10'),
    (2508595, 0xE6100000010C09F2FD1E06AC394074081C0934C14840, 2, 7, 41, '2016-06-30 23:59:28'),
    (2508594, 0xE6100000010C09F2FD1E06AC394074081C0934C14840, 2, 7, 1, '2016-06-30 23:59:37'),
    (2508611, 0xE6100000010C9F5BE84A04AC39403333333333C14840, 2, 7, 41, '2016-07-01 00:00:09'),
    (2508619, 0xE6100000010C5380DE0A17AC394001182A5A14C14840, 2, 7, 41, '2016-07-01 00:00:34'),
    (2508620, 0xE6100000010C3A7D981826AC3940C382FB010FC14840, 2, 7, 41, '2016-07-01 00:00:40'),
    (2508659, 0xE6100000010C52860552BDB03940138DFF4CCEC04840, 2, 7, 41, '2016-07-01 00:02:24'),
    (2508710, 0xE6100000010C1C6217A0C8B43940C6C7821D5AC14840, 2, 7, 41, '2016-07-01 00:03:36'),
    (2508709, 0xE6100000010C8D6AC7C331B53940129FE0078CC14840, 2, 7, 8, '2016-07-01 00:03:44'),
    (2508711, 0xE6100000010C1D7EED4F98B839405D48D1144BC34840, 2, 7, 41, '2016-07-01 00:04:55'),
    (2508758, 0xE6100000010C265305A392BC394089C44EC296C44840, 2, 7, 41, '2016-07-01 00:06:03'),
    (2508759, 0xE6100000010C47D2C9ADA4C039400DB6227BCEC54840, 2, 7, 41, '2016-07-01 00:07:13'),
    (2508805, 0xE6100000010C8AE6012CF2C33940EED4B727A3C74840, 2, 7, 41, '2016-07-01 00:08:22'),
    (2508806, 0xE6100000010CA37B31EFCCC53940810FB97427C84840, 2, 7, 41, '2016-07-01 00:08:54'),
    (2508810, 0xE6100000010C8390871975CA394051EB47D455C84840, 2, 7, 41, '2016-07-01 00:10:04'),
    (2508854, 0xE6100000010C7CC509021ACF39405560127871C84840, 2, 7, 41, '2016-07-01 00:11:14'),
    (2508855, 0xE6100000010C25B616C15AD23940359A5C8C81C84840, 2, 7, 41, '2016-07-01 00:12:03'),
    (2508916, 0xE6100000010C37250FFA88D639400D1F6C0C95C94840, 2, 7, 41, '2016-07-01 00:13:12'),
    (2508917, 0xE6100000010C2EFF21FDF6D93940226DE34F54CB4840, 2, 7, 41, '2016-07-01 00:14:21'),
    (2508965, 0xE6100000010CAFB2B6291EDD39400FA848CF3ECD4840, 2, 7, 41, '2016-07-01 00:15:30'),
    (2508966, 0xE6100000010CB539292735DF3940F627F1B913CE4840, 2, 7, 41, '2016-07-01 00:16:08'),
    (2508980, 0xE6100000010CD9B11188D7E339405A10CAFB38CE4840, 2, 7, 41, '2016-07-01 00:17:16'),
    (2509154, 0xE6100000010C2301593E81E83940B82979D047CE4840, 2, 7, 41, '2016-07-01 00:18:22'),
    (2509155, 0xE6100000010C377B5688FDEC3940C3BF63D3A5CE4840, 2, 7, 41, '2016-07-01 00:19:34'),
    (2509156, 0xE6100000010C0E7162FEC0EF394060D916AFC3D04840, 2, 7, 41, '2016-07-01 00:20:44'),
    (2509157, 0xE6100000010C41FE881524F2394075ABE7A4F7D24840, 2, 7, 41, '2016-07-01 00:21:53'),
    (2509158, 0xE6100000010CD3C1FA3F87F5394077C47CD4BAD44840, 2, 7, 41, '2016-07-01 00:23:06'),
    (2509162, 0xE6100000010CDDF6F35C95F83940386E8CF8A9D64840, 2, 7, 41, '2016-07-01 00:24:15'),
    (2509457, 0xE6100000010CAABA473657FB394044E048A0C1D84840, 2, 7, 41, '2016-07-01 00:25:23'),
    (2509459, 0xE6100000010CD20957F613FE39402EFE5B6ED5DA4840, 2, 7, 41, '2016-07-01 00:26:30'),
    (2509728, 0xE6100000010CF4401A040C013A40774F79CFDCDC4840, 2, 7, 41, '2016-07-01 00:27:40'),
    (2509729, 0xE6100000010C15C616821C043A40321180C9D7DE4840, 2, 7, 41, '2016-07-01 00:28:47'),
    (2509730, 0xE6100000010C1FBE4C1421073A40DAE21A9FC9E04840, 2, 7, 41, '2016-07-01 00:29:53'),
    (2509731, 0xE6100000010C5441A08E220A3A40467C2766BDE24840, 2, 7, 41, '2016-07-01 00:31:05'),
    (2509773, 0xE6100000010C94FF2499300D3A403E1A9826B6E44840, 2, 7, 41, '2016-07-01 00:32:12'),
    (2509775, 0xE6100000010C493547B137103A409023E70EACE64840, 2, 7, 41, '2016-07-01 00:33:19'),
    (2509785, 0xE6100000010C80D591239D133A400D384BC972E84840, 2, 7, 41, '2016-07-01 00:34:22'),
    (2510155, 0xE6100000010C12DC48D922173A404B3E761728EA4840, 2, 7, 41, '2016-07-01 00:35:29'),
    (2510156, 0xE6100000010C61FBC9181F1A3A40711294EC22EC4840, 2, 7, 41, '2016-07-01 00:36:32'),
    (2510157, 0xE6100000010C30C4A002161D3A40EC18575C1CEE4840, 2, 7, 41, '2016-07-01 00:37:38'),
    (2510159, 0xE6100000010CE053EF5F0F203A40FE2D5CB11AF04840, 2, 7, 41, '2016-07-01 00:38:48'),
    (2510542, 0xE6100000010C2E7F74A03D233A40FB5C6DC5FEF14840, 2, 7, 41, '2016-07-01 00:39:55'),
    (2510544, 0xE6100000010C36CB65A373263A40BAC0406BD9F34840, 2, 7, 41, '2016-07-01 00:41:17'),
    (2510565, 0xE6100000010CB9A81611C5283A40E19C6C5E30F54840, 2, 7, 8, '2016-07-01 00:42:13'),
    (2510571, 0xE6100000010C981936CAFA293A40C18C2958E3F54840, 2, 7, 8, '2016-07-01 00:42:42'),
    (2510663, 0xE6100000010C35CF11F92E2D3A409A661591BCF74840, 2, 7, 41, '2016-07-01 00:43:59'),
    (2510664, 0xE6100000010C90A6D5EB71303A40ABB35A608FF94840, 2, 7, 41, '2016-07-01 00:45:12'),
    (2510799, 0xE6100000010C9415C3D501343A4062F94E2734FB4840, 2, 7, 41, '2016-07-01 00:47:00'),
    (2510794, 0xE6100000010C607C2CD8A1353A40E9EE3A1BF2FB4840, 2, 7, 8, '2016-07-01 00:47:36'),
    (2510800, 0xE6100000010C5B41D3122B393A40E2EF726C98FD4840, 2, 7, 41, '2016-07-01 00:48:46'),
    (2510801, 0xE6100000010CB79BE09BA63B3A40E0E1D121CBFE4840, 2, 7, 41, '2016-07-01 00:49:52'),
    (2510802, 0xE6100000010C34BDC458A63B3A406B28B517D1FE4840, 2, 7, 41, '2016-07-01 00:49:55'),
    (2510820, 0xE6100000010C0382EFECE1393A40BFA2B6685C004940, 2, 7, 8, '2016-07-01 00:51:10'),
    (2510840, 0xE6100000010CA4ADA5DB6D383A4054FEB5BC72014940, 2, 7, 41, '2016-07-01 00:52:00'),
    (2510843, 0xE6100000010C5AB8ACC266383A40B06719F384014940, 2, 7, 41, '2016-07-01 00:52:09'),
    (2510887, 0xE6100000010CAB798EC877373A40C4A9205047024940, 2, 7, 41, '2016-07-01 00:53:06'),
    (2510888, 0xE6100000010CD755DC137F373A4044D5F90159024940, 2, 7, 41, '2016-07-01 00:53:10'),
    (2510889, 0xE6100000010CF01472A59E373A407EF66DD27E024940, 2, 7, 41, '2016-07-01 00:53:19'),
    (2510890, 0xE6100000010CC1035EC191373A40F744323F92024940, 2, 7, 41, '2016-07-01 00:53:24'),
    (2510891, 0xE6100000010CED7F80B56A373A4071EA5E82AE024940, 2, 7, 41, '2016-07-01 00:53:36'),
    (2510892, 0xE6100000010C87527B116D373A40A5677A89B1024940, 2, 7, 41, '2016-07-01 00:53:38'),
    (2510925, 0xE6100000010CA64819CCBA3A3A401CFEE4396C044940, 2, 7, 8, '2016-07-01 00:55:09'),
    (2510946, 0xE6100000010C0785F70B2C3C3A403927F6D03E054940, 2, 7, 41, '2016-07-01 00:55:44'),
    (2510952, 0xE6100000010C9E503EF3283D3A40D0BFB8AF5E054940, 2, 7, 8, '2016-07-01 00:56:01'),
    (2511021, 0xE6100000010CDC2DC901BB403A40E8717385D2054940, 2, 7, 8, '2016-07-01 00:57:02'),
    (2511023, 0xE6100000010C8ECFBFB8AF443A40F5D8960167064940, 2, 7, 41, '2016-07-01 00:58:15'),
    (2511032, 0xE6100000010CE77926EABB453A40FFAECF9CF5064940, 2, 7, 41, '2016-07-01 00:58:48'),
    (2511037, 0xE6100000010C23AC7C85BB453A4027DA5548F9064940, 2, 7, 41, '2016-07-01 00:58:50'),
    (2511038, 0xE6100000010C0D90C3BBB7453A40566C27A5FB064940, 2, 7, 41, '2016-07-01 00:58:52'),
    (2511054, 0xE6100000010CAB9FED878E453A40A9E38CBC07074940, 2, 7, 41, '2016-07-01 00:59:06'),
    (2511071, 0xE6100000010CD147CFE3E6443A401D5B2ACA00074940, 2, 7, 41, '2016-07-01 00:59:29'),
    (2511129, 0xE6100000010CFE69FEF38F433A40516C6006BE064940, 2, 7, 41, '2016-07-01 01:00:18'),
    (2511130, 0xE6100000010CBF4A992F8A433A40A49295BABF064940, 2, 7, 41, '2016-07-01 01:00:21'),
    (2511131, 0xE6100000010C6ECB36267A433A40C1B1C288D8064940, 2, 7, 41, '2016-07-01 01:01:55'),
    (2511132, 0xE6100000010C4A09C1AA7A433A40D158FB3BDB064940, 2, 7, 41, '2016-07-01 01:01:59'),
    (2511133, 0xE6100000010C4F4AF7297D433A40895E46B1DC064940, 2, 7, 41, '2016-07-01 01:02:02'),
    (2511171, 0xE6100000010CB7F182E38D433A406FAEAB13E1064940, 2, 7, 2, '2016-07-01 01:02:53'),
    (2512642, 0xE6100000010CB7F182E38D433A406FAEAB13E1064940, 2, 7, 41, '2016-07-01 02:02:54'),
    (2533183, 0xE6100000010CB7F182E38D433A406FAEAB13E1064940, 2, 7, 1, '2016-07-01 13:55:50'),
    (2533373, 0xE6100000010C1C0A9FAD83433A4035400EEFDE064940, 2, 7, 41, '2016-07-01 13:57:51'),
    (2533374, 0xE6100000010C55AB0A687D433A402EF36789DF064940, 2, 7, 41, '2016-07-01 13:57:59'),
    (2533375, 0xE6100000010CBC0C5AA379433A40C0B40309E5064940, 2, 7, 41, '2016-07-01 13:59:59'),
    (2533465, 0xE6100000010C3FEB75E679433A40FE4EEED2E1064940, 2, 7, 41, '2016-07-01 14:04:53'),
    (2533471, 0xE6100000010C7A1DCC8179433A40C60C9E53DA064940, 2, 7, 41, '2016-07-01 14:05:01'),
    (2533555, 0xE6100000010C18D2E1218C433A408C6A6C0ABF064940, 2, 7, 41, '2016-07-01 14:05:59'),
    (2533556, 0xE6100000010C57B5FF5C8F433A40F21B70A7BE064940, 2, 7, 41, '2016-07-01 14:06:01'),
    (2533557, 0xE6100000010C37CC2B3295433A40861DC6A4BF064940, 2, 7, 41, '2016-07-01 14:06:03'),
    (2533577, 0xE6100000010C49884DBF9F453A40AE3E688709074940, 2, 7, 41, '2016-07-01 14:07:39'),
    (2533578, 0xE6100000010C1F9F909DB7453A40EFAEB321FF064940, 2, 7, 41, '2016-07-01 14:07:46'),
    (2533587, 0xE6100000010CB68DF5C3BE453A40C91F0C3CF7064940, 2, 7, 41, '2016-07-01 14:08:01'),
    (2533601, 0xE6100000010C5D763EF2BD453A40E2AFC91AF5064940, 2, 7, 41, '2016-07-01 14:08:03'),
    (2533658, 0xE6100000010CAE6CD5647C443A40079A2A734E064940, 2, 7, 41, '2016-07-01 14:08:51'),
    (2533664, 0xE6100000010CEAF7B30EFD3F3A407121EA99B9054940, 2, 7, 41, '2016-07-01 14:10:27'),
    (2533745, 0xE6100000010C5A55E531B93B3A40C5CB2E7315054940, 2, 7, 41, '2016-07-01 14:11:54'),
    (2533790, 0xE6100000010C51DE228B8F383A40F185240E34034940, 2, 7, 41, '2016-07-01 14:13:28'),
    (2533791, 0xE6100000010CE4E434FA87373A40DC24500EB0024940, 2, 7, 41, '2016-07-01 14:14:03'),
    (2533792, 0xE6100000010C7842AF3F89373A4029B6DD5F98024940, 2, 7, 41, '2016-07-01 14:14:07'),
    (2533793, 0xE6100000010CDCA8047A97373A40EBF4CD4763024940, 2, 7, 41, '2016-07-01 14:14:18'),
    (2533794, 0xE6100000010C4580D3BB78373A402531523937024940, 2, 7, 41, '2016-07-01 14:14:26'),
    (2533820, 0xE6100000010CD4C1B0B26C383A403B71395E81014940, 2, 7, 41, '2016-07-01 14:15:21'),
    (2533967, 0xE6100000010C2330D637303B3A40E6D07D946CFF4840, 2, 7, 41, '2016-07-01 14:17:09'),
    (2533968, 0xE6100000010CD7F84CF6CF3B3A4072C5C551B9FE4840, 2, 7, 41, '2016-07-01 14:18:04'),
    (2533969, 0xE6100000010CAF997CB3CD3B3A401A44B5D2B5FE4840, 2, 7, 41, '2016-07-01 14:18:09'),
    (2533998, 0xE6100000010C3206312B6F383A40067987252FFD4840, 2, 7, 41, '2016-07-01 14:20:09'),
    (2534095, 0xE6100000010C78DFE7AEDB343A40E18AD5308DFB4840, 2, 7, 41, '2016-07-01 14:21:46'),
    (2534182, 0xE6100000010C67FE87AA4E313A4066BFEE74E7F94840, 2, 7, 41, '2016-07-01 14:23:27'),
    (2534183, 0xE6100000010CD22236B3F12D3A4079B361A81EF84840, 2, 7, 41, '2016-07-01 14:25:00'),
    (2534259, 0xE6100000010C6B4A0DC8B92A3A40F1129CFA40F64840, 2, 7, 41, '2016-07-01 14:26:31'),
    (2534447, 0xE6100000010C36165E937F273A40EA78CC4065F44840, 2, 7, 41, '2016-07-01 14:28:00'),
    (2534448, 0xE6100000010CE3FC4D2844243A40A36B706C87F24840, 2, 7, 41, '2016-07-01 14:29:29'),
    (2534449, 0xE6100000010C22CDB3ED0F213A40EA9CFA9BABF04840, 2, 7, 41, '2016-07-01 14:30:55'),
    (2534618, 0xE6100000010CCF30B5A50E1E3A40FE648C0FB3EE4840, 2, 7, 41, '2016-07-01 14:32:23'),
    (2534619, 0xE6100000010CD2EFB1AA141B3A40E90FCD3CB9EC4840, 2, 7, 41, '2016-07-01 14:33:47'),
    (2534620, 0xE6100000010C574513831B183A40D5642195BDEA4840, 2, 7, 41, '2016-07-01 14:35:13'),
    (2534733, 0xE6100000010C1EE7919AD1143A4087F9F202ECE84840, 2, 7, 41, '2016-07-01 14:36:38'),
    (2534755, 0xE6100000010CE536D03241113A402DDED9684AE74840, 2, 7, 41, '2016-07-01 14:38:07'),
    (2534845, 0xE6100000010C58D00F7E3D0E3A403AF1304855E54840, 2, 7, 41, '2016-07-01 14:39:30'),
    (2534886, 0xE6100000010CC868D3C7320B3A405270C2CE5EE34840, 2, 7, 41, '2016-07-01 14:40:57'),
    (2535002, 0xE6100000010C47205ED72F083A40AB7015D56CE14840, 2, 7, 41, '2016-07-01 14:42:25'),
    (2535034, 0xE6100000010C02E264D12A053A40626534F279DF4840, 2, 7, 41, '2016-07-01 14:43:52'),
    (2535104, 0xE6100000010C9EB29AAE27023A40E54691B586DD4840, 2, 7, 41, '2016-07-01 14:45:23'),
    (2535206, 0xE6100000010CFEC00B1126FF394094BF7B478DDB4840, 2, 7, 41, '2016-07-01 14:46:53'),
    (2535207, 0xE6100000010C86E7A56263FC39407733FED87FD94840, 2, 7, 41, '2016-07-01 14:48:19'),
    (2535287, 0xE6100000010C562B137EA9F939403F8C101E6DD74840, 2, 7, 41, '2016-07-01 14:49:43'),
    (2535300, 0xE6100000010C231DD434DEF639407BE9375D60D54840, 2, 7, 41, '2016-07-01 14:51:09'),
    (2535439, 0xE6100000010CE2A0736D5EF3394053B70E69AFD34840, 2, 7, 41, '2016-07-01 14:52:39'),
    (2535452, 0xE6100000010CCFE6278BB1F0394070067FBF98D14840, 2, 7, 41, '2016-07-01 14:54:11'),
    (2535571, 0xE6100000010CB10D260F55EE3940A852B3075ACF4840, 2, 7, 41, '2016-07-01 14:55:43'),
    (2535572, 0xE6100000010C5B4BB7DBE4EC3940BEA085048CCE4840, 2, 7, 41, '2016-07-01 14:56:23'),
    (2535687, 0xE6100000010C5DC6A8C6A6EA39400C76C3B645CE4840, 2, 7, 41, '2016-07-01 14:57:23'),
    (2535688, 0xE6100000010C62DDD330D7E73940516E36B11BCE4840, 2, 7, 41, '2016-07-01 14:58:57'),
    (2535691, 0xE6100000010C8FE4F21FD2E739405B80118F1FCE4840, 2, 7, 41, '2016-07-01 14:59:01'),
    (2535832, 0xE6100000010C2607A2DDD7E73940A6B915C26ACE4840, 2, 7, 41, '2016-07-01 14:59:41'),
    (2535833, 0xE6100000010CE96CB713DBE73940752F41576CCE4840, 2, 7, 41, '2016-07-01 14:59:44'),
    (2535835, 0xE6100000010C021A5BBEE4E739400BAD985B6BCE4840, 2, 7, 41, '2016-07-01 14:59:48'),
    (2535836, 0xE6100000010CDFFAB0DEA8EB3940945F50F05ECE4840, 2, 7, 41, '2016-07-01 15:01:45'),
    (2535831, 0xE6100000010C749B70AFCCEB3940E27BDA3C69CE4840, 2, 7, 2, '2016-07-01 15:02:24'),
    (2537446, 0xE6100000010C749B70AFCCEB3940E27BDA3C69CE4840, 2, 7, 41, '2016-07-01 16:01:58'),
    (2537444, 0xE6100000010C749B70AFCCEB3940E27BDA3C69CE4840, 2, 7, 1, '2016-07-01 16:02:07'),
    (2537447, 0xE6100000010C671591BCCEEB3940E7D6B5076BCE4840, 2, 7, 41, '2016-07-01 16:03:04'),
    (2537448, 0xE6100000010CAA1908B8D6EB3940330C699E6DCE4840, 2, 7, 41, '2016-07-01 16:03:11'),
    (2537453, 0xE6100000010C64B37E8EEAEB394022A7AFE76BCE4840, 2, 7, 41, '2016-07-01 16:03:28'),
    (2537454, 0xE6100000010C01738813F3EB3940C314408C6BCE4840, 2, 7, 41, '2016-07-01 16:03:33'),
    (2537510, 0xE6100000010C48FEBB992CED39403D1460B3B7CE4840, 2, 7, 41, '2016-07-01 16:04:17'),
    (2537511, 0xE6100000010C2CD8463CD9EF3940E26C848FD2D04840, 2, 7, 41, '2016-07-01 16:05:52'),
    (2537650, 0xE6100000010CA709360939F23940E93C748B0AD34840, 2, 7, 41, '2016-07-01 16:07:14'),
    (2537714, 0xE6100000010CF70C3C52D8F2394071CCB22781D34840, 2, 7, 41, '2016-07-01 16:09:14'),
    (2537715, 0xE6100000010CBAA69B1FDAF2394018CFA0A17FD34840, 2, 7, 41, '2016-07-01 16:09:34'),
    (2537773, 0xE6100000010C19EB76514FF639405194957032D54840, 2, 7, 41, '2016-07-01 16:11:22'),
    (2537774, 0xE6100000010C56DE44E33FF939403C365DAA2DD74840, 2, 7, 41, '2016-07-01 16:12:51'),
    (2537839, 0xE6100000010C6DD6CF51FDFB39406094FB7843D94840, 2, 7, 41, '2016-07-01 16:14:17'),
    (2537849, 0xE6100000010C27E77A91BFFE3940D333BDC458DB4840, 2, 7, 41, '2016-07-01 16:15:44'),
    (2537905, 0xE6100000010C962B1785B8013A409CC992944FDD4840, 2, 7, 41, '2016-07-01 16:17:07'),
    (2537909, 0xE6100000010CEFD57DB6C4043A400C8A308F46DF4840, 2, 7, 41, '2016-07-01 16:18:27'),
    (2537974, 0xE6100000010C392DD38ACA073A40B82638503BE14840, 2, 7, 41, '2016-07-01 16:19:51'),
    (2538035, 0xE6100000010C8A75AA7CCF0A3A40108B620333E34840, 2, 7, 41, '2016-07-01 16:21:16'),
    (2538036, 0xE6100000010C33FD12F1D60D3A40643090B124E54840, 2, 7, 41, '2016-07-01 16:22:37'),
    (2538100, 0xE6100000010C58CE39D3DF103A40C569D2B716E74840, 2, 7, 41, '2016-07-01 16:24:00'),
    (2538110, 0xE6100000010C352905DD5E143A406500A8E2C6E84840, 2, 7, 41, '2016-07-01 16:25:21'),
    (2538189, 0xE6100000010C4B7BDEE8BE173A405859DB148FEA4840, 2, 7, 41, '2016-07-01 16:26:45'),
    (2538201, 0xE6100000010C0FD3BEB9BF1A3A4004CB113290EC4840, 2, 7, 41, '2016-07-01 16:28:05'),
    (2538270, 0xE6100000010CD71AA5A6B81D3A40A79201A08AEE4840, 2, 7, 41, '2016-07-01 16:29:28'),
    (2538276, 0xE6100000010C2202695ABD203A4000BE254A8CF04840, 2, 7, 41, '2016-07-01 16:30:51'),
    (2538339, 0xE6100000010C34BC5983F7233A40AB4203B16CF24840, 2, 7, 41, '2016-07-01 16:32:14'),
    (2538348, 0xE6100000010CC2BF081A33273A4093F139C148F44840, 2, 7, 41, '2016-07-01 16:33:37'),
    (2538846, 0xE6100000010CC26A2C616D2A3A404C022F8E25F64840, 2, 7, 41, '2016-07-01 16:34:59'),
    (2538847, 0xE6100000010C4D39155FA32D3A407D699B2CFFF74840, 2, 7, 41, '2016-07-01 16:36:21'),
    (2538848, 0xE6100000010CCE38680AF8303A400EA2B5A2CDF94840, 2, 7, 41, '2016-07-01 16:37:43'),
    (2538850, 0xE6100000010C29232E008D343A40F964C57075FB4840, 2, 7, 41, '2016-07-01 16:39:33'),
    (2538921, 0xE6100000010CB349D97D22383A40DF7E0A911DFD4840, 2, 7, 41, '2016-07-01 16:41:08'),
    (2538961, 0xE6100000010C827AE9DCA33B3A40CF4E0647C9FE4840, 2, 7, 41, '2016-07-01 16:43:04'),
    (2538962, 0xE6100000010C38CAB040AA3B3A40D0ED258DD1FE4840, 2, 7, 41, '2016-07-01 16:43:10'),
    (2539096, 0xE6100000010C998D846C0F393A4022516859F7004940, 2, 7, 41, '2016-07-01 16:45:04'),
    (2539097, 0xE6100000010CFF791A3048363A40CE3BA98A04034940, 2, 7, 41, '2016-07-01 16:46:39'),
    (2539098, 0xE6100000010CBDA94885B1353A401958C7F143034940, 2, 7, 41, '2016-07-01 16:47:14'),
    (2539099, 0xE6100000010C282CF180B2353A40B3A08BE145034940, 2, 7, 41, '2016-07-01 16:47:16'),
    (2539100, 0xE6100000010C0807D6CCB5353A40FFDB76EB46034940, 2, 7, 41, '2016-07-01 16:47:18'),
    (2539101, 0xE6100000010C68041BD7BF353A4078A27FDD44034940, 2, 7, 41, '2016-07-01 16:47:20'),
    (2539105, 0xE6100000010C97056E3887363A4097AB1F9BE4024940, 2, 7, 41, '2016-07-01 16:47:50'),
    (2539153, 0xE6100000010CCCC3F81F4F373A4089192B7B5C024940, 2, 7, 41, '2016-07-01 16:48:28'),
    (2539154, 0xE6100000010CAFB14B546F373A4071EBC9575D024940, 2, 7, 41, '2016-07-01 16:48:33'),
    (2539155, 0xE6100000010CC9CC052E8F373A40A02AF05F6A024940, 2, 7, 41, '2016-07-01 16:48:38'),
    (2539156, 0xE6100000010CDB40704B9A373A408507CDAE7B024940, 2, 7, 41, '2016-07-01 16:48:42'),
    (2539157, 0xE6100000010C5B66C7FC92373A40099CB69091024940, 2, 7, 41, '2016-07-01 16:48:47'),
    (2539158, 0xE6100000010CC7BC8E3864373A40818B5FC2B2024940, 2, 7, 41, '2016-07-01 16:49:03'),
    (2539159, 0xE6100000010CAC7C85BB69373A409765998FB5024940, 2, 7, 41, '2016-07-01 16:49:06'),
    (2539316, 0xE6100000010CCEECA98BCA3A3A40822E2B5E76044940, 2, 7, 41, '2016-07-01 16:50:49'),
    (2539317, 0xE6100000010C4514EEF0323C3A40F75F426040054940, 2, 7, 41, '2016-07-01 16:51:29'),
    (2539318, 0xE6100000010C0428FC08B2403A40A07DF66DD2054940, 2, 7, 41, '2016-07-01 16:52:58'),
    (2539319, 0xE6100000010C2CF75D6CB5443A4030D7A20568064940, 2, 7, 41, '2016-07-01 16:54:15'),
    (2539325, 0xE6100000010C1155F833BC453A40707E1EFEF5064940, 2, 7, 41, '2016-07-01 16:54:50'),
    (2539329, 0xE6100000010C7DF77DEEBA453A406FBA6587F8064940, 2, 7, 41, '2016-07-01 16:54:52'),
    (2539334, 0xE6100000010C8B074AC09E453A40AB6BFEA902074940, 2, 7, 41, '2016-07-01 16:55:02'),
    (2539343, 0xE6100000010C6C770FD07D453A406DCBDB6C07074940, 2, 7, 41, '2016-07-01 16:55:10'),
    (2539353, 0xE6100000010CA03EB8F1DD443A409008D7EDFD064940, 2, 7, 41, '2016-07-01 16:55:32'),
    (2541008, 0xE6100000010CB47D7ECE93433A406FF59CF4BE064940, 2, 7, 41, '2016-07-01 16:56:20'),
    (2541009, 0xE6100000010C4165FCFB8C433A4063BDACE4BE064940, 2, 7, 41, '2016-07-01 16:56:23'),
    (2541010, 0xE6100000010C84BC1E4C8A433A40FDA94C8CC0064940, 2, 7, 41, '2016-07-01 16:56:25'),
    (2541011, 0xE6100000010C268F029F7A433A4091FF136DD8064940, 2, 7, 41, '2016-07-01 16:56:58'),
    (2541003, 0xE6100000010C2123FB7B84433A40D5038B68E0064940, 2, 7, 2, '2016-07-01 16:57:45'),
    (2542838, 0xE6100000010C2123FB7B84433A40D5038B68E0064940, 2, 7, 41, '2016-07-01 17:57:46'),
    (2547030, 0xE6100000010C2123FB7B84433A40D5038B68E0064940, 2, 7, 1, '2016-07-01 22:31:00'),
    (2547034, 0xE6100000010CD415229683433A40DB368C82E0064940, 2, 7, 41, '2016-07-01 22:31:15'),
    (2547037, 0xE6100000010C8B5F67F970433A401B344F09E3064940, 2, 7, 41, '2016-07-01 22:31:32'),
    (2547046, 0xE6100000010C2025766D6F433A40B38410EBE8064940, 2, 7, 41, '2016-07-01 22:31:42'),
    (2547053, 0xE6100000010CD228136D7D433A40099B4BBBE2064940, 2, 7, 41, '2016-07-01 22:31:59'),
    (2547055, 0xE6100000010C191D90847D433A40AB425E6ADF064940, 2, 7, 41, '2016-07-01 22:32:03'),
    (2547058, 0xE6100000010C9FF133E48E433A40BA5BA32FCE064940, 2, 7, 41, '2016-07-01 22:32:18'),
    (2547065, 0xE6100000010CD61C2098A3433A40AA0D4E44BF064940, 2, 7, 41, '2016-07-01 22:32:36'),
    (2547073, 0xE6100000010C158C4AEA04443A40A38F9EC7CD064940, 2, 7, 41, '2016-07-01 22:32:59'),
    (2547114, 0xE6100000010CED10FFB0A5453A40E399E15009074940, 2, 7, 41, '2016-07-01 22:34:01'),
    (2547115, 0xE6100000010C73897EC8B6453A407B9FAA4203074940, 2, 7, 41, '2016-07-01 22:34:06'),
    (2547116, 0xE6100000010C66C46059C4453A40ECDB4944F8064940, 2, 7, 41, '2016-07-01 22:34:18'),
    (2547117, 0xE6100000010CA8E73812C3453A40D02A33A5F5064940, 2, 7, 41, '2016-07-01 22:34:20'),
    (2547118, 0xE6100000010C3DC560B47D443A40492D944C4E064940, 2, 7, 41, '2016-07-01 22:35:03'),
    (2547226, 0xE6100000010CD758784DFE3F3A40B901FAD8B8054940, 2, 7, 41, '2016-07-01 22:36:34'),
    (2547227, 0xE6100000010C6754CF38C33B3A404CB7369E19054940, 2, 7, 41, '2016-07-01 22:37:54'),
    (2547228, 0xE6100000010CCB9F6F0B96383A4020A8644A35034940, 2, 7, 41, '2016-07-01 22:39:28'),
    (2547358, 0xE6100000010CB4D0292389373A40B8681206AF024940, 2, 7, 41, '2016-07-01 22:40:02'),
    (2547359, 0xE6100000010C1335875A89373A40A070766B99024940, 2, 7, 41, '2016-07-01 22:40:05'),
    (2547360, 0xE6100000010C2F17F19D98373A400B992B836A024940, 2, 7, 41, '2016-07-01 22:40:15'),
    (2547361, 0xE6100000010C4CA59F7076373A4041F6D5B03A024940, 2, 7, 41, '2016-07-01 22:40:27'),
    (2547362, 0xE6100000010C7BBE66B96C383A40F5A2D1787D014940, 2, 7, 41, '2016-07-01 22:41:17'),
    (2547363, 0xE6100000010CCA7443AE2F3B3A40D4658C6A6CFF4840, 2, 7, 41, '2016-07-01 22:43:01'),
    (2547419, 0xE6100000010CC784F3041D3E3A4090A56A16C3FD4840, 2, 7, 41, '2016-07-01 22:45:01'),
    (2547420, 0xE6100000010C31A30EE14E3E3A407082CA53B1FD4840, 2, 7, 41, '2016-07-01 22:45:12'),
    (2547421, 0xE6100000010CBA86191A4F3E3A4053B70E69AFFD4840, 2, 7, 41, '2016-07-01 22:45:14'),
    (2547422, 0xE6100000010C56E185634C3E3A40001B1021AEFD4840, 2, 7, 41, '2016-07-01 22:45:16'),
    (2547423, 0xE6100000010CD706DD14453E3A40DD442DCDADFD4840, 2, 7, 41, '2016-07-01 22:45:18'),
    (2547424, 0xE6100000010C274EEE77283E3A40EA5DBC1FB7FD4840, 2, 7, 41, '2016-07-01 22:45:24'),
    (2547425, 0xE6100000010CAE69392BFD3D3A40FAAB110BC6FD4840, 2, 7, 41, '2016-07-01 22:45:35'),
    (2547426, 0xE6100000010C0D7D66FFF23D3A409191FD3DC2FD4840, 2, 7, 41, '2016-07-01 22:45:38'),
    (2547481, 0xE6100000010CC00BB66C083D3A4005E5113702FD4840, 2, 7, 41, '2016-07-01 22:46:49'),
    (2547482, 0xE6100000010CF878D78F033D3A40ED5A8CCB02FD4840, 2, 7, 41, '2016-07-01 22:46:50'),
    (2547484, 0xE6100000010CF2F7414C783C3A40D78DD20039FD4840, 2, 7, 41, '2016-07-01 22:47:24'),
    (2547485, 0xE6100000010C8560B0766F3C3A402D9ED55D34FD4840, 2, 7, 41, '2016-07-01 22:47:27'),
    (2547486, 0xE6100000010CBB1006F9343C3A4050AFEF1EFBFC4840, 2, 7, 41, '2016-07-01 22:47:52'),
    (2547487, 0xE6100000010C835B2D663A3C3A40C8EBC1A4F8FC4840, 2, 7, 41, '2016-07-01 22:47:54'),
    (2547538, 0xE6100000010C50CB6A15583D3A40A9424D3E87FC4840, 2, 7, 41, '2016-07-01 22:48:58'),
    (2547540, 0xE6100000010CC8D3F203573D3A4063FE1BC583FC4840, 2, 7, 41, '2016-07-01 22:49:00'),
    (2547541, 0xE6100000010C81278815C93C3A40290F666E19FC4840, 2, 7, 41, '2016-07-01 22:49:42'),
    (2547542, 0xE6100000010CAE62F19BC23C3A408E08217B18FC4840, 2, 7, 41, '2016-07-01 22:49:45'),
    (2547543, 0xE6100000010CC2210A1CBF3C3A4023DC645419FC4840, 2, 7, 41, '2016-07-01 22:49:47'),
    (2547544, 0xE6100000010CF0C979B5923C3A4038E1B9522AFC4840, 2, 7, 41, '2016-07-01 22:50:08'),
    (2547545, 0xE6100000010CD6B441DC8B3C3A40F20C1AFA27FC4840, 2, 7, 41, '2016-07-01 22:50:11'),
    (2547625, 0xE6100000010CD0C3BFBE8C3C3A40A7CF697121FC4840, 2, 7, 41, '2016-07-01 22:52:11'),
    (2547723, 0xE6100000010C5F84DF3C8B3C3A400EB5B7A51FFC4840, 2, 7, 41, '2016-07-01 22:57:55'),
    (2547725, 0xE6100000010C833DDCC47F3C3A40CB8866F915FC4840, 2, 7, 41, '2016-07-01 22:58:07'),
    (2547727, 0xE6100000010CE0BDA3C6843C3A40F65503DE13FC4840, 2, 7, 41, '2016-07-01 22:58:10'),
    (2547728, 0xE6100000010C50B05AF4A93C3A402A406F850BFC4840, 2, 7, 41, '2016-07-01 22:58:31'),
    (2547729, 0xE6100000010CFF9E0E1AB03C3A40DCA227C00BFC4840, 2, 7, 41, '2016-07-01 22:58:35'),
    (2547768, 0xE6100000010C2D98F8A3A83D3A402674F27DCCFC4840, 2, 7, 41, '2016-07-01 22:59:52'),
    (2547769, 0xE6100000010C7444BE4BA93D3A40CF6BEC12D5FC4840, 2, 7, 41, '2016-07-01 22:59:56'),
    (2547770, 0xE6100000010C9831056B9C3D3A407448C55AD7FC4840, 2, 7, 41, '2016-07-01 22:59:58'),
    (2547808, 0xE6100000010CF3B116FABB3A3A4044D0E2D6EEFD4840, 2, 7, 41, '2016-07-01 23:01:58'),
    (2547810, 0xE6100000010CD722580BA23A3A4008A1CDBBFBFD4840, 2, 7, 41, '2016-07-01 23:02:07'),
    (2547811, 0xE6100000010C29154328A53A3A408ECE54E300FE4840, 2, 7, 41, '2016-07-01 23:02:10'),
    (2547812, 0xE6100000010C52465C001A3B3A40CD678A4A34FE4840, 2, 7, 41, '2016-07-01 23:02:27'),
    (2547813, 0xE6100000010C10E6762FF73B3A40FE4465C39AFE4840, 2, 7, 41, '2016-07-01 23:03:11'),
    (2547814, 0xE6100000010CACB07499F53B3A4062D0532E9EFE4840, 2, 7, 41, '2016-07-01 23:03:13'),
    (2547815, 0xE6100000010CAADAC93BE23B3A406F4507C9A7FE4840, 2, 7, 41, '2016-07-01 23:03:20'),
    (2547816, 0xE6100000010CD3C08F6AD83B3A4080208A13A9FE4840, 2, 7, 41, '2016-07-01 23:03:24'),
    (2547817, 0xE6100000010C0D6E6B0BCF3B3A404656C8A6A6FE4840, 2, 7, 41, '2016-07-01 23:03:28'),
    (2547862, 0xE6100000010C4DD87E32C63B3A4051BCCADAA6FE4840, 2, 7, 41, '2016-07-01 23:04:49'),
    (2547863, 0xE6100000010C17557545DF3B3A40D0BE4DDAAFFE4840, 2, 7, 41, '2016-07-01 23:04:58'),
    (2547864, 0xE6100000010C35464662DD3B3A40A4614216B3FE4840, 2, 7, 41, '2016-07-01 23:05:00'),
    (2547865, 0xE6100000010C690D94CACA3B3A40BFAAC486B8FE4840, 2, 7, 41, '2016-07-01 23:05:05'),
    (2547866, 0xE6100000010C9FD44D18833B3A405610035DFBFE4840, 2, 7, 41, '2016-07-01 23:05:34'),
    (2547867, 0xE6100000010CC6C4E6E3DA383A401F4EBBF31F014940, 2, 7, 41, '2016-07-01 23:07:19'),
    (2547891, 0xE6100000010C94CD0B6602363A40F931E6AE25034940, 2, 7, 41, '2016-07-01 23:08:51'),
    (2547892, 0xE6100000010C16AD927EB1353A40070143A044034940, 2, 7, 41, '2016-07-01 23:09:12'),
    (2547893, 0xE6100000010CD235936FB6353A408E34023B48034940, 2, 7, 41, '2016-07-01 23:09:15'),
    (2547894, 0xE6100000010CBCEE0802BF353A40C8E41E5C4B034940, 2, 7, 41, '2016-07-01 23:09:20'),
    (2547895, 0xE6100000010C7718EEB7D1353A40C94CB38A48034940, 2, 7, 41, '2016-07-01 23:09:25'),
    (2547896, 0xE6100000010CA7D887ABB9363A40F68AB84AC1024940, 2, 7, 41, '2016-07-01 23:09:58'),
    (2547899, 0xE6100000010CC5D2760250373A407D3D5FB35C024940, 2, 7, 41, '2016-07-01 23:10:27'),
    (2547902, 0xE6100000010C166FBFD76B373A404E1B1F775B024940, 2, 7, 41, '2016-07-01 23:10:31'),
    (2547905, 0xE6100000010CBFBA2A508B373A40C12D69D663024940, 2, 7, 41, '2016-07-01 23:10:35'),
    (2547906, 0xE6100000010C8B1BB7989F373A40274D83A279024940, 2, 7, 41, '2016-07-01 23:10:39'),
    (2547909, 0xE6100000010CB91AD99596373A40EA060ABC93024940, 2, 7, 41, '2016-07-01 23:10:44'),
    (2547916, 0xE6100000010CD4D2DC0A61373A40D369DD06B5024940, 2, 7, 41, '2016-07-01 23:11:02'),
    (2547919, 0xE6100000010C496760E465373A40D1CDFE40B9024940, 2, 7, 41, '2016-07-01 23:11:05'),
    (2547951, 0xE6100000010C182A5A14D13A3A4086973B8E7A044940, 2, 7, 41, '2016-07-01 23:12:55'),
    (2547954, 0xE6100000010C207A5226353C3A40D221CBDD42054940, 2, 7, 41, '2016-07-01 23:13:34'),
    (2547994, 0xE6100000010CA670F37CBC403A40C9C859D8D3054940, 2, 7, 41, '2016-07-01 23:15:06'),
    (2548020, 0xE6100000010C65F4ED6EAF443A407F52488D64064940, 2, 7, 41, '2016-07-01 23:16:30'),
    (2548021, 0xE6100000010C7FF8F9EFC1453A40C1DA62C8FB064940, 2, 7, 41, '2016-07-01 23:17:09'),
    (2548022, 0xE6100000010CAF7C96E7C1453A40ACE7FFB000074940, 2, 7, 41, '2016-07-01 23:17:12'),
    (2548023, 0xE6100000010C5FCFD72C97453A40F5D6C05609074940, 2, 7, 41, '2016-07-01 23:17:25'),
    (2548024, 0xE6100000010CDA73999A04453A406678FD9309074940, 2, 7, 41, '2016-07-01 23:17:43'),
    (2548059, 0xE6100000010C9F45A5C7A5423A40A979D85592064940, 2, 7, 41, '2016-07-01 23:19:43'),
    (2548075, 0xE6100000010C8A3265F1AC423A40B4D9A21694064940, 2, 7, 41, '2016-07-01 23:21:18'),
    (2548076, 0xE6100000010C6B18F4948B433A4068EA758BC0064940, 2, 7, 41, '2016-07-01 23:22:24'),
    (2548078, 0xE6100000010CF1E31E0192433A40F56ADB8BC3064940, 2, 7, 41, '2016-07-01 23:22:27'),
    (2548079, 0xE6100000010C3E8166C691433A40F4D43439C6064940, 2, 7, 41, '2016-07-01 23:22:30'),
    (2548080, 0xE6100000010C53605C058C433A4053F1DA00C7064940, 2, 7, 41, '2016-07-01 23:22:33'),
    (2548082, 0xE6100000010C3050AD1974433A4013D8F73CDA064940, 2, 7, 41, '2016-07-01 23:23:04'),
    (2548084, 0xE6100000010C9B7FAAC07F433A4070CE88D2DE064940, 2, 7, 41, '2016-07-01 23:23:17'),
    (2548085, 0xE6100000010C6B8885B58C433A40F715B545E3064940, 2, 7, 2, '2016-07-01 23:23:37'),
    (2548855, 0xE6100000010C6B8885B58C433A40F715B545E3064940, 2, 7, 41, '2016-07-02 00:23:37'),
    (2563916, 0xE6100000010C6B8885B58C433A40F715B545E3064940, 2, 7, 1, '2016-07-02 12:42:34'),
    (2563992, 0xE6100000010C8E9DA68581433A4011DABCBBDF064940, 2, 7, 41, '2016-07-02 12:43:07'),
    (2564013, 0xE6100000010C1F36EC527E433A408E1546C4DE064940, 2, 7, 41, '2016-07-02 12:43:16'),
    (2564064, 0xE6100000010CCA90BEA48C433A40A30227DBC0064940, 2, 7, 41, '2016-07-02 12:43:45'),
    (2564065, 0xE6100000010C2DEE9AEB8F433A4092B1DAFCBF064940, 2, 7, 41, '2016-07-02 12:43:47'),
    (2564272, 0xE6100000010CC9E53FA4DF443A40CC26C0B0FC064940, 2, 7, 41, '2016-07-02 12:44:33'),
    (2564273, 0xE6100000010C57F1A19F04453A408613E2DB05074940, 2, 7, 41, '2016-07-02 12:44:40'),
    (2564274, 0xE6100000010C3BE2900DA4453A405100208205074940, 2, 7, 41, '2016-07-02 12:44:58'),
    (2564275, 0xE6100000010C1AEBD10AC2453A407A34D593F9064940, 2, 7, 41, '2016-07-02 12:45:12'),
    (2564276, 0xE6100000010C566E5809CC453A4020F70890FC064940, 2, 7, 41, '2016-07-02 12:45:15'),
    (2564323, 0xE6100000010C1631EC3026473A4023224619BB074940, 2, 7, 41, '2016-07-02 12:46:26'),
    (2564330, 0xE6100000010C9FB8D22126473A40BC92E4B9BE074940, 2, 7, 41, '2016-07-02 12:46:29'),
    (2564349, 0xE6100000010C6249B9FB1C473A4001892650C4074940, 2, 7, 41, '2016-07-02 12:46:33'),
    (2564494, 0xE6100000010C7F22050594463A40521443CDEB074940, 2, 7, 41, '2016-07-02 12:47:12'),
    (2564495, 0xE6100000010C514F1F813F463A40427CBB80F2074940, 2, 7, 41, '2016-07-02 12:47:32'),
    (2564496, 0xE6100000010C28A897CE3D463A404521133AF9074940, 2, 7, 41, '2016-07-02 12:47:35'),
    (2564497, 0xE6100000010CFCA9F1D24D463A407E0283FF08084940, 2, 7, 41, '2016-07-02 12:47:41'),
    (2564498, 0xE6100000010C3A306FC449463A40F9F719170E084940, 2, 7, 41, '2016-07-02 12:47:43'),
    (2564499, 0xE6100000010C53EBFD463B463A4027A7D13F1C084940, 2, 7, 41, '2016-07-02 12:47:48'),
    (2564500, 0xE6100000010CDF933DF83F463A40F6BDE1992B084940, 2, 7, 41, '2016-07-02 12:47:52'),
    (2564501, 0xE6100000010C5D37A5BC56463A40841FE6DC37084940, 2, 7, 41, '2016-07-02 12:47:56'),
    (2564502, 0xE6100000010CFA97A432C5463A40A1359AB745084940, 2, 7, 41, '2016-07-02 12:48:12'),
    (2564503, 0xE6100000010CB2DE03CF18473A40BA5BA32FCE084940, 2, 7, 41, '2016-07-02 12:48:39'),
    (2564504, 0xE6100000010C05FFB68201473A40510658F503094940, 2, 7, 41, '2016-07-02 12:48:46'),
    (2564546, 0xE6100000010CDA4CCF053F453A409A289DA3E9094940, 2, 7, 41, '2016-07-02 12:49:31'),
    (2564547, 0xE6100000010C3CF71E2E39443A40E6DDA2DD320A4940, 2, 7, 41, '2016-07-02 12:49:57'),
    (2564548, 0xE6100000010CBFC1CD9838443A40DEB29EB5360A4940, 2, 7, 41, '2016-07-02 12:49:59'),
    (2564549, 0xE6100000010C10CEA78E55443A40F73471BC4C0A4940, 2, 7, 41, '2016-07-02 12:50:10'),
    (2564550, 0xE6100000010CB202322A5F443A40EF3DB72B4F0A4940, 2, 7, 41, '2016-07-02 12:50:14'),
    (2564551, 0xE6100000010CD1D4A18966443A40C6C4419D4D0A4940, 2, 7, 41, '2016-07-02 12:50:16'),
    (2564695, 0xE6100000010C9B0535D7C4473A407521567F84084940, 2, 7, 41, '2016-07-02 12:51:50'),
    (2564696, 0xE6100000010C4DF38E53744A3A40F2EA1C03B2064940, 2, 7, 41, '2016-07-02 12:53:09'),
    (2564697, 0xE6100000010C4C25F213BD4E3A40446F4CAA11064940, 2, 7, 41, '2016-07-02 12:54:29'),
    (2564698, 0xE6100000010C9EEFA7C64B4F3A402BA391CF2B064940, 2, 7, 41, '2016-07-02 12:54:41'),
    (2564699, 0xE6100000010CEEE1DC7069523A40363F598C15084940, 2, 7, 41, '2016-07-02 12:56:09'),
    (2564700, 0xE6100000010C04EB93371B543A40DFC897AB7A0A4940, 2, 7, 41, '2016-07-02 12:57:33'),
    (2564807, 0xE6100000010CD5A01E91A5553A405D46FB69ED0C4940, 2, 7, 41, '2016-07-02 12:58:56'),
    (2564801, 0xE6100000010C2448A5D8D1563A4075125B8B600E4940, 2, 7, 8, '2016-07-02 12:59:43'),
    (2564802, 0xE6100000010C1C4531D4BC583A40C9B0E5F0A40F4940, 2, 7, 8, '2016-07-02 13:00:34'),
    (2564803, 0xE6100000010C1651137D3E5A3A40E46A64575A114940, 2, 7, 8, '2016-07-02 13:01:30'),
    (2564805, 0xE6100000010C6DEC6D8ECE5A3A40C823B891B2114940, 2, 7, 8, '2016-07-02 13:01:45'),
    (2564864, 0xE6100000010CF644D7851F5C3A400B7C45B75E124940, 2, 7, 8, '2016-07-02 13:02:16'),
    (2564866, 0xE6100000010C81B053AC1A5E3A40BEE4DAABEA124940, 2, 7, 8, '2016-07-02 13:02:52'),
    (2564867, 0xE6100000010CA4EB7882B3623A40E9C770862C134940, 2, 7, 41, '2016-07-02 13:04:11'),
    (2564878, 0xE6100000010C09C556D0B4643A4012F5824F73134940, 2, 7, 41, '2016-07-02 13:04:51'),
    (2564879, 0xE6100000010CB32A1D07B9643A404BCD792178134940, 2, 7, 41, '2016-07-02 13:04:53'),
    (2564880, 0xE6100000010CAEA12F18B7643A40DDEA39E97D134940, 2, 7, 41, '2016-07-02 13:04:57'),
    (2564955, 0xE6100000010C5138166FBF613A400C6A09432E154940, 2, 7, 8, '2016-07-02 13:06:15'),
    (2564957, 0xE6100000010C6BD8EF89755E3A400349337106174940, 2, 7, 41, '2016-07-02 13:07:31'),
    (2565008, 0xE6100000010C0C40A374E95B3A401EC6FF780A184940, 2, 7, 41, '2016-07-02 13:09:31'),
    (2565009, 0xE6100000010C70445266DE5B3A407A9CB34F11184940, 2, 7, 41, '2016-07-02 13:10:35'),
    (2565010, 0xE6100000010C80CBAD5AE35B3A40FF3C0D1824184940, 2, 7, 41, '2016-07-02 13:10:42'),
    (2565063, 0xE6100000010C021BC693935D3A4022B60595021A4940, 2, 7, 41, '2016-07-02 13:12:42'),
    (2565065, 0xE6100000010CBA4E232D955D3A40F9646AB7021A4940, 2, 7, 41, '2016-07-02 13:12:43'),
    (2565067, 0xE6100000010CCBE1EE07975D3A409A1AB2CB011A4940, 2, 7, 41, '2016-07-02 13:12:45'),
    (2565068, 0xE6100000010C7993DFA2935D3A4031EC3026FD194940, 2, 7, 41, '2016-07-02 13:12:47'),
    (2565070, 0xE6100000010CC7F65AD07B5D3A4085B0BF91E5194940, 2, 7, 41, '2016-07-02 13:13:05'),
    (2565166, 0xE6100000010C3E1350977B5D3A40AAC024F0E2194940, 2, 7, 41, '2016-07-02 13:15:07'),
    (2565220, 0xE6100000010C79115C9B7C5D3A406783A7EBE4194940, 2, 7, 41, '2016-07-02 13:18:48'),
    (2565221, 0xE6100000010C62C1583A7A5D3A40549CB4BAE6194940, 2, 7, 41, '2016-07-02 13:18:58'),
    (2565338, 0xE6100000010C8D6C9D6E8F5C3A40B3C414F6FE184940, 2, 7, 41, '2016-07-02 13:20:17'),
    (2565339, 0xE6100000010CC3E3912EEC5B3A40F3B3ECA419184940, 2, 7, 41, '2016-07-02 13:21:08'),
    (2565341, 0xE6100000010C6153E751F15B3A40664D2CF015184940, 2, 7, 41, '2016-07-02 13:21:10'),
    (2565331, 0xE6100000010CE23AC615175F3A40FA4674CFBA164940, 2, 7, 8, '2016-07-02 13:22:30'),
    (2565428, 0xE6100000010C82C64CA25E623A40611C5C3AE6144940, 2, 7, 41, '2016-07-02 13:23:47'),
    (2565429, 0xE6100000010CA83BAAF5D9643A402AB05B5F7F134940, 2, 7, 41, '2016-07-02 13:25:47'),
    (2565430, 0xE6100000010C27333910ED643A405DE73AE86D134940, 2, 7, 41, '2016-07-02 13:25:59'),
    (2565431, 0xE6100000010C7D85BB69E9643A40EE15270868134940, 2, 7, 41, '2016-07-02 13:26:01'),
    (2565432, 0xE6100000010C35D07CCEDD643A401A2B7B5C65134940, 2, 7, 41, '2016-07-02 13:26:03'),
    (2565482, 0xE6100000010CDAC534D3BD603A40B2DBC24E0C134940, 2, 7, 8, '2016-07-02 13:27:22'),
    (2565486, 0xE6100000010CEEBE19EBD15C3A403920538891124940, 2, 7, 41, '2016-07-02 13:28:27'),
    (2565577, 0xE6100000010CE749E361EB593A40A8C9E77008114940, 2, 7, 41, '2016-07-02 13:29:39'),
    (2565571, 0xE6100000010CF0952F1E94583A408EC23FB6760F4940, 2, 7, 8, '2016-07-02 13:30:32'),
    (2565583, 0xE6100000010CEBB2F391EF553A409F8EC70C540D4940, 2, 7, 41, '2016-07-02 13:31:44'),
    (2565710, 0xE6100000010C0E97660465543A40CFB3A382D40A4940, 2, 7, 41, '2016-07-02 13:32:55'),
    (2565711, 0xE6100000010CEC4D0CC9C9523A40540FE21467084940, 2, 7, 41, '2016-07-02 13:34:09'),
    (2565777, 0xE6100000010C28D4D347E04F3A40C4E3ECE75E064940, 2, 7, 41, '2016-07-02 13:35:20'),
    (2565778, 0xE6100000010CDBFB54151A4E3A407890E8AFA1054940, 2, 7, 41, '2016-07-02 13:36:02'),
    (2565779, 0xE6100000010CD53E1D8F194E3A40BAB07FE893054940, 2, 7, 41, '2016-07-02 13:36:06'),
    (2565780, 0xE6100000010C571A42DF274E3A401AD01CA386054940, 2, 7, 41, '2016-07-02 13:36:09'),
    (2565781, 0xE6100000010C2B6DCC46424E3A40A78988AC7F054940, 2, 7, 41, '2016-07-02 13:36:12'),
    (2565782, 0xE6100000010CB80721205F4E3A40883C934781054940, 2, 7, 41, '2016-07-02 13:36:15'),
    (2565783, 0xE6100000010C3B545392754E3A40D13FC1C58A054940, 2, 7, 41, '2016-07-02 13:36:17'),
    (2565784, 0xE6100000010C3678BA4E7E4E3A40CF5037AB99054940, 2, 7, 41, '2016-07-02 13:36:20'),
    (2565785, 0xE6100000010CCA3C4DC1754E3A40C79E3D97A9054940, 2, 7, 41, '2016-07-02 13:36:24'),
    (2565786, 0xE6100000010C79D44E83584E3A40906EDFFEB7054940, 2, 7, 41, '2016-07-02 13:36:28'),
    (2565898, 0xE6100000010CF491EFADA34B3A40887A0B3554064940, 2, 7, 8, '2016-07-02 13:37:19'),
    (2565899, 0xE6100000010CC53FC7A2444A3A40E199D024B1064940, 2, 7, 8, '2016-07-02 13:37:42'),
    (2565900, 0xE6100000010C2448009244483A40C7777302E4074940, 2, 7, 41, '2016-07-02 13:38:30'),
    (2565901, 0xE6100000010C2F1C638275473A40C27174F0A7084940, 2, 7, 41, '2016-07-02 13:39:02'),
    (2565902, 0xE6100000010C98AB7A5457473A40913D8C5AAB084940, 2, 7, 41, '2016-07-02 13:39:06'),
    (2565903, 0xE6100000010C2BDA1CE736473A408E84C7C8A3084940, 2, 7, 41, '2016-07-02 13:39:10'),
    (2565904, 0xE6100000010C8F24F72AE8463A40876F61DD78084940, 2, 7, 41, '2016-07-02 13:39:22'),
    (2565905, 0xE6100000010CD52A55FDA5463A4029C12CFE00084940, 2, 7, 41, '2016-07-02 13:40:10'),
    (2565907, 0xE6100000010C73309B00C3463A40E3E0D231E7074940, 2, 7, 41, '2016-07-02 13:40:16'),
    (2565919, 0xE6100000010C526CBBBF30473A40467C2766BD074940, 2, 7, 41, '2016-07-02 13:40:58'),
    (2565925, 0xE6100000010CB8C19A1430473A40AE3FD35CB8074940, 2, 7, 41, '2016-07-02 13:41:01'),
    (2565989, 0xE6100000010C19FF3EE3C2453A405117844DF8064940, 2, 7, 41, '2016-07-02 13:42:05'),
    (2565990, 0xE6100000010CBEE60B10BB453A40406A1327F7064940, 2, 7, 41, '2016-07-02 13:42:07'),
    (2565993, 0xE6100000010CD3212697B5453A40FE463B6EF8064940, 2, 7, 41, '2016-07-02 13:42:09'),
    (2565995, 0xE6100000010C013A27518A453A407E0283FF08074940, 2, 7, 41, '2016-07-02 13:42:25'),
    (2565997, 0xE6100000010CACAD3319E9443A40353B9C0A02074940, 2, 7, 41, '2016-07-02 13:42:42'),
    (2565998, 0xE6100000010CE1140C9D8D433A4099D6A6B1BD064940, 2, 7, 41, '2016-07-02 13:43:24'),
    (2566001, 0xE6100000010CD7CEE6278B433A40AA8317D8BE064940, 2, 7, 41, '2016-07-02 13:43:26'),
    (2566003, 0xE6100000010C609E84888A433A40F7A45D96C0064940, 2, 7, 41, '2016-07-02 13:43:28'),
    (2566010, 0xE6100000010CAF473C3487433A40FF62111EC8064940, 2, 7, 41, '2016-07-02 13:43:35'),
    (2566011, 0xE6100000010C1A51DA1B7C433A408509A359D9064940, 2, 7, 41, '2016-07-02 13:43:46'),
    (2566013, 0xE6100000010CEF552B137E433A408F352383DC064940, 2, 7, 41, '2016-07-02 13:43:48'),
    (2566014, 0xE6100000010CF3D2A81B83433A4047979240DE064940, 2, 7, 41, '2016-07-02 13:43:50'),
    (2566023, 0xE6100000010C6F641EF983433A409AC3FF67DE064940, 2, 7, 41, '2016-07-02 13:43:59'),
    (2566030, 0xE6100000010CD6C56D3480433A40D6F55503DE064940, 2, 7, 41, '2016-07-02 13:44:07'),
    (2566037, 0xE6100000010C214BD52C86433A406300F26FE1064940, 2, 7, 2, '2016-07-02 13:44:33'),
    (2566198, 0xE6100000010C214BD52C86433A406300F26FE1064940, 2, 7, 41, '2016-07-02 13:50:00'),
    (2566197, 0xE6100000010C214BD52C86433A406300F26FE1064940, 2, 7, 1, '2016-07-02 13:50:09'),
    (2566199, 0xE6100000010C71B8454F80433A40715EF7B1DD064940, 2, 7, 41, '2016-07-02 13:51:54'),
    (2566214, 0xE6100000010C2FFA0AD28C433A40AFDEF2A2C0064940, 2, 7, 41, '2016-07-02 13:52:23'),
    (2566219, 0xE6100000010CA55247228F433A40FD67CD8FBF064940, 2, 7, 41, '2016-07-02 13:52:25'),
    (2566221, 0xE6100000010C56F146E691433A407AB7C370BF064940, 2, 7, 41, '2016-07-02 13:52:27'),
    (2566277, 0xE6100000010C284A9DDBDF443A4079FA5289FC064940, 2, 7, 41, '2016-07-02 13:53:26'),
    (2566278, 0xE6100000010C2B155454FD443A402DCE18E604074940, 2, 7, 41, '2016-07-02 13:53:31'),
    (2566279, 0xE6100000010C1EE9C2FEA1453A40C70270FD05074940, 2, 7, 41, '2016-07-02 13:53:58'),
    (2566280, 0xE6100000010CF748394EC0453A402DDF443EF9064940, 2, 7, 41, '2016-07-02 13:54:10'),
    (2566281, 0xE6100000010CCE064FD7C9453A40B52CA924FC064940, 2, 7, 41, '2016-07-02 13:54:14'),
    (2566366, 0xE6100000010CF226BF4527473A40A1496249B9074940, 2, 7, 41, '2016-07-02 13:55:42'),
    (2566367, 0xE6100000010CB0EF79B427473A40C297D3AFBE074940, 2, 7, 41, '2016-07-02 13:55:45'),
    (2566368, 0xE6100000010CADA6464321473A405B649698C2074940, 2, 7, 41, '2016-07-02 13:55:48'),
    (2566369, 0xE6100000010CFA6D3E6480463A402D944C4EED074940, 2, 7, 41, '2016-07-02 13:56:44'),
    (2566370, 0xE6100000010C560C570740463A40BAFA0C03F1074940, 2, 7, 41, '2016-07-02 13:57:01'),
    (2566371, 0xE6100000010CD581621A3C463A40775B3343F4074940, 2, 7, 41, '2016-07-02 13:57:03'),
    (2566372, 0xE6100000010CC3E226593D463A4099DDEE40F8074940, 2, 7, 41, '2016-07-02 13:57:05'),
    (2566373, 0xE6100000010C8A027D224F463A400ED70F5608084940, 2, 7, 41, '2016-07-02 13:57:14'),
    (2566374, 0xE6100000010CDBB7A4B448463A40228B34F10E084940, 2, 7, 41, '2016-07-02 13:57:17'),
    (2566375, 0xE6100000010C7DB262B83A463A4039F81D1E1D084940, 2, 7, 41, '2016-07-02 13:57:23'),
    (2566376, 0xE6100000010C61527C7C42463A40555051F52B084940, 2, 7, 41, '2016-07-02 13:57:27'),
    (2566378, 0xE6100000010C842EE1D05B463A401983989537084940, 2, 7, 41, '2016-07-02 13:57:32'),
    (2566382, 0xE6100000010C375A69ADC3463A40788E120544084940, 2, 7, 41, '2016-07-02 13:57:48'),
    (2566398, 0xE6100000010CA6C0B80A18473A405411B8BFC4084940, 2, 7, 41, '2016-07-02 13:58:15'),
    (2566411, 0xE6100000010C49A7093609473A4049A4C8B5FC084940, 2, 7, 41, '2016-07-02 13:58:27'),
    (2566555, 0xE6100000010C1717A29E99453A4028E2BE1FC8094940, 2, 7, 41, '2016-07-02 13:59:20'),
    (2566558, 0xE6100000010C1B1021AE9C413A401AA8E738120B4940, 2, 7, 41, '2016-07-02 14:01:03'),
    (2566618, 0xE6100000010C784C384FD03D3A407DF9AE528B0C4940, 2, 7, 41, '2016-07-02 14:02:40'),
    (2566787, 0xE6100000010C6BF706BA51393A401D739EB12F0D4940, 2, 7, 41, '2016-07-02 14:04:14'),
    (2566788, 0xE6100000010CD3026A204C383A4070D28FE10C0E4940, 2, 7, 41, '2016-07-02 14:04:51'),
    (2566789, 0xE6100000010CE2BCEE63BB373A40C32CB4739A104940, 2, 7, 41, '2016-07-02 14:06:24'),
    (2566790, 0xE6100000010C72AEBC3F39373A40D42AFA4333134940, 2, 7, 41, '2016-07-02 14:07:57'),
    (2566791, 0xE6100000010C3E7F3562C1363A40973AC8EBC1154940, 2, 7, 41, '2016-07-02 14:09:32'),
    (2566807, 0xE6100000010C1F1494A295373A40919D126B4C184940, 2, 7, 41, '2016-07-02 14:11:05'),
    (2566846, 0xE6100000010C033FAA61BF373A40CE0C2C9155194940, 2, 7, 41, '2016-07-02 14:11:53'),
    (2566847, 0xE6100000010C36621C12AD373A406E35464662194940, 2, 7, 41, '2016-07-02 14:11:57'),
    (2566848, 0xE6100000010C0D05C7C095373A40C6B656C565194940, 2, 7, 41, '2016-07-02 14:12:01'),
    (2566849, 0xE6100000010C5E6CB5E276373A4052280B5F5F194940, 2, 7, 41, '2016-07-02 14:12:05'),
    (2566850, 0xE6100000010C37B4B74A66373A404264ECDF50194940, 2, 7, 41, '2016-07-02 14:12:08'),
    (2566851, 0xE6100000010C5F27F56569373A40DF09078C3F194940, 2, 7, 41, '2016-07-02 14:12:12'),
    (2566852, 0xE6100000010C439C3D867D373A40DB6333D131194940, 2, 7, 41, '2016-07-02 14:12:16'),
    (2566919, 0xE6100000010CF3B3ECA4193C3A40C944A56CEC184940, 2, 7, 41, '2016-07-02 14:14:07'),
    (2566928, 0xE6100000010CEF09C84DC3403A405C69633612194940, 2, 7, 41, '2016-07-02 14:15:53'),
    (2566976, 0xE6100000010CE85A6A7352443A40F78F85E810184940, 2, 7, 41, '2016-07-02 14:17:53'),
    (2567071, 0xE6100000010CBCB77DEAB3443A40A5710399F8174940, 2, 7, 41, '2016-07-02 14:19:39'),
    (2567072, 0xE6100000010C8C8F053BB4443A40884A2366F6174940, 2, 7, 41, '2016-07-02 14:19:41'),
    (2567073, 0xE6100000010CD0622992AF443A403111CA56F2174940, 2, 7, 41, '2016-07-02 14:19:44'),
    (2567074, 0xE6100000010C3C3080F0A1443A40EDF2AD0FEB174940, 2, 7, 41, '2016-07-02 14:19:50'),
    (2567075, 0xE6100000010C74F9C55B9D443A40588FFB56EB174940, 2, 7, 41, '2016-07-02 14:19:52'),
    (2567192, 0xE6100000010CEF2719EF7D403A40FE2D5CB11A194940, 2, 7, 41, '2016-07-02 14:21:38'),
    (2567194, 0xE6100000010CF9E2E6AFEB3E3A40A405C31440194940, 2, 7, 41, '2016-07-02 14:22:09'),
    (2567196, 0xE6100000010C3B59C576523A3A400856D5CBEF184940, 2, 7, 41, '2016-07-02 14:23:46'),
    (2567197, 0xE6100000010CE4FED94587383A4058BD0D7BEB184940, 2, 7, 41, '2016-07-02 14:24:42'),
    (2567204, 0xE6100000010CD73B9281F2373A40DAA21694B3184940, 2, 7, 41, '2016-07-02 14:25:07'),
    (2567257, 0xE6100000010C6922C731ED363A40B22AC24D46164940, 2, 7, 41, '2016-07-02 14:26:50'),
    (2567412, 0xE6100000010C5C92037635373A40ED5BF7A0B1134940, 2, 7, 41, '2016-07-02 14:28:30'),
    (2567413, 0xE6100000010CCC441152B7373A40B58993FB1D114940, 2, 7, 41, '2016-07-02 14:29:59'),
    (2567414, 0xE6100000010C07A2DDD737383A40110F72288D0E4940, 2, 7, 41, '2016-07-02 14:31:23'),
    (2567442, 0xE6100000010C4474BE8EEE383A407959130B7C0D4940, 2, 7, 41, '2016-07-02 14:31:59'),
    (2567858, 0xE6100000010C3936F1C4623A3A4081053065E00C4940, 2, 7, 41, '2016-07-02 14:32:34'),
    (2567859, 0xE6100000010C8813984EEB3E3A40AEF545425B0C4940, 2, 7, 41, '2016-07-02 14:34:03'),
    (2567860, 0xE6100000010C61CA1BBB9F423A405D31C802CB0A4940, 2, 7, 41, '2016-07-02 14:35:33'),
    (2567862, 0xE6100000010C47F4215E8D463A40B89AD07F6A094940, 2, 7, 41, '2016-07-02 14:37:04'),
    (2567863, 0xE6100000010CC432ECE698483A40D15D6D20B8074940, 2, 7, 41, '2016-07-02 14:38:24'),
    (2567864, 0xE6100000010C29154328A5483A404EEFE2FDB8074940, 2, 7, 41, '2016-07-02 14:38:27'),
    (2567865, 0xE6100000010C3018B72CBA483A408D9EB6A1BD074940, 2, 7, 41, '2016-07-02 14:38:36'),
    (2567866, 0xE6100000010CA378F06EC0483A401E51A1BAB9074940, 2, 7, 41, '2016-07-02 14:40:36'),
    (2567867, 0xE6100000010CDF066B52C0483A40249E4720B9074940, 2, 7, 41, '2016-07-02 14:41:57'),
    (2567868, 0xE6100000010CDED220BBC1483A40CD785BE9B5074940, 2, 7, 41, '2016-07-02 14:42:00'),
    (2567869, 0xE6100000010C61945632B6483A40FF250406A4074940, 2, 7, 41, '2016-07-02 14:44:00'),
    (2567870, 0xE6100000010C62DC0DA2B5483A407157AF22A3074940, 2, 7, 41, '2016-07-02 14:46:31'),
    (2567871, 0xE6100000010C40FE2D5CB1483A405F11572998074940, 2, 7, 41, '2016-07-02 14:46:44'),
    (2567872, 0xE6100000010C15E5D2F885493A40AF7B2B1213074940, 2, 7, 41, '2016-07-02 14:47:35'),
    (2567980, 0xE6100000010C04954CA9A64D3A405D8EB2D9EC054940, 2, 7, 41, '2016-07-02 14:49:05'),
    (2567981, 0xE6100000010CFE310807D64E3A403B472E49AF054940, 2, 7, 41, '2016-07-02 14:49:37'),
    (2567982, 0xE6100000010CF5824F73F24E3A40CB10C7BAB8054940, 2, 7, 41, '2016-07-02 14:49:41'),
    (2567983, 0xE6100000010C7FA31D37FC4E3A40062CB98AC5054940, 2, 7, 41, '2016-07-02 14:49:45'),
    (2567984, 0xE6100000010C81F7448DF84E3A4081E84999D4054940, 2, 7, 41, '2016-07-02 14:49:48'),
    (2567985, 0xE6100000010C18F4948BE74E3A40E6CAA0DAE0054940, 2, 7, 41, '2016-07-02 14:49:51'),
    (2567986, 0xE6100000010C6D4892D6CE4E3A40C629841FE6054940, 2, 7, 41, '2016-07-02 14:49:53'),
    (2567987, 0xE6100000010C924C3DC1B44E3A405019FF3EE3054940, 2, 7, 41, '2016-07-02 14:49:56'),
    (2567988, 0xE6100000010C5260014C194E3A403CA64984A1054940, 2, 7, 41, '2016-07-02 14:50:16'),
    (2567989, 0xE6100000010CBEA662BE174E3A404FCC7A3194054940, 2, 7, 41, '2016-07-02 14:50:20'),
    (2567990, 0xE6100000010C825DA857254E3A409DAE38E686054940, 2, 7, 41, '2016-07-02 14:50:23'),
    (2567991, 0xE6100000010C58C51B99474E3A40070EC3A27D054940, 2, 7, 41, '2016-07-02 14:50:27'),
    (2567992, 0xE6100000010C94066D286B4E3A403F0E942584054940, 2, 7, 41, '2016-07-02 14:50:30'),
    (2567993, 0xE6100000010C274D83A2794E3A4063D34A2190054940, 2, 7, 41, '2016-07-02 14:50:33'),
    (2567994, 0xE6100000010CC8A06EFB794E3A403C16DBA4A2054940, 2, 7, 41, '2016-07-02 14:50:37'),
    (2567995, 0xE6100000010C7E7A223E664E3A408D0B0742B2054940, 2, 7, 41, '2016-07-02 14:50:41'),
    (2567998, 0xE6100000010C2AB7A3EEB94A3A401DBD2BCC8C064940, 2, 7, 8, '2016-07-02 14:51:54'),
    (2568129, 0xE6100000010CDCF86E4E80483A400FDB711EA9074940, 2, 7, 41, '2016-07-02 14:52:46'),
    (2568130, 0xE6100000010CDF910C946F473A40B090B932A8084940, 2, 7, 41, '2016-07-02 14:53:29'),
    (2568131, 0xE6100000010CBD8DCD8E54473A40C1F572E9A9084940, 2, 7, 41, '2016-07-02 14:53:32'),
    (2568132, 0xE6100000010C8D7E349C32473A400DC68844A1084940, 2, 7, 41, '2016-07-02 14:53:37'),
    (2568133, 0xE6100000010C9D3A45FDE4463A40BFDC820074084940, 2, 7, 41, '2016-07-02 14:53:48'),
    (2568134, 0xE6100000010C4C33DDEBA4463A409591C4DCFF074940, 2, 7, 41, '2016-07-02 14:54:33'),
    (2568135, 0xE6100000010CF5A91908B8463A40284DDE5BEC074940, 2, 7, 41, '2016-07-02 14:54:39'),
    (2568136, 0xE6100000010CD5928E7230473A40065152BBBA074940, 2, 7, 41, '2016-07-02 14:55:24'),
    (2568137, 0xE6100000010CACFF73982F473A409C30067BB8074940, 2, 7, 41, '2016-07-02 14:55:26'),
    (2568179, 0xE6100000010C047E439726473A4050D37833B4074940, 2, 7, 41, '2016-07-02 14:57:26'),
    (2568180, 0xE6100000010C8868CFC023473A403FCAE3C4B2074940, 2, 7, 41, '2016-07-02 14:57:42'),
    (2568281, 0xE6100000010C4D73E1F6BA453A409FCE705EF7064940, 2, 7, 41, '2016-07-02 14:59:05'),
    (2568282, 0xE6100000010CD912A8B4B4453A400ADB4FC6F8064940, 2, 7, 41, '2016-07-02 14:59:07'),
    (2568283, 0xE6100000010C53D0ED258D453A40F6662F3608074940, 2, 7, 41, '2016-07-02 14:59:23'),
    (2568284, 0xE6100000010C704793E6EA443A4046787B1002074940, 2, 7, 41, '2016-07-02 14:59:43'),
    (2568288, 0xE6100000010C649703988D433A40E0DE90A1BE064940, 2, 7, 41, '2016-07-02 15:00:29'),
    (2568290, 0xE6100000010CC63B1B4D89433A402C144438C1064940, 2, 7, 41, '2016-07-02 15:00:31'),
    (2568309, 0xE6100000010C392E3E6079433A403752B648DA064940, 2, 7, 41, '2016-07-02 15:01:07'),
    (2568313, 0xE6100000010CCD4301367B433A4072642F25DC064940, 2, 7, 41, '2016-07-02 15:01:09'),
    (2568317, 0xE6100000010C958E28A380433A40591C29B6DD064940, 2, 7, 41, '2016-07-02 15:01:13'),
    (2568320, 0xE6100000010C5FB2F1608B433A400BEF7211DF064940, 2, 7, 41, '2016-07-02 15:01:21'),
    (2569534, 0xE6100000010CF3C7B4368D433A40F2785A7EE0064940, 2, 7, 2, '2016-07-02 15:02:00'),
    (2569537, 0xE6100000010CF3C7B4368D433A40F2785A7EE0064940, 2, 7, 41, '2016-07-02 16:02:01'),
    (2573466, 0xE6100000010CF3C7B4368D433A40F2785A7EE0064940, 2, 7, 1, '2016-07-02 18:34:41'),
    (2573557, 0xE6100000010CD390A79B7A433A4085549B49E5064940, 2, 7, 41, '2016-07-02 18:36:41'),
    (2573558, 0xE6100000010CBB3434547B433A40B9FC87F4DB064940, 2, 7, 41, '2016-07-02 18:37:33'),
    (2573620, 0xE6100000010C0EFF44C07C433A401C1DA1B0D5064940, 2, 7, 41, '2016-07-02 18:39:33'),
    (2574406, 0xE6100000010CBAA4C5747C433A4087BF266BD4064940, 2, 7, 41, '2016-07-02 19:16:19'),
    (2574408, 0xE6100000010C8F2221808A433A4073C009E0C1064940, 2, 7, 41, '2016-07-02 19:16:47'),
    (2574411, 0xE6100000010C5120A28790433A4015BE0864C0064940, 2, 7, 41, '2016-07-02 19:16:51'),
    (2574519, 0xE6100000010C88E244AADE443A40FCD86ECCFC064940, 2, 7, 41, '2016-07-02 19:17:43'),
    (2574520, 0xE6100000010CCF89986D02453A40D96D612706074940, 2, 7, 41, '2016-07-02 19:17:49'),
    (2574521, 0xE6100000010CE5524B299E453A40FCFB8C0B07074940, 2, 7, 41, '2016-07-02 19:18:08'),
    (2574522, 0xE6100000010C110D41C4BC453A40B1396288F7064940, 2, 7, 41, '2016-07-02 19:18:22'),
    (2574523, 0xE6100000010C46F2F0F9BC453A401853FA53F4064940, 2, 7, 41, '2016-07-02 19:18:24'),
    (2574524, 0xE6100000010CF18288D4B4453A4098721992EE064940, 2, 7, 41, '2016-07-02 19:18:27'),
    (2574525, 0xE6100000010CB5728AE99D433A4025B20FB22C064940, 2, 7, 41, '2016-07-02 19:19:34'),
    (2574528, 0xE6100000010C448C32761D3F3A4079B0C56E9F054940, 2, 7, 41, '2016-07-02 19:21:10'),
    (2574563, 0xE6100000010C8B7BE2EFCD3B3A403868AF3E1E054940, 2, 7, 41, '2016-07-02 19:22:18'),
    (2574586, 0xE6100000010CC8EC2C7AA7383A403AB764B03D034940, 2, 7, 41, '2016-07-02 19:23:52'),
    (2574647, 0xE6100000010C9CD0DA238A373A402305604DAF024940, 2, 7, 41, '2016-07-02 19:24:28'),
    (2574649, 0xE6100000010C301AE8908A373A40D50D6F319A024940, 2, 7, 41, '2016-07-02 19:24:32'),
    (2574651, 0xE6100000010C6B7D91D096373A4015C5ABAC6D024940, 2, 7, 41, '2016-07-02 19:24:41'),
    (2574653, 0xE6100000010C9309AEA877373A40B03DB32440024940, 2, 7, 41, '2016-07-02 19:24:51'),
    (2574726, 0xE6100000010CA6643909A5393A40A7DDF98F96004940, 2, 7, 41, '2016-07-02 19:26:51'),
    (2574731, 0xE6100000010C95319985D13B3A40A1496249B9FE4840, 2, 7, 41, '2016-07-02 19:28:34'),
    (2574735, 0xE6100000010C39D1AE42CA3B3A40441F871CB6FE4840, 2, 7, 41, '2016-07-02 19:28:47'),
    (2574775, 0xE6100000010C4057B66A32383A40BE30992A18FD4840, 2, 7, 41, '2016-07-02 19:30:42'),
    (2574865, 0xE6100000010CC44FD2B2A4343A40130F289B72FB4840, 2, 7, 41, '2016-07-02 19:32:11'),
    (2574866, 0xE6100000010CE702F2800D313A40F1BC546CCCF94840, 2, 7, 41, '2016-07-02 19:34:06'),
    (2574908, 0xE6100000010CAE878ACCB72D3A40253E7782FDF74840, 2, 7, 41, '2016-07-02 19:35:45'),
    (2574915, 0xE6100000010C6B3D8DC5802A3A40ADFC321823F64840, 2, 7, 41, '2016-07-02 19:37:32'),
    (2575030, 0xE6100000010CB08EE3874A273A405F460C9645F44840, 2, 7, 41, '2016-07-02 19:39:13'),
    (2575031, 0xE6100000010CD065C5CB2E253A401310EE2994F24840, 2, 7, 41, '2016-07-02 19:40:47'),
    (2575032, 0xE6100000010C2D81EF9128253A4090E91A7794F24840, 2, 7, 41, '2016-07-02 19:40:50'),
    (2575033, 0xE6100000010CA8797D9C1F253A40E2EF726C98F24840, 2, 7, 41, '2016-07-02 19:40:54'),
    (2575034, 0xE6100000010CCB58237145243A402B4F20EC14F34840, 2, 7, 41, '2016-07-02 19:41:36'),
    (2575035, 0xE6100000010CE04092A34A243A404C6F7F2E1AF34840, 2, 7, 41, '2016-07-02 19:41:40'),
    (2575036, 0xE6100000010C0CFA1C69BA243A404233993B44F34840, 2, 7, 41, '2016-07-02 19:41:59'),
    (2575037, 0xE6100000010C9B070B8222273A40F15A536A40F44840, 2, 7, 41, '2016-07-02 19:43:21'),
    (2575074, 0xE6100000010C51A8024933273A403239B5334CF44840, 2, 7, 41, '2016-07-02 19:45:21'),
    (2575289, 0xE6100000010C28710CB732273A406EE1D4624BF44840, 2, 7, 41, '2016-07-02 19:55:21'),
    (2575644, 0xE6100000010CC6CCF40137273A404989B8944EF44840, 2, 7, 41, '2016-07-02 19:59:21')
;





	SELECT
			 DriverId 
			,AssetId
			,StartOfDay
			,EndOfDay
			,WorkedTimeHHMMSS = DATEDIFF(SECOND, StartOfDay, EndOfDay)
			,TotalDistance = SUM(DistanceCovered) --OVER(PARTITION BY StartOfDay)
		FROM (

            SELECT 
                 AssetId = ignOn.AssetId
				,DriverId = ignOn.DriverId
                ,EventCode = p.EventCode
				,LogDate = FORMAT(p.LogDateTime, 'dd-MMM-yyyy')
				,LogDateTime = p.LogDateTime
				,StartOfDay = MIN(ignOn.LogDateTime) OVER (PARTITION BY ignOn.DriverId, ignOn.AssetId, CAST(ignOn.LogDateTime AS DATE))
				,EndOfDay = MAX(ignOff.LogDateTime) OVER (PARTITION BY ignOff.DriverId, ignOff.AssetId, CAST(ignOff.LogDateTime AS DATE))
                ,DistanceCovered = p.GeoLocation.STDistance(
                                        LEAD(p.GeoLocation) OVER(PARTITION BY ignOn.AssetId, ignOn.LogDateTime ORDER BY p.LogDateTime))
                
            FROM #VehicleLogs ignOn
            CROSS APPLY (
                SELECT top(1) LogId, EventCode, LogDateTime, GeoLocation , DriverId, AssetId
                FROM #VehicleLogs  WHERE 
                AssetId = ignOn.AssetId AND LogDateTime > ignOn.LogDateTime AND EventCode = 2
                ORDER by LogDateTime
            ) ignOff
            INNER JOIN #VehicleLogs p ON p.AssetId = ignOn.AssetId AND p.LogDateTime >= ignOn.LogDateTime AND p.LogDateTime <= ignOff.LogDateTime
            WHERE 
               -- ignOn.LogDateTime BETWEEN @utcStartDate AND @utcEndDate
				ignOn.DriverId = 7
                AND ignOn.EventCode = 1
			) K
		GROUP BY StartOfDay, EndOfDay, DriverId, AssetId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results