added joins to decrease the db queries from 14 to 1 on the menu page