-
- protected function whoWhomWhenSql() {
- return "
- SELECT who.id who_id, who.display_name who_name, whom.id whom_id, whom.display_name whom_name
- FROM `{$this->db}`.log_civicrm_contribution l
- LEFT JOIN civicrm_contact who ON (l.log_user_id = who.id)
- LEFT JOIN civicrm_contact whom ON (l.contact_id = whom.id)
- WHERE log_action = 'Update' AND log_conn_id = %1 AND log_date = %2 ORDER BY log_date DESC LIMIT 1
- ";
- }