select
  publiccomm0_.id                                         as id1_176_0_,
  publiccomm0_.affiliation_id                             as affiliat2_176_0_,
  publiccomm0_.area_id                                    as area_id3_176_0_,
  publiccomm0_.degree_of_conflict_id                      as degree_o4_176_0_,
  publiccomm0_.is_controlled_id                           as is_contr5_176_0_,
  publiccomm0_.last_update                                as last_upd6_176_0_,
  publiccomm0_.notify_citizen_date                        as notify_c7_176_0_,
  publiccomm0_.number                                     as number8_176_0_,
  publiccomm0_.project_name                               as project_9_176_0_,
  publiccomm0_.report_id                                  as report_10_176_0_,
  publiccomm0_.social_object                              as social_11_176_0_,
  publiccomm0_.stage_id                                   as stage_i12_176_0_,
  publiccomm0_.state                                      as state14_176_0_,
  publiccomm0_.type_id                                    as type_id13_176_0_,
  dictionary1_.id                                         as id1_138_1_,
  dictionary1_.name                                       as name2_138_1_,
  dictionary1_.parent_id                                  as parent_i3_138_1_,
  events2_.public_comment_id                              as public_14_156_2_,
  events2_.id                                             as id1_156_2_,
  events2_.id                                             as id1_156_3_,
  events2_.address                                        as address2_156_3_,
  events2_.city_event_id                                  as city_eve3_156_3_,
  events2_.eventDate                                      as eventDat4_156_3_,
  events2_.eventPartNumDeclare                            as eventPar5_156_3_,
  events2_.eventPartNumReal                               as eventPar6_156_3_,
  events2_.eventPermit                                    as eventPer7_156_3_,
  events2_.eventRating                                    as eventRat8_156_3_,
  events2_.eventScale                                     as eventSca9_156_3_,
  events2_.eventSubject                                   as eventSu10_156_3_,
  events2_.eventType                                      as eventTy11_156_3_,
  events2_.ind_leader                                     as ind_lea12_156_3_,
  events2_.public_comment_id                              as public_14_156_3_,
  events2_.result                                         as result13_156_3_,
  cityeventc3_.id                                         as id1_105_4_,
  cityeventc3_.accessory_party                            as accesso35_105_4_,
  cityeventc3_.address_approved                           as address_2_105_4_,
  cityeventc3_.address_notification                       as address_3_105_4_,
  cityeventc3_.address_notify                             as address_4_105_4_,
  cityeventc3_.area                                       as area36_105_4_,
  cityeventc3_.area_notify                                as area_no37_105_4_,
  cityeventc3_.base_provide                               as base_pro5_105_4_,
  cityeventc3_.comment_accessory_party                    as comment_6_105_4_,
  cityeventc3_.comment_event_type                         as comment_7_105_4_,
  cityeventc3_.comment_subject                            as comment_8_105_4_,
  cityeventc3_.comments_event                             as comments9_105_4_,
  cityeventc3_.count_man_approved                         as count_m10_105_4_,
  cityeventc3_.count_trans                                as count_t38_105_4_,
  cityeventc3_.count_trans_approved                       as count_t39_105_4_,
  cityeventc3_.crim_event_id                              as crim_ev40_105_4_,
  cityeventc3_.crim_last_update                           as crim_la41_105_4_,
  cityeventc3_.date_event                                 as date_ev11_105_4_,
  cityeventc3_.date_event_to                              as date_ev12_105_4_,
  cityeventc3_.districts                                  as distric13_105_4_,
  cityeventc3_.event_area                                 as event_a42_105_4_,
  cityeventc3_.event_area_notify                          as event_a43_105_4_,
  cityeventc3_.event_name                                 as event_n14_105_4_,
  cityeventc3_.event_type                                 as event_t44_105_4_,
  cityeventc3_.event_type_note                            as event_t45_105_4_,
  cityeventc3_.from_time                                  as from_ti15_105_4_,
  cityeventc3_.from_time_accepted                         as from_ti16_105_4_,
  cityeventc3_.goal                                       as goal17_105_4_,
  cityeventc3_.infra_feature                              as infra_f18_105_4_,
  cityeventc3_.is_road_block                              as is_road46_105_4_,
  cityeventc3_.itog_status_id                             as itog_st47_105_4_,
  cityeventc3_.meetup_time                                as meetup_48_105_4_,
  cityeventc3_.note_mass                                  as note_ma49_105_4_,
  cityeventc3_.number_of_participants                     as number_19_105_4_,
  cityeventc3_.okrug_id                                   as okrug_i20_105_4_,
  cityeventc3_.okrugs                                     as okrugs21_105_4_,
  cityeventc3_.organizer                                  as organiz22_105_4_,
  cityeventc3_.path_address                               as path_ad23_105_4_,
  cityeventc3_.path_address_notify                        as path_ad24_105_4_,
  cityeventc3_.path_len                                   as path_le50_105_4_,
  cityeventc3_.path_len_notify                            as path_le51_105_4_,
  cityeventc3_.place_note                                 as place_n25_105_4_,
  cityeventc3_.priority_event                             as priorit52_105_4_,
  cityeventc3_.ps                                         as ps53_105_4_,
  cityeventc3_.rayon_id                                   as rayon_i28_105_4_,
  cityeventc3_.Result_comment_result                      as Result_55_105_4_,
  cityeventc3_.Result_complex_event_oib                   as Result_56_105_4_,
  cityeventc3_.result_count_party_fact                    as result_57_105_4_,
  cityeventc3_.Result_number_of_participants              as Result_29_105_4_,
  cityeventc3_.Result_remark_text                         as Result_63_105_4_,
  cityeventc3_.result_report                              as result_64_105_4_,
  cityeventc3_.Result_result_event                        as Result_30_105_4_,
  cityeventc3_.Result_resume_text                         as Result_65_105_4_,
  cityeventc3_.status                                     as status31_105_4_,
  cityeventc3_.status_control                             as status_66_105_4_,
  cityeventc3_.subject                                    as subject32_105_4_,
  cityeventc3_.suggestions                                as suggest67_105_4_,
  cityeventc3_.to_time                                    as to_time33_105_4_,
  cityeventc3_.to_time_accepted                           as to_time34_105_4_,
  cityeventc3_.type_id                                    as type_id68_105_4_,
  dictionary4_.id                                         as id1_138_5_,
  dictionary4_.name                                       as name2_138_5_,
  dictionary4_.parent_id                                  as parent_i3_138_5_,
  dictionary5_.id                                         as id1_138_6_,
  dictionary5_.name                                       as name2_138_6_,
  dictionary5_.parent_id                                  as parent_i3_138_6_,
  dictionary6_.id                                         as id1_138_7_,
  dictionary6_.name                                       as name2_138_7_,
  dictionary6_.parent_id                                  as parent_i3_138_7_,
  dictionary7_.id                                         as id1_138_8_,
  dictionary7_.name                                       as name2_138_8_,
  dictionary7_.parent_id                                  as parent_i3_138_8_,
  dictionary8_.id                                         as id1_138_9_,
  dictionary8_.name                                       as name2_138_9_,
  dictionary8_.parent_id                                  as parent_i3_138_9_,
  dictionary9_.id                                         as id1_138_10_,
  dictionary9_.name                                       as name2_138_10_,
  dictionary9_.parent_id                                  as parent_i3_138_10_,
  dictionary10_.id                                        as id1_138_11_,
  dictionary10_.name                                      as name2_138_11_,
  dictionary10_.parent_id                                 as parent_i3_138_11_,
  dictionary11_.id                                        as id1_138_12_,
  dictionary11_.name                                      as name2_138_12_,
  dictionary11_.parent_id                                 as parent_i3_138_12_,
  dictionary12_.id                                        as id1_138_13_,
  dictionary12_.name                                      as name2_138_13_,
  dictionary12_.parent_id                                 as parent_i3_138_13_,
  dictionary13_.id                                        as id1_138_14_,
  dictionary13_.name                                      as name2_138_14_,
  dictionary13_.parent_id                                 as parent_i3_138_14_,
  keywordsre14_.public_comment_id                         as public_c1_192_15_,
  keywordsre14_.tag_id                                    as tag_id2_192_15_,
  keywordsre14_.public_comment_id                         as public_c1_192_16_,
  keywordsre14_.tag_id                                    as tag_id2_192_16_,
  publiccomm15_.id                                        as id1_195_17_,
  publiccomm15_.name                                      as name2_195_17_,
  publiccomm16_.public_comment_id                         as public_c2_193_18_,
  publiccomm16_.id                                        as id1_193_18_,
  publiccomm16_.id                                        as id1_193_19_,
  publiccomm16_.city_event_id                             as city_eve3_193_19_,
  publiccomm16_.conflict_id                               as conflict4_193_19_,
  publiccomm16_.department_event_id                       as departme5_193_19_,
  publiccomm16_.district_passport_id                      as district6_193_19_,
  publiccomm16_.public_comment_id                         as public_c2_193_19_,
  publiccomm16_.type_relation                             as type_rel7_193_19_,
  cityeventc17_.id                                        as id1_105_20_,
  cityeventc17_.accessory_party                           as accesso35_105_20_,
  cityeventc17_.address_approved                          as address_2_105_20_,
  cityeventc17_.address_notification                      as address_3_105_20_,
  cityeventc17_.address_notify                            as address_4_105_20_,
  cityeventc17_.area                                      as area36_105_20_,
  cityeventc17_.area_notify                               as area_no37_105_20_,
  cityeventc17_.base_provide                              as base_pro5_105_20_,
  cityeventc17_.comment_accessory_party                   as comment_6_105_20_,
  cityeventc17_.comment_event_type                        as comment_7_105_20_,
  cityeventc17_.comment_subject                           as comment_8_105_20_,
  cityeventc17_.comments_event                            as comments9_105_20_,
  cityeventc17_.count_man_approved                        as count_m10_105_20_,
  cityeventc17_.count_trans                               as count_t38_105_20_,
  cityeventc17_.count_trans_approved                      as count_t39_105_20_,
  cityeventc17_.crim_event_id                             as crim_ev40_105_20_,
  cityeventc17_.crim_last_update                          as crim_la41_105_20_,
  cityeventc17_.date_event                                as date_ev11_105_20_,
  cityeventc17_.date_event_to                             as date_ev12_105_20_,
  cityeventc17_.districts                                 as distric13_105_20_,
  cityeventc17_.event_area                                as event_a42_105_20_,
  cityeventc17_.event_area_notify                         as event_a43_105_20_,
  cityeventc17_.event_name                                as event_n14_105_20_,
  cityeventc17_.event_type                                as event_t44_105_20_,
  cityeventc17_.event_type_note                           as event_t45_105_20_,
  cityeventc17_.from_time                                 as from_ti15_105_20_,
  cityeventc17_.from_time_accepted                        as from_ti16_105_20_,
  cityeventc17_.goal                                      as goal17_105_20_,
  cityeventc17_.infra_feature                             as infra_f18_105_20_,
  cityeventc17_.is_road_block                             as is_road46_105_20_,
  cityeventc17_.itog_status_id                            as itog_st47_105_20_,
  cityeventc17_.meetup_time                               as meetup_48_105_20_,
  cityeventc17_.note_mass                                 as note_ma49_105_20_,
  cityeventc17_.number_of_participants                    as number_19_105_20_,
  cityeventc17_.okrug_id                                  as okrug_i20_105_20_,
  cityeventc17_.okrugs                                    as okrugs21_105_20_,
  cityeventc17_.organizer                                 as organiz22_105_20_,
  cityeventc17_.path_address                              as path_ad23_105_20_,
  cityeventc17_.path_address_notify                       as path_ad24_105_20_,
  cityeventc17_.path_len                                  as path_le50_105_20_,
  cityeventc17_.path_len_notify                           as path_le51_105_20_,
  cityeventc17_.place_note                                as place_n25_105_20_,
  cityeventc17_.priority_event                            as priorit52_105_20_,
  cityeventc17_.ps                                        as ps53_105_20_,
  cityeventc17_.rayon_id                                  as rayon_i28_105_20_,
  cityeventc17_.Result_comment_result                     as Result_55_105_20_,
  cityeventc17_.Result_complex_event_oib                  as Result_56_105_20_,
  cityeventc17_.result_count_party_fact                   as result_57_105_20_,
  cityeventc17_.Result_number_of_participants             as Result_29_105_20_,
  cityeventc17_.Result_remark_text                        as Result_63_105_20_,
  cityeventc17_.result_report                             as result_64_105_20_,
  cityeventc17_.Result_result_event                       as Result_30_105_20_,
  cityeventc17_.Result_resume_text                        as Result_65_105_20_,
  cityeventc17_.status                                    as status31_105_20_,
  cityeventc17_.status_control                            as status_66_105_20_,
  cityeventc17_.subject                                   as subject32_105_20_,
  cityeventc17_.suggestions                               as suggest67_105_20_,
  cityeventc17_.to_time                                   as to_time33_105_20_,
  cityeventc17_.to_time_accepted                          as to_time34_105_20_,
  cityeventc17_.type_id                                   as type_id68_105_20_,
  conflict18_.conflict_id                                 as conflict1_120_21_,
  conflict18_.address_descr                               as address_2_120_21_,
  conflict18_.rayon_id                                    as rayon_id3_120_21_,
  conflict18_.fullness                                    as fullness4_120_21_,
  conflict18_.creation_date                               as creation5_120_21_,
  conflict18_.data_source                                 as data_sou6_120_21_,
  conflict18_.cnt_event                                   as cnt_even7_120_21_,
  conflict18_.conffullname                                as conffull8_120_21_,
  conflict18_.is_conflict                                 as is_confl9_120_21_,
  conflict18_.layer_id                                    as layer_i43_120_21_,
  conflict18_.confcontrol                                 as confcon10_120_21_,
  conflict18_.confnum                                     as confnum11_120_21_,
  conflict18_.cnt_smi_article                             as cnt_smi12_120_21_,
  conflict18_.okrug_id                                    as okrug_i13_120_21_,
  conflict18_.confstate                                   as confsta14_120_21_,
  conflict18_.confalias                                   as confali15_120_21_,
  conflict18_.cnt_soc_article                             as cnt_soc16_120_21_,
  conflict18_.confstartdate                               as confsta17_120_21_,
  conflict18_.confstatus                                  as confsta18_120_21_,
  conflict18_.subject                                     as subject19_120_21_,
  conflict18_.conftop                                     as conftop20_120_21_,
  conflict18_.conftype                                    as conftyp21_120_21_,
  conflict18_.unique_id                                   as unique_22_120_21_,
  conflict18_.address                                     as address23_120_21_,
  conflict18_.confGor                                     as confGor24_120_21_,
  conflict18_.confDesc                                    as confDes25_120_21_,
  conflict18_.confHist                                    as confHis26_120_21_,
  conflict18_.confNoExpl                                  as confNoE27_120_21_,
  conflict18_.confPartMonitor                             as confPar28_120_21_,
  conflict18_.confRating                                  as confRat29_120_21_,
  conflict18_.confstartpartnum                            as confsta30_120_21_,
  conflict18_.confstate_change_reason                     as confsta31_120_21_,
  conflict18_.confnewold                                  as confnew32_120_21_,
  conflict18_.confrenewperiod                             as confren33_120_21_,
  conflict18_.content_resume                              as content34_120_21_,
  conflict18_.last_update                                 as last_up35_120_21_,
  conflict18_.point_lat                                   as point_l36_120_21_,
  conflict18_.point_lng                                   as point_l37_120_21_,
  conflict18_.PUBLIC_DYNAMIC_SMI                          as PUBLIC_38_120_21_,
  conflict18_.public_dynamic_media                        as public_39_120_21_,
  conflict18_.real_change_update_date                     as real_ch40_120_21_,
  userlayer19_.id                                         as id1_236_22_,
  userlayer19_.color                                      as color2_236_22_,
  userlayer19_.creation_date                              as creation6_236_22_,
  userlayer19_.name                                       as name3_236_22_,
  userlayer19_.opacity                                    as opacity4_236_22_,
  userlayer19_.update_date                                as update_d7_236_22_,
  userlayer19_.user_id                                    as user_id8_236_22_,
  userlayer19_.z_index                                    as z_index5_236_22_,
  (select count(*)
   from conflicts_formatted_new c
   where c.layer_id = userlayer19_.id)                    as formula18_22_,
  userentity20_.id                                        as id1_240_23_,
  userentity20_.category_id                               as categor14_240_23_,
  userentity20_.email                                     as email2_240_23_,
  userentity20_.enabled                                   as enabled3_240_23_,
  userentity20_.fullname                                  as fullname4_240_23_,
  userentity20_.mobile_device_uid                         as mobile_d5_240_23_,
  userentity20_.credentials_non_expired                   as credenti6_240_23_,
  userentity20_.notifications                             as notifica7_240_23_,
  userentity20_.password                                  as password8_240_23_,
  userentity20_.phone                                     as phone9_240_23_,
  userentity20_.position                                  as positio10_240_23_,
  userentity20_.start_page_id                             as start_p11_240_23_,
  userentity20_.subdivision                               as subdivi12_240_23_,
  userentity20_.username                                  as usernam13_240_23_,
  authoritie21_.user_id                                   as user_id1_241_24_,
  authoritye22_.id                                        as authorit2_241_24_,
  authoritye22_.id                                        as id1_103_25_,
  authoritye22_.authority                                 as authorit2_103_25_,
  authoritye22_.description                               as descript3_103_25_,
  authoritye22_.name                                      as name4_103_25_,
  categoryen23_.id                                        as id1_138_26_,
  categoryen23_.name                                      as name2_138_26_,
  responsibl24_.user_id                                   as user_id1_246_27_,
  responsibl25_.id                                        as okrug_id2_246_27_,
  responsibl25_.id                                        as id1_247_28_,
  responsibl25_.code                                      as code2_247_28_,
  responsibl25_.name                                      as name3_247_28_,
  responsibl25_.ord                                       as ord4_247_28_,
  responsibl25_.shortname                                 as shortnam5_247_28_,
  desktoppat26_.id                                        as id1_137_29_,
  desktoppat26_.acl_id                                    as acl_id2_137_29_,
  desktoppat26_.name                                      as name3_137_29_,
  desktoppat26_.path                                      as path4_137_29_,
  relatedcon27_.target_conflict_id                        as target_c1_119_30_,
  linkedconf28_.conflict_id                               as linked_c2_119_30_,
  linkedconf28_.conflict_id                               as conflict1_120_31_,
  linkedconf28_.address_descr                             as address_2_120_31_,
  linkedconf28_.cnt_smi_article                           as cnt_smi12_120_31_,
  linkedconf28_.cnt_soc_article                           as cnt_soc16_120_31_,
  linkedconf28_.conffullname                              as conffull8_120_31_,
  linkedconf28_.confstartdate                             as confsta17_120_31_,
  linkedconf28_.confstate                                 as confsta14_120_31_,
  linkedconf28_.confnum                                   as confnum11_120_31_,
  linkedconf28_.okrug_id                                  as okrug_i13_120_31_,
  linkedconf28_.sc_id                                     as sc_id41_120_31_,
  linkedconf28_.confalias                                 as confali15_120_31_,
  linkedconf28_.confstatus                                as confsta18_120_31_,
  linkedconf28_.unique_id                                 as unique_22_120_31_,
  readonlygr29_.conflict_id                               as conflict3_118_32_,
  conflictgr30_.id                                        as group_id2_118_32_,
  conflictgr30_.id                                        as id1_117_33_,
  conflictgr30_.description                               as descript2_117_33_,
  conflictgr30_.name                                      as name3_117_33_,
  department31_.id                                        as id1_131_34_,
  department31_.date                                      as date2_131_34_,
  department31_.status_id                                 as status_i3_131_34_,
  department31_.title                                     as title4_131_34_,
  department31_.unique_id                                 as unique_i5_131_34_,
  department31_.address                                   as address6_131_34_,
  department31_.address_description                       as address_7_131_34_,
  department31_.okrug_id                                  as okrug_id8_131_34_,
  department31_.control_id                                as control_9_131_34_,
  department31_.description                               as descrip10_131_34_,
  department31_.rayon_id                                  as rayon_i11_131_34_,
  department31_.end_time                                  as end_tim12_131_34_,
  department31_.last_update                               as last_up13_131_34_,
  department31_.point_lat                                 as point_l14_131_34_,
  department31_.point_lng                                 as point_l15_131_34_,
  department31_.priority_id                               as priorit16_131_34_,
  department31_.result_id                                 as result_17_131_34_,
  department31_.start_time                                as start_t18_131_34_,
  department31_.type_id                                   as type_id19_131_34_,
  dictionary32_.id                                        as id1_138_35_,
  dictionary32_.name                                      as name2_138_35_,
  dictionary32_.parent_id                                 as parent_i3_138_35_,
  dictionary33_.id                                        as id1_138_36_,
  dictionary33_.name                                      as name2_138_36_,
  dictionary33_.parent_id                                 as parent_i3_138_36_,
  dictionary34_.id                                        as id1_138_37_,
  dictionary34_.name                                      as name2_138_37_,
  dictionary34_.parent_id                                 as parent_i3_138_37_,
  dictionary35_.id                                        as id1_138_38_,
  dictionary35_.name                                      as name2_138_38_,
  dictionary35_.parent_id                                 as parent_i3_138_38_,
  dictionary36_.id                                        as id1_138_39_,
  dictionary36_.name                                      as name2_138_39_,
  dictionary36_.parent_id                                 as parent_i3_138_39_,
  dictionary37_.id                                        as id1_138_40_,
  dictionary37_.name                                      as name2_138_40_,
  dictionary37_.parent_id                                 as parent_i3_138_40_,
  dictionary38_.id                                        as id1_138_41_,
  dictionary38_.name                                      as name2_138_41_,
  dictionary38_.parent_id                                 as parent_i3_138_41_,
  districtpa39_.id                                        as id1_139_42_,
  districtpa39_.address                                   as address2_139_42_,
  districtpa39_.district_id                               as district3_139_42_,
  districtpa39_.last_change_date                          as last_cha4_139_42_,
  districtpa39_.reception_phone                           as receptio5_139_42_,
  districtpa39_.state_id                                  as state_id6_139_42_,
  districtpa39_.website                                   as website7_139_42_,
  districtpa39_.apartment_buildings_cnt                   as apartmen8_139_42_,
  districtpa39_.apartments_cnt                            as apartmen9_139_42_,
  districtpa39_.cso_clients_sprt_cnt                      as cso_cli10_139_42_,
  districtpa39_.dormitories_cnt                           as dormito11_139_42_,
  districtpa39_.entrances_cnt                             as entranc12_139_42_,
  districtpa39_.note                                      as note13_139_42_,
  districtpa39_.population                                as populat14_139_42_,
  districtpa39_.public_advisers_sprt_cnt                  as public_15_139_42_,
  districtpa39_.public_organizations_sprt_cnt             as public_16_139_42_,
  districtpa39_.ruling_party_member_sprt_cnt              as ruling_17_139_42_,
  districtpa39_.toc_cnt                                   as toc_cnt18_139_42_,
  districtpa39_.total_area                                as total_a19_139_42_,
  districtpa39_.total_sprt_cnt                            as total_s20_139_42_,
  districtpa39_.tszh_cnt                                  as tszh_cn21_139_42_,
  districtpa39_.zhsk_cnt                                  as zhsk_cn22_139_42_,
  conflictre40_.district_passport_id                      as district2_140_43_,
  conflictre40_.conflict_id                               as conflict1_140_43_,
  conflictre40_.conflict_id                               as conflict1_140_44_,
  conflictre40_.district_passport_id                      as district2_140_44_,
  conflictsh41_.conflict_id                               as conflict1_120_45_,
  conflictsh41_.address_descr                             as address_2_120_45_,
  conflictsh41_.rayon_id                                  as rayon_id3_120_45_,
  conflictsh41_.fullness                                  as fullness4_120_45_,
  conflictsh41_.creation_date                             as creation5_120_45_,
  conflictsh41_.data_source                               as data_sou6_120_45_,
  conflictsh41_.cnt_event                                 as cnt_even7_120_45_,
  conflictsh41_.conffullname                              as conffull8_120_45_,
  conflictsh41_.is_conflict                               as is_confl9_120_45_,
  conflictsh41_.layer_id                                  as layer_i43_120_45_,
  conflictsh41_.confcontrol                               as confcon10_120_45_,
  conflictsh41_.confnum                                   as confnum11_120_45_,
  conflictsh41_.cnt_smi_article                           as cnt_smi12_120_45_,
  conflictsh41_.okrug_id                                  as okrug_i13_120_45_,
  conflictsh41_.confstate                                 as confsta14_120_45_,
  conflictsh41_.confalias                                 as confali15_120_45_,
  conflictsh41_.cnt_soc_article                           as cnt_soc16_120_45_,
  conflictsh41_.confstartdate                             as confsta17_120_45_,
  conflictsh41_.confstatus                                as confsta18_120_45_,
  conflictsh41_.subject                                   as subject19_120_45_,
  conflictsh41_.conftop                                   as conftop20_120_45_,
  conflictsh41_.conftype                                  as conftyp21_120_45_,
  conflictsh41_.unique_id                                 as unique_22_120_45_,
  conflictsh41_.cnt_status_change                         as cnt_sta42_120_45_,
  constructi42_.district_passport_id                      as district2_141_46_,
  constructi42_.construction_id                           as construc1_141_46_,
  constructi42_.construction_id                           as construc1_141_47_,
  constructi42_.district_passport_id                      as district2_141_47_,
  rocobject43_.object_id                                  as object_i1_87_48_,
  rocobject43_.begin_fact_date                            as begin_fa2_87_48_,
  rocobject43_.building                                   as building3_87_48_,
  rocobject43_.clean_address                              as clean_ad4_87_48_,
  rocobject43_.c_address                                  as c_addres5_87_48_,
  rocobject43_.e_address                                  as e_addres6_87_48_,
  rocobject43_.e_point_lat                                as e_point_7_87_48_,
  rocobject43_.e_point_lng                                as e_point_8_87_48_,
  rocobject43_.e_status                                   as e_status9_87_48_,
  rocobject43_.main_functional                            as main_fu10_87_48_,
  rocobject43_.object_address                             as object_11_87_48_,
  rocobject43_.object_area                                as object_12_87_48_,
  rocobject43_.object_condition                           as object_13_87_48_,
  rocobject43_.object_name                                as object_14_87_48_,
  rocobject43_.object_not_moscow                          as object_15_87_48_,
  rocobject43_.okrug_id                                   as okrug_i16_87_48_,
  rocobject43_.on_snos                                    as on_snos17_87_48_,
  rocobject43_.post_address                               as post_ad18_87_48_,
  rocobject43_.project_ser                                as project19_87_48_,
  rocobject43_.rayon_id                                   as rayon_i20_87_48_,
  rocobject43_.source_of_finance                          as source_21_87_48_,
  rocobject43_.start_up_fact_year                         as start_u22_87_48_,
  rocobject43_.start_up_plan_year                         as start_u23_87_48_,
  rocobject43_.start_up_plan_year_pc                      as start_u24_87_48_,
  rocobject43_.construction_work_type                     as constru25_87_48_,
  dictionary44_.id                                        as id1_138_49_,
  dictionary44_.name                                      as name2_138_49_,
  dictionary44_.parent_id                                 as parent_i3_138_49_,
  dictionary45_.id                                        as id1_138_50_,
  dictionary45_.name                                      as name2_138_50_,
  dictionary45_.parent_id                                 as parent_i3_138_50_,
  districtpa46_.district_passport_id                      as district1_145_51_,
  districtpa46_.authority_end_date                        as authorit2_145_51_,
  districtpa46_.chm_name                                  as chm_name3_145_51_,
  districtpa46_.chm_patronymic                            as chm_patr4_145_51_,
  districtpa46_.chm_surname                               as chm_surn5_145_51_,
  districtpa46_.forwarded_by                              as forwarde6_145_51_,
  districtpa46_.place_of_work                             as place_of7_145_51_,
  districtpa46_.polling_places_cnt                        as polling_8_145_51_,
  districtpa46_.sd_cnt                                    as sd_cnt9_145_51_,
  districtpa46_.tik_cnt                                   as tik_cnt10_145_51_,
  districtpa46_.uik_at_place_registration_cnt             as uik_at_11_145_51_,
  districtpa46_.uik_at_tmp_place_cnt                      as uik_at_12_145_51_,
  dictionary47_.id                                        as id1_138_52_,
  dictionary47_.name                                      as name2_138_52_,
  dictionary47_.parent_id                                 as parent_i3_138_52_,
  publiccomm48_.public_comment_id                         as public_c1_177_53_,
  publiccomm48_.analysis_ended_at                         as analysis2_177_53_,
  publiccomm48_.analysis_started_at                       as analysis3_177_53_,
  publiccomm48_.information_field_index_id                as informat4_177_53_,
  publiccomm48_.integral_index_id                         as integral5_177_53_,
  publiccomm48_.negative_requests_count                   as negative6_177_53_,
  publiccomm48_.numerical_indicators_index_id             as numerica7_177_53_,
  publiccomm48_.positive_requests_count                   as positive8_177_53_,
  publiccomm48_.protest_activity_index_id                 as protest_9_177_53_,
  publiccomm49_.public_comment_analysis_id                as public_c5_178_54_,
  publiccomm49_.id                                        as id1_178_54_,
  publiccomm49_.id                                        as id1_178_55_,
  publiccomm49_.analysis_negative_reviews_count           as analysis2_178_55_,
  publiccomm49_.analysis_positive_reviews_count           as analysis3_178_55_,
  publiccomm49_.public_comment_analysis_id                as public_c5_178_55_,
  publiccomm49_.reviewed_at                               as reviewed4_178_55_,
  publiccomm50_.public_comment_id                         as public_c1_180_56_,
  publiccomm50_.address                                   as address2_180_56_,
  publiccomm50_.address_description                       as address_3_180_56_,
  publiccomm50_.decision_id                               as decision4_180_56_,
  publiccomm50_.district_id                               as district5_180_56_,
  publiccomm50_.owner_id                                  as owner_id6_180_56_,
  publiccomm50_.point_lat                                 as point_la7_180_56_,
  publiccomm50_.point_lng                                 as point_ln8_180_56_,
  publiccomm50_.socmedia_publication                      as socmedia9_180_56_,
  publiccomm51_.public_comment_id                         as public_c1_181_57_,
  publiccomm51_.conclusion_protocol_id                    as conclusi5_181_57_,
  publiccomm51_.conclusion_protocol_number                as conclusi2_181_57_,
  publiccomm51_.conclusion_protocol_published_at          as conclusi3_181_57_,
  publiccomm51_.decision_id                               as decision4_181_57_,
  conclusion52_.id                                        as id1_86_58_,
  conclusion52_.content                                   as content2_86_58_,
  conclusion52_.content_type                              as content_3_86_58_,
  conclusion52_.creation_date                             as creation4_86_58_,
  conclusion52_.description                               as descript5_86_58_,
  conclusion52_.file_length                               as file_len6_86_58_,
  conclusion52_.name                                      as name7_86_58_,
  conclusion52_.type                                      as type8_86_58_,
  conclusion52_.public_comment_conclusion_id              as public_c9_86_58_,
  publiccomm53_.public_comment_id                         as public_c1_181_59_,
  publiccomm53_.conclusion_protocol_id                    as conclusi5_181_59_,
  publiccomm53_.conclusion_protocol_number                as conclusi2_181_59_,
  publiccomm53_.conclusion_protocol_published_at          as conclusi3_181_59_,
  publiccomm53_.decision_id                               as decision4_181_59_,
  conclusion54_.id                                        as id1_85_60_,
  conclusion54_.content                                   as content2_85_60_,
  conclusion54_.content_type                              as content_3_85_60_,
  conclusion54_.creation_date                             as creation4_85_60_,
  conclusion54_.description                               as descript5_85_60_,
  conclusion54_.file_length                               as file_len6_85_60_,
  conclusion54_.name                                      as name7_85_60_,
  conclusion54_.type                                      as type8_85_60_,
  conclusion54_.public_comment_conclusion_id              as public_c9_85_60_,
  publiccomm55_.public_comment_id                         as public_c1_183_61_,
  publiccomm55_.exposition_address                        as expositi2_183_61_,
  publiccomm55_.exposition_days                           as expositi3_183_61_,
  publiccomm55_.exposition_ended_at                       as expositi4_183_61_,
  publiccomm55_.exposition_negative_reviews_count         as expositi5_183_61_,
  publiccomm55_.exposition_positive_reviews_count         as expositi6_183_61_,
  publiccomm55_.exposition_results                        as expositi7_183_61_,
  publiccomm55_.exposition_started_at                     as expositi8_183_61_,
  publiccomm55_.exposition_include_weekend                as expositi9_183_61_,
  publiccomm56_.public_comment_exposition_id              as public_c5_185_62_,
  publiccomm56_.id                                        as id1_185_62_,
  publiccomm56_.id                                        as id1_185_63_,
  publiccomm56_.exposition_negative_reviews_count         as expositi2_185_63_,
  publiccomm56_.exposition_positive_reviews_count         as expositi3_185_63_,
  publiccomm56_.public_comment_exposition_id              as public_c5_185_63_,
  publiccomm56_.reviewed_at                               as reviewed4_185_63_,
  publiccomm57_.public_comment_id                         as public_c1_186_64_,
  publiccomm57_.are_there_initiative_groups               as are_ther2_186_64_,
  publiccomm57_.meeting_address                           as meeting_3_186_64_,
  publiccomm57_.meeting_area_resident_members_count       as meeting_4_186_64_,
  publiccomm57_.meeting_employee_members_count            as meeting_5_186_64_,
  publiccomm57_.meeting_executive_authority_members_count as meeting_6_186_64_,
  publiccomm57_.meeting_no_votes_count                    as meeting_7_186_64_,
  publiccomm57_.meeting_owner_members_count               as meeting_8_186_64_,
  publiccomm57_.meeting_parties_speechers                 as meeting_9_186_64_,
  publiccomm57_.meeting_started_at                        as meeting10_186_64_,
  publiccomm57_.meeting_yes_votes_count                   as meeting11_186_64_,
  meetingque58_.public_comment_meeting_id                 as public_c3_187_65_,
  meetingque58_.id                                        as id1_187_65_,
  meetingque58_.id                                        as id1_187_66_,
  meetingque58_.public_comment_meeting_id                 as public_c3_187_66_,
  meetingque58_.question                                  as question2_187_66_,
  publiccomm59_.public_comment_id                         as public_c1_188_67_,
  publiccomm59_.negative_publications_count               as negative2_188_67_,
  publiccomm59_.publications_monitoring_data              as publicat3_188_67_,
  publiccomm60_.public_comment_id                         as public_c1_189_68_,
  publiccomm60_.offer_remark_ended_at                     as offer_re2_189_68_,
  publiccomm60_.offer_remark_negative_reviews_count       as offer_re3_189_68_,
  publiccomm60_.offer_remark_positive_reviews_count       as offer_re4_189_68_,
  publiccomm60_.offer_remark_reviews_count                as offer_re5_189_68_,
  publiccomm60_.offer_remark_started_at                   as offer_re6_189_68_,
  publiccomm61_.public_comment_offer_remark_id            as public_c6_190_69_,
  publiccomm61_.id                                        as id1_190_69_,
  publiccomm61_.id                                        as id1_190_70_,
  publiccomm61_.negative_reviews_count                    as negative2_190_70_,
  publiccomm61_.positive_reviews_count                    as positive3_190_70_,
  publiccomm61_.public_comment_offer_remark_id            as public_c6_190_70_,
  publiccomm61_.start_reviewed_at                         as start_re4_190_70_,
  publiccomm61_.stop_reviewed_at                          as stop_rev5_190_70_,
  publiccomm62_.public_comment_id                         as public_c1_191_71_,
  publiccomm62_.protest_events_monitoring_data            as protest_2_191_71_
from public_comment publiccomm0_ left outer join dict_elements dictionary1_ on publiccomm0_.state = dictionary1_.id
  left outer join event_public_comment events2_ on publiccomm0_.id = events2_.public_comment_id
  left outer join city_event cityeventc3_ on events2_.city_event_id = cityeventc3_.id
  left outer join dict_elements dictionary4_ on cityeventc3_.accessory_party = dictionary4_.id
  left outer join dict_elements dictionary5_ on cityeventc3_.event_type = dictionary5_.id
  left outer join dict_elements dictionary6_ on cityeventc3_.itog_status_id = dictionary6_.id
  left outer join dict_elements dictionary7_ on cityeventc3_.okrug_id = dictionary7_.id
  left outer join dict_elements dictionary8_ on cityeventc3_.priority_event = dictionary8_.id
  left outer join dict_elements dictionary9_ on cityeventc3_.rayon_id = dictionary9_.id
  left outer join dict_elements dictionary10_ on cityeventc3_.status = dictionary10_.id
  left outer join dict_elements dictionary11_ on cityeventc3_.status_control = dictionary11_.id
  left outer join dict_elements dictionary12_ on cityeventc3_.subject = dictionary12_.id
  left outer join dict_elements dictionary13_ on cityeventc3_.type_id = dictionary13_.id
  left outer join public_comment_ref_tags keywordsre14_ on publiccomm0_.id = keywordsre14_.public_comment_id
  left outer join public_comment_tags publiccomm15_ on keywordsre14_.tag_id = publiccomm15_.id
  left outer join public_comment_relation publiccomm16_ on publiccomm0_.id = publiccomm16_.public_comment_id
  left outer join city_event cityeventc17_ on publiccomm16_.city_event_id = cityeventc17_.id
  left outer join conflicts_formatted_new conflict18_ on publiccomm16_.conflict_id = conflict18_.conflict_id
  left outer join user_layer userlayer19_ on conflict18_.layer_id = userlayer19_.id
  left outer join users userentity20_ on userlayer19_.user_id = userentity20_.id
  left outer join users_ref_authority authoritie21_ on userentity20_.id = authoritie21_.user_id
  left outer join authority authoritye22_ on authoritie21_.authority_id = authoritye22_.id
  left outer join dict_elements categoryen23_ on userentity20_.category_id = categoryen23_.id
  left outer join v_ref_user_okrug responsibl24_ on userentity20_.id = responsibl24_.user_id
  left outer join v_spr_responsible_authorities responsibl25_ on responsibl24_.okrug_id = responsibl25_.id
  left outer join desktop_paths desktoppat26_ on userentity20_.start_page_id = desktoppat26_.id
  left outer join conflict_ref_conflict relatedcon27_ on conflict18_.conflict_id = relatedcon27_.target_conflict_id
  left outer join conflicts_formatted_new linkedconf28_ on relatedcon27_.linked_conflict_id = linkedconf28_.conflict_id
  left outer join conflict_group_item readonlygr29_ on linkedconf28_.conflict_id = readonlygr29_.conflict_id
  left outer join conflict_group conflictgr30_ on readonlygr29_.group_id = conflictgr30_.id
  left outer join department_event department31_ on publiccomm16_.department_event_id = department31_.id
  left outer join dict_elements dictionary32_ on department31_.okrug_id = dictionary32_.id
  left outer join dict_elements dictionary33_ on department31_.control_id = dictionary33_.id
  left outer join dict_elements dictionary34_ on department31_.rayon_id = dictionary34_.id
  left outer join dict_elements dictionary35_ on department31_.priority_id = dictionary35_.id
  left outer join dict_elements dictionary36_ on department31_.result_id = dictionary36_.id
  left outer join dict_elements dictionary37_ on department31_.status_id = dictionary37_.id
  left outer join dict_elements dictionary38_ on department31_.type_id = dictionary38_.id
  left outer join district_passport districtpa39_ on publiccomm16_.district_passport_id = districtpa39_.id
  left outer join district_passport_conflict conflictre40_ on districtpa39_.id = conflictre40_.district_passport_id
  left outer join conflicts_formatted_new conflictsh41_ on conflictre40_.conflict_id = conflictsh41_.conflict_id
  left outer join district_passport_construction constructi42_ on districtpa39_.id = constructi42_.district_passport_id
  left outer join public.roc_object rocobject43_ on constructi42_.construction_id = rocobject43_.object_id
  left outer join dict_elements dictionary44_ on districtpa39_.district_id = dictionary44_.id
  left outer join dict_elements dictionary45_ on districtpa39_.state_id = dictionary45_.id
  left outer join district_passport_elections districtpa46_ on districtpa39_.id = districtpa46_.district_passport_id
  left outer join dict_elements dictionary47_ on publiccomm16_.type_relation = dictionary47_.id
  left outer join public_comment_analysis publiccomm48_ on publiccomm0_.id = publiccomm48_.public_comment_id
  left outer join public_comment_analysis_review publiccomm49_
    on publiccomm48_.public_comment_id = publiccomm49_.public_comment_analysis_id
  left outer join public_comment_common publiccomm50_ on publiccomm0_.id = publiccomm50_.public_comment_id
  left outer join public_comment_conclusion publiccomm51_ on publiccomm0_.id = publiccomm51_.public_comment_id
  left outer join public.conclusion_protocol conclusion52_ on publiccomm51_.conclusion_protocol_id = conclusion52_.id
  left outer join public_comment_conclusion publiccomm53_
    on conclusion52_.public_comment_conclusion_id = publiccomm53_.public_comment_id
  left outer join public.conclusion conclusion54_
    on publiccomm53_.public_comment_id = conclusion54_.public_comment_conclusion_id
  left outer join public_comment_exposition publiccomm55_ on publiccomm0_.id = publiccomm55_.public_comment_id
  left outer join public_comment_exposition_review publiccomm56_
    on publiccomm55_.public_comment_id = publiccomm56_.public_comment_exposition_id
  left outer join public_comment_meeting publiccomm57_ on publiccomm0_.id = publiccomm57_.public_comment_id
  left outer join public_comment_meeting_question meetingque58_
    on publiccomm57_.public_comment_id = meetingque58_.public_comment_meeting_id
  left outer join public_comment_monitoring publiccomm59_ on publiccomm0_.id = publiccomm59_.public_comment_id
  left outer join public_comment_offer_remark publiccomm60_ on publiccomm0_.id = publiccomm60_.public_comment_id
  left outer join public_comment_offer_remark_review publiccomm61_
    on publiccomm60_.public_comment_id = publiccomm61_.public_comment_offer_remark_id
  left outer join public_comment_protest publiccomm62_ on publiccomm0_.id = publiccomm62_.public_comment_id
where publiccomm0_.id =513
order by linkedconf28_.conffullname, publiccomm49_.reviewed_at asc, publiccomm56_.reviewed_at asc,
  publiccomm61_.start_reviewed_at asc;