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
									pubestatechain27118_parent
								WHERE
									cha_chain IN('MjcxMTgwMDAwMDAJ6YeO5rGfMeS4geebrgkxMAnjgrDjg6njg7Pjgrnjg4bjg4fjgqPln47mnbHkuK3lpK4JMAkyMDIzLTAxLTAxCTQ=_OPEN','MjcxMTgwMDAwMDAJ6YeO5rGfMuS4geebrgk4CeOCouODvOOCq+OCuemHjuaxnwkwCTE5ODktMTAtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ6YeO5rGfNOS4geebrgk2CeOCs+OCueODouODhuODvOODq+WfjuWMlwkwCTE5OTQtMDQtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ5paw5Zac5aSaMuS4geebrgk3CeODleOCqeODvOODquOCouODqeOCpOOCuuS6rOapiwkwCTIwMTYtMDgtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ5LuK56aP5p2xMuS4geebrgkxNAnjg63jgqTjg6Tjg6vjg4/jgqTjg4Tku4rnpo/ptrTopovpp4UJMAkxOTkwLTAzLTAxCTU=_OPEN','MjcxMTgwMDAwMDAJ6Zai55uuMeS4geebrgkxNQnjg5Hjg7zjg4njg6zplqLnm64JMAkxOTkxLTA5LTAxCTU=_OPEN','MjcxMTgwMDAwMDAJ5oiQ6IKyMuS4geebrgkxMQnjgrDjg6njg7Pjg6vjg7zjgrjjg6Xln47mnbEo5pen44OR44Or44Kz5Z+O5p2xKQkwCTIwMDgtMDEtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ5Y+k5biCM+S4geebrgk3CeODoeOCvuODs+ODu+ODieODu+ODtOOCo+OCquODrOODg+ODiAkxCTE5ODgtMDQtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ6YeO5rGfMuS4geebrgkxNQnjgrDjg6njg7PjgqLjg4Pjgrfjg6Xph47msZ8JMAkyMDA4LTAyLTAxCTQ=_OPEN','MjcxMTgwMDAwMDAJ5p2x5Lit5rWcMuS4geebrgkzCeODtOOCo+ODqeadseS4rea1nAkwCTE5NzQtMDEtMDEJMw==_OPEN','MjcxMTgwMDAwMDAJ6Zai55uuNuS4geebrgkxNQnjgqLjg7zjg5Djg7Pjg5Hjg7zjgq/plqLnm67vvIjmnb7lsYvjg6zjgrjjg4fjg7PjgrnplqLnm67vvIkJMAkxOTg5LTA4LTAxCTU=_OPEN','MjcxMTgwMDAwMDAJ5p2x5Lit5rWcNOS4geebrgkzCeOBi+OBvOOBjz8JMAkxOTk1LTA3LTAxCTM=_OPEN','MjcxMTgwMDAwMDAJ6KuP6KiqMuS4geebrgk2CeODlOODpeOCouODqeOCpOOCuuirj+ioqgkwCTIwMDYtMDQtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ5LuK56aP5Y2XMeS4geebrgkzCeOCu+ODrOODi+ODhuOCo+S7iuemj+WNlwkwCTIwMTgtMDEtMDEJMQ==_OPEN','MjcxMTgwMDAwMDAJ5LuK56aP5Y2XMeS4geebrgkzCQkwCTIwMTgtMDEtMDEJMQ==_CLOSE','MjcxMTgwMDAwMDAJ5oiQ6IKyMuS4geebrgkxNQnjgrPjg5/jg6Xjg4vjg4bjgqPjgrPjg7zjg4jplqLnm64JMAkxOTkxLTExLTAxCTU=_OPEN','MjcxMTgwMDAwMDAJ5Y+k5biCM+S4geebrgk3CeODoeOCvuODs+ODu+ODieODu+ODtOOCo+OCquODrOODg+ODiAkwCTE5ODgtMDQtMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ6YeO5rGfCTE1CeOCsOODqeODs+OCouODg+OCt+ODpemHjuaxnwkwCTIwMDgtMDItMDEJNA==_OPEN','MjcxMTgwMDAwMDAJ6Zai55uuM+S4geebrgk2CeOCteODs+ODqeOCpOOCuuODhOOCpOODs+mWouebrjLlj7fppKgJMAkxOTg5LTA1LTAxCTM=_OPEN','MjcxMTgwMDAwMDAJ6bSr6YeO6KW/NOS4geebrgk0CeODl+ODqeODs+ODoeOCvuODs+OBl+OBjuOBrgkwCTE5OTAtMDEtMDEJMw==_OPEN') AND
									(ST_Distance(est_latitudelongitude::GEOGRAPHY, ST_PointFromText('POINT('|| lan_point[1] ||' '|| lan_point[0]||')', 4326)::GEOGRAPHY)) <= 1500
							) AS tmp
						WHERE
							tmp.rank = 1
						;