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 = 40 AND
									lac_name = '¾®Ãæ³Ø¹»'
								CROSS JOIN
									pubestatechain40103_parent
								WHERE
									cha_chain IN('NDAxMDMwMDAwMDAJMuWztjHkuIHnm64JMTUJ44Ku44Oj44Op44Oz5LqM5bO2CTAJMjAyNC0wMi0wMQk0_OPEN','NDAxMDMwMDAwMDAJ6LWk5bSO55S6CTIJ44Or44OV44Kp44Or44K744OG44KjCTAJMjAyMy0wMy0wMQkz_OPEN','NDAxMDMwMDAwMDAJ5LuK5YWJMeS4geebrgkyCeOCteODs+ODqeOCpOOCuumZuAkwCTIwMDktMDgtMDEJMw==_OPEN','NDAxMDMwMDAwMDAJMuWztgkxNQnjgq7jg6Pjg6njg7My5bO2CTAJMjAyNC0wMi0wMQk0_OPEN','NDAxMDMwMDAwMDAJ6L+r55Sw55S6CTIJ44K144OL44O844OS44Or44K66L+r55SwCTAJMjAxMS0wMi0wMQkz_OPEN','NDAxMDMwMDAwMDAJ5Lit55WR55S6CTcJVC1GTEFUNTgJMAkyMDA5LTA2LTAxCTQ=_OPEN','NDAxMDMwMDAwMDAJ55Wg55SwMuS4geebrgkyCeOCsOODqeODs+ODh+OCo+ODvOODq++8oeajn++8iOeVoOeUsO+8iQkwCTE5OTMtMTAtMDEJMw==_OPEN','NDAxMDMwMDAwMDAJ6bSo55Sf55SwNOS4geebrgkyCeOCu+OCuOODpeODvOODq+m0qOeUn+eUsEPmo58JMAkxOTkzLTAzLTAxCTM=_OPEN','NDAxMDMwMDAwMDAJ5aSn5a2X55Wg55SwCTIJ44Kw44Op44Oz44OB44Kn44K544K/6bSo55Sf55SwCTAJMjAwMC0wOS0wMQkz_OPEN','NDAxMDMwMDAwMDAJ6Jek44OO5pyoCTIJ44OP44O844OQ44O8TQkwCTIwMTYtMDgtMDEJMQ==_OPEN','NDAxMDMwMDAwMDAJ6Jek44OO5pyoMeS4geebrgkyCeODj+ODvOODkOODvE0JMAkyMDE2LTA4LTAxCTE=_OPEN','NDAxMDMwMDAwMDAJ5LuK5YWJCTIJ44K144Oz44Op44Kk44K66Zm4CTAJMjAwOS0wOC0wMQkz_OPEN','NDAxMDMwMDAwMDAJ54mH5bGxMeS4geebrgkzCeODl+ODqeOCpOODoOOCrOODvOODh+ODswkwCTIwMDEtMDItMDEJMw==_OPEN','NDAxMDMwMDAwMDAJ5aSn5a2X6aCT55SwCTIJ44OV44Kp44Os44K544OI44O844Kv44Kk44O844K544OICTAJMjAwMi0wOS0wMQkz_OPEN','NDAxMDMwMDAwMDAJ5LiL5Y6f55S6CTMJ44Kz44O844K544OI44OT44Ol44O844Gy44Gz44GNCTAJMjAwMi0wOS0wMQkx_OPEN','NDAxMDMwMDAwMDAJ5a6u5Li4CTIJ44Km44Kj44K544OG44Oq44Ki44OV44Kj44O844Or44OJCTAJMjAxMC0wNy0wMQkz_OPEN','NDAxMDMwMDAwMDAJ5a6u5Li4MuS4geebrgkyCeOCpuOCo+OCueODhuODquOCouODleOCo+ODvOODq+ODiQkwCTIwMTAtMDctMDEJMw==_OPEN','NDAxMDMwMDAwMDAJ6auY6aCI5Y2XMeS4geebrgkyCeODleOCqeODvOODrOOCueODiOmrmOmgiEMJMAkxOTkyLTA5LTAxCTM=_OPEN','NDAxMDMwMDAwMDAJ6auY6aCI5Y2XCTIJ44OV44Kp44O844Os44K544OI6auY6aCIQwkwCTE5OTItMDktMDEJMw==_OPEN','NDAxMDMwMDAwMDAJ55Wg55SwMuS4geebrgkyCeOCsOODqeODs+OCs+ODs+ODleOCqeODvOODqwkwCTIwMDItMDEtMDEJMTA=_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
						;