{"id":9698,"date":"2019-01-30T06:35:00","date_gmt":"2019-01-30T05:35:00","guid":{"rendered":"https:\/\/sr.wordpress.org\/support\/topic\/wpdb-get_results-%d0%bf%d0%be-%d1%83%d0%b4%d0%b0%d1%99%d0%b5%d0%bd%d0%be%d1%81%d1%82%d0%b8\/"},"modified":"2019-01-30T06:35:00","modified_gmt":"2019-01-30T05:35:00","slug":"wpdb-get_results-%d0%bf%d0%be-%d1%83%d0%b4%d0%b0%d1%99%d0%b5%d0%bd%d0%be%d1%81%d1%82%d0%b8","status":"publish","type":"topic","link":"https:\/\/sr.wordpress.org\/support\/topic\/wpdb-get_results-%d0%bf%d0%be-%d1%83%d0%b4%d0%b0%d1%99%d0%b5%d0%bd%d0%be%d1%81%d1%82%d0%b8\/","title":{"rendered":"$wpdb-&gt;get_results \u043f\u043e \u0443\u0434\u0430\u0459\u0435\u043d\u043e\u0441\u0442\u0438"},"content":{"rendered":"<p>\u041f\u043e\u0437\u0434\u0440\u0430\u0432 \u0443 \u0431\u0430\u0437\u0438 geomywp \u043f\u043b\u0443\u0433\u0438\u043d\u0430 \u043d\u0430\u043b\u0430\u0437\u0435 \u0441\u0435 \u043f\u043e\u0441\u0442\u043e\u0432\u0438 \u0441\u0430 \u0433\u0435\u043e\u0433\u0440\u0430\u0444\u0441\u043a\u043e\u043c \u0448\u0438\u0440\u0438\u043d\u043e\u043c \u0438 \u0434\u0443\u0436\u0438\u043d\u043e\u043c, \u0445\u0442\u0435\u043e \u0431\u0438\u0445 \u0434\u0430 \u043c\u0438 \u0441\u0435 \u043b\u0438\u0441\u0442\u0430\u0458\u0443 \u043f\u043e\u0441\u0442\u043e\u0432\u0438 \u0443 \u0431\u043b\u0438\u0437\u0438\u043d\u0438.\u0418\u043c\u0430\u043c \u0458\u0430 \u043e\u0432\u043e <code>SELECT ID, ( 3959 * ACOS( COS( RADIANS( 44.431438 ) ) * COS( RADIANS(<\/code>latitude<code>) ) * COS( RADIANS(<\/code>longitude<code>) - RADIANS( 21.051886 ) ) + SIN( RADIANS( 44.431438 ) ) * SIN( RADIANS(<\/code>latitude` ) ) ) ) AS distance<br \/>\nFROM wpc7_gmw_locations<br \/>\nHAVING distance &lt;25<br \/>\nORDER BY distance<br \/>\nLIMIT 0 , 20` \u0430\u043b\u0438 \u043d\u0435 \u0437\u043d\u0430\u043c \u043a\u0430\u043a\u043e \u0443\u0437 \u043f\u043e\u043c\u043e\u045b $wpdb-&gt;get_results \u0434\u0430 \u0438\u0437\u0432\u0443\u0447\u0435\u043c \u0448\u0442\u0430 \u043c\u0438 \u0442\u0440\u0435\u0431\u0430. \u041d\u0430\u0440\u0430\u0432\u043d\u043e latitude \u0438 latitude \u0442\u0440\u0435\u0432\u0430 \u0434\u0430 \u0441\u0443 \u043f\u0440\u043e\u043c\u0435\u045a\u0438\u0432\u0435 \u0442\u043e \u0458\u0435\u0441\u0442 \u0432\u0430\u0440\u0438\u0435\u0431\u043b\u0435 <\/p>\n","protected":false},"template":"","class_list":["post-9698","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sr.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sr.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/sr.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/sr.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9698\/revisions"}],"wp:attachment":[{"href":"https:\/\/sr.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=9698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}