Inconsistent results with distance/proximity filter in views.

Hi everyone,

General problem:
I've created a view with exposed filters that searches users based on their role and their proximity/distance. The problem I am running into is that filtering by certain roles seems to produce accurate location results, while certain roles return no results at all.
Thank you for your help.

More detail:

• When it searches users with a role id of 6 by proximity, the search returns nothing. Without entering anything into proximity, it returns the 2500 users properly.
• When it searches users with a role id of 8 by proximity, the search returns properly.
• As you can see from the two queries below, the only changes is the users_roles.rid from 6 to 8.

Could this be a problem with the amount of users it's trying to query? Does anybody have any other possible problems?

Extra information:
If you want to give the live version a try, go to: http://grodan101.com/store

I'm also using Profile 2, but that does not affect the filter criteria.

Queries:

Working properly:

SELECT users.picture AS users_picture, users.uid AS uid, users.name AS users_name, users.mail AS users_mail, location.lid AS location_lid, profile_users.pid AS profile_users_pid, location.name AS location_name, 'profile2' AS field_data_field_store_hours_profile2_entity_type, 'profile2' AS field_data_field_website_profile2_entity_type, (IFNULL(ACOS(0.828169832503*COS(RADIANS(location.latitude))*(-0.475718165272*COS(RADIANS(location.longitude)) + -0.879597764453*SIN(RADIANS(location.longitude))) + 0.56047723284*SIN(RADIANS(location.latitude))), 0.00000)*6371396.0928) AS location_distance_sort
FROM 
{users} users
INNER JOIN {profile} profile_users ON users.uid = profile_users.uid
LEFT JOIN {location_instance} location_instance ON users.uid = location_instance.uid
LEFT JOIN {location} location ON location_instance.lid = location.lid
INNER JOIN {users_roles} users_roles ON users.uid = users_roles.uid
WHERE (( (users.status <> '0') AND (users_roles.rid = '8') )AND( (location.latitude > '26.8526552378' AND location.latitude < '41.3249607622' AND location.longitude > '-127.154385345' AND location.longitude < '-109.657854655') AND ((IFNULL(ACOS(0.828169832503*COS(RADIANS(location.latitude))*(-0.475718165272*COS(RADIANS(location.longitude)) + -0.879597764453*SIN(RADIANS(location.longitude))) + 0.56047723284*SIN(RADIANS(location.latitude))), 0.00000)*6371396.0928) < '804673.5') ))
ORDER BY location_distance_sort ASC, location_name ASC
LIMIT 30 OFFSET 0

Returns nothing:

SELECT users.picture AS users_picture, users.uid AS uid, users.name AS users_name, users.mail AS users_mail, location.lid AS location_lid, profile_users.pid AS profile_users_pid, location.name AS location_name, 'profile2' AS field_data_field_store_hours_profile2_entity_type, 'profile2' AS field_data_field_website_profile2_entity_type, (IFNULL(ACOS(0.828169832503*COS(RADIANS(location.latitude))*(-0.475718165272*COS(RADIANS(location.longitude)) + -0.879597764453*SIN(RADIANS(location.longitude))) + 0.56047723284*SIN(RADIANS(location.latitude))), 0.00000)*6371396.0928) AS location_distance_sort
FROM 
{users} users
INNER JOIN {profile} profile_users ON users.uid = profile_users.uid
LEFT JOIN {location_instance} location_instance ON users.uid = location_instance.uid
LEFT JOIN {location} location ON location_instance.lid = location.lid
INNER JOIN {users_roles} users_roles ON users.uid = users_roles.uid
WHERE (( (users.status <> '0') AND (users_roles.rid = '6') )AND( (location.latitude > '26.8526552378' AND location.latitude < '41.3249607622' AND location.longitude > '-127.154385345' AND location.longitude < '-109.657854655') AND ((IFNULL(ACOS(0.828169832503*COS(RADIANS(location.latitude))*(-0.475718165272*COS(RADIANS(location.longitude)) + -0.879597764453*SIN(RADIANS(location.longitude))) + 0.56047723284*SIN(RADIANS(location.latitude))), 0.00000)*6371396.0928) < '804673.5') ))
ORDER BY location_distance_sort ASC, location_name ASC
LIMIT 30 OFFSET 0