SELECT acc.acc_id, acc.utag_id, acc.start, acc.stop, acc.splaces_id, acc.eplaces_id, acc.mileage,
			SEC_TO_TIME(TIMESTAMPDIFF(SECOND, acc.start, acc.stop)) AS total, acc.max_speed_gps_id,
			TIMESTAMPDIFF(SECOND, acc.start, acc.stop) AS sum_total, acc.max_speed_id,
			profile.profile_name,
			gps.speed,
			vehicle.plate, vehicle_model.vehicle_model_name, vehicle_brand.vehicle_brand_name,
			timezone.time_offset, city.city_id, places.lat, places.lon
         FROM profile_1033.acc
         LEFT JOIN main.ukey            ON (acc.ukey_id                    = ukey.ukey_id)
         LEFT JOIN profile_1033.profile 	ON (ukey.dprofile_id               = profile.profile_id)
         LEFT JOIN profile_1033.gps     	ON (acc.max_speed_gps_id           = gps.gps_id)
         LEFT JOIN profile_1033.vehicle 	ON (acc.vehicle_id                 = vehicle.vehicle_id)
         LEFT JOIN main.vehicle_model   ON (vehicle.vehicle_model_id       = vehicle_model.vehicle_model_id)
         LEFT JOIN main.vehicle_brand   ON (vehicle_model.vehicle_brand_id = vehicle_brand.vehicle_brand_id)
         LEFT JOIN locality.places      ON (acc.splaces_id                 = places.places_id)
         LEFT JOIN locality.street      ON (places.street_id               = street.street_id)
         LEFT JOIN locality.sublocality ON (street.sublocality_id          = sublocality.sublocality_id)
         LEFT JOIN locality.city        ON (sublocality.city_id            = city.city_id)
         LEFT JOIN locality.timezone    ON (city.time_id                   = timezone.time_id)
         WHERE
         (TIMESTAMPDIFF(DAY, acc.start, acc.stop) BETWEEN 0 AND 2)
        AND  (acc.vehicle_id = 1)
         AND (acc.start BETWEEN '2018-01-25T00:00' AND '2018-01-26T23:00')
         ORDER BY acc.start ASC
         LIMIT 100;