Re: Run multiple update / select from one query

[nobody nobody]

I think I fixed it:

update Device, (select id, alertState, lastContact from Device where lastContact < 1511765116 and alertState = 0) as statement set Device.alertState = 1 where Device.id = statement.id;