Advertisement
Guest User

Untitled

a guest
Apr 19th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.48 KB | None | 0 0
  1. SELECT cs.sewerage_volume_in from volga_river_recovery.sewerages_reports_mo mo
  2.     JOIN volga_river_recovery.sewerages_reports rep on mo.sewerage_report_id = mo.id
  3.     JOIN geo_tags g on mo.geo_tag_id = g.id
  4.     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
  5.     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
  6. WHERE mo.id = (?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement