59 |
" SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, " + |
" SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, " + |
60 |
" earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + |
" earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + |
61 |
" FROM trainstations " + |
" FROM trainstations " + |
62 |
" WHERE latitude IS NOT NULL AND longitude IS NOT NULL " + |
" WHERE enabled = true AND latitude IS NOT NULL AND longitude IS NOT NULL " + |
63 |
" ) AS trainstations2 " + |
" ) AS trainstations2 " + |
64 |
"ORDER BY calcdist ASC " + |
"ORDER BY calcdist ASC " + |
65 |
"LIMIT 4 "; |
"LIMIT 4 "; |