update
turned it into a view
update
test2 which does the right lookups
update
rename user views to _get and make more consistent, using uid as first term where possible
fix naming of get views to match tables and other fixes