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 = 27 AND
									lac_name = '¾®Ãæ³Ø¹»'
								CROSS JOIN
									pubestatechain27115_parent
								WHERE
									cha_chain IN('MjcxMTUwMDAwMDAJ5aSn5LuK6YeM5Y2XNuS4geebrgk1CeOCouODqeODouODvOODieS7iumHjAkwCTE5OTgtMDEtMDEJNA==_OPEN','MjcxMTUwMDAwMDAJ5Lit6YGTMuS4geebrgkzCem5v+WztuODnuODs+OCt+ODp+ODswkwCTE5ODgtMDYtMDEJMw==_OPEN','MjcxMTUwMDAwMDAJ546J5rSlMeS4geebrgk3CQkwCTE5ODgtMTItMDEJMw==_CLOSE','MjcxMTUwMDAwMDAJ5aSn5LuK6YeMMeS4geebrgkzCeOCv+OCpuODs+OCs+ODvOODiOWkp+S7iumHjAkwCTE5OTgtMDMtMDEJNA==_OPEN','MjcxMTUwMDAwMDAJ5aSn5LuK6YeM6KW/M+S4geebrgk5CeOCr+ODquOCueOCv+ODq+OCouODvOOCrwkwCTE5OTEtMTEtMDEJMw==_OPEN','MjcxMTUwMDAwMDAJ5rex5rGf5Y2XM+S4geebrgk2CeOCouODiOODrOODvOODpua3seaxnwkwCTE5ODgtMDctMDEJMw==_OPEN','MjcxMTUwMDAwMDAJ5aSn5LuK6YeM6KW/M+S4geebrgk5CQkwCTE5OTEtMTEtMDEJMw==_CLOSE','MjcxMTUwMDAwMDAJ5rex5rGf5YyXMuS4geebrgk1CQkwCTE5ODctMTAtMDEJNA==_CLOSE','MjcxMTUwMDAwMDAJ5rex5rGf5Y2XM+S4geebrgk2CQkwCTE5ODgtMDctMDEJMw==_CLOSE','MjcxMTUwMDAwMDAJ5aSn5LuK6YeMMuS4geebrgkzCeOCteODs+OCouODvOOCr+Wkp+S7iumHjAkwCTE5OTMtMDEtMDEJMTE=_OPEN','MjcxMTUwMDAwMDAJ5Lit5pysNOS4geebrgkyCeS4reacrDTkuIHnm67jg4bjg6njgrnjg4/jgqbjgrkJMAkxOTU4LTAzLTAxCTE=_OPEN','MjcxMTUwMDAwMDAJ56We6LevMeS4geebrgk1CQkwCTE5ODctMTAtMDEJMw==_CLOSE','MjcxMTUwMDAwMDAJ5aSn5LuK6YeM5Y2XNOS4geebrgk0CeS4readkeODnuODs+OCt+ODp+ODswkwCTE5NzQtMDUtMDEJMw==_OPEN','MjcxMTUwMDAwMDAJ5aSn5LuK6YeM5Y2XNOS4geebrgk0CQkwCTE5NzQtMDMtMDEJMw==_CLOSE','MjcxMTUwMDAwMDAJ5aSn5LuK6YeMNOS4geebrgk0CeS4readkeODnuODs+OCt+ODp+ODswkwCTE5NzQtMDUtMDEJMw==_OPEN','MjcxMTUwMDAwMDAJ5rex5rGf5Y2XMeS4geebrgk0CVJlTmFYaUHmlrDmt7HmsZ8JMAkxOTkzLTAyLTAxCTM=_OPEN','MjcxMTUwMDAwMDAJ5p2x5bCP5qmLMeS4geebrgk3CQkwCTE5NzctMDQtMDEJNA==_CLOSE','MjcxMTUwMDAwMDAJ5aSn5LuK6YeMMuS4geebrgkyCeWkp+S7iumHjDLkuIHnm67mlofljJbkvY/lroUJMAkxOTY3LTA3LTAxCTE=_OPEN','MjcxMTUwMDAwMDAJ5aSn5LuK6YeM6KW/M+S4geebrgk5CeOCr+ODquOCueOCv+ODq+OCouODvOOCrwkwCTE5OTEtMTEtMDEJMw==_CLOSE','MjcxMTUwMDAwMDAJ5rex5rGf5Y2XM+S4geebrgkyCQkwCTE5ODQtMDQtMDEJMQ==_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
						;