Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT cs.sewerage_volume_in from volga_river_recovery.sewerages_reports_mo mo
- JOIN volga_river_recovery.sewerages_reports rep on mo.sewerage_report_id = mo.id
- JOIN geo_tags g on mo.geo_tag_id = g.id
- JOIN volga_river_recovery.sewerage_object_state os on mo.geo_tag_id = os.geo_tag_id AND os.reporting_period_id = rep.reporting_period_id
- JOIN volga_river_recovery.central_sewerage_systems cs on os.id = cs.sewerage_object_state_id AND os.geo_tag_id = cs.geo_tag_id
- WHERE mo.id = (?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement