Event status isn't updated in the database

[Jarne St]

I use zabbix version 4.0.18 with a MySQL database (mariadb version 15.1 Distrib 10.1.44).
I have this triggers:

[URL="http://javascript<b></b>:void(0);"]No data from SAM0087-FTG, FortiGate offline[/URL]
[URL="http://javascript<b></b>:void(0);"]No data from SAM0087-REC, QNAP offline[/URL]
[URL="http://javascript<b></b>:void(0);"]No data from SAM0087 LEFT, BoschCameraLEFT offline[/URL]
[URL="http://javascript<b></b>:void(0);"]No data from SAM0087 RIGHT, BoschCameraRIGHT offline[/URL]
[URL="http://javascript<b></b>:void(0);"]No data from SAM0087 BACK, BoschCameraBACK offline[/URL]

I use this query to see all the problem events for these triggers:

SELECT COUNT(*) AS "Other"
FROM events
JOIN triggers ON events.objectid = triggers.triggerid
WHERE events.name REGEXP "No data from SAM0087(.FTG|.REC|.LEFT|.RIGHT|.BACK), .* offline"
AND events.value = 1
AND triggers.value = 1;

If I look to the documentation, events.value = 1 shows the events that have a problem state.
But a events.value = 0 shows the events that are "OK", however in the frontend this is called "RESOLVED" ???

And for triggers, triggers.value = 1 shows also the triggers that are in the problem state. So with this query I only get the problem events for these triggers.
But If I look in the database all these 11 events are still in the problem state? (see database.png)

Could this be an issue with the query?
But why I see that these events are resolved in the frontend and are still a problem in the database?
What processes are responsible for synchronizing the triggers with the database? And how are triggers synchronized with the database ?