Advertisement
psi_mmobile

Untitled

Aug 6th, 2021
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. select fu.lm_date, fu.creation_date, fu.name fixed_unit_name, p.name poi_name, oc.name operation_center_name
  2. from fixed_unit_poi fup, oc_poi p, fixed_unit fu, remote_unit ru, vehicle_data vd,oc_poi_category op, operation_center oc
  3. where fup.poi_id = p.poi_id
  4. and p.oc_poi_status_id != 0
  5. and fup.fixed_unit_id = fu.fixed_unit_id
  6. and fu.remote_unit_id = ru.remote_unit_id
  7. and ru.remote_unit_id = vd.remote_unit_id
  8. and vd.vehicle_data_id in (716264166,713522843,715912159,716259782,715916376,716279031,716267199,716389967,716388706,716376913,713748378,715594487)
  9. and op.oc_poi_category_id = p.oc_poi_category_id
  10. and oc.operation_center_id = op.operation_center_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement