sub locate join
added console sequel queries