API tools faq
paste
Advertisement
Guest User

123

a guest
May 22nd, 2019
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.20 KB | None | 0 0
raw download clone embed print report
  1.  
  2. select gt_sf.name,
  3. gt_mo.name,
  4.  
  5. ---форма ОВ-02
  6.  
  7.  
  8. CASE WHEN sewerage_wastewater_discharge_count < central_sewerage_systems_count THEN sewerage_wastewater_discharge_count||' < '||central_sewerage_systems_count
  9. ELSE '' END as "П1_V2_5<4",
  10. CASE WHEN treatment_facilities_total < treatment_facilities_first_cathegory+treatment_facilities_second_cathegory THEN treatment_facilities_total||' < '||treatment_facilities_first_cathegory+treatment_facilities_second_cathegory
  11. ELSE '' END as "П2_V2_8<6&7",
  12. CASE WHEN treatment_facilities_total != treatment_facilities_superlarge+treatment_facilities_largest+treatment_facilities_large+treatment_facilities_big+treatment_facilities_medium+treatment_facilities_small+treatment_facilities_little+treatment_facilities_ultra_small
  13. THEN treatment_facilities_total||' <> '||treatment_facilities_superlarge+treatment_facilities_largest+treatment_facilities_large+treatment_facilities_big+treatment_facilities_medium+treatment_facilities_small+treatment_facilities_little+treatment_facilities_ultra_small
  14. ELSE '' END as "П3_V2_8<>9&10&11&12&13&14&16",
  15. CASE WHEN treatment_facilities_total < project_indicators_complying_count+project_indicators_not_complying_count THEN treatment_facilities_total||' < '||project_indicators_complying_count+project_indicators_not_complying_count
  16. ELSE '' END as "П4_V2_8<V6_10&V6_13",
  17. CASE WHEN treatment_facilities_total < tech_indicators_complying_count+tech_indicators_not_complying_count THEN treatment_facilities_total||' < '||tech_indicators_complying_count+tech_indicators_not_complying_count
  18. ELSE '' END as "П5_V2_8<V6_11&V6_14",
  19. CASE WHEN treatment_facilities_total < indicators_complying_count+indicators_not_complying_count THEN treatment_facilities_total||' < '||indicators_complying_count+indicators_not_complying_count
  20. ELSE '' END as "П6_V2_8<V6_12&V6_15",
  21. CASE WHEN (pumping_station_total > 0 and networks_length_pressure_total = 0) or (pumping_station_total = 0 and networks_length_pressure_total > 0) THEN pumping_station_total||'/'||round(networks_length_pressure_total,1)
  22. ELSE '' END as "П7_V2_18/20",
  23. CASE WHEN networks_length_gravity_total = 0 THEN round(networks_length_gravity_total)||''
  24. ELSE '' END as "П8_V2_19=0",
  25. CASE WHEN (networks_length_pressure_total > 0 and pumping_station_total = 0) THEN round(networks_length_pressure_total,1)||'/'||round(pumping_station_total)
  26. ELSE '' END as "П9_V2_20/18",
  27. CASE WHEN sewerage_volume_in != clean_sewage_wastewater_volume
  28. THEN round(sewerage_volume_in,1)||' <> '||round(clean_sewage_wastewater_volume,1)
  29. ELSE '' END as "П10_V2_22<>V6_6",
  30. CASE WHEN sewerage_volume_out != vrr_cs.water_pollution
  31. THEN round(sewerage_volume_out,1)||' <> '||round(vrr_cs.water_pollution,1)
  32. ELSE '' END as "П11_V2_23<>V6_7",
  33. CASE WHEN (discharged_surface_wastewater > 0 and networks_length_total = 0) THEN round(networks_length_total,1)||'/'||round(discharged_surface_wastewater,1)
  34. ELSE '' END as "П12_V2_21/24",
  35. CASE WHEN discharged_surface_wastewater < surface_wastewater_flowing_rain_sewer THEN round(discharged_surface_wastewater,1)||' < '||round(surface_wastewater_flowing_rain_sewer,1)
  36. ELSE '' END as "П13_V2_25>24",
  37. CASE WHEN (pumping_station_total > 0 and design_parameters = 0) or (pumping_station_total = 0 and design_parameters > 0) THEN pumping_station_total||'/'||round(design_parameters,1)
  38. ELSE '' END as "П14_V2_18/27",
  39. CASE WHEN design_parameters < actual_parameters THEN round(design_parameters,1)||' < '||round(actual_parameters,1)
  40. ELSE '' END as "П15_V2_28>27",
  41.  
  42.  
  43. ---форма ОВ-03
  44.  
  45. CASE WHEN power_consumption_cleaning_parameters > 10000 or power_consumption_cleaning_parameters < 100 THEN round(power_consumption_cleaning_parameters,1) ||' должно быть в диапазоне 100 до 10000 '
  46. ELSE '' END as "П16_V3_9in[100..10000]",
  47. CASE WHEN (networks_length_pressure_total > 0 and power_consumption_sewerage_objects = 0) or (networks_length_pressure_total = 0 and power_consumption_sewerage_objects > 0) THEN round(networks_length_pressure_total,1)||'/'||round(power_consumption_sewerage_objects,1)
  48. ELSE '' END as "П17_V2_20/V3_10",
  49. CASE WHEN power_consumption_sewerage_objects < 0 or power_consumption_sewerage_objects > 10000 THEN round(power_consumption_sewerage_objects,1) ||' должно быть в диапазоне 0 до 10000 '
  50. ELSE '' END as "П17-1_V3_10in[0..10000]",
  51. CASE WHEN accidents_count > 2 THEN round(accidents_count) ||' > 2'
  52. ELSE '' END as "П18_V3_11>2",
  53. CASE WHEN count_queues_total != count_queues_1960+count_queues_1970+count_queues_1980+count_queues_1991+count_queues_2000+count_queues_2010+count_queues_2018
  54. THEN treatment_facilities_total||' <> '||count_queues_1960+count_queues_1970+count_queues_1980+count_queues_1991+count_queues_2000+count_queues_2010+count_queues_2018
  55. ELSE '' END as "П19_V3_12<>13&14&15&16&17&18&19",
  56. CASE
  57. WHEN treatment_facilities_total =0 or treatment_facilities_total is NULL THEN ''
  58. WHEN treatment_facilities_total =0 and count_queues_total>0 THEN treatment_facilities_total || ' Укажите количество ОСК'
  59. WHEN (count_queues_total/treatment_facilities_total<1) or (count_queues_total/treatment_facilities_total>10) THEN round(count_queues_total) ||' / '|| round(treatment_facilities_total)
  60. ELSE '' END as "П20_V3_12/V2_8",
  61.  
  62. ---форма ОВ-03
  63.  
  64. CASE WHEN treatment_facilities_ownerless_count+treatment_facilities_gup_exploit_count+treatment_facilities_mo_exploit_count > treatment_facilities_total THEN round(treatment_facilities_ownerless_count+treatment_facilities_gup_exploit_count+treatment_facilities_mo_exploit_count) ||' > '|| round(treatment_facilities_total)
  65. ELSE '' END as "П21_V4_3+4+5>V2_8",
  66. CASE WHEN treatment_facilities_ownerless_count+treatment_facilities_rent_exploit_count+treatment_facilities_conv_exploit_count > treatment_facilities_total THEN round(treatment_facilities_ownerless_count+treatment_facilities_rent_exploit_count+treatment_facilities_conv_exploit_count) ||' > '|| round(treatment_facilities_total)
  67. ELSE '' END as "П22_V4_3+6+7>V2_8",
  68. CASE WHEN pumping_station_count+pumping_station_gup_exploit_count+pumping_station_mo_exploit_count > pumping_station_total THEN round(pumping_station_count+pumping_station_gup_exploit_count+pumping_station_mo_exploit_count) ||' > '|| round(pumping_station_total)
  69. ELSE '' END as "П23_V4_8+9+10>V2_18",
  70. CASE WHEN pumping_station_count+pumping_station_rent_exploit_count+pumping_station_conv_exploit_count > pumping_station_total THEN round(pumping_station_count+pumping_station_rent_exploit_count+pumping_station_conv_exploit_count) ||' > '|| round(pumping_station_total)
  71. ELSE '' END as "П24_V4_8+11+12>V2_18",
  72. CASE WHEN networks_ownerless_length+networks_ownerless_gup_exploiting_length+networks_ownerless_mo_exploiting_length > networks_length_gravity_total+networks_length_pressure_total THEN round(networks_ownerless_length+networks_ownerless_gup_exploiting_length+networks_ownerless_mo_exploiting_length,1) ||' > '|| round(networks_length_gravity_total+networks_length_pressure_total,1)
  73. ELSE '' END as "П25_V4_13+14+15>V2_19+20",
  74. CASE WHEN networks_ownerless_length+networks_ownerless_rent_exploiting_length+networks_ownerless_conv_exploiting_length > networks_length_gravity_total+networks_length_pressure_total THEN round(networks_ownerless_length+networks_ownerless_rent_exploiting_length+networks_ownerless_conv_exploiting_length, 1) ||' > '|| round(networks_length_gravity_total+networks_length_pressure_total,1)
  75. ELSE '' END as "П26_V4_13+16+17>V2_19+20",
  76.  
  77. ---форма ОВ-05_1
  78.  
  79. CASE WHEN population != central_sewerage_systems_provided+without_sewerage_population_total THEN round(population) ||' <> '|| round(central_sewerage_systems_provided+without_sewerage_population_total)
  80. ELSE '' END as "П27_V51_3<>4+9",
  81. CASE WHEN (sewerage_volume_wastes_from_citizens > 0 and sewerage_volume_wastes = 0) THEN round(sewerage_volume_wastes_from_citizens,1)||'/'||round(sewerage_volume_wastes,1)
  82. ELSE '' END as "П28_V51_6/7",
  83. CASE WHEN (sewerage_volume_wastes > 0 and without_sewerage_population_wastes_export = 0) THEN round(sewerage_volume_wastes,1)||'/'||round(without_sewerage_population_wastes_export,1)
  84. ELSE '' END as "П29_V51_7/10",
  85. '' as "П30",
  86. CASE WHEN without_sewerage_population_total != population-central_sewerage_systems_provided THEN round(without_sewerage_population_total) ||' <> '|| round(population-central_sewerage_systems_provided)
  87. ELSE '' END as "П31_V51_9<>3-4",
  88.  
  89.  
  90. CASE WHEN without_sewerage_population_wastes_export > without_sewerage_population_total THEN round(without_sewerage_population_wastes_export) ||' > '|| round(without_sewerage_population_total)
  91. ELSE '' END as "П32_V51_10>9",
  92. CASE WHEN without_sewerage_population_wastes_export != decentralized_sewerage_systems_provided THEN round(without_sewerage_population_wastes_export) ||' <> '|| round(decentralized_sewerage_systems_provided)
  93. ELSE '' END as "П33_V51_10<>5",
  94. CASE WHEN implemented_total != implemented_first_half+implemented_second_half+implemented_other_consumers THEN round(implemented_total,1) ||' <> '|| round(implemented_first_half+implemented_second_half+implemented_other_consumers,1)
  95. ELSE '' END as "П34_V51_11<>12+13+14",
  96. CASE
  97. WHEN (central_sewerage_systems_provided=0) OR (central_sewerage_systems_provided is NULL) THEN central_sewerage_systems_provided || ' заполните графу 4'
  98. WHEN (decentralized_sewerage_systems_provided=0) OR (decentralized_sewerage_systems_provided is NULL) THEN decentralized_sewerage_systems_provided || ' заполните графу 5'
  99. WHEN ((implemented_first_half+implemented_second_half)*1000/(central_sewerage_systems_provided+decentralized_sewerage_systems_provided)::numeric/12<1) or ((implemented_first_half+implemented_second_half)*1000/(central_sewerage_systems_provided+decentralized_sewerage_systems_provided)::numeric/12>15) THEN round((implemented_first_half+implemented_second_half)*1000/(central_sewerage_systems_provided+decentralized_sewerage_systems_provided)::numeric/12,2) || ' должно быть в диапазоне от 1 до 15 '
  100. ELSE '' END as "П35_V51_12+13in[1..15]",
  101. CASE
  102. WHEN implemented_second_half < implemented_first_half*0.5 or (implemented_second_half > implemented_first_half*2) THEN round(implemented_second_half,1) ||' должно быть в диапазоне '||'['||round(implemented_first_half*0.5,1)||'..'||round(implemented_first_half*2,1)||']'
  103. ELSE '' END as "П36_V51_13in12*[0.5..2]",
  104. CASE
  105. WHEN other_customers_tariff=0 and implemented_other_consumers <>0 THEN round(implemented_other_consumers,1) ||'/ '|| round(other_customers_tariff,1)
  106. ELSE '' END as "П37_V51_14/17",
  107. CASE WHEN (implemented_other_consumers > 0 and other_customers_tariff = 0) THEN round(implemented_other_consumers,1)||'/'||round(other_customers_tariff,1)
  108. ELSE '' END as "П38_V51_14/17",
  109. CASE
  110. WHEN (first_half_tariff<4) or (first_half_tariff>250) THEN round(first_half_tariff,1) || ' должно быть в диапазоне от 4 до 250 '
  111. ELSE '' END as "П39_V51_15in[4..250]",
  112. CASE
  113. WHEN (second_half_tariff<first_half_tariff*0.5) or (second_half_tariff>first_half_tariff*1.5) THEN round(second_half_tariff,1) || ' должно быть в диапазоне '||'['||round(first_half_tariff*0.5,1)||'..'||round(first_half_tariff*1.5,1)||']'
  114. ELSE '' END as "П40_V51_16in15*[0.5..1.5]",
  115. CASE
  116. WHEN (second_half_tariff<4) or (second_half_tariff>250) THEN round(second_half_tariff,1) || ' должно быть в диапазоне от 4 до 250 '
  117. ELSE '' END as "П41_V51_16in[4..250]",
  118. CASE
  119. WHEN other_customers_tariff>second_half_tariff*5 THEN round(other_customers_tariff,1) || ' > '||round(second_half_tariff*5,1)
  120. ELSE '' END as "П42_V51_17>16*5" ,
  121. CASE
  122. WHEN first_half_tariff>second_half_tariff and first_half_tariff>other_customers_tariff and amount_of_receivables > first_half_tariff*implemented_total*3 THEN round(amount_of_receivables,1) || ' > '||round(first_half_tariff*implemented_total*3,1)
  123. WHEN second_half_tariff>first_half_tariff and second_half_tariff>other_customers_tariff and amount_of_receivables > second_half_tariff*implemented_total*3 THEN round(amount_of_receivables,1) || ' > '||round(second_half_tariff*implemented_total*3,1)
  124. WHEN other_customers_tariff>second_half_tariff and other_customers_tariff> first_half_tariff and amount_of_receivables > other_customers_tariff*implemented_total*3 THEN round(amount_of_receivables,1) || ' > '||round(other_customers_tariff*implemented_total*3,1)
  125. ELSE '' END as "П43_V51_18>max(15,16,17)&11*3",
  126. CASE
  127. WHEN first_half_tariff<second_half_tariff and first_half_tariff<other_customers_tariff and amount_of_receivables < first_half_tariff*implemented_total/12 THEN round(amount_of_receivables,1) || ' < '||round(first_half_tariff*implemented_total/12,1)
  128. WHEN second_half_tariff<first_half_tariff and second_half_tariff<other_customers_tariff and amount_of_receivables < second_half_tariff*implemented_total/12 THEN round(amount_of_receivables,1) || ' < '||round(second_half_tariff*implemented_total/12,1)
  129. WHEN other_customers_tariff<second_half_tariff and other_customers_tariff< first_half_tariff and amount_of_receivables < other_customers_tariff*implemented_total/12 THEN round(amount_of_receivables,1) || ' < '||round(other_customers_tariff*implemented_total/12,1)
  130. ELSE '' END as "П44_V51_18<min(15,16,17)&11/12",
  131.  
  132.  
  133. ---форма ОВ-05_2
  134.  
  135.  
  136. CASE
  137. WHEN amount_payable < power_consumption_cleaning_parameters*implemented_total/1000/12*1.5 THEN round(amount_payable,1) || ' < '||round(power_consumption_cleaning_parameters*implemented_total/1000/12*1.5,3)
  138. ELSE '' END as "П45_V52_18-1",
  139. CASE
  140. WHEN first_half_tariff>second_half_tariff and first_half_tariff>other_customers_tariff and amount_payable >= power_consumption_cleaning_parameters*implemented_total*first_half_tariff/1000*10 THEN round(amount_payable,1) || ' > '||round(power_consumption_cleaning_parameters*implemented_total*first_half_tariff/1000*10,1)
  141. WHEN second_half_tariff>first_half_tariff and second_half_tariff>other_customers_tariff and amount_payable >= power_consumption_cleaning_parameters*implemented_total*second_half_tariff/1000*10 THEN round(amount_payable,1) || ' > '||round(power_consumption_cleaning_parameters*implemented_total*second_half_tariff/1000*10,1)
  142. WHEN other_customers_tariff>second_half_tariff and other_customers_tariff> first_half_tariff and amount_payable >= power_consumption_cleaning_parameters*implemented_total*other_customers_tariff/1000*10 THEN round(amount_payable,1) || ' > '||round(power_consumption_cleaning_parameters*implemented_total*other_customers_tariff/1000*10,1)
  143. ELSE '' END as "П46_V52_18-1",
  144. CASE
  145. WHEN investment_program_approval_count > financial_assets_profit_count+financial_assets_lesion_count THEN round(investment_program_approval_count) || ' > '||round(financial_assets_profit_count+financial_assets_lesion_count)
  146. ELSE '' END as "П47_V52_18-2>18-8&18-10",
  147. CASE WHEN (financial_assets_total > 0 and investment_program_approval_count = 0) THEN round(investment_program_approval_count)||'/'||round(financial_assets_total,1)
  148. ELSE '' END as "П48_V52_18-2/18-3",
  149. CASE
  150. WHEN financial_assets_total > financial_assets_depreciation_sum+financial_assets_capital_expenditure_sum+financial_assets_budget+financial_assets_other_sources_sum THEN round(financial_assets_total,1) || ' <> '||round(financial_assets_depreciation_sum+financial_assets_capital_expenditure_sum+financial_assets_budget+financial_assets_other_sources_sum,1)
  151. ELSE '' END as "П49_V52_18-3<>18-4&18-5&18-6&18-7",
  152. CASE WHEN (financial_assets_total = 0 and investment_program_approval_count > 0) THEN round(financial_assets_total,1)||'/'||round(investment_program_approval_count)
  153. ELSE '' END as "П50_V52_18-3/18-2",
  154. CASE WHEN (financial_assets_profit_count > 0 and financial_assets_profit < 0) THEN round(financial_assets_profit_count)||'/'||round(financial_assets_profit,1)
  155. ELSE '' END as "П51_V52_18-8/18-9" ,
  156. CASE WHEN ( financial_assets_profit >= 0 and financial_assets_profit_count < 0) THEN round(financial_assets_profit,1)||'/'||round(financial_assets_profit_count)
  157. ELSE '' END as "П52_V52_18-9/18-8",
  158. CASE WHEN ( financial_assets_lesion_count > 0 and financial_assets_lesion = 0) THEN round(financial_assets_lesion_count)||'/'||round(financial_assets_lesion,1)
  159. ELSE '' END as "П53_V52_18-10/18-11",
  160. CASE WHEN ( financial_assets_lesion > 0 and financial_assets_lesion_count = 0) THEN round(financial_assets_lesion,1)||'/'||round(financial_assets_lesion_count)
  161. ELSE '' END as "П54_V52_18-11/18-10",
  162.  
  163.  
  164. ---форма ОВ-05_2
  165.  
  166. CASE WHEN wastewater_inflow*24/1000 < clean_sewage_actual_inflow*0.7 or wastewater_inflow*24/1000 > clean_sewage_actual_inflow*1.1 THEN round(wastewater_inflow*24/1000,1)|| ' должно быть в диапазоне '||'['||round(clean_sewage_actual_inflow*0.7,1)||'..'||round(clean_sewage_actual_inflow*1.1,1)||']'
  167. ELSE '' END as "П55_V6_3in5*[0.7..1.1]",
  168. CASE WHEN clean_sewage_performance < clean_sewage_actual_inflow*0.3 or clean_sewage_performance > clean_sewage_actual_inflow*10 THEN round(clean_sewage_performance,1)|| ' должно быть в диапазоне '||'['||round(clean_sewage_actual_inflow*0.3,1)||'..'||round(clean_sewage_actual_inflow*10,1)||']'
  169. ELSE '' END as "П56_V6_4in5*[0.3..10]",
  170. CASE WHEN clean_sewage_actual_inflow*365 < sewerage_volume_in*0.9 or clean_sewage_actual_inflow > sewerage_volume_in*1.1 THEN round(clean_sewage_actual_inflow*365,1)|| ' должно быть в диапазоне '||'['||round(sewerage_volume_in*0.9,1)||'..'||round(sewerage_volume_in*1.1,1)||']'
  171. ELSE '' END as "П57_V6_5inV2_22*[0.9..1.1]",
  172. CASE WHEN clean_sewage_wastewater_volume < (vrr_cs.water_pollution+water_pollution_excess+water_clear_standart)*0.9 or clean_sewage_wastewater_volume > vrr_cs.water_pollution+water_pollution_excess+water_clear_standart THEN round(clean_sewage_wastewater_volume,1)|| ' должно быть в диапазоне '||'['||round(vrr_cs.water_pollution+water_pollution_excess+water_clear_standart*0.9,1)||'..'||round(vrr_cs.water_pollution+water_pollution_excess+water_clear_standart,1)||']'
  173. ELSE '' END as "П58_V6_6in_7*8*9[0.9..1.1]",
  174. CASE WHEN vrr_cs.water_pollution != sewerage_volume_out THEN round(vrr_cs.water_pollution,1)|| ' <> '||round(vrr_cs.water_pollution,1)
  175. ELSE '' END as "П59_V6_7<>V2_23",
  176. CASE WHEN vrr_cs.water_pollution > sewerage_volume_in THEN round(vrr_cs.water_pollution,1)|| ' > '||round(sewerage_volume_in,1)
  177. ELSE '' END as "П59_1_V6_7>V2_22",
  178.  
  179. CASE WHEN water_pollution_excess > clean_sewage_wastewater_volume THEN round(water_pollution_excess,1)|| ' > '||round(clean_sewage_wastewater_volume,1)
  180. ELSE '' END as "П60_V6_8>6",
  181. CASE WHEN water_clear_standart > clean_sewage_wastewater_volume THEN round(water_clear_standart,1)|| ' > '||round(clean_sewage_wastewater_volume,1)
  182. ELSE '' END as "П61_V6_9>6",
  183. CASE WHEN project_indicators_complying_count+project_indicators_not_complying_count > treatment_facilities_total THEN round(project_indicators_complying_count+project_indicators_not_complying_count)|| ' > '||round(treatment_facilities_total)
  184. ELSE '' END as "П62_V6_10&13>V2_8",
  185. CASE WHEN tech_indicators_complying_count+tech_indicators_not_complying_count > treatment_facilities_total THEN round(tech_indicators_complying_count+tech_indicators_not_complying_count)|| ' > '||round(treatment_facilities_total)
  186. ELSE '' END as "П63_V6_11&14>V2_8",
  187. CASE WHEN indicators_complying_count+indicators_not_complying_count > treatment_facilities_total THEN round(indicators_complying_count+indicators_not_complying_count)|| ' > '||round(treatment_facilities_total)
  188. ELSE '' END as "П64_V6_12&15>V2_8" ,
  189. CASE WHEN treatment_facilities_biofilter_count+treatment_facilities_remove_nitrogen_count+treatment_facilities_before_cleaning_count > treatment_facilities_total*3 THEN round(treatment_facilities_biofilter_count+treatment_facilities_remove_nitrogen_count+treatment_facilities_before_cleaning_count)|| ' > '||round(treatment_facilities_total*3)
  190. ELSE '' END as "П65_V6_16&17&18>V2_8"
  191.  
  192.  
  193. from volga_river_recovery.sewerages_reports vrr_sf
  194. join geo_tags gt_sf on gt_sf.id=vrr_sf.geo_tag_id
  195. join volga_river_recovery.sewerages_reports_mo vrr_mo on vrr_mo.sewerage_report_id=vrr_sf.id
  196. join geo_tags gt_mo on gt_mo.id=vrr_mo.geo_tag_id
  197.  
  198. join volga_river_recovery.sewerages_reports_mo_clean_sewage vrr_cs on vrr_cs.municipal_area_id=vrr_mo.id
  199. join volga_river_recovery.sewerages_reports_mo_css vrr_css on vrr_css.municipal_area_id=vrr_mo.id
  200. join volga_river_recovery.sewerages_reports_mo_css_exploitation vrr_ce on vrr_ce.municipal_area_id=vrr_mo.id
  201. join volga_river_recovery.sewerages_reports_mo_css_state vrr_cst on vrr_cst.municipal_area_id=vrr_mo.id
  202. join volga_river_recovery.sewerages_reports_mo_service_implementation vrr_si on vrr_si.municipal_area_id=vrr_mo.id
  203.  
  204.  
  205. /*
  206. join volga_river_recovery.sewerages_reports_status_changes_rel vrr_report on vrr_report.sewerage_report_id=vrr_sf.id
  207. join public.status_changes on status_changes.id= vrr_report.status_change_id
  208. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!