all_by_location_category