select views_count, unique_views, to_char(last_viewed,'YYYY-MM-DD HH24:MI:SS') as last_viewed from view_aggregates where object_id = :object_id select count(*) from views_views where object_id = :object_id and viewer_id = :user_id