Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select fu.lm_date, fu.creation_date, fu.name fixed_unit_name, p.name poi_name, oc.name operation_center_name
- from fixed_unit_poi fup, oc_poi p, fixed_unit fu, remote_unit ru, vehicle_data vd,oc_poi_category op, operation_center oc
- where fup.poi_id = p.poi_id
- and p.oc_poi_status_id != 0
- and fup.fixed_unit_id = fu.fixed_unit_id
- and fu.remote_unit_id = ru.remote_unit_id
- and ru.remote_unit_id = vd.remote_unit_id
- and vd.vehicle_data_id in (716264166,713522843,715912159,716259782,715916376,716279031,716267199,716389967,716388706,716376913,713748378,715594487)
- and op.oc_poi_category_id = p.oc_poi_category_id
- and oc.operation_center_id = op.operation_center_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement