total locations works, but lots of queries... will need to be refactored
basic table works. very inefficient, but ok for validation