server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.|SOURCE -> 							SELECT
								estate.cha_chain
							FROM
								pubestatechain14_parent AS estate
							LEFT JOIN
								estate_score14
							ON
								esc_estatecode = estate.est_code
							LEFT JOIN
								agent_option_it_apamanshop
							ON
								agent_option_it_apamanshop.agt_code = est_agentcode
							LEFT JOIN
								lifull_it
							ON
								lifull_it.est_code = estate.est_code
							LEFT JOIN
								agent
							ON
								agent.agt_code = estate.est_agentcode
							LEFT JOIN
								estate_extend_visitreserve
							ON
								estate_extend_visitreserve.eev_estatenumber = estate.est_number
							WHERE TRUE

									

 
AND ( est_equipmentstatuscode && ARRAY[10501, 10502] ) = false
AND est_publishingperiod >= 'now'::date AND

(est_locationcode = est_locationcode ) AND 
( 
 (est_roomarrangementtotal = 2 AND est_roomarrangementcode = 30 ) OR 
 (est_roomarrangementtotal::text || est_roomarrangementcode::text ) IN('250','255') OR 
 (est_roomarrangementtotal = 3 AND est_roomarrangementcode = 20 ) OR 
 (est_roomarrangementtotal = 3 AND est_roomarrangementcode = 30 ) OR 
 (est_roomarrangementtotal::text || est_roomarrangementcode::text ) IN('350','355') OR 
 (est_roomarrangementtotal = 4 AND est_roomarrangementcode = 20 ) OR 
 (est_roomarrangementtotal = 4 AND est_roomarrangementcode = 30 ) OR 
 (est_roomarrangementtotal::text || est_roomarrangementcode::text ) IN('450','455') OR 
 (est_roomarrangementtotal = 5 AND est_roomarrangementcode >= 20 ) 
) AND 
(est_rent > '0')
AND 


 ( est_postal IN('250-0311') )



							ORDER BY esc_score DESC