select v.object_id,v.viewer_id,v.views_count,v.last_viewed, i.item_title as title from views_views v, ims_cp_items i, ims_cp_organizations o where i.ims_item_id = v.object_id and i.org_id = o.org_id and o.man_id = :man_id $extra_where select v.views_count,v.unique_views,v.last_viewed,v.object_id, i.item_title as title from view_aggregates v, ims_cp_items i, ims_cp_organizations o where i.ims_item_id = v.object_id and i.org_id = o.org_id and o.man_id = :man_id $extra_where