AFaust

delete
from
   alf_prop_link
where
   root_prop_id in (
      select
         prop1_id
      from
         alf_prop_unique_ctx ctx
         left join alf_prop_value pvj1 on ctx.value1_prop_id = pvj1.id

AFaust

select
  unpsv.string_value as user,
  max(audit_time) as lastLoginTime,
  count(*) as loginCounts
from
  alf_prop_link pl
  left join alf_audit_entry ae on ae.audit_values_id = pl.root_prop_id
  left join alf_prop_value unpv on unpv.id = ae.audit_user_id
  left join alf_prop_string_value unpsv on unpsv.id = unpv.long_value
where