gicristhie

Untitled

Mar 14th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. $sql = "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,
  2. TIMESTAMPDIFF(SECOND, acc.start, acc.stop) AS sum_total, acc.max_speed_id,
  3. profile.profile_name,
  4. gps.speed,
  5. vehicle.plate, vehicle_model.vehicle_model_name, vehicle_brand.vehicle_brand_name,
  6. timezone.time_offset, city.city_id, places.lat, places.lon
  7. FROM profile_$PID.acc
  8. LEFT JOIN main.ukey ON (acc.ukey_id = ukey.ukey_id)
  9. LEFT JOIN profile_$PID.profile ON (ukey.dprofile_id = profile.profile_id)
  10. LEFT JOIN profile_$PID.gps ON (acc.max_speed_gps_id = gps.gps_id)
  11. LEFT JOIN profile_$PID.vehicle ON (acc.vehicle_id = vehicle.vehicle_id)
  12. LEFT JOIN main.vehicle_model ON (vehicle.vehicle_model_id = vehicle_model.vehicle_model_id)
  13. LEFT JOIN main.vehicle_brand ON (vehicle_model.vehicle_brand_id = vehicle_brand.vehicle_brand_id)
  14. LEFT JOIN locality.places ON (acc.splaces_id = places.places_id)
  15. LEFT JOIN locality.street ON (places.street_id = street.street_id)
  16. LEFT JOIN locality.sublocality ON (street.sublocality_id = sublocality.sublocality_id)
  17. LEFT JOIN locality.city ON (sublocality.city_id = city.city_id)
  18. LEFT JOIN locality.timezone ON (city.time_id = timezone.time_id)
  19. WHERE
  20. (TIMESTAMPDIFF(DAY, acc.start, acc.stop) BETWEEN 0 AND 2)
  21. $vehicle_id
  22. $ukey_id
  23. $date
  24. $sort
  25. LIMIT 300"; //echo $sql;
Advertisement
Add Comment
Please, Sign In to add comment