would something like this work?

```sql
SELECT previews.caption FROM previews INNER JOIN translations ON previews.caption = translations.id INNER JOIN addons ON previews.addon_id = addons.id WHERE translations.id IS NOT NULL AND addons.addontype_id = 11 INTO @ids
UPDATE previews SET caption = NULL, modified = NOW() WHERE caption IN (@ids);
DELETE FROM translations WHERE id IN (@ids);