q = DBSession.query(cls)\
                    .filter(cls.deleted == False)\
                    .filter(cls.type==trans_type)