review populate metadata based on event log

gistfile1.txt

select el.*, ev.* from eventlog  as el
inner join event as ev on (el.event=ev.id)
inner join wellannotationlink as wal on (wal.id = el.entityid)
inner join well as w on (wal.parent=w.id)
inner join plate as p on (w.plate=p.id)
inner join screenplatelink as spl on (spl.child=p.id)
where ev."time" > '2017-01-31 16:00:00.000'
and spl.parent = 1203
and el.action != 'REINDEX'
and el.entitytype = 'ome.model.annotations.WellAnnotationLink'

order by 2


select el.*, ev.* from eventlog  as el
inner join event as ev on (el.event=ev.id)
inner join imageannotationlink as ial on (ial.id = el.entityid)
inner join image as i on (ial.parent = i.id)
inner join wellsample as ws on (ws.image=i.id)
inner join well as w on (ws.well=w.id)
inner join plate as p on (w.plate=p.id)
inner join screenplatelink as spl on (spl.child=p.id)
where ev."time" > '2017-01-31 16:00:00.000'
and spl.parent = 1203
and el.action != 'REINDEX'
and el.entitytype = 'ome.model.annotations.ImageAnnotationLink'

order by 2