Can't delete items with translations

[lluishi93]

Describe the Bug

A FK constraint is preventing the items to be deleted.

Potentially related to #12478

To Reproduce

1. Create collection A
2. Add translations field to collection A
3. Create some items for collection A with its translations
4. Try to delete the item

Errors Shown

{
  "errors": [
    {
      "message": "delete from `c_cta` where `id` in ('2149') - ER_ROW_IS_REFERENCED_2: Cannot delete or update a parent row: a foreign key constraint fails (`emma_pre_directus9`.`c_cta_translations`, CONSTRAINT `c_cta_translations_entity_foreign` FOREIGN KEY (`entity`) REFERENCES `c_cta` (`id`))",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

What version of Directus are you using?

9.9.1

What version of Node.js are you using?

16.14.0

What database are you using?

MySQL 5.7

What browser are you using?

Chrome

How are you deploying Directus?

Docker