various work

add footer and fix view query