select
	orderexecu0_.order_execution_ntfn_guid as order_ex1_12_,
	orderexecu0_.report_month as report_m2_12_,
	orderexecu0_.account_id as account_3_12_,
	orderexecu0_.fias_address as fias_add4_12_,
	orderexecu0_.fias_house_code as fias_hou5_12_,
	orderexecu0_.flat_number as flat_num6_12_,
	orderexecu0_.hcs_service_id as hcs_serv7_12_,
	orderexecu0_.hm_account_guid as hm_accou8_12_,
	orderexecu0_.non_living_number as non_livi9_12_,
	orderexecu0_.order_id as order_i10_12_,
	orderexecu0_.order_no as order_n11_12_,
	orderexecu0_.payment_date as payment12_12_,
	orderexecu0_.payment_document_id as payment13_12_,
	orderexecu0_.payment_document_number as payment14_12_,
	orderexecu0_.payment_period_month as payment15_12_,
	orderexecu0_.payment_period_year as payment16_12_,
	orderexecu0_.receiver_inn as receive17_12_,
	orderexecu0_.receiver_kpp as receive18_12_,
	orderexecu0_.receiver_name as receive19_12_,
	orderexecu0_.room_number as room_nu20_12_,
	orderexecu0_.single_account_id as single_21_12_,
	orderexecu0_.status as status22_12_,
	orderexecu0_.total as total23_12_,
	orderexecu0_.total_ack as total_a24_12_
from
	cegisso.egisso_order_execution_ntfn_info orderexecu0_
where
	orderexecu0_.payment_date>='2022-08-01'::date
	and orderexecu0_.payment_date<='2022-10-30'::date
	and (orderexecu0_.report_month in ('2022-08-01'::date  , '2022-09-01'::date  , '2022-10-01'::date ))
	and (orderexecu0_.order_execution_ntfn_guid in
		 (select
		  	notificati1_.notification_guid
		  from
		  	cegisso.egisso_notifications_payment_documents notificati1_
		  where
		  	notificati1_.report_month = orderexecu0_.report_month
		  and (notificati1_.payment_document_guid in (select
													  	paymentdoc2_.payment_document_guid
													  from
													  	cegisso.egisso_payment_document_info paymentdoc2_
													  where
													  	paymentdoc2_.report_month <= notificati1_.report_month
													  and (paymentdoc2_.account_guid in ('937b1d9c-8c61-4250-b0c2-f44db6d189d5'::uuid , '99305375-b3ba-4112-93cb-2d65aa330014'::uuid))))
		 )
		);