Page Comparison

UPDATE
email_messages
    INNER JOIN instance_properties ON instance_properties.instance_id = 3 AND instance_properties.object_id = email_messages.id
    AND instance_properties.direction = 2
SET instance_properties.object_date = email_messages.delivery_date WHERE instance_properties.created_by_userid = 2 --das ist die ID des Admins

UPDATE
	tlstatus
		INNER JOIN instance_properties ON 
			instance_properties.instance_id = tlstatus.instance_id and 
			tlstatus.instance_id=3  AND 
			instance_properties.object_id = tlstatus.object_id AND 
			instance_properties.direction = 2 AND
			tlstatus.is_resubmission=0 AND -- nicht wiedervorlegt
			tlstatus.resubmission_date is null AND -- keine wiedervorlage eingerichtet
			tlstatus.is_globalize=0 AND  -- nicht geteilt
			instance_properties.chatsession_id=0 -- nicht geteilt
 
SET tlstatus.resubmission_sort_date = instance_properties.object_date