Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.41K
Discussions / Questions x 1
~173 People Reached
Favorite Forums
Databases x 1
Favorite Tags
distance x 1
geo x 1
join x 1
mysql x 1
subquery x 1
Member Avatar for mavrick4sky
Need help in GEO query
Share on Facebook Share on Twitter Share on LinkedIn

SELECT * , 3956 *2 * ASIN( SQRT( POWER( SIN( ( 122.4058 - ABS( dest.lat ) ) * PI( ) /180 /2 ) , 2 ) + COS( 122.4058 * PI( ) /180 ) * COS( ABS( dest.lat ) * PI( ) /180 ) * POWER( SIN( ( 37.7907 - …

Databases distance geo join mysql subquery
Member Avatar for fobos
0
1
173