An Error Was Encountered

Error Number: 5

Out of memory (Needed 1677596 bytes)

SELECT user_Locations.RBA_Locations_ID, user_Locations.Description, latitude, longitude, state, count(DISTINCT user_Listing.ID) as thecount, count(DISTINCT species_id) as thespecies FROM user_Listing JOIN user_Locations ON user_Locations.RBA_Locations_ID = user_Listing.RBALocationsID JOIN user_species_seen ON user_species_seen.listing_id = user_Listing.ID WHERE user_Locations.State = 'Arizona' AND user_Listing.RBALocationsID != 0 AND user_Listing.deleted = 0 AND user_Listing.Privacy = 3 GROUP BY RBA_Locations_ID ORDER BY thecount desc LIMIT 20