fixed some views and queries

Signed-off-by: Juliana Davila <judaro13@gmail.com>