7pZHbKKk

1use leaderce_sdbx_civicrm;
2
3DROP TABLE IF EXISTS log_contacts;
4
5CREATE TABLE IF NOT EXISTS log_contacts AS (
6SELECT log.* FROM 
7	log_civicrm_contact log
8INNER JOIN 
9	( SELECT id, MAX(log_date) log_date FROM log_civicrm_contact WHERE employer_id IS NOT NULL GROUP BY id) latest
10ON log.id = latest.id AND log.log_date = latest.log_date
11)
12;
13
14UPDATE 
15-- SELECT cnt.id, cnt.organization_name, log.organization_name FROM
16civicrm_contact cnt
17INNER JOIN log_contacts log
18ON cnt.id = log.id and log.organization_name IS NOT NULL
19SET cnt.organization_name = log.organization_name, cnt.employer_id = log.employer_id
20WHERE cnt.employer_id IS NULL 
21;
22
23DROP TABLE IF EXISTS log_contacts;