intermediate table joins (mostly) working
alias tables in query