Amélioration Audityx

Pour les retrouver :

SELECT *
FROM items gest
         LEFT JOIN items ri ON ri.managermissionid = gest.itemid
WHERE gest.familyid = 32
  AND gest.categoryid NOT IN (141)
  AND date(gest.createdat) > '2024-10-01'
  AND gest.managermissionid IS NULL
AND ri.itemid IS NULL;