fix the query join for index page, fix minor issues on account summary
page.