server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.|SOURCE -> 						SELECT DISTINCT ON(cha_chain)
							*
						FROM
							(
								SELECT
									lan_geocord,
									(ST_Distance(est_latitudelongitude::GEOGRAPHY, ST_PointFromText('POINT('|| lan_point[1] ||' '|| lan_point[0]||')', 4326)::GEOGRAPHY)) AS lan_distance,
									cha_chain,
									RANK()
										OVER
									(
										partition by
											cha_chain
										order by
										(ST_Distance(est_latitudelongitude::GEOGRAPHY, ST_PointFromText('POINT('|| lan_point[1] ||' '|| lan_point[0]||')', 4326)::GEOGRAPHY)) ASC
									) as rank
								FROM
									landmark
								JOIN
									landmarkcategory
								ON
									lan_categorycode = lac_code AND
									lac_type = 2 AND
									lan_prefecturecode = lac_prefecturecode::integer AND
									lan_prefecturecode = 14 AND
									lac_name = '¾®Ãæ³Ø¹»'
								CROSS JOIN
									pubestatechain14_parent
								WHERE
									cha_chain IN('MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCeahguWPsOilv+iyuOWutgkwCTE5OTItMDMtMDEJMQ==_OPEN','MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCeODj+OCpOODhOahguWPsAkwCTE5ODgtMDMtMDEJMQ==_OPEN','MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCeODl+ODrOOCpOODs+ahguWPsO+8owkwCTIwMDUtMDktMDEJMTA=_OPEN','MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCeahguWPsOilv+iyuOWutu+8ru+9j++8ju+8kwkwCTE5OTItMDMtMDEJMQ==_OPEN','MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCeahguWPsOilv+iyuOWutgkwCTE5OTItMDQtMDEJMQ==_OPEN','MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCeahguWPsOilv+iyuOWutu+8iO+8ku+8je+8l++8je+8k++8iQkwCTE5OTItMDMtMDEJMQ==_OPEN','MTQxMTUwMDAwMDAJ5qGC5Y+w6KW/MuS4geebrgkyCQkwCTE5ODgtMDMtMDEJMQ==_CLOSE') AND
									(ST_Distance(est_latitudelongitude::GEOGRAPHY, ST_PointFromText('POINT('|| lan_point[1] ||' '|| lan_point[0]||')', 4326)::GEOGRAPHY)) <= 1500
							) AS tmp
						WHERE
							tmp.rank = 1
						;