For NodeJS

haversinehelper.js

var HaversineHelper = {
	getQueryString: function
	(
		latitiude,
		longitude,
		keywords
	){
		return "SELECT id, post_id, full_name, description, (6371 * acos(cos(radians($latitude)) * cos(radians(latitude)) * cos(radians(longitude) - radians(longitude)) + sin(radians(latitude)) * sin(radians(latitude)))) distance FROM wp_locations WHERE full_name LIKE '%$keywords%' OR description LIKE '%keywords%' GROUP BY full_name HAVING distance < $distance ORDER BY distance LIMIT 0, 20";
	}
};
module.exports = HaversineHelper;