'Identify shared pages'

def _get_shared(self, trans):

    shared_by_others = trans.sa_session.query(model.PageUserShareAssociation).filter_by(user=trans.get_user()).join(model.Page.table).filter((model.Page.deleted == false())).order_by(desc(model.Page.update_time)).all()
    return [{'username': p.page.user.username, 'slug': p.page.slug, 'title': p.page.title} for p in shared_by_others]
