{"id":110344,"date":"2008-04-11T17:56:09","date_gmt":"2008-04-11T08:56:09","guid":{"rendered":"https:\/\/ja.wordpress.org\/support\/2008\/04\/11\/lightweight-google-maps%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/"},"modified":"2008-04-11T17:56:09","modified_gmt":"2008-04-11T08:56:09","slug":"lightweight-google-maps%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6","status":"closed","type":"topic","link":"https:\/\/ja.wordpress.org\/support\/topic\/lightweight-google-maps%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/","title":{"rendered":"lightweight-google-maps\u306b\u3064\u3044\u3066"},"content":{"rendered":"<p>\u65b0\u3057\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306elightweight-google-maps\u3092\u5c0e\u5165\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u56fa\u5b9a\u30da\u30fc\u30b8\u306e\u5730\u56f3\u306e\u5de6\u5074\u306e\u4e0b\u306b\u300cAND,\u300d\u306e\u6587\u5b57\u304c\u2026\u2026\u3002<br \/>\n\u3044\u308d\u3044\u308d\u8abf\u3079\u308b\u3068Lat_Long.php\u306e\u4ee5\u4e0b\u306e\u90e8\u5206\u3067\u3001\u3069\u3053\u304b\u300cAND SUBSTRING_INDEX(meta_value, &#8216;,&#8217;,-1)\u300d\u304c\u4f59\u5206\u304b\u306a\u3068\u3044\u3046\u6c17\u3082\u3059\u308b\u306e\u3067\u3059\u304c\u3001\u3069\u3046\u306a\u3093\u3067\u3057\u3087\u3046\u304b\u3002\u3069\u306a\u305f\u304b\u308f\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u3087\u3046\u304b\u3002<br \/>\n$locations = $wpdb-&gt;get_results(&#8220;SELECT post_id,meta_value FROM {$wpdb-&gt;postmeta} WHERE meta_key = &#8216;&#8221; . GEO_META_FIELD_NAME . &#8220;&#8216; AND SUBSTRING_INDEX(meta_value, &#8216;,&#8217;,1) &gt;= $south_lat AND SUBSTRING_INDEX(meta_value, &#8216;,&#8217;,1) &lt;= $north_lat AND SUBSTRING_INDEX(meta_value, &#8216;,&#8217;,-1) &gt;= $west_lon AND SUBSTRING_INDEX(meta_value, &#8216;,&#8217;,-1) &lt;= $east_lon ORDER BY post_id DESC&#8221;);<\/p>\n","protected":false},"template":"","class_list":["post-110344","topic","type-topic","status-closed","hentry","topic-tag-lightweight-google-maps","topic-tag-sql"],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/110344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/110344\/revisions"}],"wp:attachment":[{"href":"https:\/\/ja.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=110344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}